Re: [sqlalchemy] Connection pooling strategy for a small/fixed number of db users

2015-03-03 Thread Russ
well the engine is essentially a holder for a connection pool. If you use a pool like NullPool, it makes a new connection on every use, but in that case there is still not an official way to send in different connection parameters. There’s no advantage to trying to make Engine work in

[sqlalchemy] Unicode String Error on Insert

2015-03-03 Thread J.D.
Hi, I am getting the following error, when I try to execute code to insert a new row into one of my tables, and I've googled for answers and tried everything I could find online and nothing seems to resolve the issue. sqlalchemy.exc.ProgrammingError: (ProgrammingError) You must not use 8-bit

[sqlalchemy] Relationship behavior change when switching from reflected to declarative styles; test case included

2015-03-03 Thread Evan James
Hi folks, I'm working on a SQLAlchemy-based app where we've decided to make some infrastructure changes, in particular moving from reflection to declaration for mapping the models. However, we're now running into issues where, after switching to declarative, relationships aren't populated the

[sqlalchemy] Re: Unicode String Error on Insert

2015-03-03 Thread J.D.
My solution didn't work. I was able to get my Portuguese data to load by decoding it in ISO-8859-1, but by decoding I lose all the special characters like tildes. So I still don't understand how to get the engine to accept my data properly. J.D. On Tuesday, March 3, 2015 at 3:00:24 PM

Re: [sqlalchemy] Relationship behavior change when switching from reflected to declarative styles; test case included

2015-03-03 Thread Michael Bayer
Evan James thas...@gmail.com wrote: Hi folks, I'm working on a SQLAlchemy-based app where we've decided to make some infrastructure changes, in particular moving from reflection to declaration for mapping the models. However, we're now running into issues where, after switching to

[sqlalchemy] Re: Unicode String Error on Insert

2015-03-03 Thread J.D.
I actually figured this out. It had nothing to do with my SQLAlchemy create_engine configuration. The data I was trying to create an object with was in ISO-8859-1 format, so I just had to construct my Object the text decoded properly. Once I did this, the data was inserted into my sqlite3

[sqlalchemy] Re: Flushed PickleType data disappearing

2015-03-03 Thread SQLRook
To move one step from your sample toward my codebase, I made a class method to modify the pickled list. Already, I see behavior that I cannot explain. If the session is passed to modifyTarget(), you can observe the targetInstance become dirty, marked as modified, and then by the end of the

Re: [sqlalchemy] Unicode String Error on Insert

2015-03-03 Thread Michael Bayer
J.D. jd.cor...@pearson.com wrote: My solution didn't work. I was able to get my Portuguese data to load by decoding it in ISO-8859-1, but by decoding I lose all the special characters like tildes. So I still don't understand how to get the engine to accept my data properly. J.D.

Re: [sqlalchemy] Re: Flushed PickleType data disappearing

2015-03-03 Thread Michael Bayer
SQLRook dev...@gmail.com wrote: To move one step from your sample toward my codebase, I made a class method to modify the pickled list. Already, I see behavior that I cannot explain. If the session is passed to modifyTarget(), you can observe the targetInstance become dirty, marked as