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 I misunderstanding reflection? Can it not automatically figure out the row names for me? If it can, is there an example of this somewhere? Or should I just sit down and type out all my classes with rownames? Thanks On Sep 4, 5:02 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > 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 above works okay. > > > But I'd rather be able to do something like this: > > mp = mphones(word=word, mphone=phone) > > sess.add(mp) > > > Unfortunately I couldn't make that work. > > > Here's the setup code I'm using: > > from sqlalchemy import * > > from sqlalchemy.orm import sessionmaker > > > engine = create_engine("postgres://postgres:[redacted]/mydb") > > meta = MetaData() > > meta.bind = engine > > > Session = sessionmaker(bind=engine) > > sess = Session() > > > mphones = Table('mphones', meta, autoload=True) > > Table isnt going to cut it alone; you'd have to use mappers. Read > through the ORM tutorial and you'll get a sense of how to do that. > I'd recommend using declarative_base() to set things up which is what > the tutorial uses most of the way. --~--~---------~--~----~------------~-------~--~----~ 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, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---