Error: UnmappedInstanceError: Class '__builtin__.int' is not mapped

[phasma]

Traceback:

URL: http://localhost:5000/manage/new?name=test&weight=150&price=1&date=2009-06-23
File '/usr/lib/pymodules/python2.5/weberror/evalexception.py', line
431 in respond
app_iter = self.application(environ, detect_start_response)
File '/usr/lib/pymodules/python2.5/beaker/middleware.py', line 81 in
__call__
return self.app(environ, start_response)
File '/usr/lib/pymodules/python2.5/beaker/middleware.py', line 160 in
__call__
return self.wrap_app(environ, session_start_response)
File '/usr/lib/pymodules/python2.5/routes/middleware.py', line 130 in
__call__
response = self.app(environ, start_response)
File '/usr/lib/pymodules/python2.5/pylons/wsgiapp.py', line 125 in
__call__
response = self.dispatch(controller, environ, start_response)
File '/usr/lib/pymodules/python2.5/pylons/wsgiapp.py', line 324 in
dispatch
return controller(environ, start_response)
File '/var/www/food/food/food/lib/base.py', line 18 in __call__
return WSGIController.__call__(self, environ, start_response)
File '/usr/lib/pymodules/python2.5/pylons/controllers/core.py', line
221 in __call__
response = self._dispatch_call()
File '/usr/lib/pymodules/python2.5/pylons/controllers/core.py', line
172 in _dispatch_call
response = self._inspect_call(func)
File '/usr/lib/pymodules/python2.5/pylons/controllers/core.py', line
107 in _inspect_call
result = self._perform_call(func, args)
File '/usr/lib/pymodules/python2.5/pylons/controllers/core.py', line
60 in _perform_call
return func(**args)
File '/var/www/food/food/food/controllers/ui.py', line 49 in new
meta.Session.add(price)
File '/usr/lib/pymodules/python2.5/sqlalchemy/orm/scoping.py', line
121 in do
return getattr(self.registry(), name)(*args, **kwargs)
File '/usr/lib/pymodules/python2.5/sqlalchemy/orm/session.py', line
1088 in add
state = _state_for_unknown_persistence_instance(instance)
File '/usr/lib/pymodules/python2.5/sqlalchemy/orm/session.py', line
1580 in _state_for_unknown_persistence_instance
raise exc.UnmappedInstanceError(instance)
UnmappedInstanceError: Class '__builtin__.int' is not mapped

controller:

item = model.Price()
item.name=name
item.weight=weight
item.price=price
item.date=date
meta.Session.add(price)
meta.Session.commit()

model:

class Price(object):
pass

table_price = sa.Table('price', meta.metadata,
sa.Column('id', sa.types.Integer,
primary_key=True, autoincrement=True),
sa.Column('date', sa.types.DateTime
(timezone=False)),
sa.Column('name', sa.types.String(45)),
sa.Column('width', sa.types.String(45)),
sa.Column('price', sa.types.Integer),
)

orm.mapper(Price, table_price)

What's wrong ?

[Stephen Emslie]

Looks like your problem is here:

On Tue, Jun 23, 2009 at 4:21 PM, phasma<xpa...@gmail.com> wrote:
...

>        item = model.Price()
>        item.name=name
>        item.weight=weight
>        item.price=price
>        item.date=date
>        meta.Session.add(price)

You've added price (the integer) to the session instead of item (the
instance of Price).

Stephen Emslie