dialect

type ColumnSchema interface {
	TableName() string
	ColumnName() string
	ColumnType() string
	DataType() string
	IsPrimaryKey() bool
	IsAutoIncrement() bool
	Index() (name string, unique bool, ok bool)
	Default() (string, bool)
	IsNullable() bool
	Extra() (string, bool)
	Comment() (string, bool)
}

type ColumnType struct {
	Types           []string `yaml:"types"`
	GoTypes         []string `yaml:"goTypes"`
	GoNullableTypes []string `yaml:"goNullableTypes"`
	GoUnsignedTypes []string `yaml:"goUnsignedTypes"`
}

type Dialect interface {
	ColumnType(name string) string
	GoType(name string, nullable bool) string
	IsNullable(name string) bool
	ImportPackage(schema ColumnSchema) string
	Quote(s string) string
	QuoteString(s string) string

	CreateTableSQL(table Table) []string
	DropTableSQL(table Table) []string
	FindAllSQL(table Table) []string
	FindSQL(table Table) []string
	CreateSQL(table Table) []string
	DeleteSQL(table Table) []string
	UpdateSQL(table Table) []string
	AddColumnSQL(field Field) []string
	DropColumnSQL(field Field) []string
	ModifyColumnSQL(oldField, newField Field) []string
	CreateIndexSQL(index Index) []string
	DropIndexSQL(index Index) []string
}

type Field struct {
	Table         string
	Name          string
	Type          string
	Comment       string
	AutoIncrement bool
	Default       string
	Extra         string
	Nullable      bool
	ForeignKey    *ForeignKey
}

type ForeignKey struct {
	Table  string
	Column string
}

type Index struct {
	Table   string
	Name    string
	Columns []string
	Unique  bool
}

type MySQL struct {
	// contains filtered or unexported fields
}

type PrimaryKeyModifier interface {
	ModifyPrimaryKeySQL(oldPrimaryKeys, newPrimaryKeys []Field) []string
}

type Table struct {
	Name        string
	Fields      []Field
	PrimaryKeys []string
	ForeignKeys map[string]ForeignKey //map[columnName]reference
	Option      string
}

type Transactioner interface {
	Exec(sql string, args ...interface{}) error
	Commit() error
	Rollback() error
}