pgxutils

Documentation

Index

• Constants
• func FieldType(fd pgproto3.FieldDescription) reflect.Type
• func GetPSQLQueryType(query string) (queryType int, isReturningRows bool)
• func PgSqlRowsToJson(rows pgx.Rows) ([]string, []map[string]interface{})
• func QueryToDataModel(fieldQueryData []map[string]interface{}, ...) []map[string]interface{}

Constants

const (
	ERRCODE_INVALID_PASSWORD                    = "28P01" // worng password
	ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION = "28000" // db does not exist
)

const (
	QUERY_READ          = iota
	QUERY_WRITE         = iota
	QUERY_MODIFY_SCHEMA = iota
	QUERY_UNKOWN        = -1
)

const (
	LtreeOID = 16411
)

Functions

func FieldType

func FieldType(fd pgproto3.FieldDescription) reflect.Type

func GetPSQLQueryType

func GetPSQLQueryType(query string) (queryType int, isReturningRows bool)

func PgSqlRowsToJson

func PgSqlRowsToJson(rows pgx.Rows) ([]string, []map[string]interface{})

func QueryToDataModel

func QueryToDataModel(fieldQueryData []map[string]interface{}, constraintsQueryData []map[string]interface{}) []map[string]interface{}