schema

type CheckConstraint struct {
	Name               string
	Expression         string
	IsValid            bool
	IsInheritable      bool
	DependsOnFunctions []SchemaQualifiedName
}

type Column struct {
	Name      string
	Type      string
	Collation SchemaQualifiedName
	// If the column has a default value, this will be a SQL string representing that value.
	// Examples:
	//   ”::text
	//   CURRENT_TIMESTAMP
	// If empty, indicates that there is no default value.
	Default    string
	IsNullable bool

	// Size is the number of bytes required to store the value.
	// It is used for data-packing purposes
	Size int //
}

type Extension struct {
	SchemaQualifiedName
	Version string
}

type ForeignKeyConstraint struct {
	EscapedName string
	OwningTable SchemaQualifiedName
	// TableUnescapedName is a hackaround until we switch over Tables to use fully-qualified, escaped names
	OwningTableUnescapedName string
	ForeignTable             SchemaQualifiedName
	// ForeignTableUnescapedName is hackaround for the same as above
	ForeignTableUnescapedName string
	ConstraintDef             string
	IsValid                   bool
}

type Function struct {
	SchemaQualifiedName
	// FunctionDef is the statement required to completely (re)create
	// the function, as returned by `pg_get_functiondef`. It is a CREATE OR REPLACE
	// statement
	FunctionDef string
	// Language is the language of the function. This is relevant in determining if we
	// can track the dependencies of the function (or not)
	Language           string
	DependsOnFunctions []SchemaQualifiedName
}

type GetIndexDefStatement string

type GetTriggerDefStatement string

type Index struct {
	TableName string
	Name      string
	Columns   []string
	IsInvalid bool
	IsUnique  bool

	Constraint *IndexConstraint

	// GetIndexDefStmt is the output of pg_getindexdef
	GetIndexDefStmt GetIndexDefStatement

	// ParentIdxName is the name of the parent index if the index is a partition of an index
	ParentIdxName string
}

type IndexConstraint struct {
	Type                  IndexConstraintType
	EscapedConstraintName string
	ConstraintDef         string
	IsLocal               bool
}

type IndexConstraintType string

type Object interface {
	// GetName is used to identify the old and new versions of a schema object between the old and new schemas
	// If the name is not present in the old schema objects list, then it is added
	// If the name is not present in the new schemas objects list, then it is removed
	// Otherwise, it has persisted across two schemas and is possibly altered
	GetName() string
}

type ReplicaIdentity string

type Schema struct {
	Extensions            []Extension
	Tables                []Table
	Indexes               []Index
	ForeignKeyConstraints []ForeignKeyConstraint
	Sequences             []Sequence
	Functions             []Function
	Triggers              []Trigger
}

type SchemaQualifiedName struct {
	SchemaName string
	// EscapedName is the name of the object. It should already be escaped
	// We take an escaped name because there are weird exceptions, like functions, where we can't just
	// surround the name in quotes
	EscapedName string
}

type Sequence struct {
	SchemaQualifiedName
	Owner      *SequenceOwner
	Type       string
	StartValue int64
	Increment  int64
	MaxValue   int64
	MinValue   int64
	CacheSize  int64
	Cycle      bool
}

type SequenceOwner struct {
	TableName SchemaQualifiedName
	// TableUnescapedName is a hackaround until we switch over Tables to use fully-qualified, escaped names
	TableUnescapedName string
	ColumnName         string
}

type Table struct {
	Name             string
	Columns          []Column
	CheckConstraints []CheckConstraint
	ReplicaIdentity  ReplicaIdentity

	// PartitionKeyDef is the output of Pg function pg_get_partkeydef:
	// PARTITION BY $PartitionKeyDef
	// If empty, then the table is not partitioned
	PartitionKeyDef string

	ParentTableName string
	ForValues       string
}

type Trigger struct {
	EscapedName string
	OwningTable SchemaQualifiedName
	// OwningTableUnescapedName lets us be backwards compatible with the TableSQLVertexGenerator, which
	// currently uses the unescaped name as the vertex id. This will be removed once the TableSQLVertexGenerator
	// is migrated to use SchemaQualifiedName
	OwningTableUnescapedName string
	Function                 SchemaQualifiedName
	// GetTriggerDefStmt is the statement required to completely (re)create the trigger, as returned
	// by pg_get_triggerdef
	GetTriggerDefStmt GetTriggerDefStatement
}