Hi Gerhard -
is the download missing? On Pypi I see 2.8.0 is registered but no download
file:
https://pypi.python.org/pypi/pysqlite/2.8.0
pip fails:
$ ./bin/pip install pysqlite==2.8.0 --upgrade --force
Collecting pysqlite==2.8.0
Could not find a version that satisfies the requirement
ee 2.8.0 is registered but no
> download file:
>
> https://pypi.python.org/pypi/pysqlite/2.8.0
>
> pip fails:
>
> $ ./bin/pip install pysqlite==2.8.0 --upgrade --force
> Collecting pysqlite==2.8.0
> Could not find a version that satisfies the requirement pysqlite==2.8.
NEW FEATURES
- No new features, but tons of bugfixes. These mean that things now work
that
didn't before:
- Transactional DDL now works
- You can use SAVEPOINTs now
BUILD PROCESS
- Python 2.7.x is now required. If trying to use it with Python 3, print a
useful error message. Integrated all
On 13/10/2014 22:00, Terry Reedy wrote:
On 10/13/2014 4:31 PM, Dennis Lee Bieber wrote:
On Mon, 13 Oct 2014 10:49:27 +0100, Robin Becker
declaimed the following:
c:\users\rptlab\tmp\tmcallister\build\pysqlite\src\connection.h(33) : fatal
error C1083: Cannot open include file: 'sqli
On 10/13/2014 4:31 PM, Dennis Lee Bieber wrote:
On Mon, 13 Oct 2014 10:49:27 +0100, Robin Becker
declaimed the following:
c:\users\rptlab\tmp\tmcallister\build\pysqlite\src\connection.h(33) : fatal
error C1083: Cannot open include file: 'sqli
te3.h': No such file or directory
I am getting this error trying to use a python27 pip install of stuff which ends
up requiring pysqlite>=2.6.3,<2.7
building 'pysqlite2._sqlite' extension
creating build\temp.win-amd64-2.7
creating build\temp.win-amd64-2.7\Release
creating build\temp.win-amd64-2.7\Release
On Nov 20, 2010, at 12:37 PM, Navid Parvini wrote:
> Dear All,
>
> I want to install pysqlite on my Windows 64 bit machine. I have python 2.4.3
> on it.
> Would you please let me know how can I do it?
>
> That is, I need to use the source file (i.e pysqlite-2.5.6.tar.
Dear All,
I want to install pysqlite on my Windows 64 bit machine. I have python 2.4.3 on
it.
Would you please let me know how can I do it?
That is, I need to use the source file (i.e pysqlite-2.5.6.tar.gz) or there is
an executable file to install.
Thank you in advance.
Regards,
Navid
ite database (using Pysqlite) in order to perform off-line processing.
> Thus I could use both SQL's power and Python's magic to make everything
> easier. I'd like my code to be generic and work both for binary and ascii
> protocols, too.
>
> Which kind of data should I use to
Hi,
I'm trying to store frames received via serial port (using Pyserial) into a
sqlite database (using Pysqlite) in order to perform off-line processing.
Thus I could use both SQL's power and Python's magic to make everything
easier. I'd like my code to be generic and work
pysqlite 2.6.0 released
===
Release focus: Synchronize with sqlite3 module in Python trunk.
pysqlite is a DB-API 2.0-compliant database interface for SQLite.
SQLite is a in-process library that implements a self-contained,
serverless, zero-configuration, transactional SQL
> I am trying to install pysqlite (Python interface to the SQLite). I
> downloaded the file with the package (pysqlite-2.5.5.tar.gz). And I
> did the following:
>
> gunzip pysqlite-2.5.5.tar.gz
> tar xvf pysqlite-2.5.5.tar
> cd pysqlite-2.5.5
> python setup.py install
>
Roman Gorbunov schrieb:
Hi all,
I am trying to install pysqlite (Python interface to the SQLite). I
downloaded the file with the package (pysqlite-2.5.5.tar.gz). And I
did the following:
gunzip pysqlite-2.5.5.tar.gz
tar xvf pysqlite-2.5.5.tar
cd pysqlite-2.5.5
python setup.py install
At the
Hi all,
I am trying to install pysqlite (Python interface to the SQLite). I
downloaded the file with the package (pysqlite-2.5.5.tar.gz). And I
did the following:
gunzip pysqlite-2.5.5.tar.gz
tar xvf pysqlite-2.5.5.tar
cd pysqlite-2.5.5
python setup.py install
At the last step I have a problem
MRAB wrote:
> I wonder whether it's complaining about the "as count" part because
> "count" is the name of a function, although you do say that the same
> query works elsewhere.
Hey, good catch. Thanks; I'll change that. (It wasn't the problem, but
no doubt someday it could be.)
-Wm
--
http://m
william tanksley wrote:
> Oh, this is Python 2.5 on Windows.
New result: this works on Python 2.6. Obviously the SQLite format
changed between the two runs.
I'll call this "problem solved"; my app appears to run now.
-Wm
--
http://mail.python.org/mailman/listinfo/python-list
william tanksley wrote:
I'm trying to modify an app I wrote a few months ago, but now it dies
on startup (it worked before). The app loads the SQLite Media Monkey
database, and crashes on its first query (when I try to get the number
of podcasts). At the end of this post is a reduced version of t
I'm trying to modify an app I wrote a few months ago, but now it dies
on startup (it worked before). The app loads the SQLite Media Monkey
database, and crashes on its first query (when I try to get the number
of podcasts). At the end of this post is a reduced version of the
problem (which produces
On Apr 18, 2009, at 8:59 AM, oyster wrote:
I mean not a code to do seperated functions, but a real project
I have read the doc of pysqlite, but since I know little about
database, I found it is still very hard for me to cook a real database
app from the scratch with the help of codelet in
I mean not a code to do seperated functions, but a real project
I have read the doc of pysqlite, but since I know little about
database, I found it is still very hard for me to cook a real database
app from the scratch with the help of codelet in pysqlite doc. here is
the simplified details
Edzard Pasma wrote:
> Hello,
>
> It looks that the issue with fetch across rollback still can occur in the new
> version. It turned up when I applied the Pysqlite transaction test suite to
> some dbapi2 version of my own. Below is a minimal script to reproduce it. It
> has pu
Hello,
It looks that the issue with fetch across rollback still can occur in the new
version. It turned up when I applied the Pysqlite transaction test suite to
some dbapi2 version of my own. Below is a minimal script to reproduce it. It
has puzzled me what goes wrong and I would like to
pysqlite 2.5.2 released
===
Release focus: minor bugfixes, minor new features.
pysqlite is a DB-API 2.0-compliant database interface for SQLite.
SQLite is a in-process library that implements a self-contained,
serverless, zero-configuration, transactional SQL database
engine
raw_input(prompt)
> if cursor.execute('SELECT * FROM photos WHERE Tag LIKE ?',[keyword]):
> print cursor.fetchall()
> else:
> cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
> print cursor.fetchall()
>
> Any ideas and
> thanks in
klia schrieb:
klia wrote:
Hey guys;
I am trying to develop a tiny program using python to search inside sqlite
database with file extension is .db in which the program will ask users to
enter their search query and base on that it will retrieve the results But
I need the program to have som
FROM photos WHERE Tag LIKE ?',[keyword]):
>cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
* indicates all fields in the selected records, so you need to
change the * to the field that contains the name of the photo. For example:
if cursor.execu
gt; Reply
>
thank you man, it worked perfectly but one more thing;
when i print rows it retrieves the whole rows of info which i don't need, i
need just to retrieve the name of the photo.
so how am i gonna do that?
--
View this message in context:
http://www.nabble.com/pysqlite-smart-
En Mon, 23 Feb 2009 06:17:41 -0200, klia
escribió:
I need the program to have some smartness in search mechanism in which
the
program will guess that the user is looking for these key words in the
database.
so far i came up with this but the search ain't smart, i have to write
the
full
e:
cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
print cursor.fetchall()
Any ideas and
thanks in advance
Reply
--
View this message in context:
http://www.nabble.com/pysqlite-smart-search-tp22157116p22157116.html
Sent from the Python - python-list mailing list ar
gt; I found out that I have two versions of python: 2.4 at /usr/bin/
> python2.4 and 2.5.2 at /usr/local/apps/python/bin/python2.5
>
> My first try was to download the SQLite amalgamation, './configure',
> 'make' and 'make install'. Then I downloaded the PySQL
hon2.4 and 2.5.2 at /usr/local/apps/python/bin/python2.5
My first try was to download the SQLite amalgamation, './configure',
'make' and 'make install'. Then I downloaded the PySQLite and 'python
setup.py install'. The funny part is that python2.4 has sqlite
Geon. wrote:
hi everyone!
when i install pysqlite i meet bellow error. ( use easy_install and
source code building same problem )
ld: Can't find library for -lpython2.5
what mean this message? and what i do?
my system is hp-ux 11i v3. and python2.5 is installed.
ld command also aval
On 11월11일, 오후6시10분, Thorsten Kampe <[EMAIL PROTECTED]> wrote:
> * Geon. (Mon, 10 Nov 2008 18:00:56 -0800 (PST))
>
>
>
>
>
> > On 11?10?, ??1?31?, ??? <[EMAIL PROTECTED]> wrote:
> > > On Nov 10, 10:29 am, "Geon." <[EMAIL PROTECTED]> wrot
* Geon. (Mon, 10 Nov 2008 18:00:56 -0800 (PST))
> On 11?10?, ??1?31?, ??? <[EMAIL PROTECTED]> wrote:
> > On Nov 10, 10:29 am, "Geon." <[EMAIL PROTECTED]> wrote:
> > > when i install pysqlite i meet bellow error. ( use easy_install and
> > > source
On Mon, Nov 10, 2008 at 9:00 PM, Geon. <[EMAIL PROTECTED]> wrote:
> > Hi, as far as I know.
> >
> > 1. you can use module sqlite3 instead.
> > 2. you can use these commands on ubuntu:
> >
> > sudo apt-get install libsqlite3-dev
> > sudo easy_instal
On 11월10일, 오후1시31분, 一首诗 <[EMAIL PROTECTED]> wrote:
> On Nov 10, 10:29 am, "Geon." <[EMAIL PROTECTED]> wrote:
>
> > hi everyone!
>
> > when i install pysqlite i meet bellow error. ( use easy_install and
> > source code building same problem )
>
&
On 8 Nov, 05:39, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
> On Fri, 07 Nov 2008 14:36:52 +0100, Gerhard Häring <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
> > Astley Le Jasper wrote:
> > > I've been getting errors recently whe
On Nov 10, 10:29 am, "Geon." <[EMAIL PROTECTED]> wrote:
> hi everyone!
>
> when i install pysqlite i meet bellow error. ( use easy_install and
> source code building same problem )
>
> ld: Can't find library for -lpython2.5
>
> what mean this message?
On 11월10일, 오전11시29분, "Geon." <[EMAIL PROTECTED]> wrote:
> hi everyone!
>
> when i install pysqlite i meet bellow error. ( use easy_install and
> source code building same problem )
>
> ld: Can't find library for -lpython2.5
>
> what mean this message?
On Sun, Nov 9, 2008 at 9:29 PM, Geon. <[EMAIL PROTECTED]> wrote:
> hi everyone!
>
> when i install pysqlite i meet bellow error. ( use easy_install and
> source code building same problem )
>
> ld: Can't find library for -lpython2.5
>
> what mean this message?
hi everyone!
when i install pysqlite i meet bellow error. ( use easy_install and
source code building same problem )
ld: Can't find library for -lpython2.5
what mean this message? and what i do?
my system is hp-ux 11i v3. and python2.5 is installed.
ld command also avaliable.
please hel
Astley Le Jasper wrote:
I've been getting errors recently when using pysqlite. I've declared
the table columns as real numbers to 2 decimal places (I'm dealing
with money),
MySQL doesn't have any MONEY type. All it has is INTEGER, REAL, TEXT,
BLOB and NULL types.
but
On Nov 7, 6:36 am, Dan Bishop <[EMAIL PROTECTED]> wrote:
> On Nov 6, 3:46 pm, Astley Le Jasper <[EMAIL PROTECTED]> wrote:
>
> > I've been getting errors recently when using pysqlite. I've declared
> > the table columns as real numbers to 2 decimal place
On Nov 6, 3:46 pm, Astley Le Jasper <[EMAIL PROTECTED]> wrote:
> I've been getting errors recently when using pysqlite. I've declared
> the table columns as real numbers to 2 decimal places (I'm dealing
> with money), but when doing division on two numbers th
>
> > But I read your statement and understood that I do not need to install
> > neither "pysqlite" no "sqlite". In my Python session I tried to type
> > "from sqlite import connect" and it does not compaline. It meand that
> > Python see
I've been getting errors recently when using pysqlite. I've declared
the table columns as real numbers to 2 decimal places (I'm dealing
with money), but when doing division on two numbers that happen to
have no decimal fractions, the results through pysqlite are coming
through a
;
> > If for whatever reason you need the latest SQLite module for Python
> > (2.5.0), you can simply grab an rpm or build it from source and
> > install it to your home directory. To build pysqlite you need the
> > SQLite headers. If you can't install those to default p
dule sqlite3.
>
> By the way, I think the above statement is very helpfull. I tried to
> install the "pysqlite" to be able to communicate with the "sqlite",
> and then I have realized that for that I need first to install the
> "sqlite"...
>
> But I r
On Wed, Nov 5, 2008 at 8:52 PM, Kurda Yon <[EMAIL PROTECTED]> wrote:
> By the where can I find a simle tutorial about the work with the
> "sqlite" from the Python?
> --
> http://mail.python.org/mailman/listinfo/python-list
>
Once you get the connection, you can pretty much just do whatever if
you
lpfull. I tried to
install the "pysqlite" to be able to communicate with the "sqlite",
and then I have realized that for that I need first to install the
"sqlite"...
But I read your statement and understood that I do not need to install
neither "pysqlite" no
on as module
> sqlite3.
>
> If for whatever reason you need the latest SQLite module for Python
> (2.5.0), you can simply grab an rpm or build it from source and install
> it to your home directory. To build pysqlite you need the SQLite
> headers. If you can't install those
and Kurda) keep on talking the wrong stuff. First: you don't need
pysqlite2. SQLite support is included in the latest Python as module
sqlite3.
If for whatever reason you need the latest SQLite module for Python
(2.5.0), you can simply grab an rpm or build it from source and install
it to your
>> Thanks, but either I'm missing something or you're missing something.
>> I can't do any of what you describe on the machine I want to use
>> sqlite on.
>>
>> I have downloaded the binary sqlite3 file from sqlite's Web site, and
>
> The linux binary will not work. You need the headers and the
> l
On Nov 5, 10:07 pm, "Shawn Milochik" <[EMAIL PROTECTED]> wrote:
> On Wed, Nov 5, 2008 at 11:58 AM, [EMAIL PROTECTED]
>
>
>
> <[EMAIL PROTECTED]> wrote:
> > On Nov 5, 9:22 pm, "Shawn Milochik" <[EMAIL PROTECTED]> wrote:
> >> This is all useful and interesting stuff, but I don't think any of it
> >>
On Wed, Nov 5, 2008 at 11:58 AM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> On Nov 5, 9:22 pm, "Shawn Milochik" <[EMAIL PROTECTED]> wrote:
>> This is all useful and interesting stuff, but I don't think any of it
>> addresses the original poster's problem, which is that he has no root
>> access
On Nov 5, 9:22 pm, "Shawn Milochik" <[EMAIL PROTECTED]> wrote:
> This is all useful and interesting stuff, but I don't think any of it
> addresses the original poster's problem, which is that he has no root
> access to a Linux or Unix box, and wants to get pysqlite2 working in
> his home directory.
This is all useful and interesting stuff, but I don't think any of it
addresses the original poster's problem, which is that he has no root
access to a Linux or Unix box, and wants to get pysqlite2 working in
his home directory. I have exactly the same problem. I have tried the
"python setup.py ins
Not really (weird). Python, as of 2.5, includes the PySQLite DB-API
> adapter as part of the native library/source code. BUT SQLite is NOT
> part of Python (the Windows installers typically include the SQLite
> engine as a convenience, but Linux installers expect the engine to
>
s
David
Quoting Kurda Yon <[EMAIL PROTECTED]>:
On Nov 4, 8:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
On Nov 5, 6:47 am, Kurda Yon <[EMAIL PROTECTED]> wrote:
> Hi,
> I try to "build" and "install" pysqlite? After I type "pytho
On Nov 4, 8:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> On Nov 5, 6:47 am, Kurda Yon <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I try to "build" and "install" pysqlite? After I type "python setup.py
> > build&quo
On Nov 5, 6:47 am, Kurda Yon <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I try to "build" and "install" pysqlite? After I type "python setup.py
> build" I get a lot of error messages? The first error is "src/
> connection.h:33:21: error: sqlite
Hi,
I try to "build" and "install" pysqlite? After I type "python setup.py
build" I get a lot of error messages? The first error is "src/
connection.h:33:21: error: sqlite3.h: No such file or directory". So,
I assume that the absence of the "sqlite3
On Oct 12, 8:26 pm, azrael <[EMAIL PROTECTED]> wrote:
> I am working on an application using Python, wxPython and Sqlite
> (Pysqlite)
>
> So my problem is that I can connect top the database. When I open a
> dialog through a form I am able to make a select, even insert dat
I am working on an application using Python, wxPython and Sqlite
(Pysqlite)
So my problem is that I can connect top the database. When I open a
dialog through a form I am able to make a select, even insert data
into the database. Even if I open again the Dialog.
But as soon as I close the main
installed the sqlite packages fromcygwin(that is libsqlite3-devel
> > > and libsqlite3_0). When attempting to easy_install pysqlite I get:
>
> > > $ easy_install pysqlite
> > > Searching for pysqlite
> > > Readinghttp://pypi.python.org/simple/pysqlite/
> > &
On Sep 29, 7:49 am, Steve Holden <[EMAIL PROTECTED]> wrote:
> Tilman Kispersky wrote:
> > I am trying to install sqlite for use with python oncygwin. I have
> > installed the sqlite packages fromcygwin(that is libsqlite3-devel
> > and libsqlite3_0). When attempting to
Tilman Kispersky wrote:
> I am trying to install sqlite for use with python on cygwin. I have
> installed the sqlite packages from cygwin (that is libsqlite3-devel
> and libsqlite3_0). When attempting to easy_install pysqlite I get:
>
> $ easy_install pysqlite
> Searching for
Tilman Kispersky wrote:
I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:
[...]
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In
I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:
$ easy_install pysqlite
Searching for pysqlite
Reading http://pypi.python.org/simple/pysqlite
On Sep 8, 2008, at 1:56 PM, Gerhard Häring wrote:
But AFAIK it's possible to compile a custom SQLite with appropriate
flags to ./configure that will include the fulltext search extension.
It's indeed rather straightforward to integrate FTS, e.g.:
% CFLAGS="-DSQLITE_ENABLE_FTS3=1" ./configur
e SQLite source tree. I haven't found
any Makefile, so I it myself using this gcc command:
$ cd .../ext/fts3
$ gcc -shared -o ~/src/gh/pysqlite/build/lib.linux-i686-2.5/fts3.so
*.c -lsqlite3
Thanks!
Will fts3 be integrated in the Python 2.6 release?
No (only relevant on win32, where we
I haven't found
any Makefile, so I it myself using this gcc command:
$ cd .../ext/fts3
$ gcc -shared -o ~/src/gh/pysqlite/build/lib.linux-i686-2.5/fts3.so *.c
-lsqlite3
Thanks!
Will fts3 be integrated in the Python 2.6 release?
Matthias
--
http://mail.python.org/mailman/listinfo/python-list
OperationalError: Das angegebene Modul wurde nicht
gefunden.
Where should I look for the module?
The sources are in ext/fts3 in the SQLite source tree. I haven't found
any Makefile, so I it myself using this gcc command:
$ cd .../ext/fts3
$ gcc -shared -o ~/src/gh/pysqlite/build/lib.linu
Hi,
- - Connection.enable_load_extension(enabled) to allow/disallow extension
loading. Allows you to use fulltext search extension, for example ;-)
The following code (from the docs) produces an error:
from pysqlite2 import dbapi2 as sqlite3
con = sqlite3.connect(":memory:")
# Load the ful
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
pysqlite 2.5.0 released
===
I'm pleased to announce the availability of pysqlite 2.5.0. This is
a release with major new features.
Go to http://pysqlite.org/ for downloads, online documentation and
reporting bugs.
Wh
Colin Mcphail wrote:
> On 2008-03-09 18:57:00 +, Gerhard Häring <[EMAIL PROTECTED]> said:
>
> Gerhard Häring wrote:
>>>> [...] APSW
>>>>
>>>>
>>>> web:http://oss.itsystementwicklung.de/trac/apsw/
>>>> scm:
On 2008-03-09 18:57:00 +, Gerhard Häring <[EMAIL PROTECTED]> said:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Gerhard Häring wrote:
>> [...] APSW
>>
>>
>> web:http://oss.itsystementwicklung.de/trac/apsw/
>> scm:Subv
In article
<[EMAIL PROTECTED]>Gerhard Häring
<[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> Gerhard Häring wrote:
>> [...] APSW
>>
>>
>> web:http://oss.itsystementwicklung.de/trac/apsw/
>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gerhard Häring wrote:
> [...] APSW
>
>
> web:http://oss.itsystementwicklung.de/trac/apsw/
> scm:Subversion: http://initd.org/svn/pysqlite/apsw/trunk/
That should have been http://oss.itsystementwicklung.de/svn/apsw/apsw
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dear pysqlite users!
I've moved both the pysqlite and APSW project to new homes.
pysqlite
web:http://oss.itsystementwicklung.de/trac/pysqlite aka http://pysqlite.org/
scm:pysqlite now uses a Mercurial repository
mmm wrote:
> Oops I did make a mistake. The code I wanted to test should have been
>
> import copy
> print 'Test 1'
> pf= '?,?,?,?'
> sqlx1= 'INSERT INTO DTABLE2 VALUES ( %s ) ' % pf
> print sqlx1
>
> print
> print 'Test 2'
> sqlx2= copy.copy(sqlx1)
> sqlx3= sqlx1
> pf= '?,?,?, '
> print 'sq
Oops I did make a mistake. The code I wanted to test should have been
import copy
print 'Test 1'
pf= '?,?,?,?'
sqlx1= 'INSERT INTO DTABLE2 VALUES ( %s ) ' % pf
print sqlx1
print
print 'Test 2'
sqlx2= copy.copy(sqlx1)
sqlx3= sqlx1
pf= '?,?,?, '
print 'sqlx1= ', sqlx1
print 'sqlx2= ', sqlx2
pr
Peter Otten wrote:
> Steve Holden wrote:
>
>> What I will repeat, however, is that while there is a *slight*
>> difference is semantics between
>>
>> s = "some string"
>> s1 = s
>>
>> and
>>
>> s = "some string"
>> s1 = copy.copy(s)
>>
>> that difference is only to ensure that s and s1 point to di
Steve Holden wrote:
> What I will repeat, however, is that while there is a *slight*
> difference is semantics between
>
> s = "some string"
> s1 = s
>
> and
>
> s = "some string"
> s1 = copy.copy(s)
>
> that difference is only to ensure that s and s1 point to different
> copies of the same st
mmm wrote:
> Steve, I think you were right the first time is saying
>
>> it should really be this:
>> sqlxb= 'INSERT INTO DTABLE2 VALUES (?, ?, ?, ?)'
>
> my copy.copy() has the equivalent effect.
>
> Running this test code produces the output below
>
> import copy
>
> print 'Test 1'
> pf= '?
Steve, I think you were right the first time is saying
> it should really be this:
> sqlxb= 'INSERT INTO DTABLE2 VALUES (?, ?, ?, ?)'
my copy.copy() has the equivalent effect.
Running this test code produces the output below
import copy
print 'Test 1'
pf= '?,?,?,?'
sqlx1= 'INSERT INTO DTABLE
mmm wrote:
>>> Hence (if I understand python convention), this can be
>>> solved by adding
>>> sqlx= copy.copy(sqlx)
>>> before the looping. And in tests adding this step saved about 5-10% in
>>> time.
>> Now this I don;t really understand at all. What's the point of trying to
>> replace sqlx with
> > Hence (if I understand python convention), this can be
> > solved by adding
> > sqlx= copy.copy(sqlx)
> > before the looping. And in tests adding this step saved about 5-10% in
> > time.
>
> Now this I don;t really understand at all. What's the point of trying to
> replace sqlx with a copy of
[EMAIL PROTECTED] schrieb:
> I hav read on this forum that SQL coding (A) below is preferred over
> (B), but I find (B) is much faster (20-40% faster)
>
> (A)
>
> sqla= 'INSERT INTO DTABLE1 VALUES (%d, %d, %d, %f)' % values
> curs.execute(sqla)
>
> (B)
> pf= '?, ?, ?, ?'
> sql
[EMAIL PROTECTED] wrote:
> Steve, I want to make sure I understand. My test code is below, where
> ph serves as a placeholder. I am preparing for a case where the number
> of ? will be driven by the length of the insert record (dx)
>
> dtable= 'DTABLE3'
> print 'Insert data into table %s, versio
Steve, I want to make sure I understand. My test code is below, where
ph serves as a placeholder. I am preparing for a case where the number
of ? will be driven by the length of the insert record (dx)
dtable= 'DTABLE3'
print 'Insert data into table %s, version #3' % dtable
ph= '?, ?, ?, ?'
sqlx=
[EMAIL PROTECTED] wrote:
>
>I hav read on this forum that SQL coding (A) below is preferred over
>(B), but I find (B) is much faster (20-40% faster)
>
>(A)
>
>sqla= 'INSERT INTO DTABLE1 VALUES (%d, %d, %d, %f)' % values
>curs.execute(sqla)
>
>(B)
> pf= '?, ?, ?, ?'
>sqlxb= 'INSERT
[EMAIL PROTECTED] wrote:
>> (B) is better than (A). The parameter binding employed in (B)
>> is not only faster on many databases, but more secure.
> See, for example,http://informixdb.blogspot.com/2007/07/filling-in-
> blanks.html
>
> Thx. The link was helpful, and I think I have read similar th
> (B) is better than (A). The parameter binding employed in (B)
> is not only faster on many databases, but more secure.
See, for example,http://informixdb.blogspot.com/2007/07/filling-in-
blanks.html
Thx. The link was helpful, and I think I have read similar things
before-- that B is faster.
So
On Thu, 28 Feb 2008 19:35:03 -0800 (PST), mdboldin wrote
> I hav read on this forum that SQL coding (A) below is preferred over
> (B), but I find (B) is much faster (20-40% faster)
>
> (A)
>
> sqla= 'INSERT INTO DTABLE1 VALUES (%d, %d, %d, %f)' % values
> curs.execute(sqla)
>
> (B)
>
I hav read on this forum that SQL coding (A) below is preferred over
(B), but I find (B) is much faster (20-40% faster)
(A)
sqla= 'INSERT INTO DTABLE1 VALUES (%d, %d, %d, %f)' % values
curs.execute(sqla)
(B)
pf= '?, ?, ?, ?'
sqlxb= 'INSERT INTO DTABLE2 VALUES ( %s ) ' % pf
? It's not documented to have one. To do what
you intend to do with pysqlite, search its documentation for "autocommit".
-- Gerhard
--
http://mail.python.org/mailman/listinfo/python-list
Andy Smith wrote:
> Im trying to run a Python based program which uses MySQL with
> python-sqlite and Im recieving this error,
>
> 'Connection' object has no attribute 'autocommit'
>
> I´ve had a google for this and its seems like it may be a bug
> python-sqlite or sqlite bug , but also
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error,
'Connection' object has no attribute 'autocommit'
I´ve had a google for this and its seems like it may be a bug python-sqlite or
sqlite bug , but also I tried searching
for it
Ok, simple fix... Updated to MySQL_python-1.2.2 and all ok now! :D
- Original Message -
From: Andy Smith
To: python-list@python.org
Sent: Monday, February 04, 2008 3:45 PM
Subject: Pysqlite issue no attribute 'autocommit'
Hi there,
Im trying to run a Py
1 - 100 of 223 matches
Mail list logo
