Documentation
¶
Index ¶
- func BuildQueryString(user, pass, dbname, host string, port int, sslmode string) string
- type MockDriver
- func (m *MockDriver) Close()
- func (m *MockDriver) Columns(tableName string) ([]bdb.Column, error)
- func (m *MockDriver) ForeignKeyInfo(tableName string) ([]bdb.ForeignKey, error)
- func (m *MockDriver) Open() error
- func (m *MockDriver) PrimaryKeyInfo(tableName string) (*bdb.PrimaryKey, error)
- func (m *MockDriver) TableNames(exclude []string) ([]string, error)
- func (m *MockDriver) TranslateColumnType(c bdb.Column) bdb.Column
- func (m *MockDriver) UseLastInsertID() bool
- type PostgresDriver
- func (p *PostgresDriver) Close()
- func (p *PostgresDriver) Columns(tableName string) ([]bdb.Column, error)
- func (p *PostgresDriver) ForeignKeyInfo(tableName string) ([]bdb.ForeignKey, error)
- func (p *PostgresDriver) Open() error
- func (p *PostgresDriver) PrimaryKeyInfo(tableName string) (*bdb.PrimaryKey, error)
- func (p *PostgresDriver) TableNames(exclude []string) ([]string, error)
- func (p *PostgresDriver) TranslateColumnType(c bdb.Column) bdb.Column
- func (p *PostgresDriver) UseLastInsertID() bool
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
Types ¶
type MockDriver ¶
type MockDriver struct{}
MockDriver is a mock implementation of the bdb driver Interface
func (*MockDriver) Columns ¶
func (m *MockDriver) Columns(tableName string) ([]bdb.Column, error)
Columns returns a list of mock columns
func (*MockDriver) ForeignKeyInfo ¶
func (m *MockDriver) ForeignKeyInfo(tableName string) ([]bdb.ForeignKey, error)
ForeignKeyInfo returns a list of mock foreignkeys
func (*MockDriver) Open ¶
func (m *MockDriver) Open() error
Open mimics a database open call and returns nil for no error
func (*MockDriver) PrimaryKeyInfo ¶
func (m *MockDriver) PrimaryKeyInfo(tableName string) (*bdb.PrimaryKey, error)
PrimaryKeyInfo returns mock primary key info for the passed in table name
func (*MockDriver) TableNames ¶
func (m *MockDriver) TableNames(exclude []string) ([]string, error)
TableNames returns a list of mock table names
func (*MockDriver) TranslateColumnType ¶
func (m *MockDriver) TranslateColumnType(c bdb.Column) bdb.Column
TranslateColumnType converts a column to its "null." form if it is nullable
func (*MockDriver) UseLastInsertID ¶
func (m *MockDriver) UseLastInsertID() bool
UseLastInsertID returns a database mock LastInsertID compatability flag
type PostgresDriver ¶
type PostgresDriver struct {
// contains filtered or unexported fields
}
PostgresDriver holds the database connection string and a handle to the database connection.
func NewPostgresDriver ¶
func NewPostgresDriver(user, pass, dbname, host string, port int, sslmode string) *PostgresDriver
NewPostgresDriver takes the database connection details as parameters and returns a pointer to a PostgresDriver object. Note that it is required to call PostgresDriver.Open() and PostgresDriver.Close() to open and close the database connection once an object has been obtained.
func (*PostgresDriver) Close ¶
func (p *PostgresDriver) Close()
Close closes the database connection
func (*PostgresDriver) Columns ¶
func (p *PostgresDriver) Columns(tableName string) ([]bdb.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 (*PostgresDriver) ForeignKeyInfo ¶
func (p *PostgresDriver) ForeignKeyInfo(tableName string) ([]bdb.ForeignKey, error)
ForeignKeyInfo retrieves the foreign keys for a given table name.
func (*PostgresDriver) Open ¶
func (p *PostgresDriver) Open() error
Open opens the database connection using the connection string
func (*PostgresDriver) PrimaryKeyInfo ¶
func (p *PostgresDriver) PrimaryKeyInfo(tableName string) (*bdb.PrimaryKey, error)
PrimaryKeyInfo looks up the primary key for a table.
func (*PostgresDriver) TableNames ¶
func (p *PostgresDriver) TableNames(exclude []string) ([]string, error)
TableNames connects to the postgres database and retrieves all table names from the information_schema where the table schema is public. It excludes common migration tool tables such as gorp_migrations
func (*PostgresDriver) TranslateColumnType ¶
func (p *PostgresDriver) TranslateColumnType(c bdb.Column) bdb.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 (*PostgresDriver) UseLastInsertID ¶
func (p *PostgresDriver) UseLastInsertID() bool
UseLastInsertID returns false for postgres
Source Files