def test_add_userProfile_1(self): """Add new userProfile """ newUserProfile = UserProfile() newUserProfile.id = _testUserProfiles[0].get('_user') newUserProfile.name = _testUserProfiles[0].get('_name') newUserProfile.email = _testUserProfiles[0].get('_email') newUserProfile.picture_href = _testUserProfiles[0].get('_picture_href') newUserProfile.bio = _testUserProfiles[0].get('_bio') newUserProfile.role = _testUserProfiles[0].get('_role') self.userProfilesSystem.add_userProfile(newUserProfile) db = self.env.get_db_cnx() cursor = db.cursor() cursor.execute( 'SELECT name, value FROM session_attribute WHERE sid=%s', (_testUserProfiles[0].get('_user'), )) _result = {} for name, value in cursor: _result[name] = value self.assertEqual(_result['enabled'], "1") self.assertEqual(_result['name'], _testUserProfiles[0].get('_name')) self.assertEqual(_result['email'], _testUserProfiles[0].get('_email')) self.assertEqual(_result['picture_href'], _testUserProfiles[0].get('_picture_href')) self.assertEqual(_result['bio'], _testUserProfiles[0].get('_bio')) self.assertEqual(_result['role'], _testUserProfiles[0].get('_role'))
def test_add_userProfile_1(self): """Add new userProfile """ newUserProfile = UserProfile() newUserProfile.id = _testUserProfiles[0].get('_user') newUserProfile.name = _testUserProfiles[0].get('_name') newUserProfile.email =_testUserProfiles[0].get('_email') newUserProfile.picture_href = _testUserProfiles[0].get('_picture_href') newUserProfile.bio = _testUserProfiles[0].get('_bio') newUserProfile.role = _testUserProfiles[0].get('_role') self.userProfilesSystem.add_userProfile(newUserProfile) db=self.env.get_db_cnx() cursor = db.cursor() cursor.execute('SELECT name, value FROM session_attribute WHERE sid=%s',(_testUserProfiles[0].get('_user'),)) _result = {} for name,value in cursor: _result[name]=value self.assertEqual(_result['enabled'], "1") self.assertEqual(_result['name'], _testUserProfiles[0].get('_name')) self.assertEqual(_result['email'], _testUserProfiles[0].get('_email')) self.assertEqual(_result['picture_href'], _testUserProfiles[0].get('_picture_href')) self.assertEqual(_result['bio'], _testUserProfiles[0].get('_bio')) self.assertEqual(_result['role'], _testUserProfiles[0].get('_role'))
def get_userProfile(self, userProfile_id): """ Returns userProfile from store. @param userProfile_id: str @return: tracteamroster.api.UserProfile """ db = self.env.get_db_cnx() cursor = db.cursor() cursor.execute("SELECT sid, name, value FROM session_attribute " "WHERE sid=%s and authenticated=1 ORDER BY sid", (userProfile_id,)) _newUserProfile=UserProfile(userProfile_id, self) for sid, name, value in cursor: _newUserProfile[name] = value _newUserProfile.id = sid _newUserProfile.exists = True _newUserProfile.store = self return _newUserProfile
def get_userProfile(self, userProfile_id): """ Returns userProfile from store. @param userProfile_id: str @return: tracteamroster.api.UserProfile """ db = self.env.get_db_cnx() cursor = db.cursor() cursor.execute( "SELECT sid, name, value FROM session_attribute " "WHERE sid=%s and authenticated=1 ORDER BY sid", (userProfile_id, )) _newUserProfile = UserProfile(userProfile_id, self) for sid, name, value in cursor: _newUserProfile[name] = value _newUserProfile.id = sid _newUserProfile.exists = True _newUserProfile.store = self return _newUserProfile
def _get_userProfiles(self, userProfile_ids, grabAllFieldsFromDB=False): """This method returns the profiles defined by id in userProfile_ids. How it works: 1. Selecting only userProfile_ids userProfile_id name value jdoe name John Doe jdoe email [email protected] jdoe role Technical Arhitect jsmith name Joe Smith jsmith email [email protected] jsmith role Senior Developer 2. marching through result set _blankProfile=UserProfile(-1) for sid, name, value in thisExampleData: if _blankProfile.id!=sid: if not firstLoop: #loaded _blankProfile yield _blankProfile _blankProfile.id==sid _blankProfile[name]=value # Last item from loop (in thisExampleData it's about jsmith profile ). # We could avoid this by adding another loop / blank line yield _blankProfile @todo: Cache userProfiles @param userProfile_ids: list @return: list """ db = self.env.get_db_cnx() cursor = db.cursor() if grabAllFieldsFromDB: cursor.execute("SELECT sid, name, value FROM session_attribute " "WHERE sid in ('%s') ORDER BY sid"%("','".join(userProfile_ids))) else: cursor.execute("SELECT sid, name, value FROM session_attribute " "WHERE sid in ('%s') and name in ('%s') ORDER BY sid"%("','".join(userProfile_ids), "','".join(UserProfile()))) _newUserProfile=UserProfile(-1, self) _fieldsFromDb=[] for sid, name, value in cursor: if _newUserProfile.id!=sid: if _newUserProfile.id!=-1: _newUserProfile.store=self _newUserProfile.exists=True object.__setattr__(_newUserProfile, '_fieldsFromDb', _fieldsFromDb) yield _newUserProfile _newUserProfile=UserProfile(0, self) _fieldsFromDb=[] _newUserProfile.id=sid _newUserProfile[name]=value _fieldsFromDb.append(name) # last _newUserProfile if _newUserProfile.id!=-1: _newUserProfile.store=self _newUserProfile.exists=True object.__setattr__(_newUserProfile, '_fieldsFromDb', _fieldsFromDb) yield _newUserProfile
def _get_userProfiles(self, userProfile_ids, grabAllFieldsFromDB=False): """This method returns the profiles defined by id in userProfile_ids. How it works: 1. Selecting only userProfile_ids userProfile_id name value jdoe name John Doe jdoe email [email protected] jdoe role Technical Arhitect jsmith name Joe Smith jsmith email [email protected] jsmith role Senior Developer 2. marching through result set _blankProfile=UserProfile(-1) for sid, name, value in thisExampleData: if _blankProfile.id!=sid: if not firstLoop: #loaded _blankProfile yield _blankProfile _blankProfile.id==sid _blankProfile[name]=value # Last item from loop (in thisExampleData it's about jsmith profile ). # We could avoid this by adding another loop / blank line yield _blankProfile @todo: Cache userProfiles @param userProfile_ids: list @return: list """ db = self.env.get_db_cnx() cursor = db.cursor() if grabAllFieldsFromDB: cursor.execute("SELECT sid, name, value FROM session_attribute " "WHERE sid in ('%s') ORDER BY sid" % ("','".join(userProfile_ids))) else: cursor.execute( "SELECT sid, name, value FROM session_attribute " "WHERE sid in ('%s') and name in ('%s') ORDER BY sid" % ("','".join(userProfile_ids), "','".join(UserProfile()))) _newUserProfile = UserProfile(-1, self) _fieldsFromDb = [] for sid, name, value in cursor: if _newUserProfile.id != sid: if _newUserProfile.id != -1: _newUserProfile.store = self _newUserProfile.exists = True object.__setattr__(_newUserProfile, '_fieldsFromDb', _fieldsFromDb) yield _newUserProfile _newUserProfile = UserProfile(0, self) _fieldsFromDb = [] _newUserProfile.id = sid _newUserProfile[name] = value _fieldsFromDb.append(name) # last _newUserProfile if _newUserProfile.id != -1: _newUserProfile.store = self _newUserProfile.exists = True object.__setattr__(_newUserProfile, '_fieldsFromDb', _fieldsFromDb) yield _newUserProfile