jgpg

README

postgresql

操作postgresql的脚手架函数 基于gorm.io/gorm

Documentation

Index

• Constants
• type Helper
  • func NewHelper(db *gorm.DB) *Helper
  • func (h *Helper) QueryAllTables() ([]string, error)
  • func (h *Helper) QueryCreateTableSql(tableName string) (string, error)
  • func (h *Helper) QueryDBCharset() (string, error)
  • func (h *Helper) QueryDBCollate() (string, error)
  • func (h *Helper) QueryDBVersion() (string, error)

Constants

const (
	// 字段类型
	CT_SMALLINT    = "SMALLINT"
	CT_INT         = "INT"
	CT_BIGINT      = "BIGINT"
	CT_DECIMAL     = "DECIMAL"
	CT_FLOAT       = "FLOAT"
	CT_DOUBLE      = "DOUBLE"
	CT_TEXT        = "TEXT"
	CT_CHAR        = "CHAR"
	CT_VARCHAR     = "VARCHAR"
	CT_JSON        = "JSON"
	CT_JSONB       = "JSONB"
	CT_DATE        = "DATE"
	CT_TIME        = "TIME"
	CT_TIMESTAMP   = "TIMESTAMP"
	CT_BOOL        = "BOOL"
	CT_TIMETZ      = "TIMETZ"
	CT_TIMESTAMPTZ = "TIMESTAMPTZ"
	CT_BYTEA       = "BYTEA"
)

Types

type Helper

type Helper struct {
	DB *gorm.DB
}

func NewHelper

func NewHelper(db *gorm.DB) *Helper

func (*Helper) QueryAllTables

func (h *Helper) QueryAllTables() ([]string, error)

query all tables of database

func (*Helper) QueryCreateTableSql

func (h *Helper) QueryCreateTableSql(tableName string) (string, error)

query create table sql

func (*Helper) QueryDBCharset

func (h *Helper) QueryDBCharset() (string, error)

query charset of database

func (*Helper) QueryDBCollate

func (h *Helper) QueryDBCollate() (string, error)

query collate of database

func (*Helper) QueryDBVersion

func (h *Helper) QueryDBVersion() (string, error)

query version of database