Skip to main content
Module

x/dso/src/model.ts>BaseModel

Simple Orm library for Deno based on deno_mysql
manyuanrong/dso
Latest
class BaseModel
import { BaseModel } from "https://deno.land/x/dso@v1.0.0/src/model.ts";

Model base class

Constructors

new
BaseModel(connection?: Connection)

Properties

optional
created_at: Date
readonly
modelFields: FieldOptions[]

get defined fields list

readonly
modelName: string

get model name

readonly
primaryKey: FieldOptions | undefined

get primary key

optional
updated_at: Date

Methods

private
convertModel(data: { [key: string]: any; }): ModelFields<this> | undefined

Convert data object to model

private
convertObject(model: ModelFields<this>): { [key: string]: any; }

Convert model object to db object

private
optionsToQuery(options: QueryOptions)
builder(): Query

return a new Query instance with table name

delete(where: Where): Promise<number>

delete by conditions

execute(query: Query)

excute custom

findAll(options: Where | QueryOptions): Promise<ModelFields<this>[]>

find all records by given conditions

findById(id: string | number): Promise<ModelFields<this> | undefined>

find one record by primary key

findOne(options: Where | QueryOptions): Promise<ModelFields<this> | undefined>

find one record

insert(fields: Partial<this>): Promise<number | undefined>

insert record

query(query: Query): Promise<any[]>

query custom

update(data: Partial<this>, where?: Where): Promise<number | undefined>

update records by given conditions