[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-16 Thread Werner F. Bruhin
Shawn, Shawn Church wrote: On Sat, Nov 15, 2008 at 7:55 AM, Michael Bayer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: easy_install remains a mystery to me in general. Try easy_install sqlalchemy==0.5.0rc4 , or otherwise yeah delete out your dev versions. I use

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
On Nov 15, 2008, at 10:33 PM, Randy Syring wrote: Thank you so much for your response, I am extremely grateful. However, I am still getting exceptions thrown from SQLite for sharing connections across threads. Unfortuantely I cant reproduce your error now, whereas it was quite frequent

[sqlalchemy] Re: distance calculation and ORM

2008-11-16 Thread Michael Bayer
On Nov 16, 2008, at 2:09 AM, indigophone wrote: I have the following query: SET @lat = 40.81518; SET @lon = -73.0455; SELECT 3963.0 * acos(sin(@lat/57.2958) * sin(z.latitude/57.2958) + cos(@lat/ 57.2958) * cos(z.latitude/57.2958) * cos(z.longitude/57.2958 - @lon/ 57.2958)) AS

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
here is an interesting thread related to this subject: http://www.modpython.org/pipermail/mod_python/2006-August/021854.html this person reported problems with threading.local() in conjunction with mod_python. Its unfortunate that I can't locate any Python bug reports or anything to

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
On Nov 15, 2008, at 4:53 PM, Randy Syring wrote: When I run the exact same code using PyISAPIe, I get the following log file, which shows many exceptions all propagating up to my application and hosing it: Reading Graham's comments on threading:

[sqlalchemy] Python 3.0

2008-11-16 Thread greno
Can SQLAlchemy be used in a Python 3.0 environment? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group,

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread Michael Bayer
The two main issues with this are DBAPI availability, and code migration. I have been waiting for Py3K to be generally stable before even attempting to migrate the code, its going to be a huge job. We're still settling into Python 2.6 compatibility to even get on board there.

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread greno
Looks like final release of Python 3.0 will happen in December 2008 so one month. I was hoping to see projects like SQLAlchemy being almost ready for 3.0 but it seems people were waiting for final release. I guess if you have the code running under 2.6 and you have all the Py3k warnings

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread Michael Bayer
On Nov 16, 2008, at 2:27 PM, greno wrote: Looks like final release of Python 3.0 will happen in December 2008 so one month. I was hoping to see projects like SQLAlchemy being almost ready for 3.0 but it seems people were waiting for final release. I guess if you have the code running

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread Michael Bayer
On Nov 16, 2008, at 2:38 PM, Michael Bayer wrote: there's little or no DBAPIs available. There won't be widespread use before that happens in any case. If current DBAPIs don't provide for Py3K and new contenders step in, then that complicates things even further as our dialects are

[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-16 Thread Shawn Church
On Sun, Nov 16, 2008 at 1:24 AM, Werner F. Bruhin [EMAIL PROTECTED]wrote: But after I had installed rc3 I easy_installed from svn (http://svn.sqlalchemy.org/sqlalchemy/trunk) and then when rc4 came out and I wanted to do the upgrade I got again a dev version (sqlalchemy-0.5.0rc4dev_r0). I

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread Christian Heimes
http://mail.python.org/pipermail/python-list/2008-September/508112.html months to years. Yeah :/ It's realistic to assume that some packages will never be ported to 3.0. C Extensions lile most DBA are going to take several days of serious work or several months of slow migration. In order to

[sqlalchemy] Re: Python 3.0

2008-11-16 Thread Michael Bayer
On Nov 16, 2008, at 6:06 PM, Christian Heimes wrote: * wait until 2.6.1 is released. 2to3 in 2.6.0 is broken and breaks on SA 0.5rc2 rc4 runs on the current 2.6 release, I've been experimenting today. * get SA working on 2.6.1 with the -3 warning options w/o triggering a warning I've

[sqlalchemy] ORM: Retrieving table from mapped class

2008-11-16 Thread Moshe C.
Hi, Given a mapped ORM class, is it possible to retrieve from it the Table instabce to which it was mapped? TIA Moshe --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Re: ORM: Retrieving table from mapped class

2008-11-16 Thread Bobby Impollonia
Are you using declarative? If so, your class will have a property called __table__ On Sun, Nov 16, 2008 at 4:04 PM, Moshe C. [EMAIL PROTECTED] wrote: Hi, Given a mapped ORM class, is it possible to retrieve from it the Table instabce to which it was mapped? TIA Moshe

[sqlalchemy] Re: ORM: Retrieving table from mapped class

2008-11-16 Thread Moshe C.
No, I am not using declarative . On Nov 17, 2:43 am, Bobby Impollonia [EMAIL PROTECTED] wrote: Are you using declarative? If so, your class will have a property called __table__ On Sun, Nov 16, 2008 at 4:04 PM, Moshe C. [EMAIL PROTECTED] wrote: Hi, Given a mapped ORM class, is it

[sqlalchemy] Re: ORM: Retrieving table from mapped class

2008-11-16 Thread Michael Bayer
class_mapper(theclass).mapped_table On Nov 16, 2008, at 7:50 PM, Moshe C. wrote: No, I am not using declarative . On Nov 17, 2:43 am, Bobby Impollonia [EMAIL PROTECTED] wrote: Are you using declarative? If so, your class will have a property called __table__ On Sun, Nov 16, 2008 at 4:04

[sqlalchemy] Re: ORM: Retrieving table from mapped class

2008-11-16 Thread Moshe C.
thanks On Nov 17, 2:53 am, Michael Bayer [EMAIL PROTECTED] wrote: class_mapper(theclass).mapped_table On Nov 16, 2008, at 7:50 PM, Moshe C. wrote: No, I am not using declarative . On Nov 17, 2:43 am, Bobby Impollonia [EMAIL PROTECTED] wrote: Are you using declarative? If so, your

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Randy Syring
On Nov 16, 11:30 am, Michael Bayer [EMAIL PROTECTED] wrote: I've looked into PyISAPIe.    Suffice to say this seems to be an   extremely new project.  Their homepage is blank: It has been around for a couple years: http://web.archive.org/web/*/http://pyisapie.sourceforge.net/ But I agree

[sqlalchemy] Re: Should create_engine() be called per-process or per-request in threaded wsgi environment?

2008-11-16 Thread Randy Syring
Problem turns out to have been with my ISAPI WSGI interface, it looks like it has a broken thread local model. More details here if anyone is interested: http://groups.google.com/group/sqlalchemy/browse_thread/thread/fbca1399020f6a2e On Nov 6, 5:19 pm, Randy Syring [EMAIL PROTECTED] wrote:

[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-16 Thread joelanman
The new count method works great - it's a big help, thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this

[sqlalchemy] SHA1 Row Fingerprint for ETL Audit Trail

2008-11-16 Thread EricHolmberg
As part of an ETL process, I need to generate an SHA1 fingerprint that uniquely defines a row of data (collisions will have to be handled as well) for the audit trail. The data in tables consists of short strings and floating point values. What's the best way to get an SHA1 fingerprint of a row