simpledb

package module

Go to main page

Versions in this module

v1

v1.2.2

Nov 21, 2022

v1.2.1

Nov 21, 2022

v1.2.0

Nov 21, 2022

Changes in this version

+ func AllColumns(model any, exclude ...string) []string

v1.1.9

Nov 18, 2022

Changes in this version

type Database

+ func (db *Database) DeleteOneToOne(from, to Model) error

+ func (db *Database) GetOneToOneReverse(from, to Model) (Model, error)

+ func (db *Database) InsertOneToOne(from, to Model) error

+ func (db *Database) SelectOneToOne(from, to Model) (Model, error)

v1.1.8

Nov 13, 2022

v1.1.7

Nov 13, 2022

v1.1.6

Nov 13, 2022

Changes in this version

type Database

+ func (db *Database) AllModels() []Model

v1.1.5

Nov 12, 2022

v1.1.4

Nov 12, 2022

v1.1.3

Nov 12, 2022

v1.1.2

Nov 12, 2022

v1.1.1

Nov 12, 2022

v1.1.0

Nov 12, 2022

Changes in this version

type Database

+ func (d *Database) DeleteModel(model Model) error

v1.0.9

Nov 11, 2022

v1.0.8

Nov 11, 2022

Changes in this version

+ func CheckSQLError(err error, number int) bool

type Database

+ func (db *Database) CheckError(err error, number int) bool

v1.0.7

Nov 11, 2022

Changes in this version

+ func CheckError(err error, number int) bool

v1.0.6

Nov 10, 2022

v1.0.5

Nov 10, 2022

Changes in this version

type Database

+ func (d *Database) UpdateModel(model Model) error

v1.0.4

Nov 7, 2022

v1.0.3

Nov 7, 2022

v1.0.2

Nov 7, 2022

v1.0.1

Nov 7, 2022

Changes in this version

+ const EQ

+ const GT

+ const GTE

+ const IN

+ const LIKE

+ const LT

+ const LTE

+ const NE

+ const TAG

+ func Columns(model any) []string

+ func ColumnsWithTypes(model any) ([]string, []string)

+ func Exclude(a []T, b []T) []T

+ func GetColType(typ string, dialect string) string

+ func GetColTypes(types []string, dialect string) []string

+ func GetValue(model Model, column string) any

+ func MapToSlice(m map[T]any) ([]T, []any)

+ func Scan(model Model, row *sql.Rows) error

+ func SetValue(model Model, column string, value any)

+ func TagValid(field reflect.StructField) bool

+ func TagValues(field reflect.StructField) []string

+ type Column struct

+ Auto bool

+ Default string

+ Index bool

+ Length int

+ Name string

+ Nullable bool

+ Primary bool

+ Raw string

+ Table string

+ Tags ModelTags

+ Type DBType

+ Unique bool

+ func MigrationColumns(model Model) []Column

+ func (c Column) String() string

+ type DBType string

+ const BIGINT

+ const BLOB

+ const BOOLEAN

+ const DATETIME

+ const DOUBLE

+ const FLOAT

+ const FOREIGN_KEY

+ const INT

+ const SMALLINT

+ const TEXT

+ const TINYINT

+ const VARCHAR

+ type Database struct

+ Database string

+ Host string

+ LIMIT int

+ LatestMigration *Migration

+ Logger simplelog.Logger

+ Password string

+ Port any

+ SSL_MODE string

+ Username string

+ func NewDatabase(loglevel ...string) *Database

+ func (d *Database) AllModel(model Model, exclude []string) ModelSet

+ func (d *Database) AllQ(model Model, exclude []string) string

+ func (d *Database) CreateTableQuery(table string, columns []string) string

+ func (d *Database) DB_Tables() ([]string, error)

+ func (d *Database) DeleteQuery(table string, where string) string

+ func (d *Database) ExecCreateTable(table string, columns []string) error

+ func (d *Database) ExecDelete(table string, where string) error

+ func (d *Database) ExecInsert(table string, columns []string, values []interface{}) (int64, error)

+ func (d *Database) ExecSelect(table string, where string) (*sql.Rows, error)

+ func (d *Database) ExecUpdate(table string, columns []string, values []interface{}, where string) error

+ func (d *Database) Filter(model Model, filter Filters) ModelSet

+ func (d *Database) FilterWithLimit(model Model, filters Filters, limit int) ModelSet

+ func (d *Database) InsertModel(model Model) error

+ func (d *Database) InsertQuery(table string, columns []string) string

+ func (d *Database) QuerySelect(table string, columns []string, where string) (*sql.Rows, error)

+ func (d *Database) QuerySelectOne(table string, column string, where string) *sql.Row

+ func (d *Database) QuerySelectRow(table string, columns []string, where string) *sql.Row

+ func (d *Database) SelectOneQuery(table string, column string, where string) string

+ func (d *Database) SelectQuery(table string, columns []string, where string) string

+ func (d *Database) SelectRowQuery(table string, columns []string, where string) string

+ func (d *Database) UpdateQuery(table string, columns []string, where string) string

+ func (db *Database) Addr() string

+ func (db *Database) AlterDropOneToMany(from, to string) error

+ func (db *Database) AlterDropOneToOne(from, to string) error

+ func (db *Database) AlterOneToMany(from, to string) error

+ func (db *Database) AlterOneToOne(from, to string) error

+ func (db *Database) Begin() (*sql.Tx, error)

+ func (db *Database) Close() error

+ func (db *Database) Connect() error

+ func (db *Database) Count(table_name string, filter ...Filter) (int, error)

+ func (db *Database) CreateFKTable(from, to string) error

+ func (db *Database) DB_ColumnType(table_name string, column_name string) ([]*sql.ColumnType, error)

+ func (db *Database) DB_ColumnTypes(table_name string) ([]*sql.ColumnType, error)

+ func (db *Database) DB_Columns(table_name string) ([]string, error)

+ func (db *Database) DB_Columns_With_Type(table_name string) (map[string]string, error)

+ func (db *Database) DSN() string

+ func (db *Database) DeleteFK(from, to Model) error

+ func (db *Database) DropFKTable(from, to string) error

+ func (db *Database) DropTable(table_name string) error

+ func (db *Database) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (db *Database) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (db *Database) GetColumnValue(model Model, col string, id any) interface{}

+ func (db *Database) GetFromEnv() *Database

+ func (db *Database) GetOneToMany(from, to Model) (ModelSet, error)

+ func (db *Database) GetOneToOne(from, to Model) (ModelSet, error)

+ func (db *Database) InsertFK(from, to Model) error

+ func (db *Database) LoadCredentials() *Database

+ func (db *Database) Migrate() error

+ func (db *Database) NewQS(mdl Model) *QuerySet

+ func (db *Database) Ping() error

+ func (db *Database) Prepare(query string) (*sql.Stmt, error)

+ func (db *Database) PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)

+ func (db *Database) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (db *Database) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (db *Database) QueryRow(query string, args ...interface{}) *sql.Row

+ func (db *Database) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (db *Database) Register(model Model)

+ func (db *Database) SelectFK(from, to Model) (ModelSet, error)

+ func (db *Database) SelectFKReverse(from, to Model) (ModelSet, error)

+ func (db *Database) String() string

+ type Filter struct

+ Column string

+ Operator string

+ Value any

+ type Filters []*Filter

+ func (f Filters) Add(column string, op string, value any) Filters

+ func (f Filters) Get(column string) any

+ func (f Filters) Has(column string) bool

+ func (f Filters) Len() int

+ func (f Filters) Query(and bool) (string, []interface{})

+ func (f Filters) Remove(column string) Filters

+ type Migration struct

+ Database *Database

+ Directory string

+ Models []Model

+ Tables []Table

+ func NewMigration(db *Database) *Migration

+ func (m *Migration) CreateFromModels(models []Model)

+ func (m Migration) GetLatestMigration() (Migration, error)

+ func (m Migration) Run() error

+ func (m Migration) Validate(other Migration) ([]Table, []Column, []Relation, []Column, []Table, []Column, []Relation)

+ func (m Migration) Write() error

+ type Model interface

+ TableName func() string

+ func NewModel(model Model) Model

+ func ScanRow(row *sql.Row, model Model) (Model, error)

+ type ModelSet []Model

+ func ScanRows(rows *sql.Rows, model Model) ModelSet

+ func (ms ModelSet) Filter(args []string) ModelSet

+ func (ms ModelSet) Len() int

+ func (ms ModelSet) String() string

+ func (ms ModelSet) Values(exclude ...string) []map[string]any

+ type ModelTags map[string]string

+ func TagMap(field reflect.StructField) ModelTags

+ func (t ModelTags) Auto() bool

+ func (t ModelTags) Default() string

+ func (t ModelTags) Get(key string) string

+ func (t ModelTags) Has(key string) bool

+ func (t ModelTags) Index() bool

+ func (t ModelTags) Length() int

+ func (t ModelTags) Nullable() bool

+ func (t ModelTags) Primary() bool

+ func (t ModelTags) Raw() string

+ func (t ModelTags) RelType() string

+ func (t ModelTags) Set(key string, value string)

+ func (t ModelTags) ToColumn(tname, name, typ string) Column

+ func (t ModelTags) Type() string

+ func (t ModelTags) Unique() bool

+ type QuerySet struct

+ Filters Filters

+ LIMIT int

+ Model Model

+ OFFSET int

+ PAGESIZE int

+ Q string

+ Statements []string

+ func NewQuerySet(db *Database, model ...Model) *QuerySet

+ func (q *QuerySet) Add(statement string) *QuerySet

+ func (q *QuerySet) AddFiters(filters Filters) *QuerySet

+ func (q *QuerySet) All() *QuerySet

+ func (q *QuerySet) Clear() *QuerySet

+ func (q *QuerySet) Count() *QuerySet

+ func (q *QuerySet) Exec() (*sql.Rows, error)

+ func (q *QuerySet) ExecOne() (*sql.Row, error)

+ func (q *QuerySet) ExecRow() (*sql.Row, error)

+ func (q *QuerySet) From(table ...string) *QuerySet

+ func (q *QuerySet) Get(values ...int) *QuerySet

+ func (q *QuerySet) GetFrom(from, where, op string, value any) *QuerySet

+ func (q *QuerySet) GroupBy(columns ...string) *QuerySet

+ func (q *QuerySet) Join(table string, column string, value any, op string) *QuerySet

+ func (q *QuerySet) Limit(limit int) *QuerySet

+ func (q *QuerySet) MultiModel(model ...Model) ModelSet

+ func (q *QuerySet) Offset(offset int) *QuerySet

+ func (q *QuerySet) OrderBy(column string, order string) *QuerySet

+ func (q *QuerySet) Page(page int) ModelSet

+ func (q *QuerySet) Query() (string, []interface{})

+ func (q *QuerySet) Raw(sql string) (string, []any)

+ func (q *QuerySet) Select(columns ...string) *QuerySet

+ func (q *QuerySet) SingleModel(model ...Model) (Model, error)

+ func (q *QuerySet) Where(column string, op string, value any) *QuerySet

+ type Relation struct

+ From string

+ To string

+ Type DBType

+ func MigrationRelations(model Model) []Relation

+ type Table struct

+ Columns []Column

+ Name string

+ Relations []Relation

+ func ModelToTable(model Model) Table

+ func (t Table) String() string

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