dbless

Jul 19, 2020

Changes in this version

type DB

+ Debug bool

Jul 15, 2020

Changes in this version

+ func ListColumnsByQuery(db *DB, dbname, tableName string) ([]*sql.ColumnType, error)

+ func ListDatabaseByQuery(db *DB, query string, name string, exclude []string) ([]string, error)

+ func ListTableByQuery(db *DB, query string, name string, params ...interface{}) ([]string, error)

+ func RegisterDriver(driver Driver)

type DB

+ func (db *DB) InsertGetID(table string, row map[string]interface{}) (string, error)

type Driver

+ Placeholder func(values []interface{}) []string

+ ScanReceiver func(t *sql.ColumnType) (interface{}, error)

Mar 8, 2020

Changes in this version

+ type DB struct

+ DB *sql.DB

+ Driver Driver

+ func New(driverName string, db *sql.DB) *DB

+ func Open(driverName, dsn string) (*DB, error)

+ func (db *DB) Delete(table string, where string, args ...interface{}) (uint64, error)

+ func (db *DB) GetPaging(pageSize uint, page uint, sql string, args ...interface{}) (*PagedRows, error)

+ func (db *DB) GetRow(sql string, args ...interface{}) (Record, error)

+ func (db *DB) GetRows(sqlStr string, args ...interface{}) ([]Record, error)

+ func (db *DB) Insert(table string, row map[string]interface{}) (uint64, error)

+ func (db *DB) ListColumns(dbname, tablename string) ([]*sql.ColumnType, error)

+ func (db *DB) ListDatabases() ([]string, error)

+ func (db *DB) ListTables(dbname string) ([]string, error)

+ func (db *DB) Scalar(sql string, args ...interface{}) (uint64, error)

+ func (db *DB) Update(table string, row map[string]interface{}, where string, args ...interface{}) (uint64, error)

+ type Driver interface

+ ListColumns func(db *sql.DB, dbname string, tablename string) ([]*sql.ColumnType, error)

+ ListDatabases func(db *sql.DB) ([]string, error)

+ ListTables func(db *sql.DB, dbname string) ([]string, error)

+ Name func() string

+ QuoteIdentifier func(string) string

+ type DriverNotImplementedError struct

+ func (e DriverNotImplementedError) Error() string

+ type MysqlDriver struct

+ func (m *MysqlDriver) ListColumns(db *sql.DB, dbname string, tablename string) ([]*sql.ColumnType, error)

+ func (m *MysqlDriver) ListDatabases(db *sql.DB) ([]string, error)

+ func (m *MysqlDriver) ListTables(db *sql.DB, dbname string) ([]string, error)

+ func (m *MysqlDriver) Name() string

+ func (m *MysqlDriver) QuoteIdentifier(v string) string

+ type NoDriverError struct

+ func (e NoDriverError) Error() string

+ type PostgresDriver struct

+ func (m *PostgresDriver) ListColumns(db *sql.DB, dbname string, tablename string) ([]*sql.ColumnType, error)

+ func (m *PostgresDriver) ListDatabases(db *sql.DB) ([]string, error)

+ func (m *PostgresDriver) ListTables(db *sql.DB, dbname string) ([]string, error)

+ func (m *PostgresDriver) Name() string

+ func (m *PostgresDriver) QuoteIdentifier(v string) string

+ type SqlServerDriver struct

+ func (m *SqlServerDriver) ListColumns(db *sql.DB, dbname string, tablename string) ([]*sql.ColumnType, error)

+ func (m *SqlServerDriver) ListDatabases(db *sql.DB) ([]string, error)

+ func (m *SqlServerDriver) ListTables(db *sql.DB, dbname string) ([]string, error)

+ func (m *SqlServerDriver) Name() string

+ func (m *SqlServerDriver) QuoteIdentifier(v string) string

+ type Sqlite3Driver struct

+ func (m *Sqlite3Driver) ListColumns(db *sql.DB, dbname string, tablename string) ([]*sql.ColumnType, error)

+ func (m *Sqlite3Driver) ListDatabases(db *sql.DB) ([]string, error)

+ func (m *Sqlite3Driver) ListTables(db *sql.DB, dbname string) ([]string, error)

+ func (m *Sqlite3Driver) Name() string

+ func (m *Sqlite3Driver) QuoteIdentifier(v string) string

Jul 26, 2019

Changes in this version

type Record

+ func (r Record) Unmarshal(input interface{}) error

Jul 7, 2019

Changes in this version

type Filter

+ func (f Filter) GetWhere() (string, []interface{})

Jul 7, 2019

Changes in this version

type Field

+ Meta string

type Resource

+ Meta string

Jul 2, 2019

Changes in this version

+ type Filter map[string]interface

type ListInput

+ Filter Filter

Jun 25, 2019

Changes in this version

+ func DBDelete(db *sql.DB, table string, where string, args ...interface{}) (uint64, error)

+ func DBGetRow(db *sql.DB, sql string, args ...interface{}) (map[string]interface{}, error)

+ func DBGetRows(db *sql.DB, sql string, args ...interface{}) ([]map[string]interface{}, error)

+ func DBInsert(db *sql.DB, table string, row map[string]interface{}) (uint64, error)

+ func DBScalar(db *sql.DB, sql string, args ...interface{}) (uint64, error)

+ func DBUpdate(db *sql.DB, table string, row map[string]interface{}, where string, ...) (uint64, error)

+ func IsRecordNotFound(err error) bool

+ type Field struct

+ Description string

+ Name string

+ Title string

+ type ListInput struct

+ Pagination Pagination

+ type ListOutput struct

+ List []Record

+ type PagedRows struct

+ List []map[string]interface{}

+ func DBGetPaging(db *sql.DB, pageSize uint, page uint, sql string, args ...interface{}) (*PagedRows, error)

+ type Pagination struct

+ Page uint

+ PageSize uint

+ PageTotal uint

+ Total uint

+ func NewPagination(pageSize, page uint) *Pagination

+ func (p *Pagination) GetOffsetLimit() (uint, uint)

+ func (p *Pagination) SetTotal(total uint)

+ func (p *Pagination) Valid()

+ type Record map[string]interface

+ func (r Record) ID() uint64

+ type RecordNotFoundError struct

+ func (e RecordNotFoundError) Error() string

+ type Resource struct

+ DB *sql.DB

+ Fields []Field

+ Name string

+ Timestamp bool

+ Title string

+ func (r Resource) Delete(id uint64) error

+ func (r Resource) Get(id uint64) (Record, error)

+ func (r Resource) List(input ListInput) (*ListOutput, error)

+ func (r Resource) Save(record Record) (uint64, error)