Spaces:
Sleeping
Sleeping
File size: 6,107 Bytes
6491ad4 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 | 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 SQLiteRemoteSession extends SQLiteSession {
constructor(client, dialect, schema, batchCLient, options = {}) {
super(dialect);
this.client = client;
this.schema = schema;
this.batchCLient = batchCLient;
this.logger = options.logger ?? new NoopLogger();
this.cache = options.cache ?? new NoopCache();
}
static [entityKind] = "SQLiteRemoteSession";
logger;
cache;
prepareQuery(query, fields, executeMethod, isResponseInArrayMode, customResultMapper, queryMetadata, cacheConfig) {
return new RemotePreparedQuery(
this.client,
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);
builtQueries.push({ sql: builtQuery.sql, params: builtQuery.params, method: builtQuery.method });
}
const batchResults = await this.batchCLient(builtQueries);
return batchResults.map((result, i) => preparedQueries[i].mapResult(result, true));
}
async transaction(transaction, config) {
const tx = new SQLiteProxyTransaction("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;
}
}
extractRawAllValueFromBatchResult(result) {
return result.rows;
}
extractRawGetValueFromBatchResult(result) {
return result.rows[0];
}
extractRawValuesValueFromBatchResult(result) {
return result.rows;
}
}
class SQLiteProxyTransaction extends SQLiteTransaction {
static [entityKind] = "SQLiteProxyTransaction";
async transaction(transaction) {
const savepointName = `sp${this.nestedIndex}`;
const tx = new SQLiteProxyTransaction("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;
}
}
}
class RemotePreparedQuery extends SQLitePreparedQuery {
constructor(client, query, logger, cache, queryMetadata, cacheConfig, fields, executeMethod, _isResponseInArrayMode, customResultMapper) {
super("async", executeMethod, query, cache, queryMetadata, cacheConfig);
this.client = client;
this.logger = logger;
this.fields = fields;
this._isResponseInArrayMode = _isResponseInArrayMode;
this.customResultMapper = customResultMapper;
this.customResultMapper = customResultMapper;
this.method = executeMethod;
}
static [entityKind] = "SQLiteProxyPreparedQuery";
method;
getQuery() {
return { ...this.query, method: this.method };
}
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 await this.client(this.query.sql, params, "run");
});
}
mapAllResult(rows, isFromBatch) {
if (isFromBatch) {
rows = rows.rows;
}
if (!this.fields && !this.customResultMapper) {
return rows;
}
if (this.customResultMapper) {
return this.customResultMapper(rows);
}
return rows.map((row) => {
return mapResultRow(
this.fields,
row,
this.joinsNotNullableMap
);
});
}
async all(placeholderValues) {
const { query, logger, client } = this;
const params = fillPlaceholders(query.params, placeholderValues ?? {});
logger.logQuery(query.sql, params);
const { rows } = await this.queryWithCache(query.sql, params, async () => {
return await client(query.sql, params, "all");
});
return this.mapAllResult(rows);
}
async get(placeholderValues) {
const { query, logger, client } = this;
const params = fillPlaceholders(query.params, placeholderValues ?? {});
logger.logQuery(query.sql, params);
const clientResult = await this.queryWithCache(query.sql, params, async () => {
return await client(query.sql, params, "get");
});
return this.mapGetResult(clientResult.rows);
}
mapGetResult(rows, isFromBatch) {
if (isFromBatch) {
rows = rows.rows;
}
const row = rows;
if (!this.fields && !this.customResultMapper) {
return row;
}
if (!row) {
return void 0;
}
if (this.customResultMapper) {
return this.customResultMapper([rows]);
}
return mapResultRow(
this.fields,
row,
this.joinsNotNullableMap
);
}
async values(placeholderValues) {
const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
this.logger.logQuery(this.query.sql, params);
const clientResult = await this.queryWithCache(this.query.sql, params, async () => {
return await this.client(this.query.sql, params, "values");
});
return clientResult.rows;
}
/** @internal */
isResponseInArrayMode() {
return this._isResponseInArrayMode;
}
}
export {
RemotePreparedQuery,
SQLiteProxyTransaction,
SQLiteRemoteSession
};
//# sourceMappingURL=session.js.map |