sqlorm

func (*DBConn) Model ¶

func (m *DBConn) Model(data any) types.ORMModel

func (*Model) Asc ¶

func (m *Model) Asc(condition any) types.ORMModel

正序

func (*Model) BulkWrite ¶ added in v0.1.9

func (m *Model) BulkWrite(datas any, order bool) error

**

operations := []BulkWriteOperation{
    {
        Type: "insert",
        Data: &User{Name: "Alice"},
    },
    {
        Type:  "update",
        Data:  &User{},
        Where: map[string]any{"name": "Bob"},
        Values: map[string]any{"age": 30},
    },
    {
        Type:  "delete",
        Data:  &User{},
        Where: map[string]any{"name": "Charlie"},
    },
}

err := model.BulkWrite(operations, true) **

func (*Model) Create ¶

func (m *Model) Create(data any) (id string, err error)

插入数据

func (*Model) Delete ¶

func (m *Model) Delete(data ...any) error

删除

func (*Model) Desc ¶

func (m *Model) Desc(condition any) types.ORMModel

逆序

func (*Model) Find ¶

func (m *Model) Find() types.ORMQuary

查询数据

func (*Model) GetContext ¶ added in v0.0.4

func (m *Model) GetContext() context.Context

func (*Model) Limit ¶

func (m *Model) Limit(limit int) types.ORMModel

限制查询的数量

func (*Model) Offset ¶

func (m *Model) Offset(offset int) types.ORMModel

跳过查询的数量

func (*Model) Page ¶

func (m *Model) Page(page, limit int) types.ORMModel

func (*Model) Save ¶

func (m *Model) Save(data any, value ...any) (id string, err error)

更新或插入数据

func (*Model) Session ¶ added in v0.0.4

func (m *Model) Session(transactionFunc func(sessionContext context.Context) error) error

func (*Model) SetContext ¶ added in v0.0.4

func (m *Model) SetContext(ctx context.Context) types.ORMModel

func (*Model) Update ¶

func (m *Model) Update(data any, value ...any) error

修改

func (*Model) Where ¶

func (m *Model) Where(condition any, value ...any) types.ORMModel

限制条件

func (*Model) WhereGt ¶

func (m *Model) WhereGt(condition any, value ...any) types.ORMModel

func (*Model) WhereGte ¶ added in v0.1.1

func (m *Model) WhereGte(condition any, value ...any) types.ORMModel

func (*Model) WhereIs ¶

func (m *Model) WhereIs(key string, value any) types.ORMModel

func (*Model) WhereLt ¶

func (m *Model) WhereLt(condition any, value ...any) types.ORMModel

func (*Model) WhereLte ¶ added in v0.1.1

func (m *Model) WhereLte(condition any, value ...any) types.ORMModel

func (*Model) WhereNot ¶

func (m *Model) WhereNot(condition any, value ...any) types.ORMModel

func (*Model) WhereOr ¶

func (m *Model) WhereOr(condition any, value ...any) types.ORMModel

func (Quary) All ¶

func (q Quary) All(data any) error

func (Quary) Count ¶

func (q Quary) Count() (i int64, err error)

func (Quary) Delete ¶ added in v0.0.4

func (q Quary) Delete() error

func (Quary) One ¶

func (q Quary) One(data any) error