[sqlalchemy] Re: Inserts using reflection...

2008-09-05 Thread az
the 2 approaches are code 2 db or db 2 code; yours is db 2 code - AFAIK see sqlsoup http://www.sqlalchemy.org/docs/05/plugins.html#plugins_sqlsoup On Friday 05 September 2008 07:23:35 Sam wrote: Michael... I've read the tutorial, and I think I understand it. But maybe I don't understand

[sqlalchemy] Re: Inserts using reflection...

2008-09-05 Thread Michael Bayer
On Sep 5, 2008, at 12:23 AM, Sam wrote: Michael... I've read the tutorial, and I think I understand it. But maybe I don't understand reflection. I thought that I could use it to avoid defining anything. I'd like to have objects basically spring into life knowing exactly what their row

[sqlalchemy] Re: Inserts using reflection...

2008-09-04 Thread Michael Bayer
On Sep 4, 2008, at 7:16 PM, Sam wrote: I woke up today and decided it was time to switch one of my simpler programs from sqlobject to sqlalchemy. I'm using reflection. After some googling I was able to find a way to insert: mp = mphones.insert().execute(word=word, mphone=phone) The

[sqlalchemy] Re: Inserts using reflection...

2008-09-04 Thread Sam
Michael... I've read the tutorial, and I think I understand it. But maybe I don't understand reflection. I thought that I could use it to avoid defining anything. I'd like to have objects basically spring into life knowing exactly what their row names are, without having to type anything. Am