database

Documentation

Index

• Constants
• type Database
  • func ReverseEngineering() (*Database, error)
• type Field
• type Table

Constants

const (
	DsnTemplate = "postgresql://%s:%s@%s:%d/%s?TimeZone=%s"

	TableInfoSQL = "SELECT tableName FROM pg_tables WHERE tableName NOT LIKE 'pg%' AND tableName NOT LIKE 'sql_%' ORDER BY tableName"

	ColumnInfoSQL = `` /* 1185-byte string literal not displayed */

)

const (
	TimeZone = "Asia%2FShanghai"
)

Types

type Database

type Database struct {
	Name   string `json:"name"`
	Tables []*Table
}

func ReverseEngineering

func ReverseEngineering() (*Database, error)

type Field

type Field struct {
	TableComment string `json:"tableComment"`
	Name         string `json:"name"`
	Type         string `json:"type"`
	Comment      string `json:"comment"`
	TypLen       int    `json:"typLen"`
	TypLength    string `json:"typLength"`
	NotNull      bool   `json:"notNull"`
	PrimaryKey   bool   `json:"primarykey"`
}

type Table

type Table struct {
	Name    string `json:"tableName"`
	Comment string `json:"comment"`
	Fields  []*Field
}