On Sep 29, 6:14 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Andrew wrote:
This is very confusing; I have an ORM generated SQL statement that is
joining on a specific id. However, when I run it, for some reason,
the specific id (that was joined on) is occasionally None! However,
Andrew wrote:
On Sep 29, 6:14 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Andrew wrote:
This is very confusing; I have an ORM generated SQL statement that is
joining on a specific id. However, when I run it, for some reason,
the specific id (that was joined on) is occasionally
On Sep 30, 3:19 pm, Michael Bayer mike...@zzzcomputing.com wrote:
first of all, SQLA does generate (+) = if you set use_ansi=False in your
oracle create_engine, and then use outerjoin. Its obviously not a widely
used feature and I'd be curious if it holds up with all your queries (it
holds
Andrew wrote:
On Sep 30, 3:19 pm, Michael Bayer mike...@zzzcomputing.com wrote:
first of all, SQLA does generate (+) = if you set use_ansi=False in your
oracle create_engine, and then use outerjoin. Its obviously not a
widely
used feature and I'd be curious if it holds up with all your
On Sep 30, 3:46 pm, Michael Bayer mike...@zzzcomputing.com wrote:
what happens if you say:
engine.execute(myquery.statement).fetchall()
?
That worked (spaced out for readability):
[
(Decimal('468811'), ... ),
(Decimal('468810'), ... ),
(Decimal('468721'), ...) ,
...]
What does this
On Sep 30, 4:00 pm, Andrew redmu...@gmail.com wrote:
On Sep 30, 3:46 pm, Michael Bayer mike...@zzzcomputing.com wrote:
what happens if you say:
engine.execute(myquery.statement).fetchall()
?
That worked (spaced out for readability):
[
(Decimal('468811'), ... ),
Andrew wrote:
On Sep 30, 3:46 pm, Michael Bayer mike...@zzzcomputing.com wrote:
what happens if you say:
engine.execute(myquery.statement).fetchall()
?
That worked (spaced out for readability):
[
(Decimal('468811'), ... ),
(Decimal('468810'), ... ),
(Decimal('468721'), ...) ,
Andrew wrote:
I also went ahead and checked the raw output of query.all()--it worked
correctly; all the IDs were retrieved and displayed in raw format:
Decimal(###) and so on. HOWEVER, when parsing those rows using a
simple for loop, a'la
str =
for row in query.all():
On Sep 30, 4:31 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Andrew wrote:
I also went ahead and checked the raw output of query.all()--it worked
correctly; all the IDs were retrieved and displayed in raw format:
Decimal(###) and so on. HOWEVER, when parsing those rows using a
Andrew wrote:
On Sep 30, 4:31 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Andrew wrote:
I also went ahead and checked the raw output of query.all()--it worked
correctly; all the IDs were retrieved and displayed in raw format:
Decimal(###) and so on. HOWEVER, when parsing those
Andrew wrote:
This is very confusing; I have an ORM generated SQL statement that is
joining on a specific id. However, when I run it, for some reason,
the specific id (that was joined on) is occasionally None! However,
when I run the generated SQL copied from the server's debug log in
11 matches
Mail list logo