csdb

type Column struct {
	Field   string      `db:"COLUMN_NAME"`      //`COLUMN_NAME` varchar(64) NOT NULL DEFAULT ”,
	Pos     int64       `db:"ORDINAL_POSITION"` //`ORDINAL_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0',
	Default null.String `db:"COLUMN_DEFAULT"`   //`COLUMN_DEFAULT` longtext,
	Null    string      `db:"IS_NULLABLE"`      //`IS_NULLABLE` varchar(3) NOT NULL DEFAULT ”,
	// DataType contains the basic type of a column like smallint, int, mediumblob,
	// float, double, etc... but always transformed to lower case.
	DataType      string     `db:"DATA_TYPE"`                //`DATA_TYPE` varchar(64) NOT NULL DEFAULT ”,
	CharMaxLength null.Int64 `db:"CHARACTER_MAXIMUM_LENGTH"` //`CHARACTER_MAXIMUM_LENGTH` bigint(21) unsigned DEFAULT NULL,
	Precision     null.Int64 `db:"NUMERIC_PRECISION"`        //`NUMERIC_PRECISION` bigint(21) unsigned DEFAULT NULL,
	Scale         null.Int64 `db:"NUMERIC_SCALE"`            //`NUMERIC_SCALE` bigint(21) unsigned DEFAULT NULL,
	// ColumnType full SQL string of the column type
	ColumnType string `db:"COLUMN_TYPE"` //`COLUMN_TYPE` longtext NOT NULL,
	// Key primary or unique or ...
	Key     string `db:"COLUMN_KEY"`     //`COLUMN_KEY` varchar(3) NOT NULL DEFAULT ”,
	Extra   string `db:"EXTRA"`          //`EXTRA` varchar(30) NOT NULL DEFAULT ”,
	Comment string `db:"COLUMN_COMMENT"` //`COLUMN_COMMENT` varchar(1024) NOT NULL DEFAULT ”,
	// contains filtered or unexported fields
}

type Columns []*Column

type MasterStatus struct {
	File             string
	Position         uint
	Binlog_Do_DB     string
	Binlog_Ignore_DB string
	// Executed_Gtid_Set: When global transaction IDs are in use, Executed_Gtid_Set
	// shows the set of GTIDs for transactions that have been executed on the
	// master. This is the same as the value for the gtid_executed system variable
	// on this server, as well as the value for Executed_Gtid_Set in the output of
	// SHOW SLAVE STATUS on this server.
	Executed_Gtid_Set string
}

type Preparer interface {
	PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)
}

type Querier interface {
	// QueryContext executes a query that returns rows, typically a SELECT. The
	// args are for any placeholder parameters in the query.
	QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
}

type QueryRower interface {
	// QueryRowContext executes a query that is expected to return at most one
	// row. QueryRowContext always returns a non-nil value. Errors are deferred
	// until Row's Scan method is called.
	QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row
}

type ResurrectStmt struct {
	// DB contains for now only the prepare() function for a new statement
	// may be extended in the far future.
	DB Preparer
	// SQL is any prepareable SQL command, use ? for argument placeholders
	SQL string
	// Idle defines the duration how to wait until no query will be executed.
	Idle time.Duration
	// Log default logger is PkgLof
	Log log.Logger
	// contains filtered or unexported fields
}

type Table struct {
	// Schema represents the name of the database. Might be empty.
	Schema string
	// Name of the table
	Name string
	// Columns all table columns
	Columns Columns
	// CountPK number of primary keys. Auto updated.
	CountPK int
	// CountUnique number of unique keys. Auto updated.
	CountUnique int
	// contains filtered or unexported fields
}

type TableOption func(*Tables) error

type Tables struct {
	// Schema represents the name of the database. Might be empty.
	Schema string
	// Prefix will be put in front of each table name. TODO implement table prefix.
	Prefix string
	// contains filtered or unexported fields
}

type Variable struct {
	Name  string
	Value string
}

type Variables []*Variable