dbx

package module

Go to main page

Versions in this module

v0

v0.1.7

Jun 11, 2023

v0.1.6

Jun 11, 2023

v0.1.5

Jul 10, 2020

v0.1.4

Mar 9, 2020

Changes in this version

type SQLUpdater

+ func (this *SQLUpdater) ValueMap(valMap map[string]interface{}) (sql.Result, error)

type Table

+ func (this *Table) GetColumnsMapFromForm(r *http.Request) (map[string]interface{}, error)

v0.1.3

Mar 8, 2020

Changes in this version

type Database

+ func (this *Database) GetTableSchema(name string) (Table, error)

v0.1.2

Mar 8, 2020

Changes in this version

type Column

+ FormName string

type Table

+ func (this *Table) GetColumnsFromForm(r *http.Request) ([]string, []string, error)

v0.1.1

Mar 8, 2020

Changes in this version

+ func SetLogger(logger func(string))

v0.1.0

Mar 6, 2020

Changes in this version

+ const DRIVER_MYSQL

+ const DRIVER_POSTGRE

+ const DRIVER_SQLITE3

+ var DBLogger = func(sql string)

+ type Column struct

+ Index int

+ IsAutoIncrement bool

+ IsPrimaryKey bool

+ Mysql string

+ Name string

+ Postgre string

+ Sqlite string

+ type Database struct

+ func NewDatabase() *Database

+ func (this *Database) Begin() (*Transaction, error)

+ func (this *Database) Close()

+ func (this *Database) CreateTable(name string) error

+ func (this *Database) CreateTables() error

+ func (this *Database) DB() *sql.DB

+ func (this *Database) DriverName() string

+ func (this *Database) DropTable(name string) error

+ func (this *Database) Open(driver, dsn string) error

+ func (this *Database) OpenMySQL(dbName, user, passwd, host string, port int) error

+ func (this *Database) OpenSQLite(dbFile string) error

+ func (this *Database) RegisterTable(name string, table interface{}) error

+ func (this *Database) T(name string) *SQLExecutor

+ type SQLExecutor struct

+ func (this *SQLExecutor) Count(where string, args ...interface{}) (int, error)

+ func (this *SQLExecutor) CountAll() (int, error)

+ func (this *SQLExecutor) Delete(where string, args ...interface{}) error

+ func (this *SQLExecutor) Insert(row interface{}) (sql.Result, error)

+ func (this *SQLExecutor) Replace(row interface{}) (sql.Result, error)

+ func (this *SQLExecutor) Select(cols ...string) *SQLSelector

+ func (this *SQLExecutor) SelectAll() *SQLSelector

+ func (this *SQLExecutor) Update(where string, args ...interface{}) *SQLUpdater

+ type SQLJointer struct

+ func (this *SQLJointer) All(rows ...interface{}) error

+ func (this *SQLJointer) Asc(cols ...string) *SQLJointer

+ func (this *SQLJointer) Desc(cols ...string) *SQLJointer

+ func (this *SQLJointer) Filter(where string, args ...interface{}) *SQLJointer

+ func (this *SQLJointer) FullJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) FullOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) InnerJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) LeftJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) LeftOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) Limit(n int) *SQLJointer

+ func (this *SQLJointer) Offset(n int) *SQLJointer

+ func (this *SQLJointer) One(rows ...interface{}) error

+ func (this *SQLJointer) RightJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) RightOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLJointer) Run() (*sql.Rows, error)

+ type SQLSelector struct

+ func (this *SQLSelector) All(rows interface{}) error

+ func (this *SQLSelector) Asc(cols ...string) *SQLSelector

+ func (this *SQLSelector) Desc(cols ...string) *SQLSelector

+ func (this *SQLSelector) Filter(where string, args ...interface{}) *SQLSelector

+ func (this *SQLSelector) FullJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) FullOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) InnerJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) LeftJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) LeftOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) Limit(n int) *SQLSelector

+ func (this *SQLSelector) Offset(n int) *SQLSelector

+ func (this *SQLSelector) One(row interface{}) error

+ func (this *SQLSelector) RightJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) RightOuterJoin(table, onLeft, onRight string) jointer

+ func (this *SQLSelector) Run() (*sql.Rows, error)

+ func (this *SQLSelector) Values(values ...interface{}) error

+ type SQLUpdater struct

+ func (this *SQLUpdater) Set(cols ...string) *SQLUpdater

+ func (this *SQLUpdater) Value(row interface{}) (sql.Result, error)

+ func (this *SQLUpdater) Values(values ...interface{}) (sql.Result, error)

+ type Table struct

+ Columns map[string]Column

+ Name string

+ func (this *Table) ColumnIndexes() []int

+ func (this *Table) ColumnNames() []string

+ func (this *Table) CreateSQL(driver string) (string, error)

+ func (this *Table) Parse(name string, table interface{}) error

+ type Transaction struct

+ func (this *Transaction) Commit() error

+ func (this *Transaction) Rollback() error

+ func (this *Transaction) T(name string) *SQLExecutor

+ func (this *Transaction) Tx() *sql.Tx

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL