[sqlalchemy] Re: Many-To-One...What I'm doing wrong?
That works. Thank's a lot.
Marcos.
I will continue asking. Soon...
On Dec 14, 7:20 pm, [EMAIL PROTECTED] wrote:
your 'iva' table-column AND 'iva' attribute/relation/property have same
name, Thats what the error says. either rename one of them (e.g. the column
to become iva_id), or use that allow_column_override=True flag to the
producto mapper.
Marcos wrote:
Hello, first at all, sorry about my english... I'm from Mendoza,
Argentina, and I'm starting with this. Because I can't describe my
problem, I will show the next:
from sqlalchemy import *
from sqlalchemy.orm import *
class Producto(object):
pass
class Iva(object):
pass
metadata = MetaData()
engine = create_engine('postgres://postgres:[EMAIL PROTECTED]:5432/
marcos')
connection = engine.connect()
Session = sessionmaker(bind=connection, autoflush=True,
transactional=True)
session = Session()
iva_tabla = Table( 'iva' , metadata ,
Column('id' , Integer , primary_key =
True) ,
Column('valor', Float)
)
productos_tabla = Table ( 'productos' , metadata ,
Column('id', Integer ,
primary_key = True ) ,
Column('nro' , Integer ) ,
Column('descripcion' ,
String(100) ) ,
Column('iva' , Integer ,
ForeignKey('iva.id')) ,
Column('precioUnitario' ,
Float )
)
mapper(Producto, productos_tabla , properties={'iva':relation(Iva)})
mapper(Iva,iva_tabla)
- And when i run it:
raceback (most recent call last):
File /home/instancia_webware/MyContext/Pruebas/sql.py, line 29,
in ?
mapper(Producto, productos_tabla ,
properties={'iva':relation(Iva)})
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/__init__.py, line 518, in mapper
return Mapper(class_, local_table, *args, **params)
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 154, in __init__
self._compile_properties()
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 612, in _compile_properties
self._compile_property(column_key, column, init=False,
setparent=True)
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 654, in _compile_property
raise exceptions.ArgumentError(WARNING: column '%s' not being
added due to property '%s'. Specify 'allow_column_override=True' to
mapper() to ignore this condition. % (column.key, repr(prop)))
sqlalchemy.exceptions.ArgumentError: WARNING: column 'iva' not being
added due to property 'sqlalchemy.orm.properties.PropertyLoader
object at 0xb7aba1cc'. Specify 'allow_column_override=True' to
mapper() to ignore this condition.
--
I've read a lot, and I can't or I'm incapable to resolve this by
myself. Can anybody help me?
Sorry again, Marcos
--~--~-~--~~~---~--~~
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 group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: Many-To-One...What I'm doing wrong?
your 'iva' table-column AND 'iva' attribute/relation/property have same
name, Thats what the error says. either rename one of them (e.g. the column
to become iva_id), or use that allow_column_override=True flag to the
producto mapper.
Marcos wrote:
Hello, first at all, sorry about my english... I'm from Mendoza,
Argentina, and I'm starting with this. Because I can't describe my
problem, I will show the next:
from sqlalchemy import *
from sqlalchemy.orm import *
class Producto(object):
pass
class Iva(object):
pass
metadata = MetaData()
engine = create_engine('postgres://postgres:[EMAIL PROTECTED]:5432/
marcos')
connection = engine.connect()
Session = sessionmaker(bind=connection, autoflush=True,
transactional=True)
session = Session()
iva_tabla = Table( 'iva' , metadata ,
Column('id' , Integer , primary_key =
True) ,
Column('valor', Float)
)
productos_tabla = Table ( 'productos' , metadata ,
Column('id', Integer ,
primary_key = True ) ,
Column('nro' , Integer ) ,
Column('descripcion' ,
String(100) ) ,
Column('iva' , Integer ,
ForeignKey('iva.id')) ,
Column('precioUnitario' ,
Float )
)
mapper(Producto, productos_tabla , properties={'iva':relation(Iva)})
mapper(Iva,iva_tabla)
- And when i run it:
raceback (most recent call last):
File /home/instancia_webware/MyContext/Pruebas/sql.py, line 29,
in ?
mapper(Producto, productos_tabla ,
properties={'iva':relation(Iva)})
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/__init__.py, line 518, in mapper
return Mapper(class_, local_table, *args, **params)
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 154, in __init__
self._compile_properties()
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 612, in _compile_properties
self._compile_property(column_key, column, init=False,
setparent=True)
File /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.1-py2.4.egg/
sqlalchemy/orm/mapper.py, line 654, in _compile_property
raise exceptions.ArgumentError(WARNING: column '%s' not being
added due to property '%s'. Specify 'allow_column_override=True' to
mapper() to ignore this condition. % (column.key, repr(prop)))
sqlalchemy.exceptions.ArgumentError: WARNING: column 'iva' not being
added due to property 'sqlalchemy.orm.properties.PropertyLoader
object at 0xb7aba1cc'. Specify 'allow_column_override=True' to
mapper() to ignore this condition.
--
I've read a lot, and I can't or I'm incapable to resolve this by
myself. Can anybody help me?
Sorry again, Marcos
--~--~-~--~~~---~--~~
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 group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
