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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
