sqlpostgresql

Documentation

Index

• type ColumnInfo
• type EventInfo
• type ForeignKeyInfo
• type FunctionInfo
• type IndexInfo
• type PostgreSQLExtraData
  • func (e *PostgreSQLExtraData) IsBlockEnd(line string) bool
• type PostgreSQLType
  • func (t PostgreSQLType) AsInt() int
  • func (t PostgreSQLType) IsBlock() bool
  • func (t PostgreSQLType) IsNull() bool
  • func (t PostgreSQLType) String() string
• type PrimaryKeyInfo
• type ProcedureInfo
• type TriggerInfo
• type ViewInfo

Types

type ColumnInfo

type ColumnInfo struct {
	ColumnName             string         `db:"column_name"`
	DataType               string         `db:"data_type"`
	CharacterMaximumLength sql.NullInt64  `db:"character_maximum_length"`
	IsNullable             string         `db:"is_nullable"`
	ColumnDefault          sql.NullString `db:"column_default"`
	DefaultExpr            sql.NullString `db:"default_expr"`
}

ColumnInfo 表字段信息

type EventInfo

type EventInfo struct {
	JobName  string `db:"jobname"`
	Schedule string `db:"schedule"`
	Command  string `db:"command"`
}

EventInfo 事件信息

type ForeignKeyInfo

type ForeignKeyInfo struct {
	ColumnName         string `db:"column_name"`
	ForeignTableSchema string `db:"foreign_table_schema"`
	ForeignTableName   string `db:"foreign_table_name"`
	ForeignColumnName  string `db:"foreign_column_name"`
	DeleteRule         string `db:"delete_rule"`
	UpdateRule         string `db:"update_rule"`
}

ForeignKeyInfo 外键信息

type FunctionInfo

type FunctionInfo struct {
	FuncDefinition string `db:"func_definition"`
}

FunctionInfo 函数信息

type IndexInfo

type IndexInfo struct {
	IndexName  string `db:"index_name"`
	ColumnName string `db:"column_name"`
	IsUnique   string `db:"is_unique"`
}

IndexInfo 索引信息

type PostgreSQLExtraData

type PostgreSQLExtraData struct {
	EndMarks      map[string]struct{}
	DollarQuote   string
	InDollarQuote bool
}

PostgreSQLExtraData implements the ExtraData interface for PostgreSQL

func (*PostgreSQLExtraData) IsBlockEnd

func (e *PostgreSQLExtraData) IsBlockEnd(line string) bool

type PostgreSQLType

type PostgreSQLType int

PostgreSQLType implements the SQLType interface for PostgreSQL

const (
	PostgreSQLTypeUnknown PostgreSQLType = iota
	PostgreSQLTypeSelect
	PostgreSQLTypeInsert
	PostgreSQLTypeUpdate
	PostgreSQLTypeDelete
	PostgreSQLTypeCreateTable
	PostgreSQLTypeCreateIndex
	PostgreSQLTypeCreateView
	PostgreSQLTypeCreateFunction
	PostgreSQLTypeCreateProcedure
	PostgreSQLTypeCreateTrigger
	PostgreSQLTypeDrop
	PostgreSQLTypeAlter
	PostgreSQLTypeTransaction
	PostgreSQLTypeOther
)

func (PostgreSQLType) AsInt

func (t PostgreSQLType) AsInt() int

AsInt returns the integer representation of the SQL type

func (PostgreSQLType) IsBlock

func (t PostgreSQLType) IsBlock() bool

IsBlock determines if the SQL type represents a block statement

func (PostgreSQLType) IsNull

func (t PostgreSQLType) IsNull() bool

func (PostgreSQLType) String

func (t PostgreSQLType) String() string

String returns the string representation of the SQL type

type PrimaryKeyInfo

type PrimaryKeyInfo struct {
	ColumnName string `db:"column_name"`
}

PrimaryKeyInfo 主键信息

type ProcedureInfo

type ProcedureInfo struct {
	ProcDefinition string `db:"proc_definition"`
	ProcName       string `db:"proc_name"`
	ProcKind       string `db:"proc_kind"`
}

ProcedureInfo 存储过程信息

type TriggerInfo

type TriggerInfo struct {
	TriggerName       string `db:"trigger_name"`
	TriggerDefinition string `db:"trigger_definition"`
}

TriggerInfo 触发器信息

type ViewInfo

type ViewInfo struct {
	ViewDefinition string `db:"view_definition"`
}

ViewInfo 视图信息