def tearDown(self): """ clean up after a test case """ DBSession.close() DBSession.remove() testing.tearDown() os.remove('test_utils.db')
def setUp(self): """ set up everything for a test case """ self.config = testing.setUp() self.config.include('pyramid_mailer.testing') try: DBSession.close() DBSession.remove() #print("removing old DBSession ===================================") except: #print("no DBSession to remove ===================================") pass from sqlalchemy import create_engine engine = create_engine('sqlite:///test_utils.db') DBSession.configure(bind=engine) self.session = DBSession # () Base.metadata.create_all(engine) with transaction.manager: ticket1 = PartyTicket( # german firstname=u'SomeFirstnäme', lastname=u'SomeLastnäme', email=u'*****@*****.**', locale=u"DE", email_is_confirmed=False, email_confirm_code=u'ABCDEFGBAR', password=u'arandompassword', date_of_submission=date.today(), num_tickets=5, ticket_type=2, the_total=75, user_comment=u"äh, was?" ) DBSession.add(ticket1) DBSession.flush()