kysely.Transaction | /mod.ts | kysely_postgrs_js_dialect@v0.27.4

method kysely.Transaction.prototype.withTables

import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { Transaction } = kysely;

withTables<T extends Record<string, Record<string, any>>>(): Transaction<DrainOuterGeneric<DB & T>>

Returns a copy of this Kysely instance with tables added to its database type.

This method only modifies the types and doesn't affect any of the executed queries in any way.

Examples

The following example adds and uses a temporary table:

Examples

Example 1

await db.schema
  .createTable('temp_table')
  .temporary()
  .addColumn('some_column', 'integer')
  .execute()

const tempDb = db.withTables<{
  temp_table: {
    some_column: number
  }
}>()

await tempDb
  .insertInto('temp_table')
  .values({ some_column: 100 })
  .execute()

Type Parameters

T extends Record<string, Record<string, any>>

Returns

Transaction<DrainOuterGeneric<DB & T>>