And 2.7.8:
Python 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> conn=sqlite3.connect(":memory:")
>>> conn.execute("""
... 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
... );""")
<sqlite3.Cursor object at 0x01E74420>
>>> versionName=0
>>> versionNumber=0
>>> updateFrom=0
>>> metafileURL=0
>>> patchURL=0
>>> sha1=0
>>> params = versionName, versionNumber, updateFrom, metafileURL, patchURL, sha1
>>> conn.execute("INSERT INTO UpdateFrom VALUES(?,?,?,?,?,?)", params)
<sqlite3.Cursor object at 0x01E88820>
>>>
>>> for row in conn.execute('select * from updatefrom'):
... print row
...
(u'0', 0, 0, u'0', u'0', u'0')
>>>
On Monday, 13 October, 2014 11:14, Clemens Ladisch <clem...@ladisch.de> said:
>Jeffrey Parker wrote:
>> 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.
>
>The following code executes fine in Python 2.7.5:
>
>import sqlite3
>conn=sqlite3.connect(":memory:")
>conn.execute("""
>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
>);""")
>versionName=0
>versionNumber=0
>updateFrom=0
>metafileURL=0
>patchURL=0
>sha1=0
>params = versionName, versionNumber, updateFrom, metafileURL, patchURL,
>sha1
>conn.execute("INSERT INTO UpdateFrom VALUES(?,?,?,?,?,?)", params)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
