Re: [python-sqlite] Re: pysqlite 2.8.0 released

2015-08-20 Thread Gerhard Häring
0 > (from versions: 2.5.6, 2.6.0, 2.6.3, 2.7.0) > Some externally hosted files were ignored as access to them may be > unreliable (use --allow-external to allow). > No distributions matching the version for pysqlite==2.8.0 > > > > On Tuesday, August 18, 2015 at 8:17:46 PM U

pysqlite 2.8.0 released

2015-08-18 Thread Gerhard Häring
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

Re: are there pros or contras, keeping a connection to a (sqlite) database ?

2010-09-09 Thread Gerhard Häring
On Thu, Sep 9, 2010 at 12:29 AM, CM wrote: > [...] > I'm not even sure what a "connection" really is; I assumed it was > nothing more than a rule that says to write to the database with the > file named in the parentheses. [...] The following list is not exclusive, but these are the first things

Re: rich comparison fscks up reference count?

2010-04-12 Thread Gerhard Häring
On Apr 12, 4:27 pm, Gerhard Häring wrote: > Maybe somebody can enlighten me here. I can't figure out why doing a > rich comparison on my object decreases the total reference count by 1. [...] Doh! It turned out the strange effect was due to my particular build process. My Python

Re: rich comparison fscks up reference count?

2010-04-12 Thread Gerhard Häring
Can be run like this: ghaer...@ws124~/src/gh/test$ python3 setup.py build_ext --inplace running build_ext building 'foo' extension gcc -fno-strict-aliasing -g -fwrapv -O0 -Wall -Wstrict-prototypes - arch i386 -m32 -I/opt/jetstream/include/python3.1 -c foo.c -o build/ temp.macosx-10.4-i386-3.1-pyde

rich comparison fscks up reference count?

2010-04-12 Thread Gerhard Häring
Maybe somebody can enlighten me here. I can't figure out why doing a rich comparison on my object decreases the total reference count by 1. Linked is the minimal test case with a C exension that compiles under both Python 2.6 and 3.1. No external dependencies, except a DEBUG build of Python to see

[ANN] pysqlite 2.6.0 released

2010-03-05 Thread Gerhard Häring
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 dat

Building Python with Scons

2010-03-01 Thread Gerhard Häring
I'm setting up a third-party library project (similar to the one in Google Chromium) where I use SCons as build tool. Now I need to integrate Python, too. Has anybody written a Scons script for Python 2.x or 3.x, yet? -- Gerhard -- http://mail.python.org/mailman/listinfo/python-list

Re: Why Doesn't XP Pro Show Size, Time and Date Mod of a Created File?

2009-12-08 Thread Gerhard Häring
W. eWatson wrote: > I created a folder, and wrote a file to it. When I look at what files > are in it, they are correct. However, The Size, Type, and Date Mod are > not shown. Why am I missing those columns? I'm writing files with a > suffix of dat, which seem only to match up with video CD movie.

Re: editor with autocompletion

2009-12-04 Thread Gerhard Häring
Siva B wrote: > Hi friends, > > I am writing a new language. > So I want an editor with auto complete. > I there any such tool in Python ?(not only in python any other) > I want it for my new lang IDLE, the Integrated Development Environment included with your Python installation nowadays has aut

Re: dbapi2 select where IN (...)

2009-11-30 Thread Gerhard Häring
yota.n...@gmail.com wrote: > hello, > > I couldn't find how the dbapi2 planned to handle the sql IN statement. > > ex : > SELECT * FROM table WHERE num IN (2,3,8,9); > > I'd be glad to take advantage of the ? mechanism, but what about > tuples ! > > execute("""SELECT * FROM table WHERE num IN ?

Re: IDE+hg

2009-11-24 Thread Gerhard Häring
Rhodri James wrote: > On Mon, 23 Nov 2009 19:20:27 -, NiklasRTZ wrote: > >> Dear experts, >> Since no py IDE I found has easy hg access. IDEs PIDA and Eric claim >> Mercurial support not found i.e. buttons to clone, commit and push to >> repositories to define dev env dvcs, editor and deploym

Python & OpenOffice Spreadsheets

2009-11-23 Thread Gerhard Häring
Is there a *simple* way to read OpenOffice spreadsheets? Bonus: write them, too? I mean something like: doc.cells[0][0] = "foo" doc.save("xyz.ods") >From a quick look, pyodf offers little more than just using a XML parser directly. -- Gerhard -- http://mail.python.org/mailman/listinfo/python

Re: python and web pages

2009-11-19 Thread Gerhard Häring
Daniel Dalton wrote: > Hi, > > Here is my situation: > I'm using the command line, as in, I'm not starting gnome or kde (I'm on > linux.) > I have a string of text attached to a variable,. So I need to use one of > the browsers on linux, that run under the command line, eg. lynx, > elinks, links,

Re: Pyfora, a place for python

2009-11-03 Thread Gerhard Häring
Lorenzo Gatti wrote: > On Nov 1, 8:06 am, Saketh wrote: >> Hi everyone, >> >> I am proud to announce the release of Pyfora (http://pyfora.org), an >> online community of Python enthusiasts to supplement comp.lang.python >> and #python. While the site is small right now, please feel free to >> regi

Re: Python: Text file insert to MySQL

2009-10-07 Thread Gerhard Häring
On Wed, Oct 7, 2009 at 1:32 PM, Schedule wrote: > That was great ! Now I am able to insert the values from the file. > > Somehow I am not able to update a specific field with all the vaues in the > file. For eg: >     [...] >     c.execute("UPDATE a SET last = %s", row) The database does what you

Re: Python: Text file insert to MySQL

2009-10-06 Thread Gerhard Häring
Schedule wrote: > Hello, > > I am currenty using MySQL 5.1 community server and trying to import the > data of the comma delimited text file into the table using python 2.6 > scripts. I have installed Mysqldb 1.2.2. > > follwoing is my script: > [...] >7. > c.execute("INSERT INTO a (fir

Re: Compile kinterbasdb with mingw32 and python 2.6 - DLL load failed

2009-09-21 Thread Gerhard Häring
Laszlo Nagy wrote: > >>> The building and installation went find. But I cannot "import >>> kinterbasdb" >>> because I get a "DLL load failed" error. I figured out that has >>> something to >>> do with msvcr90 and "_ftime". Can you please give me some advice how to >>> solve this problem? >>>

Re: file comparison

2009-07-31 Thread Gerhard Häring
learner learner wrote: > Hi all, > > I want to compare two text files line by line and eliminate the > matching/repeated line and store the unmatched/leftout lines into a > third file or overwrite into one of them. gl & hf! -- http://mail.python.org/mailman/listinfo/python-list

Re: non-owning references?

2009-07-24 Thread Gerhard Häring
Utpal Sarkar wrote: > Hi, > [...] You're looking for the weakref module. What you're describing there sounds like a nice exercise, but I cannot imagine why you'd really need to clean it up, if it really is a singleton. -- Gerhard -- http://mail.python.org/mailman/listinfo/python-list

Re: Creating xml

2009-07-23 Thread Gerhard Häring
Greg Lindstrom wrote: > It's been a while since I've played with XML using Python but I've been > asked to create XML using data from our postgres database. Currently we > are generating XML directly from the database using a set of stored > procedures but it is too slow (yes, I have numbers). I

Re: [RELEASED] Python 3.1 final

2009-06-28 Thread Gerhard Häring
Scott David Daniels wrote: > Nobody wrote: >> On Sat, 27 Jun 2009 16:12:10 -0500, Benjamin Peterson wrote: >> >> >> That's a significant improvement >> All in all, Python 3.x still has a long way to go before it will be >> suitable for real-world use. > > Fortunately, I have assiduously avoid

Re: Column types with DB API

2009-06-28 Thread Gerhard Häring
Thomas Robitaille wrote: > Hi, > > I'm trying to use DB API compliant database modules > (psycopg2,MySQLdb,SQLite) to access SQL databases, and I am trying to > determine the type of each column in a table. The DB API defines > cursor.description which contains information about the column names a

Re: sqlite3, OperationalError: no such column, shouldn't that ne a ProgrammingError?

2009-06-19 Thread Gerhard Häring
John Machin wrote: > Hi Gerhard, > [...] > In http://www.sqlite.org/c3ref/prepare.html it says """When an error > occurs, sqlite3_step() will return one of the detailed error codes or > extended error codes. The legacy behavior was that sqlite3_step() > would only return a generic SQLITE_ERROR resu

Re: sqlite3, OperationalError: no such column, shouldn't that ne a ProgrammingError?

2009-06-19 Thread Gerhard Häring
Gabriel Rossetti wrote: > Hello everyone, > > I get an OperationalError with sqlite3 if I put the wrong column name, > but shouldn't that be a ProgrammingError instead? I read PEP 249 and it > says : > > "OperationalError >Exception raised for errors that are related t

Re: Observer implementations

2009-06-15 Thread Gerhard Häring
Tobias Weber wrote: > Hi, > how to use the Observer pattern in Python? Implement it in your classes? > I found PubSub and PyDispatcher, both of which are abandoned. [...] I haven't searched for these, but googling for "python observer pattern" yields http://code.activestate.com/recipes/131499/ a

Re: command prompt: the ntvdm cpu has encountered an illegal instruction

2009-05-24 Thread Gerhard Häring
Daniel wrote: > If I try to invoke python via the command prompt I get an error > "command prompt: the ntvdm cpu has encountered an illegal > instruction..." > > I don't get this problem if I first cd to the python directory. I am > running python 3.0 on windows. Running Python from the Cygwin s

Re: Learning C++ for Python Development

2009-05-11 Thread Gerhard Häring
joshua.pea...@gmail.com wrote: > I am a recovering C# web developer who has recently picked up Django > and I'm loving it. > > I would eventually like to get a job as a Django/Python developer. It > seems that many Python jobs require that you also be a C++ developer. I've seen the C++/Python com

Re: update python version

2009-05-07 Thread Gerhard Häring
km wrote: > Hi all, > > Is there a way to update python 2.6.1 to 2.6.2 using easy_install ? No, easy_install installs Python packages. It doesn't upgrade Python itself. If this is Windows, just install the newer Python version. No need to uninstall the 2.6.1 first. If this is some Unix variant,

Re: configuring python with disable-thread in Ubuntu

2009-05-07 Thread Gerhard Häring
Deepak Chandran wrote: > Hello, > > I am embedding python inside a C++ program. For some reason (I think > libxml2), I am getting Segmentation fault at PyThread_release_lock. > > The solution I found online was to configure python with --disable-thread. That doesn't sound like a solution, but

Re: Web framework for embedded system

2009-04-28 Thread Gerhard Häring
Thomas Heller wrote: > I'm looking for a lightweight web-framework for an embedded system. > The system is running a realtime linux-variant on a 200 MHz ARM > processor, Python reports a performance of around 500 pystones. > > The web application will not be too fancy, no databases involved > for

Re: value error

2009-04-23 Thread Gerhard Häring
Francesco Pietra wrote: > hi: > with script > > data = open('134-176_rectified_edited.pdb', 'r') > outp = open('134-176_renumbered.pdb', 'w') > > for L in data: >if L[3] == 'M': > L = L[:24] + "%4d" % (int(L[24-28])+133) + L[28:] >outp.write(L) > > > i wanted to modify lines of the

Re: Memory problems (garbage collection)

2009-04-23 Thread Gerhard Häring
Here's a link for you: http://wiki.python.org/moin/PythonSpeed/PerformanceTips which also talks about string concatenation and othere do's and don'ts. -- Gerhard -- http://mail.python.org/mailman/listinfo/python-list

Re: Memory problems (garbage collection)

2009-04-23 Thread Gerhard Häring
Carbon Man wrote: > Very new to Python, running 2.5 on windows. > I am processing an XML file (7.2MB). Using the standard library I am > recursively processing each node and parsing it. The branches don't go > particularly deep. What is happening is that the program is running really > really sl

Re: and [True,True] --> [True, True]?????

2009-04-20 Thread Gerhard Häring
Martin v. Löwis wrote: >> Are they widespread? I haven't noticed, yet. >> >> I prefer to write it explicitly: >> >> if len(lst) > 0: > > I prefer to test explicitly for the truth value of the > list. I don't want to test whether the length of the list > is greater than 0 (in fact, I don't care abo

Re: when can i expect libraries and third party tools to be updated for python 3 ?

2009-04-20 Thread Gerhard Häring
Deep_Feelings wrote: > every one is telling "dont go with python 3 , 3rd party tools and > libraries have no compitability with python 3" > > so from previous experience : when can i expect libraries and third > party tools to be updated for python 3 ? (especially libraries ) The problem is: ther

Re: and [True,True] --> [True, True]?????

2009-04-20 Thread Gerhard Häring
Peter Otten wrote: > bdb112 wrote: > >> Your explanation of Boolean ops on lists was clear. >> It leads to some intriguing results: >> >> bool([False]) >> --> True >> >> I wonder if python 3 changes any of this? > > No. Tests like > > if items: >... > > to verify that items is a non-empty l

WHIFF - was: Re: Using Python after a few years of Ruby

2009-04-15 Thread Gerhard Häring
Aaron Watters wrote: > On Apr 15, 3:49 am, Tim Hoffman wrote: > >> There are plenty of python web frameworks, some have quite different >> approaches, >> what suits you will depend very much on your own bias, interest. > > I've had a lot of luck with WHIFF > ( http://whiff.sourceforge.net ) > Of

Re: [ANN] Falcon - powering innovation

2009-04-13 Thread Gerhard Häring
Kless wrote: > If anybody is interesed in new technologies, you'll love this new > language called Falcon [1], which has been open sourced ago little > time. > > Falcon is a scripting engine ready to empower mission-critical > multithreaded applications. "Mission-critical" and "empower" sound li

Re: C API String Parsing/Returning

2009-04-06 Thread Gerhard Häring
k3xji wrote: > Hi all, > > This might be a newbie question. I am trying to implement a simple > string decoder/encoder algorithm. Just suppose I am substrcating some > values from the string passed as a parameter to the function and I > want the function to return encoded/decoded version of the st

Re: group several methods under a attribute

2009-04-06 Thread Gerhard Häring
jelle wrote: > Hi, > > I'm working on a pretty large class Can you describe what its purpose is? > and I'd like to group several methods under a attribute. That doesn't work in Python without bending the Python. > Its not convenient to chop up the class in several smaller classes, But that's

Re: HTTP Authentication

2009-04-06 Thread Gerhard Häring
Lakshman wrote: > Whats is the python urllib2 equivallent of > > curl -u username:password status="abcd" http://example.com/update.json > > I did this: > > handle = urllib2.Request(url) > authheader = "Basic %s" % base64.encodestring('%s:%s' % (username, > password)) > handle.add_header("Author

Re: Cannot find text in *.py files with Windows Explorer?

2009-04-05 Thread Gerhard Häring
John Machin wrote: > On Apr 4, 3:21 pm, John Doe wrote: >> Anybody have a solution for Windows (XP) Explorer search not finding >> ordinary text in *.py files? >> > > Get a grep on yourself! > > http://gnuwin32.sourceforge.net/packages/grep.htm There's something even better: "ack -- better tha

Re: Best Compatible JS Lib for Django

2009-04-05 Thread Gerhard Häring
Daniel Fetchinson wrote: >> Does anyone have experience with using JS Libraries with Django? >> Do some work better than others and are easier to code with? > > You might want to ask this on the django list. Or on a JavaScript list ;-) It doesn't matter much in what context you use the JavaScript

Re: PyPy Progress (and Psyco)

2009-03-15 Thread Gerhard Häring
andrew cooke wrote: This looks very promising - http://www.voidspace.org.uk/python/weblog/arch_d7_2009_03_14.shtml#e1063 I am really looking forwards to PyPy having a final release. I hope it happens. Me too. I doubt it, though. From an outside view, the project seems to lack focus. To me, i

[ANN] pysqlite 2.5.2

2009-03-03 Thread Gerhard Häring
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.

Re: Display a list using PyQt

2009-02-16 Thread Gerhard Häring
member Basu wrote: > I'm writing an application with PyQt as the GUI toolkit. I have a > function that returns a simple list and I would like to update a List > View widget with it. However I can't get it to work. I'm not sure if I > need to subclass one of the Model classes, because it is just a l

Re: Which core am I running on?

2009-02-10 Thread Gerhard Häring
psaff...@googlemail.com wrote: > On 9 Feb, 12:24, Gerhard Häring wrote: >> http://objectmix.com/python/631346-parallel-python.html >> > > Hmm. In fact, this doesn't seem to work for pp. When I run the code > below, it says everything is running on the one core. &

Re: Which core am I running on?

2009-02-09 Thread Gerhard Häring
psaff...@googlemail.com wrote: > Is there some way I can get at this information at run-time? I'd like > to use it to tag diagnostic output dumped during runs using Parallel > Python. There should be a way, but not with the Python standard library. It's also platform-specific. What are you using?

Re: Which core am I running on?

2009-02-09 Thread Gerhard Häring
psaff...@googlemail.com wrote: > Is there some way I can get at this information at run-time? I'd like > to use it to tag diagnostic output dumped during runs using Parallel > Python. Looks like I have answered a similar question once, btw. ;-) http://objectmix.com/python/631346-parallel-python.h

Re: Local python web server problem

2009-02-09 Thread Gerhard Häring
Farsheed Ashouri wrote: > Hi everyone. I have started to develop a web base software for > renderfarm managing. > I run the cherrypy hello world! example and when I visit > 127.0.0.1:8080 > on firefox, a nice "Hello World" appears. I am on ubuntu and my ip in > local network is 192.168.100.18 > but

Re: updating nntplib

2009-02-06 Thread Gerhard Häring
Travis wrote: > Hello all, > > There are some notable deficiencies in nntlib. Here are two: [...] Be sure to add a bug report/patch to the Python bug tracker. http://bugs.python.org/ Anything else will most likely be overlooked or forgotten. -- Gerhard -- http://mail.python.org/mailman/listi

Re: Is there anyway Vpython and pyODE can be made to work with newer versions of Python 2.6.1 etc. without a lot of changes to source code?

2009-01-24 Thread Gerhard Häring
Casey Hawthorne wrote: Is there anyway Vpython and pyODE can be made to work with newer versions of Python 2.6.1 etc. without a lot of changes to source code? I suppose I'm thinking of an extra layer of indirection, which might slow things down to much. Aren't this just Python libraries that i

Re: PyQt4 on Windows ?

2009-01-20 Thread Gerhard Häring
Linuxguy123 wrote: What does it take to get a PyQt4 application running on a Windows machine ? To run, installing Python + PyQt4 ;-) To create a binary wrapper, I use py2exe (I also tried cx_Freeze, both work the same). There's a gotcha with PyQt4 - snippet follows: setup( options = {"p

Re: Encrypted Logging in python

2009-01-09 Thread Gerhard Häring
koranth...@gmail.com wrote: >I was wondering if there is a mechanism to encrypt logging > automatically in python. Python's standard library doesn't include any "strong" symmetric ciphers. But if you include for example a cryptographic module for AES, for example, it should be easy (I guess 10

Re: Python Apache Handler

2009-01-09 Thread Gerhard Häring
Scooter wrote: > Does anyone have any good examples, or links thereto for using python > as an Apache handler? And I should qualify all of this by saying I'm a > python newbie, and while having experience with Apache, I've never > done anything outside whats "in the box" . > > What I'm looking for

Re: pg_result_status() alternative?

2009-01-07 Thread Gerhard Häring
Qian Xu wrote: Steve Holden wrote: Without knowing the full details of that particular module I would hazard a guess that any database errors will raise exceptions in Python. No exceptions means your database operation worked fine. result status is not an exception. It means the information of

Re: Is there a better algorithm?

2009-01-02 Thread Gerhard Häring
Kottiyath wrote: I have the following list of tuples: L = [(1, 2), (3, 4, 5), (6, 7)] I want to loop through the list and extract the values. The only algorithm I could think of is: [...] If this is part of a real program, instead of an exercise, you should fix the code that creates this list

Re: Easy-to-use Python GUI

2008-12-31 Thread Gerhard Häring
Dotan Cohen wrote: I have been following this thread with interest. Is there a way to build Qt apps with relative easy? I use KDE and would prefer the Qt toolkit for my GUI apps. Thanks. A few years ago, I've had bad experiences with wxPython (random things not actually working on Linux, only

Re: SQL, lite lite lite

2008-12-30 Thread Gerhard Häring
Bruno Desthuilliers wrote: Aaron Brady a écrit : Hi all, (snip) > I don't think relational data can be read and written very easily in Python. Did you try SQLAlchemy or Django's ORM ? [...] Using an ORM when you don't grasp the relational model and/or the SQL query language is futile.

Re: turtle ?

2008-12-23 Thread Gerhard Häring
sai wrote: > python newbie here :-) > > I am trying to get turtle to run but got stuck here: > > $ python > Python 2.5.2 (r252:60911, Aug 5 2008, 16:17:28) > [GCC 4.2.2 20071128 (prerelease) (4.2.2-3.1mdv2008.0)] on linux2 > Type "help", "copyright", "credits" or "license" for more information.

Re: RELEASED Python 3.0 final

2008-12-04 Thread Gerhard Häring
Iain King wrote: > [...] Props. I just looked through the What's New and the change log, but I > couldn't find the answer to something: has any change been made to > how tabs and spaces are used as indentation? Can they still be > (inadvisably) mixed in one file? Or, more extremely, has one or

Re: Pythonic design patterns

2008-12-04 Thread Gerhard Häring
Slaunger wrote: > Hi comp.lang.python > > I am this novice Python programmer, who is not educated as a computer > scientist (I am a physicist), and who (regrettably) has never read the > GOF on design patterns. [...] > I guess I could boost my productivity by learning these well-proven > and well

Re: building an extension module with autotools?

2008-12-03 Thread Gerhard Häring
Michael George wrote: Hello, (Please CC me in replies, as I am off-list) Ok, but please reply publicly. I'm building an application (a game) in python, with a single C module containing some performance-critical code. I'm trying to figure out the best way to set it up to build. Use dist

Re: python an sqlite objects

2008-12-03 Thread Gerhard Häring
azrael wrote: It logical that it would be more efficient and logical to use a object oriented database, but in this case I ask because of the portable nature of sqlite. so, if I get it right, this should be possible [...] Did you try it? Did it work? If so,it was pure luck. Attached is a scri

Re: python an sqlite objects

2008-12-03 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: > azrael> is it possible to save a python object into a sqlite database as > azrael> an atribute of type BLOB > > Sure. Just pickle the object and save the resulting string. Be sure to save it as BLOB, not TEXT. Suppose you have serialized your object as Python

Re: pysqlite install error on hp ux (ld: Can't find library for -lpython2.5)

2008-11-12 Thread Gerhard Häring
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 avaliable. I

Re: Problem with sqlite3 cursor and imbricated for loop

2008-11-12 Thread Gerhard Häring
Charles V. wrote: Hi, Both may be standard compliant, but if you're depending on implementation details, you may still get different behaviour. I'm pretty sure that MySQLdb always fetches the entire resultset from the server. The sqlite3 module uses what would have been called "server-side curs

Re: Problem with sqlite3 cursor and imbricated for loop

2008-11-12 Thread Gerhard Häring
Steve Holden wrote: [...] I feel with you. The fact that cursors, and not connection objects have the executeXXX methods is totally braindead. So you'd rather have to use separate connections? That would make isloated transaction processing a little tricky ... No, I just find code like: con

Re: Problem with sqlite3 cursor and imbricated for loop

2008-11-12 Thread Gerhard Häring
Charles V. wrote: Hi, Thank for replying. Either use a second cursor OR ensure you fetch all the data from the first .execute() first: Are these really the only solutions ? Yes. I was expecting the same behavior than MySQLdb module, which is, as sqlite3, DB-API 2.0 compatible. Both ma

Re: PySqlite - division of real numbers without decimal fractions

2008-11-07 Thread Gerhard Häring
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 when doing division on

Re: Is psyco available for python 2.6?

2008-10-30 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: sert: I used the windows installer for the latest version of psyco, which is labeled as compatible with 2.5, but it gives the following error: ImportError: DLL load failed: The specified module could not be found. (check that the compiled extension 'C:\Python26\lib\site-

Re: list versions of all installed modules

2008-10-28 Thread Gerhard Häring
John [H2O] wrote: Is there a quick way to list the version of each installed module? $ sudo easy_install yolk $ yolk -l -- Gerhard -- http://mail.python.org/mailman/listinfo/python-list

Re: Python 2.5 + sqlite full text search possible?

2008-10-28 Thread Gerhard Häring
Guillermo wrote: Hi! Is it possible to use the full-text module of SQLite with the sqlite3 module? I've done a bit of investigation and it seems the stand-alone distribution of SQLite is compiled without it, Yes, though compiling using the amalgamation and defining SQLITE_ENABLE_FTS3 helps.

Re: Python 2.5 + sqlite full text search possible?

2008-10-28 Thread Gerhard Häring
Guillermo wrote: Hi! Is it possible to load the full-text search module for the SQLite version bundled with Python 2.5? [...] I'm on Windows XP. Yes, it's possible. But not easily. You have to replace the sqlite3.dll that comes with Python 2.5 with one that includes fulltext search. If you

Re: [newbie] Right way to access item in array?

2008-10-28 Thread Gerhard Häring
Diez B. Roggisch wrote: Gilles Ganault wrote: Hello I'd like to know what the right way is to access an item in a row as returned by a database: = import apsw connection=apsw.Connection("test.sqlite") cursor=connection.cursor() rows=cursor.execute("SELECT isbn,price FROM books WHERE pri

Re: conversion to and from unicode strings

2008-10-27 Thread Gerhard Häring
abhishek wrote: hello group, i want to represent and store a string u'\x00\x07\xa7' as '\x00\x07\xa7'. any ideas on how to achieve this. You want to store it in the form of the repr() of the string? It is possible to use repr() to get a bytestring to store and to use eval() to create a unic

Re: look-behind fixed width issue (package re)

2008-10-24 Thread Gerhard Häring
MRAB wrote: On Oct 24, 6:29 am, Peng Yu <[EMAIL PROTECTED]> wrote: Hi, It seem that the current python requires fixed-width pattern for look- behind. I'm wondering if there is any newly development which make variable-width pattern available for look-behind. The re module is currently being w

Re: [APSW] SELECT COUNT(*) not succesfull?

2008-10-23 Thread Gerhard Häring
Gilles Ganault wrote: On Thu, 23 Oct 2008 00:24:01 -0200, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: In case you didn't notice, B.D. already provided the answer you're after - reread his 3rd paragraph from the end. Yes, but it doesn't work with this wrapper (APSW version 3.5.9-r1): The

Re: [APSW] SELECT COUNT(*) not succesfull?

2008-10-23 Thread Gerhard Häring
Dennis Lee Bieber wrote: On Thu, 23 Oct 2008 09:26:54 +0200, Gilles Ganault <[EMAIL PROTECTED]> declaimed the following in comp.lang.python: Yes, but it doesn't work with this wrapper (APSW version 3.5.9-r1): APSW is not, so far as I recall, a "DB-API 2" adapter -- it is a touch more

Re: like using python

2008-10-16 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: as the subject me2 -- http://mail.python.org/mailman/listinfo/python-list

Re: Race condition when generating .pyc files

2008-10-07 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: I have a large body of Python code which runs on many different (Unix) machines concurrently. Part of the code lives in one place, but most of it lives in directories which I find at runtime. I only have one copy of each Python source file and I think I'm hitting a race

Re: Pure Python interface to MySQL?

2008-10-07 Thread Gerhard Häring
Gerhard Häring wrote: James Mills wrote: On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <[EMAIL PROTECTED]> wrote: Does there exist a pure Python version of a MySQL module? I've got a data logging application that needs to run on a whole bunch of OSs, ranging from Windows to a doze

Re: Pure Python interface to MySQL?

2008-10-07 Thread Gerhard Häring
James Mills wrote: On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <[EMAIL PROTECTED]> wrote: Does there exist a pure Python version of a MySQL module? I've got a data logging application that needs to run on a whole bunch of OSs, ranging from Windows to a dozen different unix flavors on all sorts of

Re: Cannot install pysqlite on Cygwin

2008-09-29 Thread Gerhard Häring
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 function

Re: finding domain name

2008-09-23 Thread Gerhard Häring
Bobby Roberts wrote: hi group. I'm new to python and need some help and hope you can answer this question. I have a situation in my code where i need to create a file on the server and write to it. That's not a problem if i hard code the path. However, the domain name needs to be dynamic so i

Re: Comparing float and decimal

2008-09-23 Thread Gerhard Häring
D'Arcy J.M. Cain wrote: I'm not sure I follow this logic. Can someone explain why float and integer can be compared with each other and decimal can be compared to integer but decimal can't be compared to float? from decimal import Decimal i = 10 f = 10.0 d = Decimal("10.00") i == f True i ==

Re: adding in-place operator to Python

2008-09-23 Thread Gerhard Häring
Arash Arfaee wrote: Hi All, Is there anyway to add new in-place operator to Python? You can't create new syntax, like %= Or is there any way to redefine internal in-place operators? What you can do is give your objects the ability to use these operators. See http://docs.python.org/ref/nu

Re: how dump a program which is running in memory

2008-09-11 Thread Gerhard Häring
ruqiang826 wrote: hi I have written a service running backgroud to do something in linux. unfortunately,I deleted the source code by mistake, and I can still see the process running background using "ps aux" : username 13820 0.0 0.0 60368 2964 ?SAug20 0:33 python ./UpdateJobSta

Re: [ANN] pysqlite 2.5.0 released

2008-09-08 Thread Gerhard Häring
Matthias Huening wrote: Gerhard Häring (08.09.2008 10:12): Error is: con.execute("select load_extension('./fts3.so')") pysqlite2._sqlite.OperationalError: Das angegebene Modul wurde nicht gefunden. Where should I look for the module? The sources are in ext/fts3 in th

Re: [ANN] pysqlite 2.5.0 released

2008-09-08 Thread Gerhard Häring
Matthias Huening wrote: 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(":

Re: embed python in ms-word?

2008-09-06 Thread Gerhard Häring
oyster wrote: > In my ms-word documnet, there are some calculation whihc I have to > change due to different argumnet. is there any way to embed python > code in word, so that I can write the following as a macro or > something else, then the result (i.e. 2) is shown in the word > documnet? > > de

Re: sqlite3 import performance

2008-09-05 Thread Gerhard Häring
Ben Lee wrote: > hi folks -- > > a quick python and sqlite3 performance question. i find that > inserting a million rows of in-memory data into an in-memory database > via a single executemany() is about 30% slower than using the sqlite3 > CLI and the .import command (reading the same data from a

[ANN] pysqlite 2.5.0 released

2008-09-05 Thread Gerhard Häring
-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. What is pysqlit

Re: cPickle

2008-09-04 Thread Gerhard Häring
gopal mishra wrote: I have 3 objects and want to save in one pickle file. I used cPickle to dump 3 objects in a pkl file i.e cPickle.dump(object1, fileobject, -1) cPickle.dump(object2, fileobject, -1) cPickle.dump(object3, fileobject, -1) I have chang

Re: use of Queue

2008-08-27 Thread Gerhard Häring
Alexandru Mosoi wrote: how is Queue intended to be used? I found the following code in python manual, but I don't understand how to stop consumers after all items have been produced. I tried different approaches but all of them seemed incorrect (race, deadlock or duplicating queue functionality)

Re: Non-evil multithreaded WSGI server?

2008-08-27 Thread Gerhard Häring
Gabriel Genellina wrote: En Tue, 26 Aug 2008 03:20:53 -0300, Gerhard Häring <[EMAIL PROTECTED]> escribi�: In a recent experiment I've done this: from BaseHTTPServer import HTTPServer, BaseHTTPRequestHandler from wsgiref.simple_server import make_server, demo_app from SocketSe

Non-evil multithreaded WSGI server?

2008-08-25 Thread Gerhard Häring
In a recent experiment I've done this: from BaseHTTPServer import HTTPServer, BaseHTTPRequestHandler from wsgiref.simple_server import make_server, demo_app from SocketServer import ThreadingMixIn # Let's make a WSGI server that can use multiple threads. class ThreadedHTTPServer(ThreadingMixIn,

Re: rspec for python

2008-08-25 Thread Gerhard Häring
Rustom Mody wrote: Is there anything equivalent to rspec for python? I had to Google to see what it is: "A Behaviour Driven Development" framework for Ruby. In a blog article from Ian Bicking says that it is impossible to have a Python port of this because Python doesn't allow you to inject

Re: newbie question

2008-08-25 Thread Gerhard Häring
sharon k wrote: hi all, i am new to python. > i fetch a webpage with urllib, extract a few numbers in a format as follow; 10,884 24,068 my question is how to remove the comma between the number, since i have to add them up later. Strings have a replace method. Calling replace(",", "") on

  1   2   3   >