Hmm maybe I'm missing something. Perhaps someone else can jump in,
and show me what I'm missing?
When I take your code, and execute the following 5 cases:
CASE A: no 'subquery' on relationship, 'subqueryload' on query
CASE B: 'subquery' on relationship, no 'subqueryload' on query
Morning Martin:
I could be wrong, but I think what you're looking for is lazy='joined'
rather than lazy='subquery'.
When I change the following, I see one query per showDatabase() call
rather than two.
class Men(Human):
myChildren = relationship('Child', secondary=link_table,
Hi John:
The following import is causing that error.
from sqlalchemy.orm import session, Session
In the all-in-one example you provided, you later go on to reassign
'session' and 'Session', replacing those imported values with your own
values.
Session =
[hmmm, let's try that again... not sure why gmail mangled my email]
Hi John:
The following import is causing that error.
from sqlalchemy.orm import session, Session
In the all-in-one example you provided, you later go on to reassign
'session' and 'Session', replacing those imported values
Any ideas why I'm getting one row back with an id of 5 when I filtered
by id IS NULL?
[SQLAlchemy-0.6.4, MySQL 5, MyISAM]
sqlalchemy.engine.base.Engine.0x...eb2c: INFO: SELECT user.id AS
user_id, user.username AS user_username, user.level AS user_level
FROM user
WHERE user.level = %s AND
26, 2010 at 11:27 PM, Michael Bayer
mike...@zzzcomputing.com wrote:
yeah you'd have to search around MySQL's bugtracker for that one, I've seen
it before, the only record I can find at the moment is #4 here:
http://sql-info.de/mysql/gotchas.html#1_1
On Oct 26, 2010, at 11:16 PM, Diana
Hi Chris:
I'm a bit hesitant to share what I've done, b/c it's still a work in
progress etc, but here goes:
MySQL MyISAM, wait_timeout=28800
SQLAlchemy 0.5.6, pool_recycle=3600
I've written a few decorators (mostly stolen from SQLAlchemy docs
examples):
def with_query_write(fn):
Yup, no transactions (legacy, can't switch anytime soon) which is why
I didn't originally write any rollback framing... but I was still
getting the following error after MySQL raised a 2006 (until app
restart), and a quick peek at _handle_dbapi_exception seemed to
suggest that I needed to issue
Yes, Congratulations Thank-you!
--diana
On Sun, Apr 18, 2010 at 8:02 PM, Michael Bayer mike...@zzzcomputing.com wrote:
The first official 0.6 release of SQLAlchemy is now available.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to
Thanks for the quick response, Michael.
We are mapping the classes dynamically, and we patched an in-house
copy of SQLAlchemy 0.5.6 with the stricter mutex from SQLAlchemy 0.6
to fix the sporadic mappers failed to compile errors we were seeing
under production load.
We also added a Least
A, deferred (new to me), thanks!
in sqlalchemy/test/orm/sharding/test_shard.py:
mapper(WeatherLocation, weather_locations, properties={
'reports':relation(Report, backref='location'),
'city': deferred(weather_locations.c.city),
})
When I comment
? Is there some way I
can optimize this case, perhaps by setting the shard_id somewhere, so
that 4 queries aren't executed in this case?
Thanks,
--diana
On Mon, Jan 11, 2010 at 3:38 PM, Diana Clarke
diana.joan.cla...@gmail.com wrote:
Question #2 similar, but w/ session.add(). I'll send a new email
Thanks, Michael.
This will take me a bit to digest, and I'm about to start the second
shift as wife and mother... tomorrow maybe.
Thanks again for the quick responses -- greatly exceeding expectations!
Cheers,
--diana
On Mon, Jan 11, 2010 at 5:14 PM, Michael Bayer mike...@zzzcomputing.com
On Mon, Jan 11, 2010 at 7:07 PM, Antoine Pitrou solip...@pitrou.net wrote:
Le lundi 11 janvier 2010 à 15:55 -0800, diana a écrit :
Well if you only want to count entries, use Query.count(), not
Query.all().
Yup, I don't actually do this in a real app. I was just doing this (in
a hello world
patterns, so I'm very confident that
there's no issues within SQLA itself.
On Jan 11, 2010, at 7:17 PM, Diana Clarke wrote:
On Mon, Jan 11, 2010 at 7:07 PM, Antoine Pitrou solip...@pitrou.net wrote:
Le lundi 11 janvier 2010 à 15:55 -0800, diana a écrit :
Well if you only want to count entries
15 matches
Mail list logo