constants

const (
	// Self
	SelfConfigDirName  = ".dbdaddy"
	SelfConfigFileName = "dbdaddy.config.json"
	SelfDbName         = "__daddys_home"

	//  Config keys
	DbConfigOriginsKey       = "origins"
	DbConfigConnSubkey       = "connection"
	DbConfigDriverKey        = DbConfigConnSubkey + ".driver"
	DbConfigHostKey          = DbConfigConnSubkey + ".host"
	DbConfigPortKey          = DbConfigConnSubkey + ".port"
	DbConfigDbNameKey        = DbConfigConnSubkey + ".dbname"
	DbConfigUserKey          = DbConfigConnSubkey + ".user"
	DbConfigPassKey          = DbConfigConnSubkey + ".password"
	DbConfigParamsKey        = DbConfigConnSubkey + ".params"
	DbConfigCurrentBranchKey = "status.currentBranch"

	// Config possible driver values
	DbDriverPostgres = "postgres"
	DbDriverMySQL    = "mysql"
	DbDriverSqlite   = "sqlite"

	// dumps
	PgDumpDir     = "pg_dumps"
	MySqlDumpDir  = "mysql_dumps"
	SqliteDumpDir = "sqlite_dumps"

	// project
	ScriptsDirName = "scripts"
	SchemaDirName  = "schema"

	// tmp
	TmpDir          = "tmp"
	TextQueryOutput = "query.out"
	CSVQueryOutput  = "query.csv"

	// misc
	SoftDeleteSuffix = "__DELETED"
)

const (
	TableTypeBaseTable = "BASE TABLE"
	TableTypeView      = "VIEW"
)

const (
	MigDirStateFile        = "state.json"
	MigDirActiveSignalFile = "active"
	MigDirInfoFile         = "info.md"
	MigDirUpSqlFile        = "up.sql"
	MigDirDownSqlFile      = "down.sql"
)

const (
	MigActionCreateTable = "CREATE_TABLE"
	MigActionDropTable   = "DROP_TABLE"

	MigActionCreateCol = "CREATE_COLUMN"
	MigActionDropCol   = "DROP_COLUMN"

	MigActionCreateType = "CREATE_TYPE"
	MigActionDropType   = "DROP_TYPE"

	MigActionCreateConstraint = "CREATE_CONSTRAINT"
	MigActionDropConstraint   = "DROP_CONSTRAINT"

	MigActionCreateView = "CREATE_VIEW"
	MigActionDropView   = "DROP_VIEW"
)

const (
	PgBigInt            = "bigint"
	PgBigSerial         = "bigserial"
	PgBit               = "bit"
	PgBitVarying        = "bit varying"
	PgBoolean           = "boolean"
	PgBox               = "box"
	PgBytea             = "bytea"
	PgCharacter         = "character"
	PgCharacterVarying  = "character varying"
	PgCidr              = "cidr"
	PgCircle            = "circle"
	PgDate              = "date"
	PgDoublePrecision   = "double precision"
	PgInet              = "inet"
	PgInteger           = "integer"
	PgInterval          = "interval"
	PgJSON              = "json"
	PgJSONB             = "jsonb"
	PgLine              = "line"
	PgLseg              = "lseg"
	PgMacaddr           = "macaddr"
	PgMacaddr8          = "macaddr8"
	PgMoney             = "money"
	PgNumeric           = "numeric"
	PgPath              = "path"
	PgPgLsn             = "pg_lsn"
	PgPgSnapshot        = "pg_snapshot"
	PgPoint             = "point"
	PgPolygon           = "polygon"
	PgReal              = "real"
	PgSmallInt          = "smallint"
	PgSmallSerial       = "smallserial"
	PgSerial            = "serial"
	PgText              = "text"
	PgTime              = "time"
	PgTimeWithTimeZone  = "time with time zone"
	PgTimestamp         = "timestamp"
	PgTimestampWithZone = "timestamp with time zone"
	PgTsquery           = "tsquery"
	PgTsvector          = "tsvector"
	PgTxidSnapshot      = "txid_snapshot"
	PgUUID              = "uuid"
	PgXML               = "xml"
)

const (
	MigDirName = "migrations"
)

const (
	MigFileIndentation = "    "
)