SQLite on iPhone - Get final query string with parameters after binding

Question

I would like to get the final SQL query, with parameter values bound (replaced) for debugging. It is a rather large and complex query (some joins, and about 20 parameters). Just wondered if it was possible to access the final query passed to the sqlite db.

//PSEUDO CODE

theSQL = "SELECT a,b,c FROM myTable where aField = ?";
sqlite3_prepare_v2(myDb, theSQL, -1, &compiledStatement, NULL);
sqlite3_bind_text(compiledStatement, 1, myUTF8stringParam, -1, SQLITE_STATIC);

theSQLwithBoundParams = //<<<--- here is missing what I look for ;)
NSLog(@"Perpared Statement with params: %@", theSQLwithBoundParams);

...

I already looked around on the web and the sqlite documentation without luck. For reference, I found a similar question here on stackoverflow. It is almost a year old - so I thought asking again should be ok…

Thanks in advance,
Markus

Community · Accepted Answer · 2017-05-23 12:07:01Z

1

You migth want to take a look at this question. Basically, you can write your own sqlite3_trace to record the latest query.

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Oct 27, 2009 at 12:26

pierrotlefou

41k39 gold badges140 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bernardo Ramos · Accepted Answer · 2016-11-14 02:43:39Z

0

Starting on SQLite 3.14 there is the sqlite3_expanded_sql() function.

You can call it inside a callback registered with the sqlite3_trace_v2() function.

answered Nov 14, 2016 at 2:43

Bernardo Ramos

4,81733 silver badges31 bronze badges

Collectives™ on Stack Overflow

SQLite on iPhone - Get final query string with parameters after binding

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related