Yes, Is there a way to get to that chapter? Thanks,
Sam. On Jul 4, 9:30 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Jul 4, 10:22 pm, SamDonaldson <[EMAIL PROTECTED]> wrote: > > > I want to use MetaData() to return an object passed in it is the db > > uri. I want the connection object returned back to me from the meta. > > > meta = MetaData(db_uri) > > > #getting the connection object > > conn = meta.connect <-- is this correct > > > Now, I want to start a transaction and then commit or rollback upon > > exception using the connection object versus using > > session.create_transaction. > > no, its not correct. first, read this paragraph: > > http://www.sqlalchemy.org/docs/tutorial.html#tutorial_twoinone > > and then, read this page: > > http://www.sqlalchemy.org/docs/dbengine.html > > that should answer everything youve asked thus far. then youll > probably want to read these: > > http://www.sqlalchemy.org/docs/metadata.htmlhttp://www.sqlalchemy.org/docs/sqlconstruction.html > > and then that is it. do *not* read anything about data mapping, > sessions, or units of work. ignore all the various tutorials on pylons > and TG that are all ORM-centric. you do not need to use anything from > sqlalchemy.orm. > > as yet another alternative, if you want *strictly* just a connection > pool, and *absolutely nothing else* except regular old DBAPI, you can > also read this: > > http://www.sqlalchemy.org/docs/pooling.html > > If that appeals to you, i.e. using totally straight DBAPI, learn about > that style of programming via the PEP: > > http://www.python.org/dev/peps/pep-0249/ > > > I wanted an in-depth understanding of what goes on in connection > > management in sqlalchemy. I want to use sqlalchemy for it's > > connection management but I'm planning on building my own custom orm. > > if you like, I can hook you up with chapter 6 of the SA book, the only > chapter ive written so far, which is quite in depth about connection > management. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---