Class SQLiteInsertBuilder<TTable, TResultType, TRunResult>

constructor

• new SQLiteInsertBuilder<
      TTable extends SQLiteTable<TableConfig>,
      TResultType extends "sync" | "async",
      TRunResult,
  >(
      table: TTable,
      session: SQLiteSession<any, any, any, any>,
      dialect: SQLiteDialect,
      withList?: Subquery<string, Record<string, unknown>>[],
  ): SQLiteInsertBuilder<TTable, TResultType, TRunResult>

  Type Parameters

  • TTable extends SQLiteTable<TableConfig>
  • TResultType extends "sync" | "async"
  • TRunResult

  Parameters

  • table: TTable
  • session: SQLiteSession<any, any, any, any>
  • dialect: SQLiteDialect
  • OptionalwithList: Subquery<string, Record<string, unknown>>[]

  Returns SQLiteInsertBuilder<TTable, TResultType, TRunResult>

Static Readonly[entityKind]

select

• select(
      selectQuery: (
          qb: QueryBuilder,
      ) => SQLiteInsertSelectQueryBuilder<TTable>,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • selectQuery: (qb: QueryBuilder) => SQLiteInsertSelectQueryBuilder<TTable>

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

• select(
      selectQuery: (qb: QueryBuilder) => SQL,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • selectQuery: (qb: QueryBuilder) => SQL

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

• select(selectQuery: SQL): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • selectQuery: SQL

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

• select(
      selectQuery: SQLiteInsertSelectQueryBuilder<TTable>,
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • selectQuery: SQLiteInsertSelectQueryBuilder<TTable>

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

values

• values(
      value: {
          [K in string | number | symbol]: {
              [Key in string | number | symbol]:
                  | SQL<unknown>
                  | Placeholder<string, any>
                  | TTable["$inferInsert"][Key]
          }[K]
      },
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • value: {
        [K in string | number | symbol]: {
            [Key in string | number | symbol]:
                | SQL<unknown>
                | Placeholder<string, any>
                | TTable["$inferInsert"][Key]
        }[K]
    }

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>

• values(
      values: {
          [K in string | number | symbol]: {
              [Key in string | number | symbol]:
                  | SQL<unknown>
                  | Placeholder<string, any>
                  | TTable["$inferInsert"][Key]
          }[K]
      }[],
  ): SQLiteInsertBase<TTable, TResultType, TRunResult>

  Parameters

  • values: {
        [K in string | number | symbol]: {
            [Key in string | number | symbol]:
                | SQL<unknown>
                | Placeholder<string, any>
                | TTable["$inferInsert"][Key]
        }[K]
    }[]

  Returns SQLiteInsertBase<TTable, TResultType, TRunResult>