modelv005

Documentation

Index

• type DBTX
• type Email
• type EmailType
• type FlywaySchemaHistory
• type PeopleView
• type Person
• type PhoneNumber
• type PhoneType
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) GetEmail(ctx context.Context, emailID int32) (Email, error)
  • func (q *Queries) GetSchemaVersion(ctx context.Context) (int64, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type State

Types

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Email

type Email struct {
	EmailID      int32
	EmailAddress sql.NullString
	EmailType    string
	PersonID     int32
}

type EmailType

type EmailType struct {
	EmailType   string
	Description sql.NullString
}

type FlywaySchemaHistory

type FlywaySchemaHistory struct {
	InstalledRank int32
	Version       sql.NullString
	Description   string
	Type          string
	Script        string
	Checksum      sql.NullInt32
	InstalledBy   string
	InstalledOn   time.Time
	ExecutionTime int32
	Success       bool
}

type PeopleView

type PeopleView struct {
	PersonID     int32
	FirstName    sql.NullString
	LastName     sql.NullString
	PhoneNumber  sql.NullString
	AddressLine1 sql.NullString
	AddressLine2 sql.NullString
	City         sql.NullString
	State        sql.NullString
	ZipCode      sql.NullString
}

type Person

type Person struct {
	PersonID     int32
	FirstName    sql.NullString
	LastName     sql.NullString
	AddressLine1 sql.NullString
	AddressLine2 sql.NullString
	City         sql.NullString
	State        sql.NullString
	ZipCode      sql.NullString
}

type PhoneNumber

type PhoneNumber struct {
	PhoneNumberID int32
	PhoneNumber   sql.NullString
	PhoneType     sql.NullString
	PersonID      int32
}

type PhoneType

type PhoneType struct {
	PhoneType   sql.NullString
	Description sql.NullString
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) GetEmail

func (q *Queries) GetEmail(ctx context.Context, emailID int32) (Email, error)

func (*Queries) GetSchemaVersion

func (q *Queries) GetSchemaVersion(ctx context.Context) (int64, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type State

type State struct {
	State       string
	Description sql.NullString
}