Readonlycolumns

columns: T

ReadonlyprimaryKeys

primaryKeys: Extract<keyof T, string>[]

ReadonlytableName

tableName: string

ReadonlyuniqueKeys

uniqueKeys: Extract<keyof T, string>[][]

D1Orm

• get D1Orm(): D1Orm

• Returns D1Orm

  The ORM instance that this model is using.

createTableDefinition

• get createTableDefinition(): string

• Returns string

  A CreateTable definition for the model, which can be used in a CREATE TABLE statement.

All

• All(options): Promise<D1Result<InferFromColumns<T>>>

• Returns Promise<D1Result<InferFromColumns<T>>>

  Returns all rows that match the where clause.

CreateTable

• CreateTable(options?): Promise<D1ExecResult>

• Parameters

  • options: {
        strategy: "default" | "force";
    } = ...

    • strategy: "default" | "force"

  Returns Promise<D1ExecResult>

Delete

• Delete(options): Promise<D1Result<unknown>>

• Returns Promise<D1Result<unknown>>

DropTable

• DropTable(silent?): Promise<D1ExecResult>

• Parameters

  • Optionalsilent: boolean

  Returns Promise<D1ExecResult>

First

• First(options): Promise<null | InferFromColumns<T>>

• Returns Promise<null | InferFromColumns<T>>

  Returns the first row that matches the where clause, or null if no rows match.

InsertMany

• InsertMany(data, orReplace?): Promise<D1Result<InferFromColumns<T>>[]>

• Parameters

  • data: Partial<InferFromColumns<T>>[]
  • orReplace: boolean = false

  Returns Promise<D1Result<InferFromColumns<T>>[]>

InsertOne

• InsertOne(data, orReplace?): Promise<D1Result<InferFromColumns<T>>>

• Parameters

  • data: Partial<InferFromColumns<T>>
  • orReplace: boolean = false

  Returns Promise<D1Result<InferFromColumns<T>>>

SetOrm

• SetOrm(orm): this

• Returns this

Update

• Update(options): Promise<D1Result<unknown>>

• Returns Promise<D1Result<unknown>>

Upsert

• Upsert(options): Promise<D1Result<unknown>>

• Parameters

  • options: Pick<GenerateQueryOptions<InferFromColumns<T>>, "data" | "where" | "upsertOnlyUpdateData">

  Returns Promise<D1Result<unknown>>