primary_key argument to mapper is a list
primary_key=[my_column, my_other_column, ..]
clearly this is a bug: http://www.sqlalchemy.org/docs/orm/mapper_config.html#,
ill change that now
I'll see if I can add a scalar->list adapter in 0.7 for that arg
On Nov 16, 2010, at 4:53 PM, Royce wrote:
> Using version 0.6.5 under python 2.6.5 even simple augments to
> __mapper_args__ variable course errors
>
> E.g.
> from sqlalchemy import *
> from sqlalchemy.dialects.mysql import *
> from sqlalchemy.ext.declarative import declarative_base
>
> Base = declarative_base()
>
> class CourseAliases(Base):
> __tablename__ = 'CourseAliases'
>
> alias = Column(CHAR(length=7), nullable=False)
> year = Column(INTEGER())
> course_stream_id = Column(INTEGER(), nullable=False)
> auto_gen = Column(CHAR(length=1), nullable=False)
>
> __mapper_args__ = {
> 'primary_key': course_stream_id
> }
>
>
> If I try to import it the resultant errors are
>
> from tables import CourseAliases2
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "tables/CourseAliases2.py", line 7, in <module>
> class CourseAliases(Base):
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/ext/declarative.py", line 1231, in __init__
> _as_declarative(cls, classname, cls.__dict__)
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/ext/declarative.py", line 1224, in
> _as_declarative
> **mapper_args)
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/orm/__init__.py", line 861, in mapper
> return Mapper(class_, local_table, *args, **params)
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/orm/mapper.py", line 217, in __init__
> self._configure_pks()
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/orm/mapper.py", line 481, in _configure_pks
> if self.primary_key_argument:
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/sql/expression.py", line 1423, in __nonzero__
> raise TypeError("Boolean value of this clause is not defined")
> TypeError: Boolean value of this clause is not defined
>
> I know I can add the primary_key=True to a Column but what I actually
> wanted to do is make a multiple column primary key
>
> E.g
> __mapper_args__ = {
> 'primary_key': [course_stream_id,alias]
> }
>
> this produces a different error.
>
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "tables/CourseAliases2.py", line 7, in <module>
> class CourseAliases(Base):
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/ext/declarative.py", line 1231, in __init__
> _as_declarative(cls, classname, cls.__dict__)
> File "/usr/pkg/lib/python2.6/site-packages/SQLAlchemy-0.6.5-
> py2.6.egg/sqlalchemy/ext/declarative.py", line 1048, in
> _as_declarative
> mapper_args[k] = column_copies.get(v,v)
> TypeError: Error when calling the metaclass bases
> unhashable type: 'list'
>
> What am I doing wrong ? I am fairly sure I am only doing what the
> documentation says.
>
> Thanks for any help
> Royce
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
