dialect

Documentation

Index

• Constants
• Variables
• func ReplacePlaceholdersWithNumbers(sql string) string
• type Dialect
  • func PickDialect(name string) (Dialect, bool)
  • func (dialect Dialect) ReplacePlaceholders(sql string, names []string) string
• type PlaceholderStyle

Constants

const (
	SqliteIndex = iota
	MysqlIndex
	PostgresIndex
)

Variables

var Mysql = Dialect{
	Ident:            MysqlIndex,
	PlaceholderStyle: Queries,
	Quoter:           quote.MySqlQuoter,
}

Mysql handles the MySQL syntax.

var Postgres = Dialect{
	Ident:            PostgresIndex,
	PlaceholderStyle: Numbered,
	Quoter:           quote.AnsiQuoter,
}

Postgres handles the PostgreSQL syntax.

var Sqlite = Dialect{
	Ident:            SqliteIndex,
	PlaceholderStyle: Queries,
	Quoter:           quote.AnsiQuoter,
}

Sqlite handles the Sqlite syntax.

Functions

func ReplacePlaceholdersWithNumbers

func ReplacePlaceholdersWithNumbers(sql string) string

ReplacePlaceholdersWithNumbers replaces all '?' placeholders with '$1' etc numbered placeholders, as used by PostgreSQL etc.

Types

type Dialect

type Dialect struct {
	// Name is used for
	Ident int

	// HasNumberedPlaceholders is true for numbered placehoders (Postgresql),
	// or false for the default '?' placeholders.
	PlaceholderStyle PlaceholderStyle

	// Quoter determines the quote marks surrounding identifiers.
	Quoter quote.Quoter
}

func PickDialect

func PickDialect(name string) (Dialect, bool)

PickDialect finds a dialect that matches by name, ignoring letter case. It returns false if not found.

func (Dialect) ReplacePlaceholders

func (dialect Dialect) ReplacePlaceholders(sql string, names []string) string

ReplacePlaceholders converts a string containing '?' placeholders to the form used by the dialect.

type PlaceholderStyle

type PlaceholderStyle int

const (
	Queries PlaceholderStyle = iota
	Numbered
)