types

type ActionType string

type CobraCmdFn = func(cmd *cobra.Command, args []string)

type Column struct {
	TableSchema      string
	TableName        string
	Name             string
	Default          string
	Nullable         bool
	DataType         string
	CharMaxLen       int
	NumericPrecision int
	NumericScale     int
}

type DbConstraint struct {
	// on table
	TableSchema string
	TableName   string
	ColName     string

	ConName          string
	ConSchema        string
	Type             string // can be 'p', 'f', 'c' or 'u'
	UpdateActionType string
	DeleteActionType string

	// foreign table
	FTableSchema string
	FTableName   string
	FColName     string

	Syntax string
}

type DbDumpFilesMap = map[string][]string

type DbMigration struct {
	// dir path will also contain the id (.../migrations/dbname/<timestamp>)
	DirPath  string
	IsActive bool
	Up       *DbMigration
	Down     *DbMigration
}

type DbRow struct {
	DataType string
	Value    interface{}
}

type DbRows = map[string][]DbRow

type DbSchema struct {
	DbName    string
	Tables    map[string]*TableSchema
	Views     map[string]*TableSchema
	Types     []DbType
	Schemas   []Schema
	Sequences []DbSequence
}

type DbSequence struct {
	Schema      string
	Name        string
	DataType    string
	IncrementBy int
	MinValue    int
	MaxValue    int
	StartValue  int
	CacheSize   int
	Cycle       bool
}

type DbType struct {
	Schema string
	Name   string
}

type DiffKey struct {
	Entity   Entity
	StateTag StateTag
}

type Entity struct {
	Type EntityType
	Id   []string

	// pointer to the real entity
	Ptr interface{}
}

type EntityType string

type MiddlewareFunc = func(fn CobraCmdFn) CobraCmdFn

type MigAction struct {
	ActionType ActionType
	StateTag   StateTag
	Entity     Entity

	/*
		For table, dep id is "schema.table", for col it's "schema.table.colname", for constraint/type it's "schema.name"
	*/
	DepArr []string
}

type MigrationStatus struct {
	Migrations      []DbMigration
	ActiveMigration *DbMigration
	IsInit          bool
}

type QueryResult struct {
	RowCount uint
	Data     DbRows
	Columns  []string
}

type Response struct {
	Message string
	Data    any
}

type SafeVar[T any] struct {
	// contains filtered or unexported fields
}

type Schema struct {
	Name string
}

type StateTag string

type Table struct {
	Schema string
	Name   string

	// IMP: possible values to be put in from constants 'TableType*'
	Type string
}

type TableSchema struct {
	Schema      string
	Name        string
	DefSyntax   string // populated for only views
	Columns     []Column
	Constraints []*DbConstraint
}