[sqlalchemy] Association Object Pattern

2009-04-08 Thread Christiaan Putter
Hi guys, I've got a question regarding the association object pattern. Though perhaps it's not what I should be using... Let's say I've got a Parent class that I'd like to add tags with data to. class Parent(Base) id = Str # The association object class Tag(Base) parent_id = Str

[sqlalchemy] Re: Generating a _BinaryExpression

2009-04-03 Thread Christiaan Putter
Hi Svil, My integration between traits and sqlalchemy is working rather well (at least it's passing the unit tests I could think of). Thanks for all your help on that. Now I'm trying to do something similar to what you did in dbcook with expressions. I'd like to construct a gui for the user

[sqlalchemy] Query Builder

2009-04-02 Thread Christiaan Putter
Hi guys, Is there a gui somewhere to allow a user to construct queries for SQLAlchemy? What would the best approach be if I make one myself? Right now I just use eval() to get some filter and order_by expressions typed in by the user, so obviously a gui would be much nicer. Regards, Christian

[sqlalchemy] Re: How does query.get() work?

2009-04-01 Thread Christiaan Putter
. Christiaan Putter wrote: Hi, Small extract from the query's _get method:         if not self._populate_existing and not refresh_state and not self._mapper_zero().always_refresh and lockmode is None:             try:                 instance = self.session.identity_map[key]                 state

[sqlalchemy] Re: Attribute expiration

2009-03-30 Thread Christiaan Putter
, Christiaan Putter ceput...@googlemail.com wrote: Hi guys, I haven't been able to figure out how to work with sessions, threads and a gui yet?  Can someone explain to me what the best practices are? The main problem really is that for displaying data on a gui I need an open session the entire

[sqlalchemy] Attribute expiration

2009-03-29 Thread Christiaan Putter
Hi guys, I haven't been able to figure out how to work with sessions, threads and a gui yet? Can someone explain to me what the best practices are? The main problem really is that for displaying data on a gui I need an open session the entire time. It seems as soon as I close a session

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-25 Thread Christiaan Putter
Hi, Right now I'm really only using multiple threads for speeding up downloads over the internet (which I need to update the data). Actually commiting the data is still done via the gui's thread session. At some point speeding up the algorithms would be nice, a concurrent solution would be

[sqlalchemy] Re: How does query.get() work?

2009-03-24 Thread Christiaan Putter
Hi, You won't be able to get() multiple objects at the same time. query(SomeClass).get(pk1, pk2, pk3) takes in a tuple of values representing the primary key of some record in your table. In this case the primary key consists of three separate columns (thus a composite key), though the record

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-23 Thread Christiaan Putter
Hi, You're quite right, the join was the tricky bit at first. Basically I construct an outer join over all the 'dynamic' extension classes. Here's an extract: def _get_selectable(self): j = None for key, val in HasTraitsORM._decl_class_registry.iteritems(): if

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-22 Thread Christiaan Putter
and watch what goes on behind and how SA-activities intertwist with traits' /your ones. ciao svilen On Sunday 22 March 2009 04:00:27 Christiaan Putter wrote: Hi svilen, Thanks for your advice, going through your code helped a lot in understanding how SA works. I've gotten traited classes

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-22 Thread Christiaan Putter
that having several copies of essentially the same data is not a good idea perhaps and should be treated with care. Some thoughts from anyone perhaps? Y'all have a great week, Christian 2009/3/22 Christiaan Putter ceput...@googlemail.com: Hi Svilen, Setting up tests is a very good idea, I'll start

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-22 Thread Christiaan Putter
Hi, Maybe some better explanation is required from my side for you to be able to help me better. My app is basically for doing some plotting, analysis and filtering of securities on the stock market. The main class that does most of the work is Security(HasTraitsORM), where HasTraitsORM is my

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-03-21 Thread Christiaan Putter
Hi svilen, Thanks for your advice, going through your code helped a lot in understanding how SA works. I've gotten traited classes to behave like classes generated by SA's declarative extension. After a lot of stepping through code I realised the main problem was that SA removes values from an

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-02-07 Thread Christiaan Putter
Hi Michael, Thanks for your swift reply. I wasn't really sure which way to go with combining Traits and SA. From reading through the source it seemed that I had to use InstrumentationManager, I think it said somewhere it was the stable public interface. I had a look at the Trellis source as

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-02-07 Thread Christiaan Putter
Hi, uh thats a little weird since the InstrumentationManager is designed to be the thing you subclass. you're not supposed to subclass ClassManager. There should be no difference in behavior subclassing one or the other. It behaves a little weird to when I tried it myself. I'll stick

[sqlalchemy] Re: Declarative with Enthoughts Traits framework.

2009-02-07 Thread Christiaan Putter
Thanks for the link. That's where I figured out most of what I'm trying to do. Now that I've stepped through the code I noticed that 'install_state' is only being called on the first 2 iterations of the loop. Haven't found out yet why that is. What exactly is supposed to be in the state? Is