def testEdit(self): from tg2testapp.model import User, Group, DBSession as session u = User() u.user_name=u'userTestEdit' u.password = u'asdf' u.email_address=u"*****@*****.**" session.save(u) session.commit() session.flush() u_id = str(u.user_id) resp = app.get('/dbmechanic/delete/tg_user?user_id='+u_id)
def testCreateRelationships(self): from tg2testapp.model import User, Group, DBSession as session u = User() u.user_name=u'userCreateRel' u.password = u'asdf' u.email_address=u"*****@*****.**" session.save(u) session.commit() group = Group() group.group_name=u"create_rel_group" group.display_name=u"group" session.save(group) session.flush() u_id = str(u.user_id) #add group 1 resp = app.get('/dbmechanic/edit/tg_user', params=dict(user_id=u_id, user_name=u'new_username', email_address=u'*****@*****.**', dbsprockets_id=u'editRecord__tg_user', many_many_tg_group="1", ))
def testEdit(self): from tg2testapp.model import User, Group, DBSession as session u = User() u.user_name=u'userTestEdit' u.password = u'asdf' u.email_address=u"*****@*****.**" session.save(u) session.commit() session.flush() u_id = str(u.user_id) resp = app.get('/dbmechanic/editRecord/tg_user?user_id='+u_id) value = resp.body resp = app.get('/dbmechanic/edit/tg_user', params=dict(user_id=u_id, user_name=u'new_username', email_address=u'*****@*****.**', dbsprockets_id=u'editRecord__tg_user' )) actual = resp.follow().namespace expected = {'controller': '/dbmechanic', 'recordsPerPage': 25, 'tableName': 'tg_user', 'mainCount': 1, 'page': 1} mainValue ={u'town': None, u'user_id': 1, # u'created': datetime.datetime(2008, 2, 23, 11, 59, 35, 144897), u'email_address': u'*****@*****.**', 'tg_groups': '', u'display_name': None, u'password': '******', u'user_name': u'new_username'} for key, value in expected.iteritems(): yield eq_, value, actual[key] actualRow = actual['mainValue'][0] for key, value in mainValue.iteritems(): yield eq_, value, actualRow[key]