Model | /lib/model.ts | denodb@v1.4.0

Using Deno in production at your company? Earn free Deno merch.

MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

Popular

Latest

method Model.leftOuterJoin

import { Model } from "https://deno.land/x/denodb@v1.4.0/lib/model.ts";

leftOuterJoin<T extends ModelSchema>(

this: T,

joinTable: ModelSchema,

originField: string,

targetField: string,

)

Join a table with left outer statement to the current query.

await Flight.where(
  Flight.field("departure"),
  "Paris",
).leftOuterJoin(
  Airport,
  Airport.field("id"),
  Flight.field("airportId"),
).get()

Type Parameters

T extends ModelSchema

this: T

joinTable: ModelSchema

originField: string

targetField: string