On Fri, Jul 8, 2016 at 12:04 AM, <[email protected]> wrote:
> 34 sql = "INSERT INTO Frisch VALUES(" + unicode(counter) +
> ", " + "'" + el.strip() + "');"
Don't ever do this. Instead, use parameterized queries:
cur.execute("INSERT INTO Frisch VALUES (?, ?)", (counter, el.strip()))
> 38 conn.commit
Do you know what this does?
> 39 counter = int(counter)
This is unnecessary; counter is already an integer.
Does anything actually call your code? If not, none of the above will
matter. But possibly there's an invocation that I'm not seeing.
ChrisA
--
https://mail.python.org/mailman/listinfo/python-list