Curiousity question :
Why are you basing your SQLfast next book on Python 2.7.6 rather than
Python 3.3 (or 3.4) ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 7 Jul 2014, at 6:49am, big stone wrote:
> If I understood well, the "autocommit" idea was to not "hold" the database
> file by default, and ease multi-user access to the file database.
Not executing "BEGIN" is also the most frequent error that SQL programmers
make. Just like even the most
Hi again,
To answer the question in the title :
- yes, the "autocommit" bug is buggy with "with",
http://bugs.python.org/issue21718
- it is also buggy with comments at the beginning of the 'select'.
The "autocommit" feature was a false good idea, but as sqlite3 arrived like
that in the standard
ie, this will work: isolation_level = None and explicitly "BEGIN" transactions
...
import sqlite3
def displayDBcontents():
query = "select * from PERSON"
c.execute(query)
print
for row in c: print '%-4s %-10s' % (row[0],row[1])
# We create and fill the STAFF database
conn = sql
Hi Jean-Luc,
All your problem is that you must use conn.isolation_level = None
With conn.isolation_level = "" , the default of sqlite3, nothing related
with transaction will work.
Just try with :
* this program :
https://github.com/stonebig/sqlite_bro/blob/master/sqlite_bro.py
(or pip install sq
Python 2.7.8 cannot run your program using the shipped version of SQLite. It
does not support either multiple valued inserts nor the WITH statement. Did
you just "drop in" a new version of the sqlite3.dll?
While this (dropping a new version of sqlite3.dll) will work fine mostly, the
dbapi2 c
On 2014/07/05 21:55, Jean-Luc Hainaut wrote:
Hi,
Context: Python 2.7.6, Windows XP, SQLite v3.8.5.
The following test program suggest that "with" queries automatically execute a
commit, as if they were DDL statements. I hope this is a bug, otherwise, this side effect
considerably reduces the
Jean-Luc Hainaut wrote:
> Context: Python
>
> The following test program suggest that "with" queries automatically
> execute a commit, as if they were DDL statements.
SQLite itself does not differentiate between DDL and DML statements;
when there are no explicit transactions, every statement gets
8 matches
Mail list logo