oracle

Documentation

Index

• func NewFromConfig(cfg config.KVStore, path string) (*sql.DB, error)
• func NewOracleDatabase(opt *db.Option, opts ...db.Options) (*sql.DB, error)

Functions

func NewFromConfig

func NewFromConfig(cfg config.KVStore, path string) (*sql.DB, error)

NewFromConfig returns postgres-based *sqlx.DB instance from yaml config file

given config file contents:

	db:
	  primary:
		username: <username>
		password: "<password>"
		host: mydb.ap-southeast-1.rds.amazonaws.com
		port: 5432
		schema: my_db_schema
		conn:
		  max-idle: 20
		  max-lifetime: 10m
		  timeout: 5m
		  max-open: 100
		  keep-alive-interval: 30s

then we can call using :

	v := viper.New()
	... set v file configs, etc

	db, err := log.NewFromConfig(v, "db.primary")
	...continue using db.

func NewOracleDatabase

func NewOracleDatabase(opt *db.Option, opts ...db.Options) (*sql.DB, error)

NewOracleDatabase - create & validate postgres connection given certain db.Option the caller have the responsibility to close the *sqlx.DB when succeed.