On 10/13/2014 11:44 PM, Jeffrey Parker wrote:
Hello,
I am working with sqlite3 in python 2.7.8 and I am running into a strange
error where I get the below exception when running an insert into statement
on an empty table. I know this is probably more to do with the python
libraries but I thought that I would ask the question here in case someone
has any recommendations.
sqlite3.IntegrityError: column VersionName is not unique
The insert still works and when I do the next insert into that table there
is no exception.
It sounds like you are attempting to insert a duplicate row.
You could temporarily add a SELECT statement before the INSERT to check
if a record with the specified "versionName" is already present in the
table.
Dan.
There are multiple insert statements and multiple tables. The insert
statements look like below.
params = versionName, versionNumber, updateFrom, metafileURL, patchURL, sha1
conn.execute("INSERT INTO UpdateFrom VALUES(?,?,?,?,?,?)", params)
and the table looks like below.
CREATE TABLE `UpdateFrom` (
`VersionName` TEXT NOT NULL UNIQUE,
`VersionNumber` INTEGER NOT NULL,
`UpdateFrom` INTEGER NOT NULL,
`MetafileURL` TEXT NOT NULL,
`PatchURL` TEXT NOT NULL,
`SHA1` TEXT NOT NULL
);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
