database

type Column struct {
	Name            string
	DataType        string
	FullDataType    string // includes precision, scale, etc.
	IsNullable      bool
	DefaultValue    *string
	IsPrimaryKey    bool
	IsAutoIncrement bool
	Comment         string
	OrdinalPosition int
}

type Driver interface {
	// Connection management
	Connect(ctx context.Context) error
	Close() error
	Ping(ctx context.Context) error

	// Schema operations
	GetTables(ctx context.Context) ([]Table, error)
	GetTableSchema(ctx context.Context, tableName string) (*TableSchema, error)
	GetPrimaryKey(ctx context.Context, tableName string) ([]string, error)

	// Data operations
	Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
	Execute(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

	// Batch operations
	BulkInsert(ctx context.Context, tableName string, columns []string, rows [][]interface{}) error

	// Transaction support
	BeginTx(ctx context.Context) (*sql.Tx, error)

	// Metadata
	DriverName() string
	DatabaseName() string
}

type ForeignKey struct {
	Name              string
	Columns           []string
	ReferencedTable   string
	ReferencedColumns []string
	OnUpdate          string
	OnDelete          string
}

type Index struct {
	Name      string
	Columns   []string
	IsUnique  bool
	IsPrimary bool
}

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

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

type Table struct {
	Name    string
	Schema  string
	Type    string // TABLE, VIEW, etc.
	Comment string
}

type TableSchema struct {
	Name        string
	Columns     []Column
	PrimaryKey  []string
	Indexes     []Index
	ForeignKeys []ForeignKey
}