| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168 |
- import { NoopCache } from "../cache/core/index.js";
- import { Column } from "../column.js";
- import { entityKind, is } from "../entity.js";
- import { NoopLogger } from "../logger.js";
- import {
- MySqlPreparedQuery,
- MySqlSession,
- MySqlTransaction
- } from "../mysql-core/session.js";
- import { fillPlaceholders, sql } from "../sql/sql.js";
- import { mapResultRow } from "../utils.js";
- class PlanetScalePreparedQuery extends MySqlPreparedQuery {
- constructor(client, queryString, params, logger, cache, queryMetadata, cacheConfig, fields, customResultMapper, generatedIds, returningIds) {
- super(cache, queryMetadata, cacheConfig);
- this.client = client;
- this.queryString = queryString;
- this.params = params;
- this.logger = logger;
- this.fields = fields;
- this.customResultMapper = customResultMapper;
- this.generatedIds = generatedIds;
- this.returningIds = returningIds;
- }
- static [entityKind] = "PlanetScalePreparedQuery";
- rawQuery = { as: "object" };
- query = { as: "array" };
- async execute(placeholderValues = {}) {
- const params = fillPlaceholders(this.params, placeholderValues);
- this.logger.logQuery(this.queryString, params);
- const {
- fields,
- client,
- queryString,
- rawQuery,
- query,
- joinsNotNullableMap,
- customResultMapper,
- returningIds,
- generatedIds
- } = this;
- if (!fields && !customResultMapper) {
- const res = await this.queryWithCache(queryString, params, async () => {
- return await client.execute(queryString, params, rawQuery);
- });
- const insertId = Number.parseFloat(res.insertId);
- const affectedRows = res.rowsAffected;
- if (returningIds) {
- const returningResponse = [];
- let j = 0;
- for (let i = insertId; i < insertId + affectedRows; i++) {
- for (const column of returningIds) {
- const key = returningIds[0].path[0];
- if (is(column.field, Column)) {
- if (column.field.primary && column.field.autoIncrement) {
- returningResponse.push({ [key]: i });
- }
- if (column.field.defaultFn && generatedIds) {
- returningResponse.push({ [key]: generatedIds[j][key] });
- }
- }
- }
- j++;
- }
- return returningResponse;
- }
- return res;
- }
- const { rows } = await this.queryWithCache(queryString, params, async () => {
- return await client.execute(queryString, params, query);
- });
- if (customResultMapper) {
- return customResultMapper(rows);
- }
- return rows.map((row) => mapResultRow(fields, row, joinsNotNullableMap));
- }
- iterator(_placeholderValues) {
- throw new Error("Streaming is not supported by the PlanetScale Serverless driver");
- }
- }
- class PlanetscaleSession extends MySqlSession {
- constructor(baseClient, dialect, tx, schema, options = {}) {
- super(dialect);
- this.baseClient = baseClient;
- this.schema = schema;
- this.options = options;
- this.client = tx ?? baseClient;
- this.logger = options.logger ?? new NoopLogger();
- this.cache = options.cache ?? new NoopCache();
- }
- static [entityKind] = "PlanetscaleSession";
- logger;
- client;
- cache;
- prepareQuery(query, fields, customResultMapper, generatedIds, returningIds, queryMetadata, cacheConfig) {
- return new PlanetScalePreparedQuery(
- this.client,
- query.sql,
- query.params,
- this.logger,
- this.cache,
- queryMetadata,
- cacheConfig,
- fields,
- customResultMapper,
- generatedIds,
- returningIds
- );
- }
- async query(query, params) {
- this.logger.logQuery(query, params);
- return await this.client.execute(query, params, { as: "array" });
- }
- async queryObjects(query, params) {
- return this.client.execute(query, params, { as: "object" });
- }
- all(query) {
- const querySql = this.dialect.sqlToQuery(query);
- this.logger.logQuery(querySql.sql, querySql.params);
- return this.client.execute(querySql.sql, querySql.params, { as: "object" }).then((eQuery) => eQuery.rows);
- }
- async count(sql2) {
- const res = await this.execute(sql2);
- return Number(
- res["rows"][0]["count"]
- );
- }
- transaction(transaction) {
- return this.baseClient.transaction((pstx) => {
- const session = new PlanetscaleSession(this.baseClient, this.dialect, pstx, this.schema, this.options);
- const tx = new PlanetScaleTransaction(
- this.dialect,
- session,
- this.schema
- );
- return transaction(tx);
- });
- }
- }
- class PlanetScaleTransaction extends MySqlTransaction {
- static [entityKind] = "PlanetScaleTransaction";
- constructor(dialect, session, schema, nestedIndex = 0) {
- super(dialect, session, schema, nestedIndex, "planetscale");
- }
- async transaction(transaction) {
- const savepointName = `sp${this.nestedIndex + 1}`;
- const tx = new PlanetScaleTransaction(
- this.dialect,
- this.session,
- this.schema,
- this.nestedIndex + 1
- );
- await tx.execute(sql.raw(`savepoint ${savepointName}`));
- try {
- const result = await transaction(tx);
- await tx.execute(sql.raw(`release savepoint ${savepointName}`));
- return result;
- } catch (err) {
- await tx.execute(sql.raw(`rollback to savepoint ${savepointName}`));
- throw err;
- }
- }
- }
- export {
- PlanetScalePreparedQuery,
- PlanetScaleTransaction,
- PlanetscaleSession
- };
- //# sourceMappingURL=session.js.map
|