http://blog.gmane.org/gmane.comp.python.db.pysqlite.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.python.db.pysqlite.user/2352 <pre>Hello, I was guilty of a misconfiguration of the mail server this list is hosted on. The effect was that the only subscriber that received mails from the list for a month or so were members subscribed to the domain ghaering.de. I. e. only me. So I decided to outsource the administration problems to Google. This mailing list will move over to Google Groups (Roger Binns already set a group up there): http://groups.google.de/group/python-sqlite I'll invite all subscribers of this list in a few minutes. I will move the pysqlite hosting to Google Code during the next days, too. </pre> Gerhard Häring 2009-10-18T08:33:15 http://comments.gmane.org/gmane.comp.python.db.pysqlite.user/2350 <pre>_______________________________________________ list-pysqlite mailing list list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ&lt; at &gt;public.gmane.org http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite</pre> Dinesh B Vadhia 2009-09-03T21:50:20 http://comments.gmane.org/gmane.comp.python.db.pysqlite.user/2348 <pre>I've found that Blob.close() throws a ReadOnlyError if I've previously attempted to perform a write on that blob. I was surprised by this, but I wanted to see if this is expected behavior. Here's code that demonstrates the issue: import apsw sql = ''' CREATE TABLE IF NOT EXISTS data (id INTEGER PRIMARY KEY NOT NULL, data BLOB NOT NULL)''' conn = apsw.Connection('test.db') cur = conn.cursor() cur.execute(sql) cur.execute('INSERT INTO data VALUES(?,?)', (None, apsw.zeroblob(1000))) rowid = conn.last_insert_rowid() blob = conn.blobopen('main', 'data', 'data', rowid, False) # Attempt a write try: blob.write('x' * 10) except apsw.ReadOnlyError: # expected pass # This throws ReadOnlyError unexpectedly blob.close() This is with version 3.6.16 on python 2.6.1. Austin </pre> Austin Bingham 2009-09-01T13:09:59 http://comments.gmane.org/gmane.comp.python.db.pysqlite.user/2346 <pre>Hi list, The install-source.txt file said to email this list if I encountered errors running pysqlite2.test.test(), but didn't encounter any errors during compilation or installation. So that's what I am doing. Here's the error I encountered (it says there are nine of them....but they sure seem related): ################################ [GCC 4.0.1 (Apple Inc. build 5465)] on darwin Type "help", "copyright", "credits" or "license" for more information. &gt;&gt;&gt; from pysqlite2 import test &gt;&gt;&gt; test.test() .....................................................................................................................................................................EEEEEEEEE ................................. ====================================================================== ERROR: CheckDMLdoesAutoCommitBefore (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckDeleteStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckInsertStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckLocking (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckRaiseTimeout (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckReplaceStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckRollbackCursorConsistency (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckToggleAutoCommit (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ====================================================================== ERROR: CheckUpdateStartsTransaction (pysqlite2.test.transactions.TransactionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Python/2.5/site-packages/pysqlite2/test/ transactions.py", line 38, in setUp self.con1 = sqlite.connect(get_db_path(), timeout=0.1) OperationalError: unable to open database file ---------------------------------------------------------------------- Ran 207 tests in 0.083s FAILED (errors=9) ##################################### Thanks so much! David </pre> David Garfield 2009-08-12T14:34:08 http://comments.gmane.org/gmane.comp.python.db.pysqlite.user/2345 <pre>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 APSW 3.6.17-r1 is now available. The home page is at http://code.google.com/p/apsw/ which includes full documentation, source and binary distributions for Windows (Python 2.3 onwards including 3.0 &amp; 3.1). APSW is a wrapper around SQLite that provides all SQLite API functionality in Python. It is not DBAPI compliant as it provides SQLite semantics. pysqlite provides DBAPI semantics. You can see the two approaches contrasted at http://apsw.googlecode.com/svn/publish/pysqlite.html Changelist is below and a clickable version at http://apsw.googlecode.com/svn/publish/changes.html APSW has migrated from Subversion to Mercurial for source code control. Hosting remains at Google Code Updated a test due to VFS xUnlock errors now being ignored sometimes by SQLite (SQLite ticket 3946). The downloads page in the help didn’t mention the Windows Python 3.1 installer. Running the test suite is now integrated into setup.py so you can do the building and testing all in one go. Sample command line: $ python setup.py install test The test suite will now check the functionality of the FTS3, RTree and ICU extensions if they were included. (The Windows binary distribution includes FTS3 and RTree by default.) Fixed issue 55 where FTS3 was unintentionally omitted from the Windows binary distribution. Various documentation updates. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqBD9AACgkQmOOfHg372QSXtACggQZbyhdeYPqH7VF9CseQ+Lcm En0An0t8i3wN4y8hZTUSlhT28Qq28Jop =ZjOk -----END PGP SIGNATURE----- _______________________________________________ list-pysqlite mailing list list-pysqlite&lt; at &gt;lists.itsystementwicklung.de http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite</pre> Roger Binns 2009-08-11T06:29:40 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.db.pysqlite.user