gopgdbgen

README

gopgdbgen

Documentation

Index

• Variables
• type Config
• type DatabaseConfig
• type DbGenerator
  • func NewGenerator() *DbGenerator
  • func (dbg *DbGenerator) BuildDatabase(sqlfiles []string) error
  • func (dbg *DbGenerator) ClearDdlDirectory() error
  • func (dbg *DbGenerator) ComposeTableFromJson(filepath string) (tbl *Table, err error)
  • func (dbg *DbGenerator) GenerateAll() ([]string, error)
  • func (dbg *DbGenerator) ReadConfiguration(configfilepath string)
• type DirectoryConfig
• type Field
  • func (f *Field) AddFieldDdl() string
  • func (f *Field) AlterFieldDdl() []string
  • func (f *Field) CreateFieldDdl() string
• type Relation
• type Table
  • func NewTable(jsondata []byte) (tbl *Table, err error)
  • func (tbl *Table) AddMandatoryFields() []string
  • func (tbl *Table) GetRelations() []*Relation
  • func (tbl *Table) WriteSql(sqlfilepath string) error
• type TableRelations
  • func NewTableRelations() *TableRelations
  • func (t *TableRelations) Add(r []*Relation)
  • func (t *TableRelations) WriteSql(sqlfilepath string) error

Variables

var ColorBlue = "\033[34m"

var ColorCyan = "\033[36m"

var ColorGray = "\033[37m"

var ColorGreen = "\033[32m"

var ColorMagenta = "\033[35m"

var ColorRed = "\033[31m"

var ColorReset = "\033[0m"

var ColorWhite = "\033[97m"

var ColorYellow = "\033[33m"

var FieldProp []string = []string{"name", "descr", "type", "length", "precision", "nullable", "default"}

var RelationProp []string = []string{"key", "name", "table", "field"}

var TableProp []string = []string{"schema", "table", "descr", "fields", "primarykeys", "uniques", "relations"}

Types

type Config

type Config struct {
	Database    *DatabaseConfig  `yml:"database"`
	Directories *DirectoryConfig `yml:"directories"`
}

type DatabaseConfig

type DatabaseConfig struct {
	Host     string `yml:"host"`
	Port     int    `yml:"port"`
	Dbname   string `yml:"dbname"`
	Username string `yml:"username"`
	Password string `yml:"password"`
}

type DbGenerator

type DbGenerator struct {
	Config *Config
}

func NewGenerator

func NewGenerator() *DbGenerator

func (*DbGenerator) BuildDatabase

func (dbg *DbGenerator) BuildDatabase(sqlfiles []string) error

func (*DbGenerator) ClearDdlDirectory

func (dbg *DbGenerator) ClearDdlDirectory() error

func (*DbGenerator) ComposeTableFromJson

func (dbg *DbGenerator) ComposeTableFromJson(filepath string) (tbl *Table, err error)

func (*DbGenerator) GenerateAll

func (dbg *DbGenerator) GenerateAll() ([]string, error)

func (*DbGenerator) ReadConfiguration

func (dbg *DbGenerator) ReadConfiguration(configfilepath string)

type DirectoryConfig

type DirectoryConfig struct {
	Ddl string `yml:"./dbbuild/ddl"`
	Tbl string `yml:"./dbbuild/tbl"`
}

type Field

type Field struct {
	Name         string `json:"name"`
	Description  string `json:"descr"`
	DataType     string `json:"type"`
	Length       int    `json:"length"`
	Precision    int    `json:"precision"`
	Nullable     bool   `json:"nullable"`
	DefaultValue string `json:"default"`
	IsPrimaryKey bool
}

func (*Field) AddFieldDdl

func (f *Field) AddFieldDdl() string

func (*Field) AlterFieldDdl

func (f *Field) AlterFieldDdl() []string

func (*Field) CreateFieldDdl

func (f *Field) CreateFieldDdl() string

type Relation

type Relation struct {
	Name     string `json:"name"`
	Table    string
	Key      string `json:"key"`
	RefTable string `json:"reftable"`
	RefKey   string `json:"refkey"`
}

type Table

type Table struct {
	Schema      string               `json:"schema"`
	TableName   string               `json:"table"`
	Description string               `json:"descr"`
	Fields      map[string]*Field    `json:"fields"`
	PrimaryKeys []string             `json:"primarykeys"`
	Uniques     map[string]*[]string `json:"uniques"`
	Relations   map[string]Relation  `json:"relations"`

	FieldNames []string
	PropNames  []string
}

func NewTable

func NewTable(jsondata []byte) (tbl *Table, err error)

func (*Table) AddMandatoryFields

func (tbl *Table) AddMandatoryFields() []string

func (*Table) GetRelations

func (tbl *Table) GetRelations() []*Relation

func (*Table) WriteSql

func (tbl *Table) WriteSql(sqlfilepath string) error

type TableRelations

type TableRelations struct {
	Relations []*Relation
}

func NewTableRelations

func NewTableRelations() *TableRelations

func (*TableRelations) Add

func (t *TableRelations) Add(r []*Relation)

func (*TableRelations) WriteSql

func (t *TableRelations) WriteSql(sqlfilepath string) error