[PyQt] Creating a table in a sqlite db using QtSql

[Chris Wood]

Ah. You always find the mistakes just after you ask for help... I was,
of course, not using the instantiated QSqlQuery object to run the
exec_() call.

Chris

On 3 December 2014 at 16:50, Chris Wood <c.c.wood at gmail.com> wrote:
> I’m attempting to create a sqlite database using the QtSql module. I
> ensure that the database doesn’t already exist, and then create a
> table. However, I get an error message: 'table People already exists
> Unable to fetch row' - how can it already exist when I’m creating the
> db in the previous line of code? It even happens when I explicitly try
> and delete the table in advance. Full code is:
>
> from PyQt4.QtSql import *
> import os
>
> print os.listdir(".")
> database = QSqlDatabase.addDatabase("QSQLITE")
> database.setDatabaseName("mynewdb.sqlite")
> database.open()
> sql = QSqlQuery("DROP TABLE IF EXISTS People")
> a = QSqlQuery.exec_(sql)
> print a
> print sql.lastError().text()
> sql = QSqlQuery("CREATE TABLE People (id integer primary key
> autoincrement, name varchar(255))")
> a = QSqlQuery.exec_(sql)
> print a
> print sql.lastError().text()
>
> and output is:
>
> [chris at chris dbdev]$ python test.py
> []
> True
>
> False
> table People already exists Unable to fetch row
>
> Just for my sanity, I checked it worked manually, and it does:
>
> [chris at chris dbdev]$ ls
> [chris at chris dbdev]$
> [chris at chris dbdev]$ sqlite3
> SQLite version 3.8.7 2014-10-17 11:24:17
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".open FILENAME" to reopen on a persistent database.
> sqlite> .open mynewdb.sqlite
> sqlite> .tables
> sqlite>
> sqlite> create table People(id integer primary key autoincrement, name
> varchar(255));
> sqlite> .tables
> People
> sqlite> drop table People;
> sqlite>
> sqlite> .tables
> sqlite>
> sqlite> create table People(id integer primary key autoincrement, name
> varchar(255));
> sqlite> .tables
> People
>
> Any hints as to what I’m doing wrong?!
>
> Cheers,
> Chris