python sqlite3: executescript fails

Question

This is a minimum code:

import sqlite3 as sq3
import os
import sys

def main(argv):
    q = 'select * from table_name;'
    db = 'test.db'

    con = sq3.connect(db)
    cur = con.cursor()
    cur.executescript(q)    // cur.execute(q) will work

    print cur.fetchone()


if __name__ == '__main__':
    sys.exit(main(sys.argv))

My problem is executescript always fails while execute works fine. Is it because executescript is Nonstandard or some libraries I missed?

Wessie · Accepted Answer · 2013-05-22 17:14:38Z

4

executescript isn't supposed to return anything, what would it return? The last statement? The first statement? or maybe that one in the middle.

Since it allows you to execute multiple SQL statements there is no way to tell which one you want to have returned.

answered May 22, 2013 at 17:14

Wessie

3,5302 gold badges15 silver badges17 bronze badges

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

5 Comments

gongzhitaao Over a year ago

Sorry for misleading, I should have said that cur.fetchone() is None.

Wessie Over a year ago

Yes, executescript does not save any results in the cursor, thus fetchone won't have anything to fetch. There is no way for the sql library to know what you want returned, you should use execute instead.

gongzhitaao Over a year ago

executescript does not affect the cursor!!! That makes sense!!! Why should it affect the cursor!!! silly mistake. Thanks.

Oliver Over a year ago

@Wessie if you can point to a reliable source saying that executescript does not save any results in cursor, that would be much appreciated. Because my understanding is that executescript just separates into a bunch of statements, executes each one, and commits. If that is the case (I have to test), then the last statement in the script could put data in the cursor (if it is a select statement), or perhaps even whatever last SELECT statement (even if followed by inserts). It would be nice if "no results in cursor were a 100% sure thing for scripts.

dataman Over a year ago

You might want the last statement returned, no?

kindall · Accepted Answer · 2013-05-22 17:14:37Z

2

executescript() is for executing multiple SQL commands, i.e., a script. What is the return value of multiple SQL commands? Hard to say, which is why executescript() returns None. You're not doing anything wrong nor do you have anything missing in your installation.

answered May 22, 2013 at 17:14

kindall

185k36 gold badges291 silver badges321 bronze badges

3 Comments

gongzhitaao Over a year ago

Sorry, corrected. What I meant is after executescript, cur.fetchone returns None.

kindall Over a year ago

Same basic reason. How is executescript() supposed to know which of the result sets produced by queries in the script should be made accessible via the cursor?

gongzhitaao Over a year ago

Thanks. That makes sense. Silly logic mistake.

Collectives™ on Stack Overflow

python sqlite3: executescript fails

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related