how to get full QueryInterfaceRequest sql string in grdb including all arguments (GRDB.StatementArguments) in the string

Question

I need to get full sql query of query interface in order to save them in user defaults but i couldn't find this functionality

update: in order to achieve full query string:

including arguments that were trimmed by sqlite for injection you can not replace those arguments with question mark manualy.
you can not achieve real value of those arguments because they are private

score 2 · Answer 1 · answered Apr 22 '21 at 08:02

2

There is a trace function in the latest GRDB:

// Prints all SQL statements
var config = Configuration()
config.prepareDatabase { db in
    db.trace { print($0) }
}

answered Apr 22 '21 at 08:02

Aliaksandr Bialiauski

1,541
20
25

Follow link in the other answer if you're not sure where to put the above code – Nick Jan 07 '22 at 08:35

Gwendal Roué · Answer 2 · 2019-04-24T06:36:19.253

1

The How do I print a request as SQL? FAQ says:

You can turn your request into a SQLRequest instance:

try dbQueue.read { db in
    let request = Wine
        .filter(Column("origin") == "Burgundy")
        .order(Column("price")

    let sqlRequest = try SQLRequest(db, request: request)
    print(sqlRequest.sql)
    // Prints SELECT * FROM wine WHERE origin = ? ORDER BY price
    print(sqlRequest.arguments)
    // Prints ["Burgundy"]
}

edited Apr 24 '19 at 06:36

answered Apr 23 '19 at 11:52

Gwendal Roué

3,949
15
34

first of all thanks for your answer. i know this but in order to achieve full query string including arguments that were trimmed by sqlite for injection you can not replace those arguments with question mark manualy.another cons is you can not achieve real value of those arguments because they are private – Hamed Nova Apr 24 '19 at 10:34
1

OK @nova. Next time you ask a question on SO, will you please make sure you tell what you already know, so that both the question and answers are better focused? This will help everybody, not only you. Now your comment is about something else. I suggest you ask another question, or, if some feature is missing, open a Github issue. – Gwendal Roué Apr 24 '19 at 10:48
Good Point. i will update the question, i didn't know it from the time when i asked the question. – Hamed Nova Apr 27 '19 at 11:18

score 0 · Answer 3 · answered Nov 24 '22 at 16:28

For newer versions of GRDB, the answer is different.

taken from How do I print a request as SQL? :

try dbQueue.read { db in
    let request = Player.filter(Column("email") == "arthur@example.com")
    let statement = try request.makePreparedRequest(db).statement
    print(statement) // SELECT * FROM player WHERE email = ?
    print(statement.arguments) // ["arthur@example.com"]
}

how to get full QueryInterfaceRequest sql string in grdb including all arguments (GRDB.StatementArguments) in the string

3 Answers3