APSW is a thin Python wrapper over the SQLite API.
APSW is not fully compatible with Python's DBAPI in order to completely support all SQLite features.
Questions tagged [apsw]
37 questions
0
votes
2 answers
Odd error when installing apsw on Windows
I tried to install apsw on another system, we got a multitude of errors, depending on how we installed it. First off, installing via exe gave us a "This application is not a valid win32 program" When we manually installed it from my system, we got a…
Varriount
- 663
- 5
- 18
0
votes
1 answer
How to insert a large number of list entries into sqlite statements
Ok, I am using apsw with sqlite, and have a large list of entries.Each entry contains a new row to be inserted. The number of entries is sometimes 20, sometimes 21. Since apsw supports multiple sql statements in curser.execute(), I was wondering if…
Varriount
- 663
- 5
- 18
0
votes
1 answer
Python sqlite error: ValueError: database parameter must be string or APSW Connection object
I am trying to create, edit and read from a sqlite file using a python script. My code is a server client model with the client writing to the database on receiving a command from the server.
Each command from the server is received on a separate…
HighonH
- 169
- 3
- 16
0
votes
1 answer
apsw.Connection has no attribute enableloadextension
I have installed Python 2.7.9 on Mac OS X Yosemite with Homebrew and I have also installed apsw 3.8.8.2-r1 via the bundled pip.
However, even though the apsw module is found, I cannot seem to be able to run my application, as if fails with the an…
ergysdo
- 1,139
- 11
- 20
0
votes
0 answers
python using a iterator more then once
I have a iterator that basically returns some modify values from a iterator created with sql commands from apsw
class DatabaseIterator():
"""
turns the select statement iterator into a deserialized iterator
I.E. jsonBlob will be a tweet…
zidsal
- 577
- 1
- 7
- 30
0
votes
1 answer
How to update a field with APSW
I am trying to update the timestamp on a database entry when I use it and I can't seem to get the Update statement to work
import apsw
from datetime import datetime
def updateTimestamp(primary, timestamp):
tableName = 'Images'
…
Siecje
- 3,594
- 10
- 32
- 50
-1
votes
1 answer
Searching values in SQLite, with apsw, on python
Why this code returns the row 'p',8,9 when i asked it to returns only the rows where the first element is > then 3 ? The first element of this row is 'p'.
I noticed that this metod work fine with int, but if the element compared is a str, this…
Vitor Oliveira
- 327
- 2
- 10