Hi Michael,
On Mon, 2011-08-01 at 14:18 -0400, Michael Bayer wrote:
The Session's default behavior is to expire fully the state present after a
rollback occurs. The next access of any attribute will guaranteed pull
fresh from the DB in a new transaction.
I'm assuming you know this,
Sorry Michael,
there was a typo in my code, due to some wrong copy/paste or search/replace
I guess, I'm afraid.
The error I reported comes up mapping to `TransmLimit` and not `SurfaceRes`
(which is the one already mapped above).
I edited the pastebin:
http://pastebin.com/mjfgPrcB
now with:
In my controller class, I perform a rather basic, straightforward SQL
query:
connection = engine.connect()
trans = connection.begin()
try:
c.result = connection.execute(select
current_disposition_code,count(*) as num from cms_input_file group by
On Tue, Aug 2, 2011 at 3:07 PM, RVince rvinc...@gmail.com wrote:
In my controller class, I perform a rather basic, straightforward SQL
query:
connection = engine.connect()
trans = connection.begin()
try:
c.result = connection.execute(select
Tamas,
I'm more confused now -- would I do this in my controller or in the
mako file? If, in my controller, dont I need to create an array for
each field, that is:
i = 0
for row in c.result
c.current_disposition_code[i] = row['current_disposition_code']
c.num[i] = row['num']
i = i +
On Aug 2, 2011, at 3:33 AM, Torsten Landschoff wrote:
I looked at the is_active flag in SQLAlchemy 0.6.8 already and I think I
can only use it with autocommit disabled. Unfortunately I use
autocommit=True.
if you're in autocommit=True and you're calling session.flush() which fails, it
On Aug 2, 2011, at 9:07 AM, RVince wrote:
In my controller class, I perform a rather basic, straightforward SQL
query:
connection = engine.connect()
connection, OK
trans = connection.begin()
start a transaction, OK
try:
c.result =
Michael,
Right, thats a better idea -- I am working with snippets of other
people's code here. However, I still have the original problem of
going from a ResultProxy object to output in a mako file which is a
chasm I cannnot seem to bridge! RVInce
On Aug 2, 10:06 am, Michael Bayer
On Aug 2, 2011, at 11:31 AM, RVince wrote:
Michael,
Right, thats a better idea -- I am working with snippets of other
people's code here. However, I still have the original problem of
going from a ResultProxy object to output in a mako file which is a
chasm I cannnot seem to bridge!
Michael,
But if I do the following, and do NOT close it (at least, I dont
believe I am now):
result = engine.execute(select
current_disposition_code,count(*) as num from cms_input_file group by
current_disposition_code;)
c.curent_disposition_codes = []
c.num = []
Thank you for all the effort you put in.
SQLAlchemy has been a proven tool for me and as it seems for many others.
On Aug 1, 2011, at 02:17 , Michael Bayer wrote:
SQLAlchemy version 0.7.2 is now available.
A lot has been going on leading up to this release, and there was actually a
On Aug 2, 2011, at 12:09 PM, RVince wrote:
Michael,
But if I do the following, and do NOT close it (at least, I dont
believe I am now):
result = engine.execute(select
current_disposition_code,count(*) as num from cms_input_file group by
current_disposition_code;)
I'd just like to echo Martin's statement, thank you very much. Just your
responses to this list seem like a full time job, let alone the
development to SQLAlchemy - which continues to surprise and impress me
with it's features and support.
James.
On 08/02/2011 09:28 AM, Martijn Moeling
LOL,I'm going backwards here, and taking far too long to get something
so very simple done (there's a genuine lack of documentation here I
think -- the only way to manage to learn much of this is by trial and
error). Rather than trying to do this with straight SQL statements I
will go plan B here
Thanks so much for the help. For the record, setting an __init__ argument on
the association argument did the trick.
Ben
On 2 Aug 2011, at 01:47, Michael Bayer mike...@zzzcomputing.com wrote:
On Aug 1, 2011, at 8:34 PM, somewhatofftheway wrote:
Hi,
I'm trying to convert a
Yes I'm using PostgreSQL and now that you've linked to the docs, I
remember there was a possibility for recursion. Thanks for suggestion,
I'll look into it.
.oO V Oo.
On 08/02/2011 03:41 AM, Gunnlaugur Briem wrote:
You could look for recursive CTE (Common Table Expressions), if your
I'm trying to follow the instructions in the SA docs regarding Unicode and
SQLite. I've declared all my character fields as either Unicode or
UnicodeText. When populating the data, I specify strings as unicode strings
(u'string'), but I'm still getting an warning: SAWarning Unicode type
On Aug 2, 2011, at 6:35 PM, Mark Erbaugh wrote:
I'm trying to follow the instructions in the SA docs regarding Unicode and
SQLite. I've declared all my character fields as either Unicode or
UnicodeText. When populating the data, I specify strings as unicode strings
(u'string'), but I'm
Hi All,
Just me or does this:
http://www.sqlalchemy.org/docs/core/engines.html?highlight=logging#configuring-logging
...imply that to get pool logging you just need to do:
import logging
logging.getLogger('sqlalchemy.pool').setLevel(logging.DEBUG)
Whereas, in fact, you need to do:
import
On Aug 2, 2011, at 6:50 PM, Michael Bayer wrote:
On Aug 2, 2011, at 6:35 PM, Mark Erbaugh wrote:
I'm trying to follow the instructions in the SA docs regarding Unicode and
SQLite. I've declared all my character fields as either Unicode or
UnicodeText. When populating the data, I
On Aug 2, 2011, at 7:13 PM, Chris Withers wrote:
Hi All,
Just me or does this:
http://www.sqlalchemy.org/docs/core/engines.html?highlight=logging#configuring-logging
...imply that to get pool logging you just need to do:
import logging
21 matches
Mail list logo