Re: [Sqlalchemy-users] SQLAlchemy and py2exe Instructions

2006-05-07 Thread Rick Morrison
Also be aware that the database imports (that is both database-specific support within SA such as "mysql.py", "mssql.py" etc., as well as the DBAPI files used beneath the covers)   are loaded dynamically by SA, and therefore won't be detected by the dependency checkers in py2exe and cxFreeze. You'

Re: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Jonathan Ellis
On 5/7/06, Dennis Muhlestein <[EMAIL PROTECTED]> wrote: On 5/6/06, Jonathan Vanasco <[EMAIL PROTECTED] > wrote: Just wondering-Has anyone thought of making a tool for sqlalchemy to reverseengineer a database?I haven't tried it yet, but I read the blog post and it appears that this is what you want

Re: [Sqlalchemy-users] should i go with 0.17 or pre 0.2?

2006-05-07 Thread Michael Bayer
if youre evaluating, 0.2 is what its going to be. its mostly working now but is subject to destabilizing checkins. also keep in mind all of SA is still "alpha"...not ready for air traffic control apps just yet... On May 6, 2006, at 4:38 PM, Soni Bergraj wrote: Hello, I'm considering to

Re: [Sqlalchemy-users] case insensitive LIKE

2006-05-07 Thread Michael Bayer
what happens if you just run that query in postgres directly ? does straight LIKE work ? you can also do your ilike like this: item.c.item_name.op('ilike')('%toto%') On May 6, 2006, at 8:49 PM, Yuan HOng wrote: I have a simple Item class mapped to table automatically reflected from the Post

Re: [Sqlalchemy-users] Problem with objectstore.commit() for object deletion

2006-05-07 Thread Michael Bayer
when you delete the "series" objects, they are being removed from the unit of work, but are not being removed from your Brand object. you have to do that yourself. therefore when the deletion of Brand occurs, it attempts to update the "Series" objects still attached to the Brand and fails

Re: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Michael Bayer
regardless of if you have a DB with 250 or 1000 tables. is it then appropriate to have 1000 separate classes ? shouldnt the concepts of some of those tables be rolled up into coarser-grained domain objects ? whats the point of using an ORM and a domain model really if youre just going to

[Sqlalchemy-users] SQLAlchemy and py2exe Instructions

2006-05-07 Thread Gambit
Hey All, Spent a little time today trying to package up my application for it's first round of test users and such. Put it together with the py2exe (and, eventually, will probably use 'freeze' for the linux side) and immediately ran into the problem of py2exe not understanding .egg's. Sigh. The

Re[4]: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Gambit
Hey Jonathan, Ah yeah, for sure. I thought of it pretty shortly once I started getting in on things here too. That's what I was saying, though, wrt to the pickle command being potentially just what you're looking for. polpak on #python also suggested exporting it to XML, which actually strikes

Re: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Dennis Muhlestein
On 5/6/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: Just wondering-Has anyone thought of making a tool for sqlalchemy to reverseengineer a database?I haven't tried it yet, but I read the blog post and it appears that this is what you want. http://spyced.blogspot.com/2006/04/introducing-sqlsoup.h

Re: Re[2]: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Jonathan Vanasco
On May 7, 2006, at 6:28 AM, Gambit wrote: Hey All, Maybe I'm missing something, but isn't this what reflection is all about? You can easily (well, on most DB's at least) throw a bit of explicit SQL at the database to get a list of all the tables, from there simply create the necessary Ta

[Sqlalchemy-users] Problem with objectstore.commit() for object deletion

2006-05-07 Thread Yuan HOng
Hi, I encountered a strange situation when trying to delete an object from a parent table with all its child objects. I found that if you call objectstore.commit() after the deletion of each child object, then you got problem when deleting the parent object. The parent table is called 'brand', w

Re[2]: [Sqlalchemy-users] reverse engineer?

2006-05-07 Thread Gambit
Hey All, Maybe I'm missing something, but isn't this what reflection is all about? You can easily (well, on most DB's at least) throw a bit of explicit SQL at the database to get a list of all the tables, from there simply create the necessary Table() objects. It might take a while, of course, b