[sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread AlexVhr
Hi all. I need to find out if a certain class has one-to-many relations to other classes, and what exactly this classes are. Something like this: *class* *Parent*(Base): __tablename__ = 'parent' id = Column(Integer, primary_key=True) children = relationship(Child) *class*

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread Juan Hernandez
I'm not sure I get your question... if you have this already children = relationship(Child) what is it that you need to know?? By using MyClass.children you'll have access to it's children and they will be, one2many relationships On Wed, Dec 12, 2012 at 4:57 AM, AlexVhr viho...@gmail.com

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread AlexVhr
I have this allready at compile-time. But at run-time I will have to deal with instances of different classes dinamically. So I need to inspect the instances to find out if they are linked to others or not, and what is that they are linked to. Something like this: *def

[sqlalchemy] How to identify that an InstrumentedAttribute or its ColumnProperty are read-only?

2012-12-12 Thread Peter Bunyan
Much like FormAlchemy, I am trying to update my model from a post in a generic manner. I'd like to find out if an Attribute(InstrumentedAttribute) or its associated ColumnProperty is read-only. (please excuse ridiculous example) class Foo(Base): id = Column(Integer, primary_key=True)

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread Michael Bayer
On Dec 12, 2012, at 4:27 AM, AlexVhr wrote: Hi all. I need to find out if a certain class has one-to-many relations to other classes, and what exactly this classes are. Something like this: I'm kind of half way there: def findRelatedClasses(cls): #iterate cls.__dict__, find a class

Re: [sqlalchemy] How to identify that an InstrumentedAttribute or its ColumnProperty are read-only?

2012-12-12 Thread Michael Bayer
On Dec 12, 2012, at 10:07 AM, Peter Bunyan wrote: Much like FormAlchemy, I am trying to update my model from a post in a generic manner. I'd like to find out if an Attribute(InstrumentedAttribute) or its associated ColumnProperty is read-only. (please excuse ridiculous example) class

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread AlexVhr
Thanks a lot, it works perfectly. On a matter of using 0.8 - is it allready stable enough to switch to? (My projects are nothing critical, but still...) On Wednesday, December 12, 2012 6:11:55 PM UTC+2, Michael Bayer wrote: On Dec 12, 2012, at 4:27 AM, AlexVhr wrote: Hi all. I need to find

Re: [sqlalchemy] How to identify that an InstrumentedAttribute or its ColumnProperty are read-only?

2012-12-12 Thread Peter Bunyan
Thank you so much. Wonderful! -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/wcjW6WJRVccJ. To post to this group, send email to sqlalchemy@googlegroups.com. To

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread Michael Bayer
yeah 0.8 is fine, was almost ready to put 0.8.0b2 and then final the other day, just little things coming in On Dec 12, 2012, at 11:27 AM, AlexVhr wrote: Thanks a lot, it works perfectly. On a matter of using 0.8 - is it allready stable enough to switch to? (My projects are nothing

Re: [sqlalchemy] How to find one-to-many relations of a class?

2012-12-12 Thread AlexVhr
Glad to hear it, I'll give it a try. On Wednesday, December 12, 2012 7:10:49 PM UTC+2, Michael Bayer wrote: yeah 0.8 is fine, was almost ready to put 0.8.0b2 and then final the other day, just little things coming in On Dec 12, 2012, at 11:27 AM, AlexVhr wrote: Thanks a lot, it works

[sqlalchemy] Why I couldn't find my module (alembic autogenerate)?

2012-12-12 Thread junepeach
I installed alembic tool in 3 of my computers. 2 of them finally worked fine, but this one doesn't work with the same configuration. I tried both of below code in env.py: 1) import os, sys sys.path.append(os.getcwd()) from dbmodule import SAINT8 target_metadata = SAINT8.Base.metadata 2) I

Re: [sqlalchemy] Re: Is it possible for alembic or other migration tool to handle case sensitivity or insensitivity across database engines

2012-12-12 Thread junepeach
Sorry, I haven't touched that issue recently. Where I should turn on 'echo=true', in module or migration script? I saw 'create_engine' has this, but I didn't directly use 'create_engine'. SHOW CREATE TABLE gave something back to me: utf8_general_ci is default collation rule in charset utf8.

Re: [sqlalchemy] Re: Is it possible for alembic or other migration tool to handle case sensitivity or insensitivity across database engines

2012-12-12 Thread junepeach
Please ignore it, actually you are right, when I changed to collation 'utf8_unicode_ci', it works perfectly fine. Thanks a lot! -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit

[sqlalchemy] Performance degradation after few hours running

2012-12-12 Thread Jaimy Azle
Previously, I use SQLA 0.7.2 on Jython for production and it works great for almost one year deployment until recently I manage to upgrade to 0.7.8. With this new version, I noticed a constant performance degradation mostly after serveral hours running, eventually overall system become almost