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
• 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 string) *DBValue
  • func (r *Rows) GetByName(fieldName string) *DBValue
  • func (r *Rows) GetByNameDef(fieldName string, def string) *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

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"
)

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 string) *DBValue

func (*Rows) GetByName

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

func (*Rows) GetByNameDef

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