Right now, I can only log statements like:
SELECT * FROM users WHERE id = ?;
Is there a way to log SQLite queries after their parameters have been bound? So the queries look more like:
SELECT * FROM users WHERE id = '3';
Asked
Active
Viewed 83 times
0
nighthawk454
- 943
- 12
- 20
-
1you probably can use `SQLiteQueryBuilder` instead of plain strings – njzk2 Oct 27 '14 at 21:04
-
I am, in places, but it doesn't seem to log the query any more completely. – nighthawk454 Oct 27 '14 at 21:15
-
it can, if you log `buildQuery` with the same parameters as for the `query` call. – njzk2 Oct 27 '14 at 21:20
-
Ah, I found the an isLoggable() wrapper around that. Still, this will only work for queries using the QueryBuilder yes? I'm trying to analyze existing queries, not all of which use a builder. – nighthawk454 Oct 27 '14 at 21:39
-
yes. You may have to refactor to use querybuilders. – njzk2 Oct 27 '14 at 21:43
-
Not going to happen. However if you create a provider with a private db you could easily log the crud going to the provider. – danny117 Oct 28 '14 at 01:43