database

Documentation

Index

• Constants
• type Config
• type Database
  • func NewMySqlWithConfig(my MySQLConfig) Database
  • func NewWithConfig(cfg Config, driver string) Database
  • func (db *Database) Close() error
  • func (db *Database) Connect() error
  • func (db *Database) ConnectWithGormConfig(gormCfg gorm.Config) error
  • func (db *Database) Ctx() *gorm.DB
  • func (db *Database) MigrateDatabase(tables []interface{}) error
  • func (db *Database) Reconnect() error
  • func (db *Database) SetDebug()
  • func (db *Database) SqlDB() *sql.DB
• type KSModel
  • func (ks *KSModel) BeforeCreate(tx *gorm.DB) error
• type Logger
  • func NewGormLog(debug bool) *Logger
  • func NewGormLogWithConfig(cfg Logger) *Logger
  • func (l *Logger) Error(ctx context.Context, s string, args ...interface{})
  • func (l *Logger) Info(ctx context.Context, s string, args ...interface{})
  • func (l *Logger) LogMode(gormlogger.LogLevel) gormlogger.Interface
  • func (l *Logger) Trace(ctx context.Context, begin time.Time, fc func() (string, int64), err error)
  • func (l *Logger) Warn(ctx context.Context, s string, args ...interface{})
• type Model
  • func (m *Model) BeforeCreate(tx *gorm.DB) error
• type MySQLConfig

Constants

const (
	DriverMSSQL    = "mssql"
	DriverMySQL    = "mysql"
	DriverSQLLite  = "sqlite3"
	DriverPostgres = "postgres"

	DefaultMySQLCharset = "utf8mb4"
)

Types

type Config

type Config struct {
	Host       string
	Port       string
	Username   string
	Password   string
	Name       string
	DebugMode  bool
	Filename   string
	SSLEnabled bool
	Charset    string
}

type Database

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

func NewMySqlWithConfig

func NewMySqlWithConfig(my MySQLConfig) Database

func NewWithConfig

func NewWithConfig(cfg Config, driver string) Database

func (*Database) Close

func (db *Database) Close() error

func (*Database) Connect

func (db *Database) Connect() error

func (*Database) ConnectWithGormConfig

func (db *Database) ConnectWithGormConfig(gormCfg gorm.Config) error

func (*Database) Ctx

func (db *Database) Ctx() *gorm.DB

func (*Database) MigrateDatabase

func (db *Database) MigrateDatabase(tables []interface{}) error

func (*Database) Reconnect

func (db *Database) Reconnect() error

func (*Database) SetDebug

func (db *Database) SetDebug()

func (*Database) SqlDB

func (db *Database) SqlDB() *sql.DB

type KSModel

type KSModel struct {
	Uid       ksuid.KSUID    `json:"uid" gorm:"primary_key;type:varbinary(27);index"`
	CreatedAt time.Time      `json:"created_at" gorm:"index"`
	UpdatedAt time.Time      `json:"updated_at"`
	DeletedAt gorm.DeletedAt `json:"deleted_at" gorm:"index"`
}

KSModel is uid alternative

func (*KSModel) BeforeCreate

func (ks *KSModel) BeforeCreate(tx *gorm.DB) error

type Logger

type Logger struct {
	SlowThreshold         time.Duration
	SourceField           string
	SkipErrRecordNotFound bool
	Debug                 bool
}

func NewGormLog

func NewGormLog(debug bool) *Logger

func NewGormLogWithConfig

func NewGormLogWithConfig(cfg Logger) *Logger

func (*Logger) Error

func (l *Logger) Error(ctx context.Context, s string, args ...interface{})

func (*Logger) Info

func (l *Logger) Info(ctx context.Context, s string, args ...interface{})

func (*Logger) LogMode

func (l *Logger) LogMode(gormlogger.LogLevel) gormlogger.Interface

func (*Logger) Trace

func (l *Logger) Trace(ctx context.Context, begin time.Time, fc func() (string, int64), err error)

func (*Logger) Warn

func (l *Logger) Warn(ctx context.Context, s string, args ...interface{})

type Model

type Model struct {
	Seq       int64          `json:"seq" gorm:"primary_key;auto_increment:false;"`
	Uid       uuid.UUID      `json:"uid" gorm:"primary_key;index"`
	CreatedAt time.Time      `json:"created_at" gorm:"index"`
	UpdatedAt time.Time      `json:"updated_at"`
	DeletedAt gorm.DeletedAt `json:"deleted_at" gorm:"index"`
}

Model struct

func (*Model) BeforeCreate

func (m *Model) BeforeCreate(tx *gorm.DB) error

BeforeCreate hook table

type MySQLConfig

type MySQLConfig struct {
	Host         string
	Port         string
	Username     string
	Password     string
	DatabaseName string
	DebugMode    bool
}