Re: [sqlalchemy] Bug in mssql dialect?

2011-03-04 Thread Michael Naber
You are right. Thanks once again. On Mar 3, 2011, at 11:11, Michael Bayer mike...@zzzcomputing.com wrote: That looks certainly like a misconfigured relationship(). Not sure why SQLite would let it pass through (sqlite is in general extremely liberal), but that's clearly a literal string

Re: [sqlalchemy] Re: Unmapped Column Error

2011-03-04 Thread Michael Bayer
just an FYI its often easier to just use the actual objects in the primary/secondary join instead of the strings. the string thing is just so that order of declaration is not an issue. On Mar 3, 2011, at 8:39 PM, Doug wrote: Thanks for the tip Michael, that solved my problem! It now looks

Re: [sqlalchemy] Deadlock in iterating over a session

2011-03-04 Thread Michael Bayer
On Mar 4, 2011, at 2:58 AM, Lenza McElrath wrote: Hello! I'm iterating over a session to look at all the objects: for obj in session: do_something_cool(obj) Yesterday this caused what looks like a deadlock in SQLAlchemy code. Here is the stack I grabbed using gdb:

Re: [sqlalchemy] Deadlock in iterating over a session

2011-03-04 Thread Michael Bayer
On Mar 4, 2011, at 10:32 AM, Michael Bayer wrote: On Mar 4, 2011, at 2:58 AM, Lenza McElrath wrote: Hello! I'm iterating over a session to look at all the objects: for obj in session: do_something_cool(obj) Yesterday this caused what looks like a deadlock in SQLAlchemy code.

[sqlalchemy] In-memory sqlite database to blob?

2011-03-04 Thread thatsanicehatyouhave
Hi, I'd like to write a script that creates an in-memory SQLite database via SQLAlchemy, but when I've finished with it I'd like to upload it as a file to a server, preferably without ever creating a temporary file on the client side. Is this possible? Cheers, Demitri -- You received this

Re: [sqlalchemy] Deadlock in iterating over a session

2011-03-04 Thread Lenza McElrath
Thanks for the quick response to this as usual. See me responses below. On Fri, Mar 4, 2011 at 7:32 AM, Michael Bayer mike...@zzzcomputing.comwrote: On Mar 4, 2011, at 2:58 AM, Lenza McElrath wrote: Hello! I'm iterating over a session to look at all the objects: for obj in session:

Re: [sqlalchemy] In-memory sqlite database to blob?

2011-03-04 Thread Michael Bayer
you can ATTACH the memory database to a file and then transfer tables using insert-from-select.Don't think there's a way to go straight to a stream, though. On Mar 4, 2011, at 4:50 PM, thatsanicehatyouh...@mac.com wrote: Hi, I'd like to write a script that creates an in-memory SQLite

Re: [sqlalchemy] Deadlock in iterating over a session

2011-03-04 Thread Michael Bayer
On Mar 4, 2011, at 5:09 PM, Lenza McElrath wrote: So there is no way to accomplish this in 0.6? I was looking at doing it the way I describe above, but it is not trivial to figure out which model/session a value is attached to. And I guess it is theoretically possible that a value

Re: [sqlalchemy] In-memory sqlite database to blob?

2011-03-04 Thread A.M.
On Mar 4, 2011, at 4:50 PM, thatsanicehatyouh...@mac.com wrote: Hi, I'd like to write a script that creates an in-memory SQLite database via SQLAlchemy, but when I've finished with it I'd like to upload it as a file to a server, preferably without ever creating a temporary file on the

Re: [sqlalchemy] In-memory sqlite database to blob?

2011-03-04 Thread thatsanicehatyouhave
Thanks for the pointers. I'l probably just write it to a file initially to keep it simple! Cheers, Demitri -- 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