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]