diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-06-02 15:25:53 -0400 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-02 15:25:53 -0400 |
| commit | 825f219368f2e8c0587630f3ac0cb0e07d4aa7a0 (patch) | |
| tree | 20fdd9496083600a2aabf9c6ffd0d575ad6dc2e9 /packages/backend/src/postgres.ts | |
| parent | merge: allow fragments in AP ID URLs - fixes polls (!1076) (diff) | |
| download | sharkey-825f219368f2e8c0587630f3ac0cb0e07d4aa7a0.tar.gz sharkey-825f219368f2e8c0587630f3ac0cb0e07d4aa7a0.tar.bz2 sharkey-825f219368f2e8c0587630f3ac0cb0e07d4aa7a0.zip | |
improve query/parameter logging
Diffstat (limited to 'packages/backend/src/postgres.ts')
| -rw-r--r-- | packages/backend/src/postgres.ts | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/packages/backend/src/postgres.ts b/packages/backend/src/postgres.ts index b4bd934972..45caec54ce 100644 --- a/packages/backend/src/postgres.ts +++ b/packages/backend/src/postgres.ts @@ -145,7 +145,10 @@ class MyCustomLogger implements Logger { @bindThis private transformParameters(parameters?: any[]) { if (this.props.enableQueryParamLogging && parameters && parameters.length > 0) { - return parameters.map(stringifyParameter); + return parameters.reduce((params, p, i) => { + params[`$${i + 1}`] = stringifyParameter(p); + return params; + }, {} as Record<string, string>); } return undefined; @@ -158,7 +161,8 @@ class MyCustomLogger implements Logger { const prefix = (this.props.printReplicationMode && queryRunner) ? `[${queryRunner.getReplicationMode()}] ` : undefined; - sqlLogger.info(this.transformQueryLog(query, { prefix }), this.transformParameters(parameters)); + const transformed = this.transformQueryLog(query, { prefix }); + sqlLogger.debug(`Query run: ${transformed}`, this.transformParameters(parameters)); } @bindThis |