On Fri, 31 Aug 2007 12:28:49 +0530, "B V, Phanisekhar" <[EMAIL PROTECTED]>
wrote:
> Hi Gerhard,
>
> I am finding your code really tough to understand. Can you
> please provide some comments?
try:
from pysqlite2 import dbapi2 as sqlite
except ImportError:
import sqlite3
On Thu, 30 Aug 2007 13:06:38 +0100, "Simon Davies" <[EMAIL PROTECTED]> wrote:
> On 30/08/2007, B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
>> Simon,
>>Yeah you can term the problem like that. Can't I use the
>> function which is assigning a unique id for INTEGER PRIMARY KEY column
On Fri, Jul 15, 2005 at 08:27:14AM -0400, D. Richard Hipp wrote:
> [...]
> I am constantly amazed at the prevailing idea (exemplified
> by Java) that software should be strongly typed and should
> not use goto statement or pointers - all in the name of
> reducing bugs - but that it is OK to use
Some pysqlite users are experiencing problems with locks not going away,
as described in http://www.third-bit.com/trac/argon/wiki/Locking
In order to fix this, I need some information:
- is it true that after sqlite3_prepare, only the first call to
sqlite3_step can return SQLITE_BUSY, or can
Hi Mike,
good to know you're still around :-)
On Wed, May 18, 2005 at 10:22:39AM -0500, Mike Owens wrote:
> What about sqlite3_set_authorizer()? Implement a callback function and
> monitor changes in transaction state for each connection object: [...]
Didn't try, yet. But does this get called
In pysqlite, I need to keep track of the transaction state (in
transaction/not in transaction). To handle ON CONFLICT ROLLBACK in
pysqlite correctly, I need to be able to query the transaction state.
As I see it, that's currently not possible. Am I mistaken?
Otherwise, could you please
Off topic, but people creating tables with that number of columns
should really think about normalizing their data structures.
-- Gerhard
signature.asc
Description: Digital signature
On Thu, Mar 17, 2005 at 09:47:16AM +0800, cross wind wrote:
> Thanks Gehard. Finally, I am seeing the pattern on how the scripts
> ought to be run.
In the pysqlite2 alpha *source* releases, there's a script included to
run tests.
Because it's just that single file, you can download it here,
On Wed, Mar 16, 2005 at 06:45:23PM +0800, cross wind wrote:
> [...]
> ### When ran, I get the ff messages:
>
> C:/PYTHON23/pythonw.exe -u "Z:/devpy/test/sqlite.pyw"
> Traceback (most recent call last):
> File "Z:/devpy/test/sqlite.pyw", line 1, in ?
> import sqlite
> File
On Thu, Mar 17, 2005 at 06:52:03AM +0800, cross wind wrote:
> On my other computer I tried installing
> pysqlite-2.0.alpha2.win32-py2.3.exe and rerun my test script, it also
> failed on the same error. However, when I changed the import line to:
>
> import pysqlite2.dbapi2 as sqlite
>
> The test
On Thu, Nov 11, 2004 at 09:40:44AM -0500, [EMAIL PROTECTED] wrote:
> [...] The following SQL does not work, complaint is "Error: no such column:
> B.GROUP_ID"
>
>
> select ID,
> (select SERVER_ID from A where A.ID=B.GROUP_ID) as GROUP_ID
> from B [...]
Looks like you haven't read this
On Tue, Nov 09, 2004 at 10:45:35AM -0500, Richard Boehme wrote:
> Hi there. How well does SQLite do in a client/server environment
> where the SQLite database is handling a batch of 100 inserts and the
> same number of queries a every 0.5 seconds? The inserts would be
> batched into a transaction.
On Thu, Nov 04, 2004 at 04:24:50PM +0800, Ng Pheng Siong wrote:
> On Thu, Nov 04, 2004 at 10:18:12AM +0200, [EMAIL PROTECTED] wrote:
> > I've just started using Sqlite and still haven't figured out how to
> > save the database to the disk. I can create a database and insert any
> > data I
On Tue, Nov 02, 2004 at 04:36:41PM +0200, CARIOTOGLOU MIKE wrote:
> [user-defined functions loadable through shared libraries]
> true. OTOH, since, as you say, it *is* simple, why not provide some extra
> functionality on one platform ? it does not affect other platforms, and it
> is s nice to
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
> Hello all,
>
> I wonder if there is a possibility to save (dump) an in-memory
> database to file (and vice versa, loading from file) in a fast way?
> (Without having to create a new database and copying records by
> select and
On Thu, Oct 21, 2004 at 04:36:16PM +0200, Guillaume Fougnies wrote:
> Hi,
>
> This problem was evoked on the list. sqlite3_exec do not catch
> SQLITE_BUSY on the sqlite3_step.
I'm not even using sqlite3_exec, I was writing my own my_sqlite3_exec,
because sqlite3_exec was not compatible with the
Hi,
I'm converting SQLite2 code to SQLite3. It looks to me like the
sqlite3_busy_handler() and sqlite3_busy_timeout() don't do anything.
At least not anything useful. At least not when using the new API with
sqlite3_step() and friends.
Is that true? Do I have to catch SQLITE_BUSY from the
17 matches
Mail list logo