postgres

package

v0.0.2 Latest Latest Go to latest Published: Nov 26, 2022 License: MIT Imports: 9 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

This section is empty.

type ColumnInfo struct {
	ColumnName string `db:"column_name"`
	IsPK       bool   `db:"is_pk"`
	TableName  string `db:"table_name"`
}

type Config struct {
	DBName string
	// contains filtered or unexported fields
}

func NewConfigFromEnv() (*Config, error)

func (cfg *Config) GetKVConnectionString() string

func (cfg *Config) GetSearchPathOrPublic() string

type DB struct {
	// contains filtered or unexported fields
}

func NewDB(db *sqlx.DB) *DB

func OpenPostgresDB(cfg *Config) (*DB, error)

func (db *DB) Close() error

func (db *DB) Exec(query string) (sql.Result, error)

func (db *DB) ExplainWithAnalyze(query string) ([]string, error)

func (db *DB) GetIndexes(database string, tables []string) ([]*IndexInfo, error)

func (db *DB) GetTableColumns(schema string, tables []string) ([]*ColumnInfo, error)

type IndexInfo struct {
	TableName string
	Columns   []string
}