database

Documentation

Index

• Constants
• func Connect(dbType DatabaseType, connStr string) *sql.DB
• func CustomConnect(dbType string, connStr string) *sql.DB
• func DBBoolean(b bool) []uint8
• func Delete(db *sql.DB, sql string, args ...any) (int64, error)
• func Insert(db *sql.DB, sql string, args ...any) (int64, error)
• func PrepareExec(db *sql.DB, name, sql string, args ...any) (int64, error)
• func PrepareQuery(db *sql.DB, name, sql string, args ...any) ([]map[string]string, error)
• func PrepareQueryRow(db *sql.DB, name, sql string, args ...any) (map[string]string, error)
• func PrepareQueryScalar(db *sql.DB, name, sql string, args ...any) (string, error)
• func PrepareSql(db *sql.DB, name, sql string) (*sql.Stmt, error)
• func Query(db *sql.DB, sql string, args ...any) ([]map[string]string, error)
• func QueryRow(db *sql.DB, sql string, args ...any) (map[string]string, error)
• func QueryScalar(db *sql.DB, sql string, key string, args ...any) (string, error)
• func Update(db *sql.DB, sql string, args ...any) (int64, error)
• type DBValue
  • func (v *DBValue) ToBoolean() bool
  • func (v *DBValue) ToBytes() []byte
  • func (v *DBValue) ToDouble() float64
  • func (v *DBValue) ToFloat() float32
  • func (v *DBValue) ToInt() int
  • func (v *DBValue) ToInt64() int64
  • func (v *DBValue) ToString() string
  • func (v *DBValue) ToTime() time.Time
• type DatabaseType
• type Rows
  • func (r *Rows) GetByIndex(index int) *DBValue
  • func (r *Rows) GetByIndexDef(index int, def any) *DBValue
  • func (r *Rows) GetByName(fieldName string) *DBValue
  • func (r *Rows) GetByNameDef(fieldName string, def any) *DBValue

Constants

const (
	//CONNECTION_STRING user:password@tcp(host:port)/databaseName
	CONNECTION_STRING = "%s:%s@tcp(%s:%d)/%s"
)

Functions

func Connect

func Connect(dbType DatabaseType, connStr string) *sql.DB

func CustomConnect

func CustomConnect(dbType string, connStr string) *sql.DB

func DBBoolean

func DBBoolean(b bool) []uint8

func Delete

func Delete(db *sql.DB, sql string, args ...any) (int64, error)

func Insert

func Insert(db *sql.DB, sql string, args ...any) (int64, error)

func PrepareExec

func PrepareExec(db *sql.DB, name, sql string, args ...any) (int64, error)

func PrepareQuery

func PrepareQuery(db *sql.DB, name, sql string, args ...any) ([]map[string]string, error)

func PrepareQueryRow

func PrepareQueryRow(db *sql.DB, name, sql string, args ...any) (map[string]string, error)

func PrepareQueryScalar

func PrepareQueryScalar(db *sql.DB, name, sql string, args ...any) (string, error)

func PrepareSql

func PrepareSql(db *sql.DB, name, sql string) (*sql.Stmt, error)

func Query

func Query(db *sql.DB, sql string, args ...any) ([]map[string]string, error)

func QueryRow

func QueryRow(db *sql.DB, sql string, args ...any) (map[string]string, error)

func QueryScalar

func QueryScalar(db *sql.DB, sql string, key string, args ...any) (string, error)

func Update

func Update(db *sql.DB, sql string, args ...any) (int64, error)

Types

type DBValue

type DBValue struct {
	Value any
}

func (*DBValue) ToBoolean

func (v *DBValue) ToBoolean() bool

func (*DBValue) ToBytes

func (v *DBValue) ToBytes() []byte

func (*DBValue) ToDouble

func (v *DBValue) ToDouble() float64

func (*DBValue) ToFloat

func (v *DBValue) ToFloat() float32

func (*DBValue) ToInt

func (v *DBValue) ToInt() int

func (*DBValue) ToInt64

func (v *DBValue) ToInt64() int64

func (*DBValue) ToString

func (v *DBValue) ToString() string

func (*DBValue) ToTime

func (v *DBValue) ToTime() time.Time

type DatabaseType

type DatabaseType int

const (
	MySQL      DatabaseType = iota // import _ "github.com/go-sql-driver/mysql"
	Oracle                         // import _ "github.com/mattn/go-oci8"
	SqlServer                      // import _ "github.com/denisenkom/go-mssqldb"
	PostgreSql                     // import _ "github.com/lib/pq"
	Sqlite3                        // import _ "github.com/mattn/go-sqlite3"
)

type Rows

type Rows struct {
	*sql.Rows
}

func (*Rows) GetByIndex

func (r *Rows) GetByIndex(index int) *DBValue

func (*Rows) GetByIndexDef

func (r *Rows) GetByIndexDef(index int, def any) *DBValue

func (*Rows) GetByName

func (r *Rows) GetByName(fieldName string) *DBValue

func (*Rows) GetByNameDef

func (r *Rows) GetByNameDef(fieldName string, def any) *DBValue