| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272 |
- "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 session_exports = {};
- __export(session_exports, {
- MySql2PreparedQuery: () => MySql2PreparedQuery,
- MySql2Session: () => MySql2Session,
- MySql2Transaction: () => MySql2Transaction
- });
- module.exports = __toCommonJS(session_exports);
- var import_node_events = require("node:events");
- var import_core = require("../cache/core/index.cjs");
- var import_column = require("../column.cjs");
- var import_entity = require("../entity.cjs");
- var import_logger = require("../logger.cjs");
- var import_session = require("../mysql-core/session.cjs");
- var import_sql = require("../sql/sql.cjs");
- var import_utils = require("../utils.cjs");
- class MySql2PreparedQuery extends import_session.MySqlPreparedQuery {
- constructor(client, queryString, params, logger, cache, queryMetadata, cacheConfig, fields, customResultMapper, generatedIds, returningIds) {
- super(cache, queryMetadata, cacheConfig);
- this.client = client;
- this.params = params;
- this.logger = logger;
- this.fields = fields;
- this.customResultMapper = customResultMapper;
- this.generatedIds = generatedIds;
- this.returningIds = returningIds;
- this.rawQuery = {
- sql: queryString,
- // rowsAsArray: true,
- typeCast: function(field, next) {
- if (field.type === "TIMESTAMP" || field.type === "DATETIME" || field.type === "DATE") {
- return field.string();
- }
- return next();
- }
- };
- this.query = {
- sql: queryString,
- rowsAsArray: true,
- typeCast: function(field, next) {
- if (field.type === "TIMESTAMP" || field.type === "DATETIME" || field.type === "DATE") {
- return field.string();
- }
- return next();
- }
- };
- }
- static [import_entity.entityKind] = "MySql2PreparedQuery";
- rawQuery;
- query;
- async execute(placeholderValues = {}) {
- const params = (0, import_sql.fillPlaceholders)(this.params, placeholderValues);
- this.logger.logQuery(this.rawQuery.sql, params);
- const { fields, client, rawQuery, query, joinsNotNullableMap, customResultMapper, returningIds, generatedIds } = this;
- if (!fields && !customResultMapper) {
- const res = await this.queryWithCache(rawQuery.sql, params, async () => {
- return await client.query(rawQuery, params);
- });
- const insertId = res[0].insertId;
- const affectedRows = res[0].affectedRows;
- 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 ((0, import_entity.is)(column.field, import_column.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 result = await this.queryWithCache(query.sql, params, async () => {
- return await client.query(query, params);
- });
- const rows = result[0];
- if (customResultMapper) {
- return customResultMapper(rows);
- }
- return rows.map((row) => (0, import_utils.mapResultRow)(fields, row, joinsNotNullableMap));
- }
- async *iterator(placeholderValues = {}) {
- const params = (0, import_sql.fillPlaceholders)(this.params, placeholderValues);
- const conn = (isPool(this.client) ? await this.client.getConnection() : this.client).connection;
- const { fields, query, rawQuery, joinsNotNullableMap, client, customResultMapper } = this;
- const hasRowsMapper = Boolean(fields || customResultMapper);
- const driverQuery = hasRowsMapper ? conn.query(query, params) : conn.query(rawQuery, params);
- const stream = driverQuery.stream();
- function dataListener() {
- stream.pause();
- }
- stream.on("data", dataListener);
- try {
- const onEnd = (0, import_node_events.once)(stream, "end");
- const onError = (0, import_node_events.once)(stream, "error");
- while (true) {
- stream.resume();
- const row = await Promise.race([onEnd, onError, new Promise((resolve) => stream.once("data", resolve))]);
- if (row === void 0 || Array.isArray(row) && row.length === 0) {
- break;
- } else if (row instanceof Error) {
- throw row;
- } else {
- if (hasRowsMapper) {
- if (customResultMapper) {
- const mappedRow = customResultMapper([row]);
- yield Array.isArray(mappedRow) ? mappedRow[0] : mappedRow;
- } else {
- yield (0, import_utils.mapResultRow)(fields, row, joinsNotNullableMap);
- }
- } else {
- yield row;
- }
- }
- }
- } finally {
- stream.off("data", dataListener);
- if (isPool(client)) {
- conn.end();
- }
- }
- }
- }
- class MySql2Session extends import_session.MySqlSession {
- constructor(client, dialect, schema, options) {
- super(dialect);
- this.client = client;
- this.schema = schema;
- this.options = options;
- this.logger = options.logger ?? new import_logger.NoopLogger();
- this.cache = options.cache ?? new import_core.NoopCache();
- this.mode = options.mode;
- }
- static [import_entity.entityKind] = "MySql2Session";
- logger;
- mode;
- cache;
- prepareQuery(query, fields, customResultMapper, generatedIds, returningIds, queryMetadata, cacheConfig) {
- return new MySql2PreparedQuery(
- this.client,
- query.sql,
- query.params,
- this.logger,
- this.cache,
- queryMetadata,
- cacheConfig,
- fields,
- customResultMapper,
- generatedIds,
- returningIds
- );
- }
- /**
- * @internal
- * What is its purpose?
- */
- async query(query, params) {
- this.logger.logQuery(query, params);
- const result = await this.client.query({
- sql: query,
- values: params,
- rowsAsArray: true,
- typeCast: function(field, next) {
- if (field.type === "TIMESTAMP" || field.type === "DATETIME" || field.type === "DATE") {
- return field.string();
- }
- return next();
- }
- });
- return result;
- }
- all(query) {
- const querySql = this.dialect.sqlToQuery(query);
- this.logger.logQuery(querySql.sql, querySql.params);
- return this.client.execute(querySql.sql, querySql.params).then((result) => result[0]);
- }
- async transaction(transaction, config) {
- const session = isPool(this.client) ? new MySql2Session(
- await this.client.getConnection(),
- this.dialect,
- this.schema,
- this.options
- ) : this;
- const tx = new MySql2Transaction(
- this.dialect,
- session,
- this.schema,
- 0,
- this.mode
- );
- if (config) {
- const setTransactionConfigSql = this.getSetTransactionSQL(config);
- if (setTransactionConfigSql) {
- await tx.execute(setTransactionConfigSql);
- }
- const startTransactionSql = this.getStartTransactionSQL(config);
- await (startTransactionSql ? tx.execute(startTransactionSql) : tx.execute(import_sql.sql`begin`));
- } else {
- await tx.execute(import_sql.sql`begin`);
- }
- try {
- const result = await transaction(tx);
- await tx.execute(import_sql.sql`commit`);
- return result;
- } catch (err) {
- await tx.execute(import_sql.sql`rollback`);
- throw err;
- } finally {
- if (isPool(this.client)) {
- session.client.release();
- }
- }
- }
- }
- class MySql2Transaction extends import_session.MySqlTransaction {
- static [import_entity.entityKind] = "MySql2Transaction";
- async transaction(transaction) {
- const savepointName = `sp${this.nestedIndex + 1}`;
- const tx = new MySql2Transaction(
- this.dialect,
- this.session,
- this.schema,
- this.nestedIndex + 1,
- this.mode
- );
- await tx.execute(import_sql.sql.raw(`savepoint ${savepointName}`));
- try {
- const result = await transaction(tx);
- await tx.execute(import_sql.sql.raw(`release savepoint ${savepointName}`));
- return result;
- } catch (err) {
- await tx.execute(import_sql.sql.raw(`rollback to savepoint ${savepointName}`));
- throw err;
- }
- }
- }
- function isPool(client) {
- return "getConnection" in client;
- }
- // Annotate the CommonJS export names for ESM import in node:
- 0 && (module.exports = {
- MySql2PreparedQuery,
- MySql2Session,
- MySql2Transaction
- });
- //# sourceMappingURL=session.cjs.map
|