postgres

Documentation

Index

• func CondSql(first bool) string
• func NewPostgres(conf *Config) *sqlx.DB
• func ReadTables(uri string) ([]string, error)
• func SqlIntegerArray(ids ...int) string
• func SqlIntegerIn(ids ...int) string
• func SqlStringArray(ids ...string) string
• func SqlStringIn(ids ...string) string
• func SqlWithIn(lng, lat float64, radius int) string
• func ValuePlaceHolderAndGeometry(start int, count int, geometryPos ...int) string
• func ValuesPlaceHolder(start int, count int) string
• type Config
  • func NewConfig(uri string) *Config

Functions

func CondSql

func CondSql(first bool) string

func NewPostgres

func NewPostgres(conf *Config) *sqlx.DB

func ReadTables

func ReadTables(uri string) ([]string, error)

func SqlIntegerArray

func SqlIntegerArray(ids ...int) string

func SqlIntegerIn

func SqlIntegerIn(ids ...int) string

func SqlStringArray

func SqlStringArray(ids ...string) string

func SqlStringIn

func SqlStringIn(ids ...string) string

func SqlWithIn

func SqlWithIn(lng, lat float64, radius int) string

func ValuePlaceHolderAndGeometry

func ValuePlaceHolderAndGeometry(start int, count int, geometryPos ...int) string

func ValuesPlaceHolder

func ValuesPlaceHolder(start int, count int) string

Types

type Config

type Config struct {
	Uri     string `yaml:"uri"`
	MaxIdle int    `yaml:"maxIdle" default:"10"`
	MaxOpen int    `yaml:"maxOpen" default:"100"`
}

func NewConfig

func NewConfig(uri string) *Config