| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223 |
- import {
- types,
- VercelPool
- } from "@vercel/postgres";
- import { NoopCache } from "../cache/core/cache.js";
- import { entityKind } from "../entity.js";
- import { NoopLogger } from "../logger.js";
- import { PgTransaction } from "../pg-core/index.js";
- import { PgPreparedQuery, PgSession } from "../pg-core/session.js";
- import { fillPlaceholders, sql } from "../sql/sql.js";
- import { mapResultRow } from "../utils.js";
- class VercelPgPreparedQuery extends PgPreparedQuery {
- constructor(client, queryString, params, logger, cache, queryMetadata, cacheConfig, fields, name, _isResponseInArrayMode, customResultMapper) {
- super({ sql: queryString, params }, cache, queryMetadata, cacheConfig);
- this.client = client;
- this.params = params;
- this.logger = logger;
- this.fields = fields;
- this._isResponseInArrayMode = _isResponseInArrayMode;
- this.customResultMapper = customResultMapper;
- this.rawQuery = {
- name,
- text: queryString,
- types: {
- // @ts-ignore
- getTypeParser: (typeId, format) => {
- if (typeId === types.builtins.TIMESTAMPTZ) {
- return (val) => val;
- }
- if (typeId === types.builtins.TIMESTAMP) {
- return (val) => val;
- }
- if (typeId === types.builtins.DATE) {
- return (val) => val;
- }
- if (typeId === types.builtins.INTERVAL) {
- return (val) => val;
- }
- if (typeId === 1231) {
- return (val) => val;
- }
- if (typeId === 1115) {
- return (val) => val;
- }
- if (typeId === 1185) {
- return (val) => val;
- }
- if (typeId === 1187) {
- return (val) => val;
- }
- if (typeId === 1182) {
- return (val) => val;
- }
- return types.getTypeParser(typeId, format);
- }
- }
- };
- this.queryConfig = {
- name,
- text: queryString,
- rowMode: "array",
- types: {
- // @ts-ignore
- getTypeParser: (typeId, format) => {
- if (typeId === types.builtins.TIMESTAMPTZ) {
- return (val) => val;
- }
- if (typeId === types.builtins.TIMESTAMP) {
- return (val) => val;
- }
- if (typeId === types.builtins.DATE) {
- return (val) => val;
- }
- if (typeId === types.builtins.INTERVAL) {
- return (val) => val;
- }
- if (typeId === 1231) {
- return (val) => val;
- }
- if (typeId === 1115) {
- return (val) => val;
- }
- if (typeId === 1185) {
- return (val) => val;
- }
- if (typeId === 1187) {
- return (val) => val;
- }
- if (typeId === 1182) {
- return (val) => val;
- }
- return types.getTypeParser(typeId, format);
- }
- }
- };
- }
- static [entityKind] = "VercelPgPreparedQuery";
- rawQuery;
- queryConfig;
- async execute(placeholderValues = {}) {
- const params = fillPlaceholders(this.params, placeholderValues);
- this.logger.logQuery(this.rawQuery.text, params);
- const { fields, rawQuery, client, queryConfig: query, joinsNotNullableMap, customResultMapper } = this;
- if (!fields && !customResultMapper) {
- return this.queryWithCache(rawQuery.text, params, async () => {
- return await client.query(rawQuery, params);
- });
- }
- const { rows } = await this.queryWithCache(query.text, params, async () => {
- return await client.query(query, params);
- });
- if (customResultMapper) {
- return customResultMapper(rows);
- }
- return rows.map((row) => mapResultRow(fields, row, joinsNotNullableMap));
- }
- all(placeholderValues = {}) {
- const params = fillPlaceholders(this.params, placeholderValues);
- this.logger.logQuery(this.rawQuery.text, params);
- return this.queryWithCache(this.rawQuery.text, params, async () => {
- return await this.client.query(this.rawQuery, params);
- }).then((result) => result.rows);
- }
- values(placeholderValues = {}) {
- const params = fillPlaceholders(this.params, placeholderValues);
- this.logger.logQuery(this.rawQuery.text, params);
- return this.queryWithCache(this.queryConfig.text, params, async () => {
- return await this.client.query(this.queryConfig, params);
- }).then((result) => result.rows);
- }
- /** @internal */
- isResponseInArrayMode() {
- return this._isResponseInArrayMode;
- }
- }
- class VercelPgSession extends PgSession {
- 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] = "VercelPgSession";
- logger;
- cache;
- prepareQuery(query, fields, name, isResponseInArrayMode, customResultMapper, queryMetadata, cacheConfig) {
- return new VercelPgPreparedQuery(
- this.client,
- query.sql,
- query.params,
- this.logger,
- this.cache,
- queryMetadata,
- cacheConfig,
- fields,
- name,
- isResponseInArrayMode,
- customResultMapper
- );
- }
- async query(query, params) {
- this.logger.logQuery(query, params);
- const result = await this.client.query({
- rowMode: "array",
- text: query,
- values: params
- });
- return result;
- }
- async queryObjects(query, params) {
- return this.client.query(query, params);
- }
- async count(sql2) {
- const result = await this.execute(sql2);
- return Number(result["rows"][0]["count"]);
- }
- async transaction(transaction, config) {
- const session = this.client instanceof VercelPool ? new VercelPgSession(await this.client.connect(), this.dialect, this.schema, this.options) : this;
- const tx = new VercelPgTransaction(this.dialect, session, this.schema);
- await tx.execute(sql`begin${config ? sql` ${tx.getTransactionConfigSQL(config)}` : void 0}`);
- try {
- const result = await transaction(tx);
- await tx.execute(sql`commit`);
- return result;
- } catch (error) {
- await tx.execute(sql`rollback`);
- throw error;
- } finally {
- if (this.client instanceof VercelPool) {
- session.client.release();
- }
- }
- }
- }
- class VercelPgTransaction extends PgTransaction {
- static [entityKind] = "VercelPgTransaction";
- async transaction(transaction) {
- const savepointName = `sp${this.nestedIndex + 1}`;
- const tx = new VercelPgTransaction(
- 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 {
- VercelPgPreparedQuery,
- VercelPgSession,
- VercelPgTransaction
- };
- //# sourceMappingURL=session.js.map
|