db

Documentation

Index

• func DatabaseDrivers() []string
• func EnableDatabase(engine *common.ScriptEngine) error
• type Database
  • func NewDatabase(driver, dsn string) (*Database, error)
  • func (database *Database) Begin() error
  • func (database *Database) Close() error
  • func (database *Database) Commit() error
  • func (database *Database) Execute(sqlcmd string, args ...any) (int64, error)
  • func (database *Database) Init(driver, dsn string) error
  • func (database *Database) Open() error
  • func (database *Database) Query(sqlcmd string, args ...any) (*Resultset, error)
  • func (database *Database) Rollback() error
• type Field
  • func (f *Field) String() string
• type Resultset
  • func (rs *Resultset) Get(row int, fieldName string) (Field, error)

Functions

func DatabaseDrivers

func DatabaseDrivers() []string

func EnableDatabase

func EnableDatabase(engine *common.ScriptEngine) error

Types

type Database

type Database struct {
	Driver    string
	DSN       string
	Timeout   time.Duration
	Isolation sql.IsolationLevel
	// contains filtered or unexported fields
}

func NewDatabase

func NewDatabase(driver, dsn string) (*Database, error)

func (*Database) Begin

func (database *Database) Begin() error

func (*Database) Close

func (database *Database) Close() error

func (*Database) Commit

func (database *Database) Commit() error

func (*Database) Execute

func (database *Database) Execute(sqlcmd string, args ...any) (int64, error)

func (*Database) Init

func (database *Database) Init(driver, dsn string) error

func (*Database) Open

func (database *Database) Open() error

func (*Database) Query

func (database *Database) Query(sqlcmd string, args ...any) (*Resultset, error)

func (*Database) Rollback

func (database *Database) Rollback() error

type Field

type Field struct {
	Value  any  `json:"value"`
	IsNull bool `json:"isnull"`
}

func (*Field) String

func (f *Field) String() string

type Resultset

type Resultset struct {
	ColumnNames []string
	RowCount    int
	Rows        any
}

func (*Resultset) Get

func (rs *Resultset) Get(row int, fieldName string) (Field, error)