state

type DBManager interface {
	/// IsReady will indicate if the SQL connection is ready
	IsReady() bool

	// IsLocked returns if the DB is available but locked
	IsLocked() bool

	// IsInitialized returns if the DB has ever been created
	IsInitialized() bool

	Type() string

	// Unlock will unlock an SQL database with a key/passphrase
	Unlock(string) error

	// RegisterInitScript will register initialization scripts
	// WILL PANIC IF ANY OF THESE SCRIPTS DO NOT RUN
	RegisterInitScript(string)

	// SafeQuery will query safely if the DB is ready
	SafeQuery(query string, args ...interface{}) (Rows, error)
	// SafeExec will query safely if the DB is ready
	SafeExec(query string, args ...interface{}) (Result, error)

	// GetKey gets a value
	GetKey(key []byte) (string, error)

	// SetKey sets a key with a value
	SetKey(key []byte, value []byte) error

	// DelKey deletes a key
	DelKey(key []byte) error

	KVDB() *bolt.DB
}

type Result interface {
	// LastInsertId returns the integer generated by the database
	// in response to a command. Typically this will be from an
	// "auto increment" column when inserting a new row. Not all
	// databases support this feature, and the syntax of such
	// statements varies.
	LastInsertId() (int64, error)

	// RowsAffected returns the number of rows affected by an
	// update, insert, or delete. Not every database or database
	// driver may support this.
	RowsAffected() (int64, error)
}

type Rows interface {
	Next() bool
	NextResultSet() bool
	Err() error
	Columns() ([]string, error)
	ColumnTypes() ([]*sql.ColumnType, error)
	Scan(dest ...interface{}) error
	Close() error
}