Re: [sqlalchemy] Re: porting GeoAlchemy to 0.7

2011-06-14 Thread Eric Lemoine
On Thu, Jun 9, 2011 at 7:21 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 9, 2011, at 12:37 PM, Eric Lemoine wrote: On Thu, Jun 9, 2011 at 6:28 PM, Michael Bayer mike...@zzzcomputing.com wrote: That's the default adaption provided by TypeEngine.adapt().    Provide your own

[sqlalchemy] question re using the session object

2011-06-14 Thread robert rottermann
hi there, for a zope website I am using sqlalchemy. Now I am unsure how to use the session object. What I do now is: from sqlalchemy.orm import scoped_session ... Session = scoped_session(session_factory, scopefunc) session = Session() this session object I import into all classes where ever I

RE: [sqlalchemy] question re using the session object

2011-06-14 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of robert rottermann Sent: 14 June 2011 10:53 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] question re using the session object hi there, for a zope website I am using

[sqlalchemy] Classes with the same name in different namespaces.

2011-06-14 Thread Filip Zyzniewski - Tefnet
Hi, I am having a problem with declarative and inheritance from a class which has the same name, but different namespace (module): === names.py == # Fails with Python-2.7.1 and SQLAlchemy-0.7.1 # import sqlalchemy import sqlalchemy.ext.declarative Base =

Re: [sqlalchemy] Re: porting GeoAlchemy to 0.7

2011-06-14 Thread Michael Bayer
On Jun 14, 2011, at 3:17 AM, Eric Lemoine wrote: Here's our TypeEngine: So dialect-specific parameters are stored in self.kwargs. I can try to add a test to SQLAlchemy if you indicate me where this test should go. thanks, I need to add the elements of it to the user-defined types

Re: [sqlalchemy] Classes with the same name in different namespaces.

2011-06-14 Thread Michael Bayer
this is fixed in r462bd17d7ea2 however you'll want to use __mapper_args__ and not mapper_args in your classes, also the issue only exists if you didn't specify inherits yourself, so since you're already explicitly referencing the superclass you can work around easily by saying: __mapper_args__

[sqlalchemy] mapper error, and db object cannot be incremented

2011-06-14 Thread Liju
I'm new to SQLAlchemy. I wrote a method that retrieves a record, update the object after incrementing it by 1, and return that record object to the caller (pyramid view). Following is the test function. I get following errors : 1) when I call this method multiple times, I get an error that say

Re: [sqlalchemy] mapper error, and db object cannot be incremented

2011-06-14 Thread Michael Bayer
You're best starting with the declarative usage patterns described in the ORM tutorial at http://www.sqlalchemy.org/docs/orm/tutorial.html, starting with http://www.sqlalchemy.org/docs/orm/tutorial.html#creating-table-class-and-mapper-all-at-once-declaratively. I would declare the class +

[sqlalchemy] Re: mapper error, and db object cannot be incremented

2011-06-14 Thread Liju
Thank you so much Michael. By the way SQLAlchemy and Mako template are so cool. Thank you so much for all your efforts. Liju. On Jun 14, 9:38 am, Michael Bayer mike...@zzzcomputing.com wrote: You're best starting with the declarative usage patterns described in the ORM tutorial

[sqlalchemy] General questions of a newbee

2011-06-14 Thread Knack
Hi guys, I've done some programming, but I'm new to RDBMS and ORMs. I've read some documentation, but before diving in deeper and doing some tutorials, I'm trying to understand what can be done with SQLAlchemy and get a coarse understanding of how it works. Imagine some tables which are all