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
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
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
: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
).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
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 =
://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
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
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
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
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
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
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
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
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,
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
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
, 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
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
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
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'
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
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.
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
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
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
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
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
28 matches
Mail list logo