sqlx

Documentation

Index

• func NewSqlDB(cfg *conf.Configuration) *sql.DB
• func RegisterEncryptor(name string, e Encryptor)
• type Encryptor

Functions

func NewSqlDB

func NewSqlDB(cfg *conf.Configuration) *sql.DB

NewSqlDB create a sql.DB instance from config.

Configuration example:

	dbname:
	  driverName: testDriver
	  dsn: root:123456@tcp(127.0.0.1:3306)
	  maxIdleConns: 10
	  maxOpenConns: 100
	  connMaxLifetime:

Encrypted password example:
	dbname:
	  driverName: testDriver
	  dsn: root:${password}@tcp(127.0.0.1:3306)
	  maxIdleConns: 10
	  maxOpenConns: 100
	  connMaxLifetime:
      encryption:
        password: U2FsdGVkX1+tlVEqk7q5J4HmwH0tZg
        method: aes-gcm

if use encrypted password, you need pass the env "DB_SECRET_KEY" which used AES-GCM encrypted by default

func RegisterEncryptor

func RegisterEncryptor(name string, e Encryptor)

RegisterEncryptor register a new encryptor

Types

type Encryptor

type Encryptor interface {
	Encrypt(plaintext string) (string, error)
	Decrypt(ciphertext string) (string, error)
}

Encryptor is used to encrypt and decrypt password