[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-15 Thread Werner F. Bruhin
I just easy_install'ed it and got sqlalchemy-0.5.0rc4dev_r0-py2.5.egg Is this the correct one or did my getting the SVN version the other day causes a problem? Werner --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-15 Thread Michael Bayer
easy_install remains a mystery to me in general. Try easy_install sqlalchemy==0.5.0rc4 , or otherwise yeah delete out your dev versions. On Nov 15, 2008, at 3:41 AM, Werner F. Bruhin wrote: I just easy_install'ed it and got sqlalchemy-0.5.0rc4dev_r0- py2.5.egg Is this the correct one

[sqlalchemy] Info needed regarding the use of cascade

2008-11-15 Thread --- [EMAIL PROTECTED] ---
am a newbie .. encountered a small problem any help will be appreciated class Stock(declarative_base): __tablename__ = 'tbl_stock' books = relation(Book, order_by=Book.id, backref=tbl_stock) pass class Book(declarative_base):

[sqlalchemy] Re: Info needed regarding the use of cascade

2008-11-15 Thread Michael Bayer
On Nov 15, 2008, at 6:03 AM, --- [EMAIL PROTECTED] --- wrote: i have tried giving cascade = 'a'',delete-orphan' but errors comes you should use delete-orphan for that functionality. If there are error messages, feel free to ask what they mean. Also you have redundant relations set up,

[sqlalchemy] Re: multilingual content / multiple currencies (prices)

2008-11-15 Thread g00fy
I was using sqlite but that should not matter. Now my concern is: How to create Translation object , that can refer to multiple tables?, how can I create copy of tables (schema) with only different table name? otherwords: How can I implement the solution with multiple Translation tables (table

[sqlalchemy] Re: SQLAlchemy 0.5rc4 Released

2008-11-15 Thread Shawn Church
On Sat, Nov 15, 2008 at 7:55 AM, Michael Bayer [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 easy_install --upgrade sqlalchemy: [EMAIL PROTECTED]:~/$ sudo easy_install

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

2008-11-15 Thread Randy Syring
As noted here, I have been having some problems with SQLite connections: http://groups.google.com/group/sqlalchemy/browse_thread/thread/5f742fdd313f3da9/ I went ahead and produced what I hope is a very narrow test case to show that I am not explicitly holding onto connections (unless I

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

2008-11-15 Thread Michael Bayer
On Nov 15, 2008, at 4:53 PM, Randy Syring wrote: I went ahead and produced what I hope is a very narrow test case to show that I am not explicitly holding onto connections (unless I completely misunderstand, which is possible). Here is my test code: http://paste.pocoo.org/show/91285/

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

2008-11-15 Thread Randy Syring
On Nov 15, 6:39 pm, Michael Bayer [EMAIL PROTECTED] 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. The explicit connection as well as the threadlocal strategy are all

[sqlalchemy] distance calculation and ORM

2008-11-15 Thread indigophone
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 distance, fa.advisor_id, c.city_name, s.iso_state_name FROM