Re: Enum name gets lost.

2014-02-04 Thread Michael Mulqueen
Sorry, I should have noted the versions earlier. SQLAlchemy: 0.7.4 Alembic: 0.6.3 Python: 2.7.3 Mike On Tuesday, February 4, 2014 1:56:57 PM UTC, Michael Mulqueen wrote: I'm hoping someone can help with this. My code is all built on SA's declarative base. What's happening is that from my

[sqlalchemy] SQLite: OperationalError when decoding 0x92 in TEXT column

2014-02-04 Thread Erich Blume
I am working on a binding to a SQLite database that I do not control the creation of, with the aid of reflection. I'm running in to what I believe are very basic UTF-8 decoding errors. For instance, a TEXT cell has the byte '0x92' in it and is causing an OperationalError. Presumably, this is

Re: [sqlalchemy] SQLite: OperationalError when decoding 0x92 in TEXT column

2014-02-04 Thread Erich Blume
Thanks Simon, Do you know how I might use that with reflection? There's several hundred of these columns, I'd hate to have to override each one individually - that sort of defeats the purpose of reflection. One thought I just had was perhaps I could subclass the Text type and then override the

Re: [sqlalchemy] SQLite: OperationalError when decoding 0x92 in TEXT column

2014-02-04 Thread Simon King
I've not done much with reflection, but perhaps you could use the column_reflect event: http://docs.sqlalchemy.org/en/rel_0_8/core/events.html#sqlalchemy.events.DDLEvents.column_reflect Simon On Tue, Feb 4, 2014 at 11:28 AM, Erich Blume blume.er...@gmail.com wrote: Thanks Simon, Do you

Re: [sqlalchemy] AttributeError: 'CompositeProperty' object has no attribute 'props'

2014-02-04 Thread Matt Phipps
Cool, thanks! On Mon, Feb 3, 2014 at 7:14 PM, Michael Bayer mike...@zzzcomputing.comwrote: just call configure_mappers() for now, and the need for that step has been removed in b069127b2d3f7b3f2c27f91cf, http://www.sqlalchemy.org/trac/ticket/2935. On Feb 3, 2014, at 4:12 PM, Matthew

Re: [sqlalchemy] sqlalchemy 0.9.2 + pymysql 0.6.1 + python 3.3 - traceback ?

2014-02-04 Thread Alexander Belchenko
вторник, 4 февраля 2014 г., 9:36:20 UTC+2 пользователь Alexander Belchenko написал: понедельник, 3 февраля 2014 г., 19:13:04 UTC+2 пользователь Michael Bayer написал: On Feb 3, 2014, at 10:51 AM, Alexander Belchenko alexander...@gmail.com wrote: this is a Py3k-specific issue, ticket

[sqlalchemy] How To Insert Relationship-Object Data Into DB?

2014-02-04 Thread Jude Lucien
I am using SQLAlchemy 0.9 with Python 2.7.6 and Flask. I receive form data, place it into object and add the objects to the session. When I try to do a db.commit() I get a rollback which seems to due to the relationship object in the INSERT statement. The SQL error is as follows: INFO

Re: [sqlalchemy] How To Insert Relationship-Object Data Into DB?

2014-02-04 Thread Michael Bayer
On Feb 4, 2014, at 8:20 PM, Jude Lucien jluc...@gmail.com wrote: I am using SQLAlchemy 0.9 with Python 2.7.6 and Flask. I receive form data, place it into object and add the objects to the session. When I try to do a db.commit() I get a rollback which seems to due to the relationship