you haven't placed a full stack trace so its impossible to see where
there error initiates, but it means that you're attempting to use the
ORM against the Users class without the mapper() function having been
called for the Users class. It means your logic within init_model()
has not been called by the time you attempt to use the ORM.
On Dec 14, 2008, at 2:11 PM, Sean Shepard wrote:
>
> Greetings. I'm working on my first Pylons project and am just trying
> to get familiar with things in a test environment. I'm having no
> success linking to the MySQL database. I have stalled out with a
> problem that I've seen others report, but didn't see any responses
> that looked relevant (I could be wrong - the world has changed in the
> decade plus since I last did much development).
>
> I saw references to mapper but I don't understand what mapper has to
> do with this. My noob understanding of mapper may not be correct.
>
> *** Environment:
> Debian Etch
> Python 2.4.4
> Pylons 0.9.6.2-1
> SQLalchemy 0.3.1-2
>
> *** Here is the last bit of the error:
>
> File '/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py', line
> 1413 in class_mapper
> raise exceptions.InvalidRequestError("Class '%s' entity name '%s'
> has no mapper associated with it" % (class_.__name__, entity_name))
> InvalidRequestError: Class 'Users' entity name 'None' has no mapper
> associated with it
>
>
> *** Here are the code examples:
> *** FROM __init__.py:
>
> import sqlalchemy as sa
> import sqlalchemy.orm as orm
>
>
> class Users(object):
> def __repr__(self):
> return "%s (%r, %r, %r, %r, %r)" % (
> self.__class__.__name__,
> self.users_username,
> self.users_password,
> self.users_email,
> self.users_date_added,
> self.users_jurisdictions,
> )
>
> def init_model(app_conf):
> global metadata, users
> if not globals().get('metadata'):
> dsn = app_conf['sqlalchemy.dburi']
> metadata = sa.BoundMetaData(dsn)
> users = sa.Table('libertyfile', metadata,
> autoload=True)
> orm.mapper(Users, users)
>
> def create_all(app_conf):
> init_model(app_conf)
> metadata.create_all()
>
>
> *** excerpts FROM hello.py (relevant portions only)
>
>
> from helloworld.model import Users
> ### = error line
>
> if request.params['submit'] == 'Submit':
> query = dbsession.query(Users) ###
> user = query.get_by(users_username=c.user_username)
> if user is None:
>
>
>
>
> Thank you for any insight or guidance that can point me in the right
> direction.
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
