KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to get all rows from a table. In controller I have: meta.Session.query(User).all() The result is [, ] , but I have 2 rows in this table. I use this model for the table: import hashlib import sqlalchemy as sa from sqlalchemy import orm from allsun.model import meta t_user = sa.Table("users",meta.metadata,autoload=True) class Duplicat(Exception): pass class LoginExistsException(Exception): pass class EmailExistsException(Exception): pass And next, in the same file: class User(object): def loginExists(self): try: meta.Session .query(User) .filter(User.login==self.login) .one() except orm.exc.NoResultFound: pass else: raise LoginExistsException() def emailExists(self): try: meta .Session .query(User) .filter(User.email==self.email) .one() except orm.exc.NoResultFound: pass else: raise EmailExistsException() def save(self): meta.Session.begin() meta.Session.save(self) try: meta.Session.commit() except sa.exc.IntegrityError: raise Duplicat() orm.mapper(User, t_user)
Tags (comma-separated)
Save Edits
Cancel