sql

Documentation

Index

• func DictionaryToSQL(dict types.DictionaryRepresentable, dialect SQLDialect, includeSchema bool) (string, error)
• type DEFINITIONS
• type DICTIONARIES
• type ENTRIES
• type ETYMOLOGIES
• type EXAMPLES
• type GROUPS
• type NOTES
• type SENSES
• type SQLBuilder
  • func (builder *SQLBuilder) AddCommand(cmd sq.SQLWriter)
  • func (builder *SQLBuilder) Build(dialect SQLDialect) (string, error)
• type SQLDialect

Functions

func DictionaryToSQL

func DictionaryToSQL(dict types.DictionaryRepresentable, dialect SQLDialect, includeSchema bool) (string, error)

Types

type DEFINITIONS

type DEFINITIONS struct {
	sq.TableStruct
	ID       sq.UUIDField   `ddl:"primarykey"`
	VALUE    sq.StringField `ddl:"notnull"`
	SENSE_ID sq.UUIDField   `ddl:"references=senses.id"`
	GROUP_ID sq.UUIDField   `ddl:"references=groups.id"`
}

type DICTIONARIES

type DICTIONARIES struct {
	sq.TableStruct
	ID   sq.UUIDField   `ddl:"primarykey"`
	NAME sq.StringField `ddl:"notnull"`
}

type ENTRIES

type ENTRIES struct {
	sq.TableStruct
	ID            sq.UUIDField `ddl:"primarykey"`
	CREATED_AT    sq.TimeField `ddl:"default=CURRENT_TIMESTAMP"`
	UPDATED_AT    sq.TimeField
	TERM          sq.StringField `ddl:"notnull"`
	DICTIONARY_ID sq.UUIDField   `ddl:"references=dictionaries.id"`
}

type ETYMOLOGIES

type ETYMOLOGIES struct {
	sq.TableStruct
	ID          sq.UUIDField `ddl:"primarykey"`
	DESCRIPTION sq.StringField
	ENTRY_ID    sq.UUIDField `ddl:"notnull references=entries.id"`
}

type EXAMPLES

type EXAMPLES struct {
	sq.TableStruct
	ID            sq.StringField `ddl:"primarykey"`
	TEXT          sq.StringField `ddl:"notnull"`
	DEFINITION_ID sq.UUIDField   `ddl:"references=definitions.id"`
	NOTE_ID       sq.UUIDField   `ddl:"references=notes.id"`
}

type GROUPS

type GROUPS struct {
	sq.TableStruct
	ID          sq.UUIDField `ddl:"primarykey"`
	DESCRIPTION sq.StringField
	SENSE_ID    sq.UUIDField `ddl:"notnull references=senses.id"`
}

type NOTES

type NOTES struct {
	sq.TableStruct
	ID            sq.UUIDField `ddl:"primarykey"`
	VALUE         sq.StringField
	DEFINITION_ID sq.UUIDField `ddl:"notnull references=definitions.id"`
}

type SENSES

type SENSES struct {
	sq.TableStruct
	ID           sq.UUIDField `ddl:"primarykey"`
	POS          sq.EnumField `ddl:"default='unknown'"`
	ETYMOLOGY_ID sq.UUIDField `ddl:"notnull references=etymologies.id"`
}

type SQLBuilder

type SQLBuilder struct {
	// contains filtered or unexported fields
}

func (*SQLBuilder) AddCommand

func (builder *SQLBuilder) AddCommand(cmd sq.SQLWriter)

func (*SQLBuilder) Build

func (builder *SQLBuilder) Build(dialect SQLDialect) (string, error)

type SQLDialect

type SQLDialect = string