Python Session.query方法代码示例

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_04_cascade_delete(self):
     """ Test for cascade delete between `VoluntaryMember` and `Person` models."""
     v_member = Session.query(model.VoluntaryMember).filter_by().first()
     Session.delete(v_member)
     Session.commit()
     person = Session.query(model.Person).filter_by(person_id=v_member.person_id).count()
     assert person == 0

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_04_cascade_delete(self):
     """ Test for cascade delete on the `Address` model."""
     person = Session.query(model.Person).filter_by().first()
     Session.delete(person)
     Session.commit()
     addresses = Session.query(model.Address).filter_by(person_id=person.person_id).count()
     assert addresses == 0

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_04_cascade_delete(self):
     """ Test for cascade delete on the `Photo` model."""
     person = Session.query(model.Person).filter_by().first()
     Session.delete(person)
     Session.commit()
     photos = Session.query(model.Photo).filter_by(person_id=person.person_id).count()
     assert photos == 0

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_03_cascade_delete(self):
     """ Test for cascade delete on the `Excavation` model."""
     person = Session.query(model.Person).filter_by().first()
     Session.delete(person)
     Session.commit()
     excavations = Session.query(model.Excavation). \
         filter_by(person_id=person.person_id).count()
     assert excavations == 0

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def validate_python(self, values, state):
     """ Check for the uniqueness of an `email_address`."""
     email_address = values['email_address']
     if email_address != None:  # do not check for empty `email_adress`
         if values.has_key('user_id'):
             user_id = values['user_id']
             email = Session.query(User).filter(User.user_id != user_id). \
                 filter(User.email_address == email_address).first()
         else:
             email = Session.query(User).filter(
                 User.email_address == email_address).first()
         if email:
             errors = {'email_address': self.message('not_unique_email', state)}
             raise formencode.Invalid(self.message('not_unique_email', state), values, state, error_dict=errors)

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_03_child_relations(self):
     """ Test the `Person` model child relations."""
     address_fixture()
     photo_fixture()
     person = Session.query(model.Person).filter_by().first()
     assert person.addresses, '`Address` child relation is missing.'
     assert person.photo, '`Photo` child relation is missing.'

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def show(self, id=None):
     """ Display a person excavation record."""
     c.excavation = Session.query(Excavation).get(id)
     if c.excavation:
         return render('/excavations/show.mako')
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def confirm_delete(self, id=None):
     """ Show an address record and ask to confirm deletion."""
     c.address = Session.query(Address).get(id)
     if c.address:
         return render('/addresses/confirm_delete.mako')
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def show(self, id=None):
     """ Display a person address record."""
     c.address = Session.query(Address).get(id)
     if c.address:
         return render('/addresses/show.mako')
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def create(self):
     """ Add a new address record for a person in the database."""
     person_id = self.form_result['person_id']
     person = Session.query(Person).get(person_id)
     address = Address(**self.form_result)
     person.addresses.append(address)
     Session.commit()
     flash_message(_("New address record added"), 'success')
     return redirect(url.current(action='show', id=address.address_id))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def create(self):
     """ Add a new excavation record for a person in the database."""
     person_id = self.form_result['person_id']
     person = Session.query(Person).get(person_id)
     excavation = Excavation(**self.form_result)
     person.excavations.append(excavation)
     Session.commit()
     flash_message(_("New excavation record added"), 'success')
     return redirect(url.current(action='show', id=excavation.excavation_id))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def show(self, id=None):
     """ Display a person record."""
     c.person = Session.query(Person).get(id)
     #c.audit = Session.query(Audit).filter(Audit.modelname=='Person').all()
     if c.person:
         return render('/persons/show.mako')
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_01_columns(self):
     """ Test the `Permission` model columns and types."""
     permission = Session.query(model.Permission).filter_by().first()
     assert isinstance(permission.permission_id, int), \
         '`permission_id` column is missing or has changed.'
     assert isinstance(permission.permission_name, unicode), \
         '`permission_name` column is missing or has changed.'
     assert isinstance(permission.description, unicode), \
         '`description` column is missing or has changed.'

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_01_columns(self):
     """ Test the `Photo` model columns and types."""
     photo = Session.query(model.Photo).filter_by().first()
     assert isinstance(photo.photo_id, int), \
         '`photo_id` column is missing or has changed.'
     assert isinstance(photo.person_id, int), \
         '`person_id` column is missing or has changed.'
     assert isinstance(photo.path, unicode), \
         '`path` column is missing or has changed.'

# 需要导入模块: from archeologicaladdressbook.model import Session [as 别名]
# 或者: from archeologicaladdressbook.model.Session import query [as 别名]
 def test_01_columns(self):
     """ Test the `Group` model columns and types."""
     group = Session.query(model.Group).filter_by().first()
     assert isinstance(group.group_id, int), \
         '`group_id` column is missing or has changed.'
     assert isinstance(group.group_name, unicode), \
         '`group_name` column is missing or has changed.'
     assert isinstance(group.display_name, unicode), \
         '`display_name` column is missing or has changed.'