[sqlalchemy] Re: sharding id_chooser query_chooser

2008-07-03 Thread lilo
For example, you have user, post, comment table. Sharding is done by user_id and shard_lookup is done via lookup table. If one is going to create a post, you would lookup the user_id in the lookup table and insert the post entry into the shard where the user_id belongs to. How would you translat

[sqlalchemy] Re: sharding id_chooser query_chooser

2008-06-27 Thread King Simon-NFHD78
Lilo wrote: > > My understanding of this query_chooser is that it's used when you want > to execute orm's sql rather than raw sql. > > I don't quite understand what is visit_binary function do from > attribute_shard.py example. What does it mean binary.operator, > binary.left, binary.right.clau

[sqlalchemy] Re: sharding id_chooser query_chooser

2008-06-26 Thread lilo
My understanding of this query_chooser is that it's used when you want to execute orm's sql rather than raw sql. I don't quite understand what is visit_binary function do from attribute_shard.py example. What does it mean binary.operator, binary.left, binary.right.clause and query._criterion? T

[sqlalchemy] Re: sharding id_chooser query_chooser

2008-06-25 Thread Michael Bayer
On Jun 25, 2008, at 6:30 PM, lilo wrote: > > I am trying to understand what id_chooser and query_chooser do. > Id_chooser basically uses a instance primary key to determine what > shard the intance should be saved to? id_chooser receives a primary key identifier, and then returns a list of sh