models

package
v0.3.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 21, 2021 License: MIT Imports: 8 Imported by: 0

Documentation

Overview

Package models contains generated code for schema 'public'.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Errorf

func Errorf(s string, v ...interface{})

Errorf logs an error message using the package error logger.

func Logf

func Logf(s string, v ...interface{})

Logf logs a message using the package logger.

func MysqlSchema

func MysqlSchema(ctx context.Context, db DB) (string, error)

MysqlSchema retrieves the schema.

func MysqlViewCreate

func MysqlViewCreate(ctx context.Context, db DB, schema, id string, query []string) (sql.Result, error)

MysqlViewCreate creates a view for introspection.

func MysqlViewDrop

func MysqlViewDrop(ctx context.Context, db DB, schema, id string) (sql.Result, error)

MysqlViewDrop drops a view created for introspection.

func OracleSchema

func OracleSchema(ctx context.Context, db DB) (string, error)

OracleSchema retrieves the schema.

func OracleViewCreate

func OracleViewCreate(ctx context.Context, db DB, schema, id string, query []string) (sql.Result, error)

OracleViewCreate creates a view for introspection.

func OracleViewDrop

func OracleViewDrop(ctx context.Context, db DB, schema, id string) (sql.Result, error)

OracleViewDrop drops a view created for introspection.

func OracleViewTruncate

func OracleViewTruncate(ctx context.Context, db DB, schema, id string) (sql.Result, error)

OracleViewTruncate truncates a view created for introspection.

func PostgresSchema

func PostgresSchema(ctx context.Context, db DB) (string, error)

PostgresSchema retrieves the schema.

func PostgresViewCreate

func PostgresViewCreate(ctx context.Context, db DB, schema, id string, query []string) (sql.Result, error)

PostgresViewCreate creates a view for introspection.

func PostgresViewDrop

func PostgresViewDrop(ctx context.Context, db DB, schema, id string) (sql.Result, error)

PostgresViewDrop drops a view created for introspection.

func PostgresViewSchema

func PostgresViewSchema(ctx context.Context, db DB, id string) (string, error)

PostgresViewSchema retrieves the schema for a view created for introspection.

func SetErrorLogger

func SetErrorLogger(logger interface{})

SetErrorLogger sets the package error logger. Valid logger types:

io.Writer
func(string, ...interface{}) (int, error) // fmt.Printf
func(string, ...interface{}) // log.Printf

func SetLogger

func SetLogger(logger interface{})

SetLogger sets the package logger. Valid logger types:

io.Writer
func(string, ...interface{}) (int, error) // fmt.Printf
func(string, ...interface{}) // log.Printf

func Sqlite3Schema

func Sqlite3Schema(ctx context.Context, db DB) (string, error)

Sqlite3Schema retrieves the schema.

func Sqlite3ViewCreate

func Sqlite3ViewCreate(ctx context.Context, db DB, schema, id string, query []string) (sql.Result, error)

Sqlite3ViewCreate creates a view for introspection.

func Sqlite3ViewDrop

func Sqlite3ViewDrop(ctx context.Context, db DB, schema, id string) (sql.Result, error)

Sqlite3ViewDrop drops a view created for introspection.

func SqlserverSchema

func SqlserverSchema(ctx context.Context, db DB) (string, error)

SqlserverSchema retrieves the schema.

func SqlserverViewCreate

func SqlserverViewCreate(ctx context.Context, db DB, schema, id string, query []string) (sql.Result, error)

SqlserverViewCreate creates a view for introspection.

func SqlserverViewDrop

func SqlserverViewDrop(ctx context.Context, db DB, schema, id string) (sql.Result, error)

SqlserverViewDrop drops a view created for introspection.

Types

type Column

type Column struct {
	FieldOrdinal int            `json:"field_ordinal"`  // field_ordinal
	ColumnName   string         `json:"column_name"`    // column_name
	DataType     string         `json:"data_type"`      // data_type
	NotNull      bool           `json:"not_null"`       // not_null
	DefaultValue sql.NullString `json:"default_value"`  // default_value
	IsPrimaryKey bool           `json:"is_primary_key"` // is_primary_key
}

Column is a column.

func MysqlTableColumns

func MysqlTableColumns(ctx context.Context, db DB, schema, table string) ([]*Column, error)

MysqlTableColumns runs a custom query, returning results as Column.

func OracleTableColumns

func OracleTableColumns(ctx context.Context, db DB, schema, table string) ([]*Column, error)

OracleTableColumns runs a custom query, returning results as Column.

func PostgresTableColumns

func PostgresTableColumns(ctx context.Context, db DB, schema, table string, sys bool) ([]*Column, error)

PostgresTableColumns runs a custom query, returning results as Column.

func Sqlite3TableColumns

func Sqlite3TableColumns(ctx context.Context, db DB, schema, table string) ([]*Column, error)

Sqlite3TableColumns runs a custom query, returning results as Column.

func SqlserverTableColumns

func SqlserverTableColumns(ctx context.Context, db DB, schema, table string) ([]*Column, error)

SqlserverTableColumns runs a custom query, returning results as Column.

type DB

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

DB is the common interface for database operations that can be used with types from schema 'public'.

This works with both database/sql.DB and database/sql.Tx.

type Enum

type Enum struct {
	EnumName string `json:"enum_name"` // enum_name
}

Enum is a enum.

func MysqlEnums

func MysqlEnums(ctx context.Context, db DB, schema string) ([]*Enum, error)

MysqlEnums runs a custom query, returning results as Enum.

func PostgresEnums

func PostgresEnums(ctx context.Context, db DB, schema string) ([]*Enum, error)

PostgresEnums runs a custom query, returning results as Enum.

type EnumValue

type EnumValue struct {
	EnumValue  string `json:"enum_value"`  // enum_value
	ConstValue int    `json:"const_value"` // const_value
}

EnumValue is a enum value.

func PostgresEnumValues

func PostgresEnumValues(ctx context.Context, db DB, schema, enum string) ([]*EnumValue, error)

PostgresEnumValues runs a custom query, returning results as EnumValue.

type ErrDecodeFailed

type ErrDecodeFailed struct {
	Err error
}

ErrDecodeFailed is the decode failed error.

func (*ErrDecodeFailed) Error

func (err *ErrDecodeFailed) Error() string

Error satisfies the error interface.

func (*ErrDecodeFailed) Unwrap

func (err *ErrDecodeFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type ErrInsertFailed

type ErrInsertFailed struct {
	Err error
}

ErrInsertFailed is the insert failed error.

func (*ErrInsertFailed) Error

func (err *ErrInsertFailed) Error() string

Error satisfies the error interface.

func (*ErrInsertFailed) Unwrap

func (err *ErrInsertFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type ErrUpdateFailed

type ErrUpdateFailed struct {
	Err error
}

ErrUpdateFailed is the update failed error.

func (*ErrUpdateFailed) Error

func (err *ErrUpdateFailed) Error() string

Error satisfies the error interface.

func (*ErrUpdateFailed) Unwrap

func (err *ErrUpdateFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type ErrUpsertFailed

type ErrUpsertFailed struct {
	Err error
}

ErrUpsertFailed is the upsert failed error.

func (*ErrUpsertFailed) Error

func (err *ErrUpsertFailed) Error() string

Error satisfies the error interface.

func (*ErrUpsertFailed) Unwrap

func (err *ErrUpsertFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type Error

type Error string

Error is an error.

const (
	// ErrAlreadyExists is the already exists error.
	ErrAlreadyExists Error = "already exists"
	// ErrDoesNotExist is the does not exist error.
	ErrDoesNotExist Error = "does not exist"
	// ErrMarkedForDeletion is the marked for deletion error.
	ErrMarkedForDeletion Error = "marked for deletion"
)

Error values.

const ErrInvalidStringSlice Error = "invalid StringSlice"

ErrInvalidStringSlice is the invalid StringSlice error.

func (Error) Error

func (err Error) Error() string

Error satisfies the error interface.

type ForeignKey

type ForeignKey struct {
	ForeignKeyName string `json:"foreign_key_name"` // foreign_key_name
	ColumnName     string `json:"column_name"`      // column_name
	RefTableName   string `json:"ref_table_name"`   // ref_table_name
	RefColumnName  string `json:"ref_column_name"`  // ref_column_name
	KeyID          int    `json:"key_id"`           // key_id
}

ForeignKey is a foreign key.

func MysqlTableForeignKeys

func MysqlTableForeignKeys(ctx context.Context, db DB, schema, table string) ([]*ForeignKey, error)

MysqlTableForeignKeys runs a custom query, returning results as ForeignKey.

func OracleTableForeignKeys

func OracleTableForeignKeys(ctx context.Context, db DB, schema, table string) ([]*ForeignKey, error)

OracleTableForeignKeys runs a custom query, returning results as ForeignKey.

func PostgresTableForeignKeys

func PostgresTableForeignKeys(ctx context.Context, db DB, schema, table string) ([]*ForeignKey, error)

PostgresTableForeignKeys runs a custom query, returning results as ForeignKey.

func Sqlite3TableForeignKeys

func Sqlite3TableForeignKeys(ctx context.Context, db DB, schema, table string) ([]*ForeignKey, error)

Sqlite3TableForeignKeys runs a custom query, returning results as ForeignKey.

func SqlserverTableForeignKeys

func SqlserverTableForeignKeys(ctx context.Context, db DB, schema, table string) ([]*ForeignKey, error)

SqlserverTableForeignKeys runs a custom query, returning results as ForeignKey.

type Index

type Index struct {
	IndexName string `json:"index_name"` // index_name
	IsUnique  bool   `json:"is_unique"`  // is_unique
	IsPrimary bool   `json:"is_primary"` // is_primary
}

Index is a index.

func MysqlTableIndexes

func MysqlTableIndexes(ctx context.Context, db DB, schema, table string) ([]*Index, error)

MysqlTableIndexes runs a custom query, returning results as Index.

func OracleTableIndexes

func OracleTableIndexes(ctx context.Context, db DB, schema, table string) ([]*Index, error)

OracleTableIndexes runs a custom query, returning results as Index.

func PostgresTableIndexes

func PostgresTableIndexes(ctx context.Context, db DB, schema, table string) ([]*Index, error)

PostgresTableIndexes runs a custom query, returning results as Index.

func Sqlite3TableIndexes

func Sqlite3TableIndexes(ctx context.Context, db DB, schema, table string) ([]*Index, error)

Sqlite3TableIndexes runs a custom query, returning results as Index.

func SqlserverTableIndexes

func SqlserverTableIndexes(ctx context.Context, db DB, schema, table string) ([]*Index, error)

SqlserverTableIndexes runs a custom query, returning results as Index.

type IndexColumn

type IndexColumn struct {
	SeqNo      int    `json:"seq_no"`      // seq_no
	Cid        int    `json:"cid"`         // cid
	ColumnName string `json:"column_name"` // column_name
}

IndexColumn is a index column.

func MysqlIndexColumns

func MysqlIndexColumns(ctx context.Context, db DB, schema, table, index string) ([]*IndexColumn, error)

MysqlIndexColumns runs a custom query, returning results as IndexColumn.

func OracleIndexColumns

func OracleIndexColumns(ctx context.Context, db DB, schema, table, index string) ([]*IndexColumn, error)

OracleIndexColumns runs a custom query, returning results as IndexColumn.

func PostgresIndexColumns

func PostgresIndexColumns(ctx context.Context, db DB, schema, index string) ([]*IndexColumn, error)

PostgresIndexColumns runs a custom query, returning results as IndexColumn.

func Sqlite3IndexColumns

func Sqlite3IndexColumns(ctx context.Context, db DB, schema, table, index string) ([]*IndexColumn, error)

Sqlite3IndexColumns runs a custom query, returning results as IndexColumn.

func SqlserverIndexColumns

func SqlserverIndexColumns(ctx context.Context, db DB, schema, table, index string) ([]*IndexColumn, error)

SqlserverIndexColumns runs a custom query, returning results as IndexColumn.

type MysqlEnumValue

type MysqlEnumValue struct {
	EnumValues string `json:"enum_values"` // enum_values
}

MysqlEnumValue represents a row from 'mysql.mysql_enum_value'.

func MysqlEnumValues

func MysqlEnumValues(ctx context.Context, db DB, schema, enum string) (*MysqlEnumValue, error)

MysqlEnumValues runs a custom query, returning results as MysqlEnumValue.

type PostgresColOrder

type PostgresColOrder struct {
	Ord string `json:"ord"` // ord
}

PostgresColOrder is a index column order.

func PostgresGetColOrder

func PostgresGetColOrder(ctx context.Context, db DB, schema, index string) (*PostgresColOrder, error)

PostgresGetColOrder runs a custom query, returning results as PostgresColOrder.

type Proc

type Proc struct {
	ProcID     string `json:"proc_id"`     // proc_id
	ProcName   string `json:"proc_name"`   // proc_name
	ProcType   string `json:"proc_type"`   // proc_type
	ReturnType string `json:"return_type"` // return_type
	ReturnName string `json:"return_name"` // return_name
	ProcDef    string `json:"proc_def"`    // proc_def
}

Proc is a stored procedure.

func MysqlProcs

func MysqlProcs(ctx context.Context, db DB, schema string) ([]*Proc, error)

MysqlProcs runs a custom query, returning results as Proc.

func OracleProcs

func OracleProcs(ctx context.Context, db DB, schema string) ([]*Proc, error)

OracleProcs runs a custom query, returning results as Proc.

func PostgresProcs

func PostgresProcs(ctx context.Context, db DB, schema string) ([]*Proc, error)

PostgresProcs runs a custom query, returning results as Proc.

func SqlserverProcs

func SqlserverProcs(ctx context.Context, db DB, schema string) ([]*Proc, error)

SqlserverProcs runs a custom query, returning results as Proc.

type ProcParam

type ProcParam struct {
	ParamName string `json:"param_name"` // param_name
	ParamType string `json:"param_type"` // param_type
}

ProcParam is a stored procedure param.

func MysqlProcParams

func MysqlProcParams(ctx context.Context, db DB, schema, id string) ([]*ProcParam, error)

MysqlProcParams runs a custom query, returning results as ProcParam.

func OracleProcParams

func OracleProcParams(ctx context.Context, db DB, schema, id string) ([]*ProcParam, error)

OracleProcParams runs a custom query, returning results as ProcParam.

func PostgresProcParams

func PostgresProcParams(ctx context.Context, db DB, schema, id string) ([]*ProcParam, error)

PostgresProcParams runs a custom query, returning results as ProcParam.

func SqlserverProcParams

func SqlserverProcParams(ctx context.Context, db DB, schema, id string) ([]*ProcParam, error)

SqlserverProcParams runs a custom query, returning results as ProcParam.

type Sequence

type Sequence struct {
	ColumnName string `json:"column_name"` // column_name
}

Sequence is a sequence.

func MysqlTableSequences

func MysqlTableSequences(ctx context.Context, db DB, schema, table string) ([]*Sequence, error)

MysqlTableSequences runs a custom query, returning results as Sequence.

func OracleTableSequences

func OracleTableSequences(ctx context.Context, db DB, schema, table string) ([]*Sequence, error)

OracleTableSequences runs a custom query, returning results as Sequence.

func PostgresTableSequences

func PostgresTableSequences(ctx context.Context, db DB, schema, table string) ([]*Sequence, error)

PostgresTableSequences runs a custom query, returning results as Sequence.

func Sqlite3TableSequences

func Sqlite3TableSequences(ctx context.Context, db DB, schema, table string) ([]*Sequence, error)

Sqlite3TableSequences runs a custom query, returning results as Sequence.

func SqlserverTableSequences

func SqlserverTableSequences(ctx context.Context, db DB, schema, table string) ([]*Sequence, error)

SqlserverTableSequences runs a custom query, returning results as Sequence.

type StringSlice

type StringSlice []string

StringSlice is a slice of strings.

func (*StringSlice) Scan

func (ss *StringSlice) Scan(v interface{}) error

Scan satisfies the sql.Scanner interface for StringSlice.

func (StringSlice) Value

func (ss StringSlice) Value() (driver.Value, error)

Value satisfies the sql/driver.Valuer interface.

type Table

type Table struct {
	Type      string `json:"type"`       // type
	TableName string `json:"table_name"` // table_name
	ManualPk  bool   `json:"manual_pk"`  // manual_pk
	ViewDef   string `json:"view_def"`   // view_def
}

Table is a table.

func MysqlTables

func MysqlTables(ctx context.Context, db DB, schema, typ string) ([]*Table, error)

MysqlTables runs a custom query, returning results as Table.

func OracleTables

func OracleTables(ctx context.Context, db DB, schema, typ string) ([]*Table, error)

OracleTables runs a custom query, returning results as Table.

func PostgresTables

func PostgresTables(ctx context.Context, db DB, schema, typ string) ([]*Table, error)

PostgresTables runs a custom query, returning results as Table.

func Sqlite3Tables

func Sqlite3Tables(ctx context.Context, db DB, schema, typ string) ([]*Table, error)

Sqlite3Tables runs a custom query, returning results as Table.

func SqlserverTables

func SqlserverTables(ctx context.Context, db DB, schema, typ string) ([]*Table, error)

SqlserverTables runs a custom query, returning results as Table.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL