On Apr 11, 2014, at 2:02 PM, Mauricio de Abreu Antunes
<[email protected]> wrote:
>
>
> My consideration here are:
>
> Why is my code translation to "FROM client_global_counter, (SELECT
> client_glogal_counter2.date" instead of just "FROM (SELECT
> client_glogal_counter2.date"?
OK when you see this pattern, "FROM x, (SELECT ... FROM .. x)", that means
you are calling upon columns directly from "x" in some cases and from the
subquery in others.
You need to make sure that your outermost SELECT always selects things in
context of the subquery, and not the things that are contained within it.
This can be illustrated with some rudimentary table objects:
from sqlalchemy.sql import select, table, column
t1 = table('t1', column('x'), column('y'))
s1 = select([t1]).alias()
s2 = select([s1.c.x, s1.c.y]) # correct
s3 = select([t1.c.x, s1.c.y]) # (typically) incorrect
print s2
# prints:
# SELECT anon_1.x, anon_1.y
# FROM (SELECT t1.x AS x, t1.y AS y
# FROM t1) AS anon_1
print s3
# prints:
# SELECT t1.x, anon_1.y
# FROM t1, (SELECT t1.x AS x, t1.y AS y
# FROM t1) AS anon_1
I didn't dig into your code but hopefully you can see where this is happening.
>
> MySQL is not recognizing some field like client_global_counter.date, hour and
> minute in the first line. Looks like my alias is not doing the right thing or
> I am doing something wrong.
define "not recognizing".
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
