Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

pgsql

package

Go to main page

Versions in this module

v1

v1.3.2

May 16, 2022

v1.3.1

Apr 28, 2021

v1.3.0

Mar 24, 2021

v1.1.0

Mar 24, 2021

Changes in this version

type Column

+ HintUsing string

type ParseCtx

+ Config *target.Config

v1.0.0

Mar 22, 2021

Changes in this version

+ const DC_TYPE_C

+ const DC_TYPE_CH

+ const DC_TYPE_FK

+ const DC_TYPE_PK

+ const DC_TYPE_UQ

+ func DbClose(db interface{})

+ func DbExec(db interface{}, stmt string, args ...interface{}) error

+ func DbPing(db interface{}) error

+ func MergeAddOperation(dest *string, elem string)

+ func MergeCheck(mrg *StmtCtx, localTable *Table, remTable *Table, ss *MergeScriptCtx)

+ func MergeColumns(rem *StmtCtx, localTable *Table, remTable *Table, ts *MergeTableCtx, ...)

+ func MergeCompareCColumn(c1 []ConstraintColumn, c2 []ConstraintColumn) bool

+ func MergeCompareColumn(m *StmtCtx, c1 *Column, c2 *Column) bool

+ func MergeDropRecreate(m *StmtCtx, dc []MergeDropCtx, ss *MergeScriptCtx, ts *MergeTableCtx)

+ func MergeDropRecreateColRefs(m *StmtCtx, tables []Table, create *string, dc []MergeDropCtx)

+ func MergeDropRecreatePkRefs(m *StmtCtx, tables []Table, create *string, dc []MergeDropCtx)

+ func MergeFK(mrg *StmtCtx, localTable *Table, remTable *Table, ss *MergeScriptCtx)

+ func MergeIx(mrg *StmtCtx, localTable *Table, remTable *Table, ss *MergeScriptCtx)

+ func MergePrimary(mrg *StmtCtx, localTable *Table, remTable *Table, ss *MergeScriptCtx, ...)

+ func MergeUnique(mrg *StmtCtx, localTable *Table, remTable *Table, ss *MergeScriptCtx)

+ func ParserGetValidateTable(path string, fc []byte, args interface{}) error

+ func ParserIsDirectory(path string) (bool, error)

+ func ParserValidateCColumn(c []ConstraintColumn) error

+ func ParserValidateCheck(checks []Check) error

+ func ParserValidateColumn(ctx *StmtCtx, c []Column) error

+ func ParserValidateConstraint(c Constraint) error

+ func ParserValidateFK(fks []ForeignKey) error

+ func ParserValidateIndex(ixs []Index) error

+ func ParserValidatePK(pk *PrimaryKey) error

+ func ParserValidateTable(ctx *StmtCtx, t *Table, f string) error

+ func ParserValidateUnique(us []Unique) error

+ func StmtAddCheck(tableName string, c *Check) string

+ func StmtAddConstraint(tableName string, c *Constraint, cType string) string

+ func StmtAddFk(tableName string, fk *ForeignKey) string

+ func StmtAddPK(tableName string, pk *PrimaryKey) string

+ func StmtAddUnique(tableName string, u *Unique) string

+ func StmtColumnNameAndType(column *Column) string

+ func StmtConstraintColumn(c ConstraintColumn) string

+ func StmtDropConstraint(tableName string, c *Constraint) string

+ func StmtDropTable(table *Table) string

+ type Check struct

+ Def string

+ Name string

+ func HelperMapChecks(r *sql.Rows) ([]Check, error)

+ type Column struct

+ Default string

+ FullType string

+ HintDTUsing string

+ Identity bool

+ Length int

+ Name string

+ Nullable bool

+ Precision int

+ Scale int

+ Tags map[string]struct{}

+ Type string

+ func (c *Column) HasTag(tag string) bool

+ type Constraint struct

+ Columns []ConstraintColumn

+ Name string

+ type ConstraintColumn struct

+ Is_descending bool

+ Name string

+ func HelperMapCColumns(r *sql.Rows) ([]ConstraintColumn, error)

type DDObject

+ func ParserGetTablesInDir(ctx *StmtCtx, dir string) ([]DDObject, error)

+ type ForeignKey struct

+ OnDelete string

+ OnUpdate string

+ Ref_columns []ConstraintColumn

+ Ref_table string

+ type Index struct

+ Columns []IndexColumn

+ Is_clustered bool

+ Name string

+ Using string

+ type IndexColumn struct

+ Is_Included_column bool

+ Is_descending bool

+ Name string

+ func HelperMapIxColumns(rows *sql.Rows) ([]IndexColumn, error)

+ type MergeDropCtx struct

+ Check *Check

+ Column *Column

+ Foreign *ForeignKey

+ Primary *PrimaryKey

+ Table string

+ Type uint

+ Unique *Unique

+ func MergeDropColRefs(m *StmtCtx, col *Column, table *Table, tables []Table, drop *string) []MergeDropCtx

+ func MergeDropNewC(tablename string, c *Column) MergeDropCtx

+ func MergeDropNewFK(tableName string, fk *ForeignKey) MergeDropCtx

+ func MergeDropNewPK(tableName string, pk *PrimaryKey) MergeDropCtx

+ func MergeDropNewUnique(tablename string, u *Unique) MergeDropCtx

+ func MergeDropPkRefs(m *StmtCtx, tableName string, tables []Table, drop *string) []MergeDropCtx

+ func (d MergeDropCtx) IsC() bool

+ func (d MergeDropCtx) IsCh() bool

+ func (d MergeDropCtx) IsFk() bool

+ func (d MergeDropCtx) IsPk() bool

+ func (d MergeDropCtx) IsUq() bool

+ type MergeScriptCtx struct

+ Create *string

+ Drop *string

+ type MergeTableCtx struct

+ LocalTables []Table

+ RemoteTables []Table

+ type PrimaryKey struct

type StmtCtx

+ AddCheck func(string, *Check) string

+ AddColumn func(string, *Column) string

+ AddFK func(string, *ForeignKey) string

+ AddIndex func(string, *Index) string

+ AddPK func(string, *PrimaryKey) string

+ AddUnique func(string, *Unique) string

+ AlterColumn func(string, *Column, *Column) string

+ ColumnType func(*Column) string

+ CreateTable func(*Table) string

+ DropColumn func(string, *Column) string

+ DropConstraint func(string, *Constraint) string

+ DropIndex func(string, *Index) string

+ DropTable func(*Table) string

+ type Table struct

+ Check []Check

+ Columns []Column

+ Foreign []ForeignKey

+ Indexes []Index

+ Name string

+ Primary *PrimaryKey

+ Type string

+ Unique []Unique

+ func MergeFindTable(name string, tables []Table) *Table

+ type Unique struct

v0

v0.2.2

Mar 18, 2021

v0.2.1

Mar 18, 2021

v0.2.0

Jan 21, 2021

v0.1.0

Jan 21, 2021

Changes in this version

+ const TypeComposite

+ const TypeEnum

+ func HelperMapColumns(r *sql.Rows) ([]rdbms.Column, error)

+ func HelperTypeExists(t *Type, localTypes []Type) bool

+ func Merge(mrg *StmtCtx, tableCtx *rdbms.MergeTableCtx, typeCtx *MergeTypeCtx) (string, error)

+ func MergeComposite(r *StmtCtx, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx, lt *Type, ...)

+ func MergeDropCompositeTypeColumnRefs(r *rdbms.StmtCtx, lt *Type, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx, ...) []rdbms.MergeDropCtx

+ func MergeDropTypeRefs(m *rdbms.StmtCtx, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx, lt *Type) []rdbms.MergeDropCtx

+ func MergeEnum(r *StmtCtx, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx, lt *Type, ...)

+ func MergeTables(ctx *StmtCtx, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx)

+ func MergeType(r *StmtCtx, ts *rdbms.MergeTableCtx, ss *rdbms.MergeScriptCtx, lt *Type, ...)

+ func MergeTypes(m *StmtCtx, tt *MergeTypeCtx, ts *rdbms.MergeTableCtx, ...)

+ func ParserElevateErrorType(tname string, err error) error

+ func ParserGetValidateObject(path string, fc []byte, args interface{}) error

+ func ParserValidateType(ctx *rdbms.StmtCtx, t *Type, path string) error

+ func RemoteGetAllCheck(db *sql.DB, tableName string) ([]rdbms.Check, error)

+ func RemoteGetAllColumn(db *sql.DB, tableName string) ([]rdbms.Column, error)

+ func RemoteGetAllFK(db *sql.DB, tableName string) ([]rdbms.ForeignKey, error)

+ func RemoteGetAllIx(db *sql.DB, tableName string) ([]rdbms.Index, error)

+ func RemoteGetAllPK(db *sql.DB, tableName string) (*rdbms.PrimaryKey, error)

+ func RemoteGetAllUnique(db *sql.DB, tableName string) ([]rdbms.Unique, error)

+ func RemoteGetMatchedTables(db *sql.DB, userTables []rdbms.Table) ([]rdbms.Table, error)

+ func RemoteGetTable(db *sql.DB, tableName string) (*rdbms.Table, error)

+ func RemoteGetTypedTableInfo(db *sql.DB, t *rdbms.Table) error

+ func StmtAddColumn(tableName string, c *rdbms.Column) string

+ func StmtAddIndex(tableName string, ix *rdbms.Index) string

+ func StmtAddType(t *Type) string

+ func StmtAlterColumn(tableName string, sc, c *rdbms.Column) string

+ func StmtColumnType(column *rdbms.Column) string

+ func StmtCreateTable(t *rdbms.Table) string

+ func StmtDropColumn(tablename string, c *rdbms.Column) string

+ func StmtDropIndex(tableName string, i *rdbms.Index) string

+ func StmtDropType(t *Type) string

+ func TargetCtxNew() *target.Ctx

+ func TargetGetCS(target *target.Target) (string, error)

+ func TargetGetDB(target *target.Target) (interface{}, error)

+ func TargetGetMergeScript(dbCtx interface{}, ectx *target.Target, args []string) (string, error)

+ type DDObject struct

+ Table *rdbms.Table

+ Type *Type

+ func ParserGetObjectsInDir(ctx *StmtCtx, dir string) ([]DDObject, error)

+ type MergeTypeCtx struct

+ type ParseCtx struct

+ Stmt *StmtCtx

+ type StmtCtx struct

+ AddType func(*Type) string

+ DropType func(*Type) string

+ func StmtNew() *StmtCtx

+ type Type struct

+ Columns []rdbms.Column

+ Name string

+ Type string

+ Values []string

+ func MergeFindType(t *Type, ts []Type) *Type

+ func RemoteGetComposite(db *sql.DB) ([]Type, error)

+ func RemoteGetEnum(db *sql.DB) ([]Type, error)

+ func RemoteGetTypes(db *sql.DB, localTypes []Type) ([]Type, error)