On Nov 1, 3:13 pm, Matthew Newhook [EMAIL PROTECTED] wrote:
I posted this message in the pylons group but as of yet have received
no response.
I saw it there and followed here. And subscribed while I'm at it - I'm
playing with SQLAlchemy myself recently.
On Nov 2, 2007, at 12:41 AM, Bruza wrote:
I am quite baffled by the deferred loading behavior on a class
member in the following code (see below). Looks like if I create an
object (t1) with some field (c2) having None as value, then after I
save, commit, and closed the object in a
I've posted a synopsis of this on the earlier referenced pylons thread
to see what those guys have to say.
I don't think this is really an AJAX specific problem - although the
asynchronous nature of AJAX means its more likely to occur. It seems
to me that any http request can arrive concurrently
On Nov 2, 2007, at 7:48 AM, Matthew Newhook wrote:
Sorry for the continuing post spam... However, I think I know what is
causing this problem. What tipped me off is I am seeing multiple
copies of the same item in my shopping cart if I really hammer at the
add cart button (instead of a
I am getting the following exception, but I can't figure out what I
specified incorrectly. I have other relations setup which work fine.
Appreciate if someone can put me right.
File c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\properties.py,
line 402, in
Thanks for the response. I duplicated the original problem with the
following test:
$ cat /f/t.py
import sqlite3
c1 = sqlite3.connect(db, timeout=5.0)
try:
c1.execute(create table person(lastname, firstname))
c1.execute(insert into person values('newhook', 'matthew'))
c1.commit()
Thanks, but this doesn't seem to do what I wanted. The merge modifies
the object and therefore tries to update the underlying table on
session.flush(). So it might work if you prevented the save also. (In
my case, the update is not only a waste, it even fails because the
table is
On Nov 2, 11:55 pm, Michael Bayer [EMAIL PROTECTED] wrote:
I'd have to disagree here; SQLAlchemy is a database access library,
its not a caching or application framework. Providing a thread-
synrchronized caching container would be the job for Pylons or some
other third party software (or
I took your advice and duplicate the problem in a small python test
app. Changing the isolation_level to immediate seems to help the
problem, which is good!
task.mapper.save_obj(task.polymorphic_tosave_objects, trans)
Module sqlalchemy.orm.mapper:1201 in save_obj
... some variables ...
rec
I don't think that two dicts would be that out of hand, for an average
schema, say 50 tables x 10 cols, with 8-16 bytes each for each dict
(how big is an empty dict anyway?), you'd be looking at 50 * ((10*2) + 1) *
16 = about 16.8K of memory. Not that big of a deal.
But you're right, you don't
Migrate, the SQLALchemy migration tool has a new home and a new name.
You can find the new improved sqlalchemy-migrate at:
http://code.google.com/p/sqlalchemy-migrate/
Jan Dittberner and dykang have done the nessisary work to get migrate
back into a functional state for SQLAlchemy 0.3.10, and
Please have a look at the attached testcase that mixes single-table
polymorphic inheritance, primaryjoin overides on the relation() and a
secondary table.
SA seems to add a WHERE clause to filter for the polymorphic type on
relations that it calculates, but forgets to add it for the test case. Is
On 11/1/07, Michael Bayer [EMAIL PROTECTED] wrote:
what happens if you autoload like the above, and then just say
t_incident.join(t_entry) ? it likely breaks. then, what happens if
you define t_entry before t_incident ?
Well, today it's working, or at least at this momement. But I did
Thanks for the reply. And you are right, column c2 has a default value
defined on it.
So, how do l configure SA to not automatically mark c2 as
deferred? Sounds
like the latest trunk has a different implementation of this. Short of
getting the
latest 0.4.1, is there a way I can configure my
the latest trunk does the same thing; it just wont try loading the
column when you assign to it. workaround here is to either not remove
your object from the session, ensure its in a session when you work
with it, or just force a load of c2 after a flush.
On Nov 2, 7:30 pm, Bruza [EMAIL
you need to have None for the tables in all the subclass mappers
(SecUser, SecRole, SecFilter, etc.) . this is one of those cases
where SQLAlchemy should really be raising some kind of error, im
surprised its trying to chug along with that (also that its not trying
to make some bizarre
16 matches
Mail list logo