| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 |
- "use strict";
- var __defProp = Object.defineProperty;
- var __getOwnPropDesc = Object.getOwnPropertyDescriptor;
- var __getOwnPropNames = Object.getOwnPropertyNames;
- var __hasOwnProp = Object.prototype.hasOwnProperty;
- var __export = (target, all) => {
- for (var name in all)
- __defProp(target, name, { get: all[name], enumerable: true });
- };
- var __copyProps = (to, from, except, desc) => {
- if (from && typeof from === "object" || typeof from === "function") {
- for (let key of __getOwnPropNames(from))
- if (!__hasOwnProp.call(to, key) && key !== except)
- __defProp(to, key, { get: () => from[key], enumerable: !(desc = __getOwnPropDesc(from, key)) || desc.enumerable });
- }
- return to;
- };
- var __toCommonJS = (mod) => __copyProps(__defProp({}, "__esModule", { value: true }), mod);
- var update_exports = {};
- __export(update_exports, {
- SQLiteUpdateBase: () => SQLiteUpdateBase,
- SQLiteUpdateBuilder: () => SQLiteUpdateBuilder
- });
- module.exports = __toCommonJS(update_exports);
- var import_entity = require("../../entity.cjs");
- var import_query_promise = require("../../query-promise.cjs");
- var import_selection_proxy = require("../../selection-proxy.cjs");
- var import_table = require("../table.cjs");
- var import_subquery = require("../../subquery.cjs");
- var import_table2 = require("../../table.cjs");
- var import_utils = require("../../utils.cjs");
- var import_view_common = require("../../view-common.cjs");
- var import_utils2 = require("../utils.cjs");
- var import_view_base = require("../view-base.cjs");
- class SQLiteUpdateBuilder {
- constructor(table, session, dialect, withList) {
- this.table = table;
- this.session = session;
- this.dialect = dialect;
- this.withList = withList;
- }
- static [import_entity.entityKind] = "SQLiteUpdateBuilder";
- set(values) {
- return new SQLiteUpdateBase(
- this.table,
- (0, import_utils.mapUpdateSet)(this.table, values),
- this.session,
- this.dialect,
- this.withList
- );
- }
- }
- class SQLiteUpdateBase extends import_query_promise.QueryPromise {
- constructor(table, set, session, dialect, withList) {
- super();
- this.session = session;
- this.dialect = dialect;
- this.config = { set, table, withList, joins: [] };
- }
- static [import_entity.entityKind] = "SQLiteUpdate";
- /** @internal */
- config;
- from(source) {
- this.config.from = source;
- return this;
- }
- createJoin(joinType) {
- return (table, on) => {
- const tableName = (0, import_utils.getTableLikeName)(table);
- if (typeof tableName === "string" && this.config.joins.some((join) => join.alias === tableName)) {
- throw new Error(`Alias "${tableName}" is already used in this query`);
- }
- if (typeof on === "function") {
- const from = this.config.from ? (0, import_entity.is)(table, import_table.SQLiteTable) ? table[import_table2.Table.Symbol.Columns] : (0, import_entity.is)(table, import_subquery.Subquery) ? table._.selectedFields : (0, import_entity.is)(table, import_view_base.SQLiteViewBase) ? table[import_view_common.ViewBaseConfig].selectedFields : void 0 : void 0;
- on = on(
- new Proxy(
- this.config.table[import_table2.Table.Symbol.Columns],
- new import_selection_proxy.SelectionProxyHandler({ sqlAliasedBehavior: "sql", sqlBehavior: "sql" })
- ),
- from && new Proxy(
- from,
- new import_selection_proxy.SelectionProxyHandler({ sqlAliasedBehavior: "sql", sqlBehavior: "sql" })
- )
- );
- }
- this.config.joins.push({ on, table, joinType, alias: tableName });
- return this;
- };
- }
- leftJoin = this.createJoin("left");
- rightJoin = this.createJoin("right");
- innerJoin = this.createJoin("inner");
- fullJoin = this.createJoin("full");
- /**
- * Adds a 'where' clause to the query.
- *
- * Calling this method will update only those rows that fulfill a specified condition.
- *
- * See docs: {@link https://orm.drizzle.team/docs/update}
- *
- * @param where the 'where' clause.
- *
- * @example
- * You can use conditional operators and `sql function` to filter the rows to be updated.
- *
- * ```ts
- * // Update all cars with green color
- * db.update(cars).set({ color: 'red' })
- * .where(eq(cars.color, 'green'));
- * // or
- * db.update(cars).set({ color: 'red' })
- * .where(sql`${cars.color} = 'green'`)
- * ```
- *
- * You can logically combine conditional operators with `and()` and `or()` operators:
- *
- * ```ts
- * // Update all BMW cars with a green color
- * db.update(cars).set({ color: 'red' })
- * .where(and(eq(cars.color, 'green'), eq(cars.brand, 'BMW')));
- *
- * // Update all cars with the green or blue color
- * db.update(cars).set({ color: 'red' })
- * .where(or(eq(cars.color, 'green'), eq(cars.color, 'blue')));
- * ```
- */
- where(where) {
- this.config.where = where;
- return this;
- }
- orderBy(...columns) {
- if (typeof columns[0] === "function") {
- const orderBy = columns[0](
- new Proxy(
- this.config.table[import_table2.Table.Symbol.Columns],
- new import_selection_proxy.SelectionProxyHandler({ sqlAliasedBehavior: "alias", sqlBehavior: "sql" })
- )
- );
- const orderByArray = Array.isArray(orderBy) ? orderBy : [orderBy];
- this.config.orderBy = orderByArray;
- } else {
- const orderByArray = columns;
- this.config.orderBy = orderByArray;
- }
- return this;
- }
- limit(limit) {
- this.config.limit = limit;
- return this;
- }
- returning(fields = this.config.table[import_table.SQLiteTable.Symbol.Columns]) {
- this.config.returning = (0, import_utils.orderSelectedFields)(fields);
- return this;
- }
- /** @internal */
- getSQL() {
- return this.dialect.buildUpdateQuery(this.config);
- }
- toSQL() {
- const { typings: _typings, ...rest } = this.dialect.sqlToQuery(this.getSQL());
- return rest;
- }
- /** @internal */
- _prepare(isOneTimeQuery = true) {
- return this.session[isOneTimeQuery ? "prepareOneTimeQuery" : "prepareQuery"](
- this.dialect.sqlToQuery(this.getSQL()),
- this.config.returning,
- this.config.returning ? "all" : "run",
- true,
- void 0,
- {
- type: "insert",
- tables: (0, import_utils2.extractUsedTable)(this.config.table)
- }
- );
- }
- prepare() {
- return this._prepare(false);
- }
- run = (placeholderValues) => {
- return this._prepare().run(placeholderValues);
- };
- all = (placeholderValues) => {
- return this._prepare().all(placeholderValues);
- };
- get = (placeholderValues) => {
- return this._prepare().get(placeholderValues);
- };
- values = (placeholderValues) => {
- return this._prepare().values(placeholderValues);
- };
- async execute() {
- return this.config.returning ? this.all() : this.run();
- }
- $dynamic() {
- return this;
- }
- }
- // Annotate the CommonJS export names for ESM import in node:
- 0 && (module.exports = {
- SQLiteUpdateBase,
- SQLiteUpdateBuilder
- });
- //# sourceMappingURL=update.cjs.map
|