db

Documentation

Index

• func DetectType(dsn string) string
• func DisplayName(dsn string) string
• func InitialQuery(dbType string) string
• func MaskDSN(dsn string) string
• func Placeholder(dbType string) string
• type DBAdapter
• type QueryResult

Functions

func DetectType

func DetectType(dsn string) string

DetectType returns the database type string for a given DSN.

func DisplayName

func DisplayName(dsn string) string

DisplayName returns a short display name for a DSN.

func InitialQuery

func InitialQuery(dbType string) string

InitialQuery returns an appropriate initial query for the database type.

func MaskDSN

func MaskDSN(dsn string) string

MaskDSN returns a display-safe version of the DSN with passwords masked.

func Placeholder

func Placeholder(dbType string) string

Placeholder returns an appropriate placeholder query for the database type.

Types

type DBAdapter

type DBAdapter interface {
	Type() string
	Query(context.Context, string) (QueryResult, error)
	Tables(context.Context) ([]string, error)
	Columns(ctx context.Context, tableName string) ([]string, error)
	Schema(context.Context) (string, error)
	QuoteIdentifier(name string) string
	Close() error
}

type QueryResult

type QueryResult struct {
	Columns     []string
	ColumnTypes []string // e.g. "INTEGER", "TEXT", "VARCHAR". nil if unavailable.
	Rows        [][]string
	Message     string
}