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
);
On Mon, Oct 6, 2014 at 3:41 PM, Jeffrey Parker <[email protected]> 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.
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
