[sqlalchemy] map several objects at once ?

2011-11-21 Thread NiL
NiL -- 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/-/3TrJBLp82toJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from

Re: [sqlalchemy] joining to a from_statement

2011-08-12 Thread NiL
groups_recursive_parents__groups_recursive_children WHERE I tried s = select([groups.c.id, column(1)],from_obj=groups) to no better luck many thanks again NiL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit

Re: [sqlalchemy] joining to a from_statement

2011-08-12 Thread NiL
AND groups_recursive_parents__groups_recursive_children.parents_id = groups_recursive.id) ) SELECT * FROM all_parents) AS anon_1 ON anon_1.id = groups_recursive.id we have problems such as column 1 does not exists if we add groups_recursive in both FROM clauses regards Nil -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] joining to a from_statement

2011-08-12 Thread NiL
:rank_1 feels weird, it is generated by the rank + 1 in union( select([groups.c.id, rank + 1]).\ but it feels really close to the solution best NiL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit

[sqlalchemy] Re: Softcoding .filter(...)

2011-08-12 Thread NiL
).filter(field_attr.endswith(searchString)) would run HTH NiL -- 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/-/DWEguyVv4dIJ. To post to this group, send email

Re: [sqlalchemy] joining to a from_statement

2011-08-12 Thread NiL
yes, many thanks I now have a method in my Group class (still in elixir syntax) def hierarchy_ng(self): with CommonTableExpression.create( all_parents, [id, rank]) as all_parents: rank = literal_column(rank) groups = Group.table groups_assoc =

[sqlalchemy] joining to a from_statement

2011-08-11 Thread NiL
://groups.google.com/forum/?fromgroups#!topic/sqlalchemy/VAttoxkLlXw but I don't feel my question is exactly the same, as I wish to keep the rank information (only available in the text query) any enlightening idea would be very welcome thanks NiL -- You received this message because you

[sqlalchemy] strange commit behaviour

2011-06-28 Thread NiL
what am I missing here ? regards NIL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more

[sqlalchemy] Re: strange commit behaviour

2011-06-28 Thread NiL
usued. thanks for any advice NIL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options

[sqlalchemy] Re: Single Table Inheritance with same Column Name

2011-05-28 Thread NiL
Hi http://www.sqlalchemy.org/docs/06/orm/extensions/declarative.html?highlight=synonym#sqlalchemy.ext.declarative.synonym_for seems close to what you want -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: Multi-Processing Environment

2011-05-28 Thread NiL
are you using sqlite ? if so : http://groups.google.com/group/sqlalchemy/browse_thread/thread/5e08e49fa1722f91/55940423d2e6f99f?lnk=gstq=nullpool#55940423d2e6f99f http://www.sqlalchemy.org/docs/06/core/pooling.html?highlight=nullpool#switching-pool-implementations might be of help -- You

[sqlalchemy] consistency problem while using ordering_list

2011-05-27 Thread NiL
untouched unless ``reorder_on_append`` is true. This is an optimization to avoid a variety of dangerous unexpected database writes. so, my questions are : - is there a way to obtain the expected behaviour ? how? thanks NIL

[sqlalchemy] Re: Need Urgent Help -Many to Many Relations

2011-02-17 Thread NiL
http://www.sqlalchemy.org/docs/orm/extensions/associationproxy.html?highlight=association%20proxy#building-complex-views http://stackoverflow.com/questions/2310153/inserting-data-in-many-to-many-relationship-in-sqlalchemy/2310548#2310548 -- You received this message because you are subscribed

[sqlalchemy] Re: Need Urgent Help -Many to Many Relations

2011-02-17 Thread NiL
your use case is unclear, maybe you could be more specific on what you want to achieve -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] Re: Need Urgent Help -Many to Many Relations

2011-02-17 Thread nil
http://www.sqlalchemy.org/docs/orm/extensions/associationproxy.html#building-complex-views Can anybody explain how to relate three tables with a single association table. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group,

[sqlalchemy] Re: similiraty search

2011-01-30 Thread NiL
almost feel as I understand the solution, thanks to your detailed explanation. Surely your answer should finds its way to the cookbook, as maybe this will be of interest to others. Best NiL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] similiraty search

2011-01-29 Thread NiL
in this order Is it posible ? Now, I would be happy enough with an answer to this first scenario, but we could imagine that the kw themselves have values, kwA is twice the weight of kwB Of course I'm in a sqla environement regards NiL -- You received this message because you are subscribed

[sqlalchemy] counting queries

2011-01-27 Thread NiL
, evaluate the number of queries to the database. I'm aware that the debug mode will output every generated SQL, but I deal with a number of queries in the 100s range ... Is there a way to know how many SQL statement have been executed, from the python testing code ? Regards NiL -- You received

[sqlalchemy] Re: select distinct on a relation to an entity with composite primary key

2011-01-24 Thread NiL
thank you very much michael, this is some kind of mind spinning sqla expression !! -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] select distinct on a relation to an entity with composite primary key

2011-01-20 Thread NiL
KEY (id), CONSTRAINT invoice_item_item_id_item_service_id_item_item_class_fk FOREIGN KEY(item_item_id, item_service_id, item_item_class) REFERENCES item (item_id, service_id, item_class) ) How can I achieve my query ? regards NIL -- You received this message because you are subscribed

[sqlalchemy] Re: select distinct on a relation to an entity with composite primary key

2011-01-20 Thread NiL
Hi Michael, thank you very much for your prompt answer. What I want to achieve is, counting the number of distinct items, grouped by user_name Given Item1: item_id = 1 service_id = 'test' item_class = 'dummy' Item2: item_id = 2 service_id = 'other' item_class = 'dummy'

[sqlalchemy] Re: select distinct on a relation to an entity with composite primary key

2011-01-20 Thread NiL
thanks again but the unicity of Item is guaranteed by the triplet of PK I can't just discriminate the distinct() based on the item_id only (it is not unique by itself in my set of data) -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to

[sqlalchemy] Re: Passing model objects to other threads

2010-10-01 Thread NiL
Hi, have you considered using TGScheduler ? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com.

[sqlalchemy] Re: internationalization of content

2010-09-19 Thread NiL
Hi, I must admit that I discovered the test I wrote to assert my approach works for polymorphic content is wrongly True. I'm working at making it reallty work but it is not that easy. Still for non polymorphic content it is quite ok of course, it is completely elixir oriented, but I'm sure it

[sqlalchemy] Re: internationalization of content

2010-09-16 Thread NiL
Hello again, I published an updated version of acts_as_localized on http://code.google.com/p/elixirlocalized/ It is an Elixir's Entity builder that will manage several translations for DB contents If anyone cares to review or use it. NiL -- You received this message because you

[sqlalchemy] Re: internationalization of content

2010-09-14 Thread NiL
talking about the translations of templates, which is not the case. best NiL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy

[sqlalchemy] Re: internationalization of content

2010-09-14 Thread NiL
Hi Werner, many thanks for your rich reply. I'm going to try an elixir implementation for now. If you want follow the thread of the same title in the elixir mailing list. I'll stay tuned to any sqla development best NiL -- You received this message because you are subscribed to the Google

[sqlalchemy] internationalization of content

2010-09-13 Thread NiL
this ? a working solution ? willing to participate in a effort to provide a solution ? regards NiL -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email