| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194 |
- import { NoopCache } from "../cache/core/index.js";
- import { entityKind } from "../entity.js";
- import { NoopLogger } from "../logger.js";
- import { fillPlaceholders, sql } from "../sql/sql.js";
- import { SQLiteTransaction } from "../sqlite-core/index.js";
- import { SQLitePreparedQuery, SQLiteSession } from "../sqlite-core/session.js";
- import { mapResultRow } from "../utils.js";
- class SQLiteD1Session extends SQLiteSession {
- constructor(client, dialect, schema, options = {}) {
- super(dialect);
- this.client = client;
- this.schema = schema;
- this.options = options;
- this.logger = options.logger ?? new NoopLogger();
- this.cache = options.cache ?? new NoopCache();
- }
- static [entityKind] = "SQLiteD1Session";
- logger;
- cache;
- prepareQuery(query, fields, executeMethod, isResponseInArrayMode, customResultMapper, queryMetadata, cacheConfig) {
- const stmt = this.client.prepare(query.sql);
- return new D1PreparedQuery(
- stmt,
- query,
- this.logger,
- this.cache,
- queryMetadata,
- cacheConfig,
- fields,
- executeMethod,
- isResponseInArrayMode,
- customResultMapper
- );
- }
- async batch(queries) {
- const preparedQueries = [];
- const builtQueries = [];
- for (const query of queries) {
- const preparedQuery = query._prepare();
- const builtQuery = preparedQuery.getQuery();
- preparedQueries.push(preparedQuery);
- if (builtQuery.params.length > 0) {
- builtQueries.push(preparedQuery.stmt.bind(...builtQuery.params));
- } else {
- const builtQuery2 = preparedQuery.getQuery();
- builtQueries.push(
- this.client.prepare(builtQuery2.sql).bind(...builtQuery2.params)
- );
- }
- }
- const batchResults = await this.client.batch(builtQueries);
- return batchResults.map((result, i) => preparedQueries[i].mapResult(result, true));
- }
- extractRawAllValueFromBatchResult(result) {
- return result.results;
- }
- extractRawGetValueFromBatchResult(result) {
- return result.results[0];
- }
- extractRawValuesValueFromBatchResult(result) {
- return d1ToRawMapping(result.results);
- }
- async transaction(transaction, config) {
- const tx = new D1Transaction("async", this.dialect, this, this.schema);
- await this.run(sql.raw(`begin${config?.behavior ? " " + config.behavior : ""}`));
- try {
- const result = await transaction(tx);
- await this.run(sql`commit`);
- return result;
- } catch (err) {
- await this.run(sql`rollback`);
- throw err;
- }
- }
- }
- class D1Transaction extends SQLiteTransaction {
- static [entityKind] = "D1Transaction";
- async transaction(transaction) {
- const savepointName = `sp${this.nestedIndex}`;
- const tx = new D1Transaction("async", this.dialect, this.session, this.schema, this.nestedIndex + 1);
- await this.session.run(sql.raw(`savepoint ${savepointName}`));
- try {
- const result = await transaction(tx);
- await this.session.run(sql.raw(`release savepoint ${savepointName}`));
- return result;
- } catch (err) {
- await this.session.run(sql.raw(`rollback to savepoint ${savepointName}`));
- throw err;
- }
- }
- }
- function d1ToRawMapping(results) {
- const rows = [];
- for (const row of results) {
- const entry = Object.keys(row).map((k) => row[k]);
- rows.push(entry);
- }
- return rows;
- }
- class D1PreparedQuery extends SQLitePreparedQuery {
- constructor(stmt, query, logger, cache, queryMetadata, cacheConfig, fields, executeMethod, _isResponseInArrayMode, customResultMapper) {
- super("async", executeMethod, query, cache, queryMetadata, cacheConfig);
- this.logger = logger;
- this._isResponseInArrayMode = _isResponseInArrayMode;
- this.customResultMapper = customResultMapper;
- this.fields = fields;
- this.stmt = stmt;
- }
- static [entityKind] = "D1PreparedQuery";
- /** @internal */
- customResultMapper;
- /** @internal */
- fields;
- /** @internal */
- stmt;
- async run(placeholderValues) {
- const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
- this.logger.logQuery(this.query.sql, params);
- return await this.queryWithCache(this.query.sql, params, async () => {
- return this.stmt.bind(...params).run();
- });
- }
- async all(placeholderValues) {
- const { fields, query, logger, stmt, customResultMapper } = this;
- if (!fields && !customResultMapper) {
- const params = fillPlaceholders(query.params, placeholderValues ?? {});
- logger.logQuery(query.sql, params);
- return await this.queryWithCache(query.sql, params, async () => {
- return stmt.bind(...params).all().then(({ results }) => this.mapAllResult(results));
- });
- }
- const rows = await this.values(placeholderValues);
- return this.mapAllResult(rows);
- }
- mapAllResult(rows, isFromBatch) {
- if (isFromBatch) {
- rows = d1ToRawMapping(rows.results);
- }
- if (!this.fields && !this.customResultMapper) {
- return rows;
- }
- if (this.customResultMapper) {
- return this.customResultMapper(rows);
- }
- return rows.map((row) => mapResultRow(this.fields, row, this.joinsNotNullableMap));
- }
- async get(placeholderValues) {
- const { fields, joinsNotNullableMap, query, logger, stmt, customResultMapper } = this;
- if (!fields && !customResultMapper) {
- const params = fillPlaceholders(query.params, placeholderValues ?? {});
- logger.logQuery(query.sql, params);
- return await this.queryWithCache(query.sql, params, async () => {
- return stmt.bind(...params).all().then(({ results }) => results[0]);
- });
- }
- const rows = await this.values(placeholderValues);
- if (!rows[0]) {
- return void 0;
- }
- if (customResultMapper) {
- return customResultMapper(rows);
- }
- return mapResultRow(fields, rows[0], joinsNotNullableMap);
- }
- mapGetResult(result, isFromBatch) {
- if (isFromBatch) {
- result = d1ToRawMapping(result.results)[0];
- }
- if (!this.fields && !this.customResultMapper) {
- return result;
- }
- if (this.customResultMapper) {
- return this.customResultMapper([result]);
- }
- return mapResultRow(this.fields, result, this.joinsNotNullableMap);
- }
- async values(placeholderValues) {
- const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
- this.logger.logQuery(this.query.sql, params);
- return await this.queryWithCache(this.query.sql, params, async () => {
- return this.stmt.bind(...params).raw();
- });
- }
- /** @internal */
- isResponseInArrayMode() {
- return this._isResponseInArrayMode;
- }
- }
- export {
- D1PreparedQuery,
- D1Transaction,
- SQLiteD1Session
- };
- //# sourceMappingURL=session.js.map
|