driver

Documentation

Index

• func Assemble(config drivers.Config) (dbinfo *drivers.DBInfo, err error)
• func MSSQLBuildQueryString(user, pass, dbname, host string, port int, sslmode string) string
• type MSSQLDriver
  • func (m *MSSQLDriver) Assemble(config drivers.Config) (dbinfo *drivers.DBInfo, err error)
  • func (m *MSSQLDriver) Columns(schema, tableName string, whitelist, blacklist []string) ([]drivers.Column, error)
  • func (m *MSSQLDriver) ForeignKeyInfo(schema, tableName string) ([]drivers.ForeignKey, error)
  • func (MSSQLDriver) Imports() (col importers.Collection, err error)
  • func (m *MSSQLDriver) PrimaryKeyInfo(schema, tableName string) (*drivers.PrimaryKey, error)
  • func (m *MSSQLDriver) TableNames(schema string, whitelist, blacklist []string) ([]string, error)
  • func (MSSQLDriver) Templates() (map[string]string, error)
  • func (m *MSSQLDriver) TranslateColumnType(c drivers.Column) drivers.Column
  • func (m *MSSQLDriver) ViewCapabilities(schema, name string) (drivers.ViewCapabilities, error)
  • func (m *MSSQLDriver) ViewColumns(schema, tableName string, whitelist, blacklist []string) ([]drivers.Column, error)
  • func (m *MSSQLDriver) ViewNames(schema string, whitelist, blacklist []string) ([]string, error)

Functions

func Assemble

func Assemble(config drivers.Config) (dbinfo *drivers.DBInfo, err error)

Assemble is more useful for calling into the library so you don't have to instantiate an empty type.

func MSSQLBuildQueryString

func MSSQLBuildQueryString(user, pass, dbname, host string, port int, sslmode string) string

MSSQLBuildQueryString builds a query string for MSSQL.

Types

type MSSQLDriver

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

MSSQLDriver holds the database connection string and a handle to the database connection.

func (*MSSQLDriver) Assemble

func (m *MSSQLDriver) Assemble(config drivers.Config) (dbinfo *drivers.DBInfo, err error)

Assemble all the information we need to provide back to the driver

func (*MSSQLDriver) Columns

func (m *MSSQLDriver) Columns(schema, tableName string, whitelist, blacklist []string) ([]drivers.Column, error)

Columns takes a table name and attempts to retrieve the table information from the database information_schema.columns. It retrieves the column names and column types and returns those as a []Column after TranslateColumnType() converts the SQL types to Go types, for example: "varchar" to "string"

func (*MSSQLDriver) ForeignKeyInfo

func (m *MSSQLDriver) ForeignKeyInfo(schema, tableName string) ([]drivers.ForeignKey, error)

ForeignKeyInfo retrieves the foreign keys for a given table name.

func (MSSQLDriver) Imports

func (MSSQLDriver) Imports() (col importers.Collection, err error)

Imports returns important imports for the driver

func (*MSSQLDriver) PrimaryKeyInfo

func (m *MSSQLDriver) PrimaryKeyInfo(schema, tableName string) (*drivers.PrimaryKey, error)

PrimaryKeyInfo looks up the primary key for a table.

func (*MSSQLDriver) TableNames

func (m *MSSQLDriver) TableNames(schema string, whitelist, blacklist []string) ([]string, error)

TableNames connects to the postgres database and retrieves all table names from the information_schema where the table schema is schema. It uses a whitelist and blacklist.

func (MSSQLDriver) Templates

func (MSSQLDriver) Templates() (map[string]string, error)

Templates that should be added/overridden

func (*MSSQLDriver) TranslateColumnType

func (m *MSSQLDriver) TranslateColumnType(c drivers.Column) drivers.Column

TranslateColumnType converts postgres database types to Go types, for example "varchar" to "string" and "bigint" to "int64". It returns this parsed data as a Column object.

func (*MSSQLDriver) ViewCapabilities

func (m *MSSQLDriver) ViewCapabilities(schema, name string) (drivers.ViewCapabilities, error)

ViewCapabilities return what actions are allowed for a view.

func (*MSSQLDriver) ViewColumns

func (m *MSSQLDriver) ViewColumns(schema, tableName string, whitelist, blacklist []string) ([]drivers.Column, error)

func (*MSSQLDriver) ViewNames

func (m *MSSQLDriver) ViewNames(schema string, whitelist, blacklist []string) ([]string, error)

ViewNames connects to the postgres database and retrieves all view names from the information_schema where the view schema is schema. It uses a whitelist and blacklist.