def test_load_user(self): from motionman.services.user import load_user session = DBSession() user_1 = copy.deepcopy(self.user_orig) user_1.email = u"testemail" user_1.name = u"testname" user_1.vote_weight = 88 try: session.add(user_1) session.flush() except IntegrityError: transaction.abort() user_load = load_user(user_1.id) self.assertEqual(user_load.name, u'testname') self.assertEqual(user_load.email, u'testemail') self.assertEqual(user_load.vote_weight, 88) self.assertEqual(user_load.status, 1) session.delete(user_load) session.flush() transaction.commit()
def test_user_model(self): from motionman.models import User user_orig = User() user_orig.id = 888 user_orig.email = u"*****@*****.**" user_orig.name = u"test1" user_orig.vote_weight = 1 user_orig.created_time = datetime.datetime.now() user_orig.created_user = 3 user_orig.last_modified_time = datetime.datetime.now() user_orig.last_modified_user = 3 user_orig.status = 2 user_new = copy.deepcopy(user_orig) session = DBSession() session.add(user_new) session.flush() transaction.commit() user_load = session.query(User).filter(User.id==888).first() self.assertEqual(user_load.email, user_orig.email) self.assertEqual(user_load.name, user_orig.name) self.assertEqual(user_load.vote_weight, user_orig.vote_weight) self.assertEqual(user_load.created_time, user_orig.created_time) self.assertEqual(user_load.created_user, user_orig.created_user) self.assertEqual(user_load.last_modified_time, user_orig.last_modified_time) self.assertEqual(user_load.last_modified_user, user_orig.last_modified_user) self.assertEqual(user_load.status, user_orig.status) session.delete(user_load) session.flush() transaction.commit()
def test_update_user(self): from motionman.services.user import update_user #prepare data session = DBSession() user_1 = copy.deepcopy(self.user_orig) try: session.add(user_1) session.flush() except IntegrityError: transaction.abort() update_user(user_1.id, u'newname', u'newemail', 888) user_load = session.query(User).filter(User.id == user_1.id).first() self.assertEqual(user_load.name, u'newname') self.assertEqual(user_load.email, u'newemail') self.assertEqual(user_load.vote_weight, 888) self.assertEqual(user_load.status, 1) session.delete(user_load) session.flush() transaction.commit()
def test_setting_model(self): from motionman.models import Setting setting_orig = Setting() setting_orig.id = 888 setting_orig.name = u"setting1" setting_orig.value = u"setting value" setting_orig.valuex = u"long setting value" setting_orig.created_time = datetime.datetime.now() setting_orig.created_user = 3 setting_orig.last_modified_time = datetime.datetime.now() setting_orig.last_modified_user = 3 setting_orig.status = 2 setting_new = copy.deepcopy(setting_orig) session = DBSession() session.add(setting_new) session.flush() transaction.commit() setting_load = session.query(Setting).filter(Setting.id==888).first() self.assertEqual(setting_load.name, setting_orig.name) self.assertEqual(setting_load.value, setting_orig.value) self.assertEqual(setting_load.valuex, setting_orig.valuex) self.assertEqual(setting_load.created_time, setting_orig.created_time) self.assertEqual(setting_load.created_user, setting_orig.created_user) self.assertEqual(setting_load.last_modified_time, setting_orig.last_modified_time) self.assertEqual(setting_load.last_modified_user, setting_orig.last_modified_user) self.assertEqual(setting_load.status, setting_orig.status) session.delete(setting_load) session.flush() transaction.commit()
def test_update_user(self): from motionman.services.user import update_user #prepare data session = DBSession() user_1 = copy.deepcopy(self.user_orig) try: session.add(user_1) session.flush() except IntegrityError: transaction.abort() update_user(user_1.id, u'newname', u'newemail', 888) user_load = session.query(User).filter(User.id==user_1.id).first() self.assertEqual(user_load.name, u'newname') self.assertEqual(user_load.email, u'newemail') self.assertEqual(user_load.vote_weight, 888) self.assertEqual(user_load.status, 1) session.delete(user_load) session.flush() transaction.commit()
def test_add_user(self): from motionman.services.user import add_user, DuplicatedName, DuplicatedEmail add_user(u"testname", u"testemail", 88) session = DBSession() user_load = session.query(User).filter(User.name==u'testname').first() self.assertEqual(user_load.name, u'testname') self.assertEqual(user_load.email, u'testemail') self.assertEqual(user_load.vote_weight, 88) self.assertEqual(user_load.status, 1) self.assertRaises(DuplicatedName, add_user, u"testname", u"different email", 88) self.assertRaises(DuplicatedEmail, add_user, u"different name", u"testemail", 88) session.delete(user_load) session.flush() transaction.commit()
def test_add_user(self): from motionman.services.user import add_user, DuplicatedName, DuplicatedEmail add_user(u"testname", u"testemail", 88) session = DBSession() user_load = session.query(User).filter( User.name == u'testname').first() self.assertEqual(user_load.name, u'testname') self.assertEqual(user_load.email, u'testemail') self.assertEqual(user_load.vote_weight, 88) self.assertEqual(user_load.status, 1) self.assertRaises(DuplicatedName, add_user, u"testname", u"different email", 88) self.assertRaises(DuplicatedEmail, add_user, u"different name", u"testemail", 88) session.delete(user_load) session.flush() transaction.commit()
def test_setting_model(self): from motionman.models import Setting setting_orig = Setting() setting_orig.id = 888 setting_orig.name = u"setting1" setting_orig.value = u"setting value" setting_orig.valuex = u"long setting value" setting_orig.created_time = datetime.datetime.now() setting_orig.created_user = 3 setting_orig.last_modified_time = datetime.datetime.now() setting_orig.last_modified_user = 3 setting_orig.status = 2 setting_new = copy.deepcopy(setting_orig) session = DBSession() session.add(setting_new) session.flush() transaction.commit() setting_load = session.query(Setting).filter(Setting.id == 888).first() self.assertEqual(setting_load.name, setting_orig.name) self.assertEqual(setting_load.value, setting_orig.value) self.assertEqual(setting_load.valuex, setting_orig.valuex) self.assertEqual(setting_load.created_time, setting_orig.created_time) self.assertEqual(setting_load.created_user, setting_orig.created_user) self.assertEqual(setting_load.last_modified_time, setting_orig.last_modified_time) self.assertEqual(setting_load.last_modified_user, setting_orig.last_modified_user) self.assertEqual(setting_load.status, setting_orig.status) session.delete(setting_load) session.flush() transaction.commit()
def test_user_model(self): from motionman.models import User user_orig = User() user_orig.id = 888 user_orig.email = u"*****@*****.**" user_orig.name = u"test1" user_orig.vote_weight = 1 user_orig.created_time = datetime.datetime.now() user_orig.created_user = 3 user_orig.last_modified_time = datetime.datetime.now() user_orig.last_modified_user = 3 user_orig.status = 2 user_new = copy.deepcopy(user_orig) session = DBSession() session.add(user_new) session.flush() transaction.commit() user_load = session.query(User).filter(User.id == 888).first() self.assertEqual(user_load.email, user_orig.email) self.assertEqual(user_load.name, user_orig.name) self.assertEqual(user_load.vote_weight, user_orig.vote_weight) self.assertEqual(user_load.created_time, user_orig.created_time) self.assertEqual(user_load.created_user, user_orig.created_user) self.assertEqual(user_load.last_modified_time, user_orig.last_modified_time) self.assertEqual(user_load.last_modified_user, user_orig.last_modified_user) self.assertEqual(user_load.status, user_orig.status) session.delete(user_load) session.flush() transaction.commit()