session.js 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. import { entityKind } from "../entity.js";
  2. import { NoopLogger } from "../logger.js";
  3. import { fillPlaceholders, sql } from "../sql/sql.js";
  4. import { SQLiteTransaction } from "../sqlite-core/index.js";
  5. import { SQLitePreparedQuery as PreparedQueryBase, SQLiteSession } from "../sqlite-core/session.js";
  6. import { mapResultRow } from "../utils.js";
  7. class SQLJsSession extends SQLiteSession {
  8. constructor(client, dialect, schema, options = {}) {
  9. super(dialect);
  10. this.client = client;
  11. this.schema = schema;
  12. this.logger = options.logger ?? new NoopLogger();
  13. }
  14. static [entityKind] = "SQLJsSession";
  15. logger;
  16. prepareQuery(query, fields, executeMethod, isResponseInArrayMode) {
  17. return new PreparedQuery(this.client, query, this.logger, fields, executeMethod, isResponseInArrayMode);
  18. }
  19. transaction(transaction, config = {}) {
  20. const tx = new SQLJsTransaction("sync", this.dialect, this, this.schema);
  21. this.run(sql.raw(`begin${config.behavior ? ` ${config.behavior}` : ""}`));
  22. try {
  23. const result = transaction(tx);
  24. this.run(sql`commit`);
  25. return result;
  26. } catch (err) {
  27. this.run(sql`rollback`);
  28. throw err;
  29. }
  30. }
  31. }
  32. class SQLJsTransaction extends SQLiteTransaction {
  33. static [entityKind] = "SQLJsTransaction";
  34. transaction(transaction) {
  35. const savepointName = `sp${this.nestedIndex + 1}`;
  36. const tx = new SQLJsTransaction("sync", this.dialect, this.session, this.schema, this.nestedIndex + 1);
  37. tx.run(sql.raw(`savepoint ${savepointName}`));
  38. try {
  39. const result = transaction(tx);
  40. tx.run(sql.raw(`release savepoint ${savepointName}`));
  41. return result;
  42. } catch (err) {
  43. tx.run(sql.raw(`rollback to savepoint ${savepointName}`));
  44. throw err;
  45. }
  46. }
  47. }
  48. class PreparedQuery extends PreparedQueryBase {
  49. constructor(client, query, logger, fields, executeMethod, _isResponseInArrayMode, customResultMapper) {
  50. super("sync", executeMethod, query);
  51. this.client = client;
  52. this.logger = logger;
  53. this.fields = fields;
  54. this._isResponseInArrayMode = _isResponseInArrayMode;
  55. this.customResultMapper = customResultMapper;
  56. }
  57. static [entityKind] = "SQLJsPreparedQuery";
  58. run(placeholderValues) {
  59. const stmt = this.client.prepare(this.query.sql);
  60. const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
  61. this.logger.logQuery(this.query.sql, params);
  62. const result = stmt.run(params);
  63. stmt.free();
  64. return result;
  65. }
  66. all(placeholderValues) {
  67. const stmt = this.client.prepare(this.query.sql);
  68. const { fields, joinsNotNullableMap, logger, query, customResultMapper } = this;
  69. if (!fields && !customResultMapper) {
  70. const params = fillPlaceholders(query.params, placeholderValues ?? {});
  71. logger.logQuery(query.sql, params);
  72. stmt.bind(params);
  73. const rows2 = [];
  74. while (stmt.step()) {
  75. rows2.push(stmt.getAsObject());
  76. }
  77. stmt.free();
  78. return rows2;
  79. }
  80. const rows = this.values(placeholderValues);
  81. if (customResultMapper) {
  82. return customResultMapper(rows, normalizeFieldValue);
  83. }
  84. return rows.map((row) => mapResultRow(fields, row.map((v) => normalizeFieldValue(v)), joinsNotNullableMap));
  85. }
  86. get(placeholderValues) {
  87. const stmt = this.client.prepare(this.query.sql);
  88. const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
  89. this.logger.logQuery(this.query.sql, params);
  90. const { fields, joinsNotNullableMap, customResultMapper } = this;
  91. if (!fields && !customResultMapper) {
  92. const result = stmt.getAsObject(params);
  93. stmt.free();
  94. return result;
  95. }
  96. const row = stmt.get(params);
  97. stmt.free();
  98. if (!row || row.length === 0 && fields.length > 0) {
  99. return void 0;
  100. }
  101. if (customResultMapper) {
  102. return customResultMapper([row], normalizeFieldValue);
  103. }
  104. return mapResultRow(fields, row.map((v) => normalizeFieldValue(v)), joinsNotNullableMap);
  105. }
  106. values(placeholderValues) {
  107. const stmt = this.client.prepare(this.query.sql);
  108. const params = fillPlaceholders(this.query.params, placeholderValues ?? {});
  109. this.logger.logQuery(this.query.sql, params);
  110. stmt.bind(params);
  111. const rows = [];
  112. while (stmt.step()) {
  113. rows.push(stmt.get());
  114. }
  115. stmt.free();
  116. return rows;
  117. }
  118. /** @internal */
  119. isResponseInArrayMode() {
  120. return this._isResponseInArrayMode;
  121. }
  122. }
  123. function normalizeFieldValue(value) {
  124. if (value instanceof Uint8Array) {
  125. if (typeof Buffer !== "undefined") {
  126. if (!(value instanceof Buffer)) {
  127. return Buffer.from(value);
  128. }
  129. return value;
  130. }
  131. if (typeof TextDecoder !== "undefined") {
  132. return new TextDecoder().decode(value);
  133. }
  134. throw new Error("TextDecoder is not available. Please provide either Buffer or TextDecoder polyfill.");
  135. }
  136. return value;
  137. }
  138. export {
  139. PreparedQuery,
  140. SQLJsSession,
  141. SQLJsTransaction
  142. };
  143. //# sourceMappingURL=session.js.map