5 ms·
How does this Python docs example work with t-strings? cur.executemany("INSERT INTO movie VALUES(?, ?, ?)", data) Can SQLite3 cache the query as it does n
by mont_tag 1y ago
How does this Python docs example work with t-strings?
cur.executemany("INSERT INTO movie VALUES(?, ?, ?)", data)
Can SQLite3 cache the query as it does now?
- roywiggins 1y agoIt seems to me that it would be straightforward to parse a Template's parameters back into ? placeholders?
- mont_tag 1y agoNo, it would fail upstream before the template post-processing even begin. The template object itself could not be formed because the each name must be a visible variable name. This is the same error that you would get with an f-string that contained an undefined variable name.
- sanderjd 1y agoI'm intrigued but confused by your comment. I think it could be done like this: cur.executemany(t"INSERT INTO movie VALUES({data})") Then the Template object would have a parameter that is a list, and it could turn that into the right number of "?"s to pass into the database driver along with the data. What am I missing?