sql

Documentation

Index

• type Column
  • func (c *Column) PrefixName(prefix string) *Column
  • func (c *Column) Schema() string
• type FieldType
  • func ProtoTypeToSQL(kind protoreflect.Kind) (FieldType, error)
• type ForeignKeyConstraint
• type PrimaryKeyConstraint
  • func (p *PrimaryKeyConstraint) Schema() string
• type Schemer
• type Table
  • func (t *Table) Schema() string

Types

type Column

type Column struct {
	Type  FieldType
	Name  string
	Null  bool
	Array bool
}

func (*Column) PrefixName

func (c *Column) PrefixName(prefix string) *Column

func (*Column) Schema

func (c *Column) Schema() string

type FieldType

type FieldType string

const (
	SQLUnknown FieldType = ""

	SQLBoolean FieldType = "boolean"

	SQLSmallInt FieldType = "smallint"
	SQLInteger  FieldType = "integer"
	SQLBigInt   FieldType = "bigint"
	SQLReal     FieldType = "real"
	SQLDouble   FieldType = "double precision"

	SQLText FieldType = "text"

	SQLBytea FieldType = "bytea"

	SQLTimestampTimezone FieldType = "timestamp with time zone"
	SQLTimestamp         FieldType = "timestamp"
	SQLDate              FieldType = "date"
)

See https://www.postgresql.org/docs/current/datatype.html

func ProtoTypeToSQL

func ProtoTypeToSQL(kind protoreflect.Kind) (FieldType, error)

type ForeignKeyConstraint

type ForeignKeyConstraint struct {
	ForeignTableName string
	Columns          []*Column
}

type PrimaryKeyConstraint

type PrimaryKeyConstraint struct {
	Columns []*Column
}

func (*PrimaryKeyConstraint) Schema

func (p *PrimaryKeyConstraint) Schema() string

type Schemer

type Schemer interface {
	Schema() string
}

type Table

type Table struct {
	Name        string
	Columns     []*Column
	Constraints []Schemer
}

func (*Table) Schema

func (t *Table) Schema() string