| 103 | } |
| 104 | |
| 105 | prepare(sql: string): SqliteStatement { |
| 106 | // node:sqlite matches better-sqlite3's calling convention (variadic |
| 107 | // positional args, or a single object for @named params), so params forward |
| 108 | // through unchanged. |
| 109 | let stmt: any; |
| 110 | try { |
| 111 | stmt = this._db.prepare(sql); |
| 112 | } catch (err) { |
| 113 | throw this.failure(err); |
| 114 | } |
| 115 | const failure = (err: unknown): unknown => this.failure(err); |
| 116 | return { |
| 117 | run(...params: any[]) { |
| 118 | let r: any; |
| 119 | try { |
| 120 | r = stmt.run(...params); |
| 121 | } catch (err) { |
| 122 | throw failure(err); |
| 123 | } |
| 124 | return { |
| 125 | changes: Number(r?.changes ?? 0), |
| 126 | lastInsertRowid: r?.lastInsertRowid ?? 0, |
| 127 | }; |
| 128 | }, |
| 129 | get(...params: any[]) { |
| 130 | try { |
| 131 | return stmt.get(...params); |
| 132 | } catch (err) { |
| 133 | throw failure(err); |
| 134 | } |
| 135 | }, |
| 136 | all(...params: any[]) { |
| 137 | try { |
| 138 | return stmt.all(...params); |
| 139 | } catch (err) { |
| 140 | throw failure(err); |
| 141 | } |
| 142 | }, |
| 143 | iterate(...params: any[]) { |
| 144 | return stmt.iterate(...params); |
| 145 | }, |
| 146 | rowsAsArrays() { |
| 147 | if (typeof stmt.setReturnArrays !== 'function' || typeof stmt.columns !== 'function') return undefined; |
| 148 | stmt.setReturnArrays(true); |
| 149 | return stmt.columns().map((column: { name: string }) => column.name); |
| 150 | }, |
| 151 | }; |
| 152 | } |
| 153 | |
| 154 | exec(sql: string): void { |
| 155 | try { |