postgresdb

Documentation

Index

• func CheckDatabaseName(databaseName string) bool
• func CheckTableName(tableName string) bool
• func EscapeApostrophes(dataString string) string
• func EscapeDoubleQuotes(dataString string) string
• func EscapePostgreSQLString(dataString string) string
• func NullStringToString(nullString sql.NullString) string
• type PostgresDBStruct
  • func Connect(conn PostgresDBStruct, checkENV ...bool) (PostgresDBStruct, error)
  • func (conn *PostgresDBStruct) Close() error
  • func (conn *PostgresDBStruct) Connect(checkENV ...bool) error
  • func (conn *PostgresDBStruct) Exec(query string, args ...any) (sql.Result, error)
  • func (conn *PostgresDBStruct) GetRowsInfo(rows *sql.Rows) ([]struct{ ... }, map[string]string, error)
  • func (conn *PostgresDBStruct) GetSQLTableInfo(tableName string) ([]struct{ ... }, map[string]string, error)
  • func (conn *PostgresDBStruct) GetTableInfo(tableName string) ([]struct{ ... }, map[string]string, error)
  • func (conn *PostgresDBStruct) Query(query string, args ...any) (*sql.Rows, error)
  • func (conn *PostgresDBStruct) QueryRecords(query string, args ...any) ([]map[string]any, error)
  • func (conn *PostgresDBStruct) QueryRow(query string, args ...any) *sql.Row
  • func (conn *PostgresDBStruct) ScanRows(sqlRows *sql.Rows) ([]map[string]any, error)
  • func (conn *PostgresDBStruct) ShowDatabases() ([]string, error)
  • func (conn *PostgresDBStruct) ShowTables() ([]string, error)
  • func (conn *PostgresDBStruct) ShowTablesMap() (map[string]map[string]string, error)
  • func (conn *PostgresDBStruct) TableExists(tableName string) (bool, error)

Functions

func CheckDatabaseName

func CheckDatabaseName(databaseName string) bool

func CheckTableName

func CheckTableName(tableName string) bool

func EscapeApostrophes

func EscapeApostrophes(dataString string) string

func EscapeDoubleQuotes

func EscapeDoubleQuotes(dataString string) string

func EscapePostgreSQLString

func EscapePostgreSQLString(dataString string) string

func NullStringToString

func NullStringToString(nullString sql.NullString) string

Types

type PostgresDBStruct

type PostgresDBStruct struct {
	//--------------------
	Host string
	//--------------------
	User     string
	Password string
	//--------------------
	Database string
	//--------------------
	AutoCreate bool
	//--------------------
	DB *sql.DB
}

func Connect

func Connect(conn PostgresDBStruct, checkENV ...bool) (PostgresDBStruct, error)

func (*PostgresDBStruct) Close

func (conn *PostgresDBStruct) Close() error

func (*PostgresDBStruct) Connect

func (conn *PostgresDBStruct) Connect(checkENV ...bool) error

func (*PostgresDBStruct) Exec

func (conn *PostgresDBStruct) Exec(query string, args ...any) (sql.Result, error)

func (*PostgresDBStruct) GetRowsInfo

func (conn *PostgresDBStruct) GetRowsInfo(rows *sql.Rows) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error,
)

func (*PostgresDBStruct) GetSQLTableInfo

func (conn *PostgresDBStruct) GetSQLTableInfo(tableName string) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error,
)

func (*PostgresDBStruct) GetTableInfo

func (conn *PostgresDBStruct) GetTableInfo(tableName string) (
	[]struct {
		Sequence int
		Name     string
		Type     string
	},
	map[string]string,
	error,
)

func (*PostgresDBStruct) Query

func (conn *PostgresDBStruct) Query(query string, args ...any) (*sql.Rows, error)

func (*PostgresDBStruct) QueryRecords

func (conn *PostgresDBStruct) QueryRecords(query string, args ...any) ([]map[string]any, error)

func (*PostgresDBStruct) QueryRow

func (conn *PostgresDBStruct) QueryRow(query string, args ...any) *sql.Row

func (*PostgresDBStruct) ScanRows

func (conn *PostgresDBStruct) ScanRows(sqlRows *sql.Rows) ([]map[string]any, error)

func (*PostgresDBStruct) ShowDatabases

func (conn *PostgresDBStruct) ShowDatabases() ([]string, error)

func (*PostgresDBStruct) ShowTables

func (conn *PostgresDBStruct) ShowTables() ([]string, error)

func (*PostgresDBStruct) ShowTablesMap

func (conn *PostgresDBStruct) ShowTablesMap() (map[string]map[string]string, error)

func (*PostgresDBStruct) TableExists

func (conn *PostgresDBStruct) TableExists(tableName string) (bool, error)