Python model.Session类代码示例

 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))

 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))

 def create(self):
     """ Add a new person record in the database."""
     # check first for a duplicate entry
     self._check_duplicate(self.form_result)
     # create the record
     person = Person(**self.form_result)
     Session.add(person)
     Session.commit()
     flash_message(_("New person record added"), 'success')
     return redirect(url.current(action='show', id=person.person_id))

 def delete(self, id=None):
     """ Delete an existing address record."""
     address = Session.query(Address).get(id)
     if address:
         Session.delete(address)
         Session.commit()
         flash_message(_("Address record deleted"), 'success')
         return redirect(url.current(action='index'))
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

 def delete(self, id=None):
     """ Delete an existing excavation record."""
     excavation = Session.query(Excavation).get(id)
     if excavation:
         Session.delete(excavation)
         Session.commit()
         flash_message(_("Excavation record deleted"), 'success')
         return redirect(url.current(action='index'))
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

 def update(self, id=None):
     """ Update an existing address record."""
     address = Session.query(Address).get(id)
     if address:
         # update record attributes
         for key, value in self.form_result.items():
             setattr(address, key, value)
         Session.commit()
         flash_message(_("Address record updated"), 'success')
         return redirect(url.current(action='show', id=address.address_id))
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

    def test_02_unique_constraint(self):
        """ Test for unique constraint for the `Photo` model.

        Test the unique constraint on `path`.
        """
        test_photo = DuplicatePhotoData.JohnDoePhoto()
        person = Session.query(model.Person).filter_by().first()
        person.photo = model.Photo(path=test_photo.path)
        try:
            Session.commit()
            raise AssertionError('`Photo` unique constraint on `path` is missing.')
        except sa.exc.IntegrityError:
            Session.rollback()

 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)

 def update(self, id=None):
     """ Update an existing person record."""
     person = Session.query(Person).get(id)
     if person:
         # check first for a duplicate entry
         self._check_duplicate(self.form_result, person.person_id)
         # update record attributes
         for key, value in self.form_result.items():
             setattr(person, key, value)
         Session.commit()
         flash_message(_("Person record updated"), 'success')
         return redirect(url.current(action='show', id=person.person_id))
     else:
         flash_message(_("This record did not exist"), 'warning')
         return redirect(url.current(action='index', id=None))

 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.'

 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))

 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))

 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))

 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.'

 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))