database

package

v0.0.82 Latest Latest Go to latest Published: Mar 2, 2024 License: MIT Imports: 11 Imported by: 5

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

Repository

github.com/alexhokl/helper

Links

Open Source Insights

Documentation ¶

Index ¶

func DumpTable(data *TableData) error
func DumpTables(list []TableData) error
func GetConnection(config *Config) (*sql.DB, error)
func GetDatabaseConnection(dialector gorm.Dialector) (*gorm.DB, error)
func GetDatabaseDailector(pathDatabaseConnectionString string) (gorm.Dialector, error)
func GetDatabaseDialectorFromConnection(conn *sql.DB) gorm.Dialector
func GetPostgresConnection(config *PostgresConfig) (*sql.DB, error)
func GetValue(pval *interface{}) string
type Config
type PostgresConfig
type TableData
- func GetData(conn *sql.DB, query string) (*TableData, error)

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func DumpTable ¶ added in v0.0.21

func DumpTable(data *TableData) error

DumpTable prints the specified table to standard output stream

func DumpTables ¶

func DumpTables(list []TableData) error

DumpTables prints the specified tables to standard output stream

func GetConnection ¶

func GetConnection(config *Config) (*sql.DB, error)

GetConnection returns a SQL database connection

func GetDatabaseConnection ¶ added in v0.0.81

func GetDatabaseConnection(dialector gorm.Dialector) (*gorm.DB, error)

func GetDatabaseDailector ¶ added in v0.0.81

func GetDatabaseDailector(pathDatabaseConnectionString string) (gorm.Dialector, error)

func GetDatabaseDialectorFromConnection ¶ added in v0.0.81

func GetDatabaseDialectorFromConnection(conn *sql.DB) gorm.Dialector

func GetPostgresConnection ¶

func GetPostgresConnection(config *PostgresConfig) (*sql.DB, error)

GetPostgresConnection returns a PostgreSQL database connection

func GetValue ¶

func GetValue(pval *interface{}) string

GetValue returns a typed value from a cell reference

Types ¶

type Config ¶

type Config struct {
	Server   string `yaml:"server" json:"server"`
	Port     int    `yaml:"port" json:"port"`
	Username string `yaml:"username" json:"username"`
	Password string `yaml:"password" json:"password"`
	Name     string `yaml:"name" json:"name"`
}

Config struct

type PostgresConfig ¶

type PostgresConfig struct {
	Config `yaml:"config" json:"config"`
	UseSSL bool `yaml:"use_ssl" json:"use_ssl"`
}

PostgresConfig contains fields for PostgreSQL configuration

type TableData ¶

type TableData struct {
	Rows    [][]interface{}
	Columns []string
}

TableData struct

func GetData ¶

func GetData(conn *sql.DB, query string) (*TableData, error)

GetData returns data retrieved by using query with conn

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL