Hi Mike,
Am 10.06.2013, 18:38 Uhr, schrieb Michael Bayer <mike...@zzzcomputing.com>:
I'm not sure here where the pain point is for you, just how to get
access to something.execute()? Session has execute(), Engines and
Connections can be stuck onto Sessions, there's any combination you'd
want there. Anything with an execute() on it, you can send an
insert()/update() etc. into.
I've already managed to get connections and execute. Let me provide some
context:
I have some models defined for a Pyramid application:
https://bitbucket.org/charlie_x/python-httparchive/src/43bd077a2d75626fe4da5251695526d7bdd7274f/httparchive/httparchive/models.py?at=default
And some necessary but ugly housekeeping scripts:
https://bitbucket.org/charlie_x/python-httparchive/src/43bd077a2d75626fe4da5251695526d7bdd7274f/httparchive/httparchive/scripts/update.py?at=default
Currently, I get the connection and just execute the statements. But, of
course, some of won't work with both MySQL and Postgres.
I have currently naively tried
from httparchive.models import Page
pages = Page()
pages.update(…)
This fails because
"AttributeError: 'Page' object has no attribute 'update'"
How should I be doing this instead?
Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
