db

package module

Go to main page

Versions in this module

v1

v1.14.0

Dec 23, 2025

v1.13.0

Dec 19, 2025

Changes in this version

+ func ProcessOrderBy[T acceptedOrdersConstraint](db *DBModel, orderBy string, acceptedOrders T, defaultOrderKey ...any)

v1.12.4

Sep 22, 2025

Changes in this version

type DBModel

+ func (db *DBModel) ToQueryBuilder() (*qb.QueryBuilder, error)

v1.12.3

Aug 11, 2025

v1.12.2

Aug 6, 2025

v1.12.1

Aug 4, 2025

v1.12.0

Aug 2, 2025

Changes in this version

type Column

+ Serial bool

type Table

+ PrimarySerial *Column

v1.11.1

Jul 22, 2025

v1.11.0

Jul 17, 2025

Changes in this version

+ type Fetch qb.Fetch

+ type FnWhereBuilder func(whereBuilder WhereBuilder) *WhereBuilder

+ type Limit qb.Limit

+ type Where struct

+ Conditions []Condition

+ type WhereBuilder struct

+ func WhereInstance() *WhereBuilder

+ func (wb *WhereBuilder) Conditions() []Condition

+ func (wb *WhereBuilder) Where(field any, opt WhereOpt, value any) *WhereBuilder

+ func (wb *WhereBuilder) WhereCondition(conditions ...Condition) *WhereBuilder

+ func (wb *WhereBuilder) WhereGroup(groupCondition FnWhereBuilder) *WhereBuilder

+ func (wb *WhereBuilder) WhereOr(field any, opt WhereOpt, value any) *WhereBuilder

v1.10.2

Jul 17, 2025

v1.10.1

Jul 16, 2025

Changes in this version

type ValueField

+ func (v ValueField) Value() string

v1.10.0

Jul 16, 2025

Changes in this version

+ type Condition struct

+ AndOr WhereAndOr

+ Field any

+ Group []Condition

+ Opt WhereOpt

+ Value any

+ func (c Condition) ToQBCondition() qb.Condition

+ type FieldEmpty qb.FieldEmpty

+ type FieldNot qb.FieldNot

+ type FieldYear qb.FieldYear

+ type ValueField qb.ValueField

v1.9.0

Jul 16, 2025

Changes in this version

+ const And

+ const Asc

+ const Between

+ const CrossJoin

+ const Desc

+ const Diff

+ const DiffAll

+ const DiffAny

+ const Eq

+ const EqAll

+ const EqAny

+ const Exists

+ const FullOuterJoin

+ const GrEq

+ const GrEqAll

+ const GrEqAny

+ const Greater

+ const GreaterAll

+ const GreaterAny

+ const In

+ const InnerJoin

+ const LeEq

+ const LeEqAll

+ const LeEqAny

+ const LeftJoin

+ const Lesser

+ const LesserAll

+ const LesserAny

+ const Like

+ const NotBetween

+ const NotEq

+ const NotEqAll

+ const NotEqAny

+ const NotExists

+ const NotIn

+ const NotLike

+ const NotNull

+ const Null

+ const Or

+ const RightJoin

+ type JoinType = qb.JoinType

+ type OrderByDir = qb.OrderByDir

+ type WhereAndOr = qb.WhereAndOr

+ type WhereOpt = qb.WhereOpt

v1.8.0

Jul 15, 2025

v1.7.0

Jul 15, 2025

v1.6.5

Jun 19, 2025

v1.6.4

Jun 5, 2025

v1.6.3

Jun 5, 2025

v1.6.2

May 8, 2025

v1.6.1

May 7, 2025

v1.6.0

May 6, 2025

v1.5.1

Apr 11, 2025

v1.5.0

Apr 9, 2025

Changes in this version

+ func FindModels[T any](page, limit int, sortField string, sortDir qb.OrderByDir, ...) ([]T, int, error)

+ func GetModelByID[T any](value any) (*T, error)

+ func GetModelBy[T any](field string, value any) (*T, error)

+ func GetModelWhereEq[T any](field string, value any) (*T, error)

v1.4.1

Dec 29, 2024

v1.4.0

Dec 27, 2024

v1.3.0

Dec 12, 2024

v1.2.0

Nov 5, 2024

v1.1.0

Aug 24, 2024

v1.0.0

Aug 23, 2024

Changes in this version

+ const CASCADE

+ const MODEL

+ const NAME

+ const REFERENCE

+ const RELATION

+ const TABLE

+ const TYPE

+ func Connect(connURL, driver string) (*sqlx.DB, error)

+ func CreateModel[T any](m *T) error

+ func DeleteModel[T any](m *T) error

+ func GetModel[T any](m *T, field string, value any, filters ...Filter) error

+ func ListModels[T any](page, limit int, field string, value any, filters ...Filter) ([]*T, int, error)

+ func Load()

+ func Register(driver IDatabase)

+ func UpdateModel[T any](m *T) error

+ type Column struct

+ HasValue bool

+ IsZero bool

+ Key string

+ Name string

+ Primary bool

+ Ref string

+ Relation string

+ Types string

+ type DB struct

+ type DBModel struct

+ func Instance() *DBModel

+ func (db *DBModel) Begin() *DBModel

+ func (db *DBModel) Commit() error

+ func (db *DBModel) Create(model any) (err error)

+ func (db *DBModel) Delete(model any, args ...any) (err error)

+ func (db *DBModel) Fetch(offset, fetch int) *DBModel

+ func (db *DBModel) Find(model any, params ...any) (total int, err error)

+ func (db *DBModel) First(model any) (err error)

+ func (db *DBModel) Get(model any, getType GetOne) (err error)

+ func (db *DBModel) GroupBy(fields ...string) *DBModel

+ func (db *DBModel) Having(field any, opt fluentsql.WhereOpt, value any) *DBModel

+ func (db *DBModel) Join(join fluentsql.JoinType, table string, condition fluentsql.Condition) *DBModel

+ func (db *DBModel) Last(model any) (err error)

+ func (db *DBModel) Limit(limit, offset int) *DBModel

+ func (db *DBModel) Model(model any) *DBModel

+ func (db *DBModel) Omit(columns ...any) *DBModel

+ func (db *DBModel) OrderBy(field string, dir fluentsql.OrderByDir) *DBModel

+ func (db *DBModel) Raw(sqlStr string, args ...any) *DBModel

+ func (db *DBModel) RemoveFetch() fluentsql.Fetch

+ func (db *DBModel) RemoveLimit() fluentsql.Limit

+ func (db *DBModel) Rollback() error

+ func (db *DBModel) Select(columns ...any) *DBModel

+ func (db *DBModel) Take(model any, args ...any) (err error)

+ func (db *DBModel) Update(model any) (err error)

+ func (db *DBModel) When(condition bool, groupCondition fluentsql.FnWhereBuilder) *DBModel

+ func (db *DBModel) Where(field any, opt fluentsql.WhereOpt, value any) *DBModel

+ func (db *DBModel) WhereGroup(groupCondition fluentsql.FnWhereBuilder) *DBModel

+ func (db *DBModel) WhereOr(field any, opt fluentsql.WhereOpt, value any) *DBModel

+ type Filter core.Data

+ type GetOne int

+ const GetFirst

+ const GetLast

+ const TakeOne

+ type IDatabase interface

+ Load func() (*sqlx.DB, error)

+ type MetaData string

+ type Raw struct

+ type Table struct

+ Columns []Column

+ HasData bool

+ Name string

+ Primaries []Column

+ Relation []*Table

+ Values map[string]any

+ func ModelData(model any) (*Table, error)

+ func NewTable() *Table

Other modules containing this package

github.com/gflydev/db/v2

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