Re: [sqlalchemy] column_prefix

2010-04-16 Thread jose soares
I am sorry Michael, Maybe the problem is not in the column_prefix, The thing that I don't understand in this query is why sa tries to change the primary key of this row. I changed in my form only the value of id_operator, thus I expected a query like: UPDATE anagrafica SET id_operatore=1695

[sqlalchemy] column_prefix

2010-04-15 Thread jo
Hi all, Module sqlalchemy.engine.base:*1180* in |__execute_context ||context*.*parameters*[**0**]**,* context*=*context*)*| Module sqlalchemy.engine.base:*1249* in |_cursor_execute|| self*.*_handle_dbapi_exception*(*e*,* statement*,* parameters*,* cursor*,* context*)*| Module

Re: [sqlalchemy] column_prefix

2010-04-15 Thread Michael Bayer
If you could send code examples in a readable format, that would be helpful. Here is column_prefix working as documented: from sqlalchemy import * from sqlalchemy.orm import * engine = create_engine('sqlite://', echo=True) metadata = MetaData() t = Table('foo', metadata, Column('id',

[sqlalchemy] column_prefix with synonym

2007-06-27 Thread jdu
It seems that both options don't work in common: dates = Table('dates', meta, Column('date', Date, primary_key=True) ) mapper(MyDate, dates, column_prefix='_', properties=dict( date = synonym('_date'), ) produces with 0.3.8: ArgumentError: WARNING: column 'date' not being added due to

[sqlalchemy] column_prefix()

2006-12-19 Thread Julien Cigar
Hello, I'm using SQLAlchemy 0.3.1 with Python 2.4 and PostgreSQL I have a strange problem with property(), it seems that they're not propagated to the children classes : Here is the code which fail : File A assign_mapper(session_context, taxonomy.Taxonomy, table_taxonomies,