def rollback_for_el_not_in_engagement():
query_str = "select uuid from ice_user_profile where full_name = " +\
"'el_for_test';"
user_uuid = DBGeneral.select_query(query_str)
fullName = DBBridge.helper_rand_string("randomString")
updatequery = "UPDATE ice_user_profile SET role_id=1,full_name " +\
"= '%s' WHERE uuid = '%s' ;" % (fullName, user_uuid)
DBGeneral.update_query(updatequery)
def set_engagement_peer_reviewer(engagement_uuid, email):
user_uuid = DBUser.select_user_uuid(email)
update_query = "UPDATE ice_user_profile SET role_id=2 WHERE " +\
"uuid = '%s';" % user_uuid
DBGeneral.update_query(update_query)
user_id = DBGeneral.select_query(
"SELECT id FROM ice_user_profile WHERE uuid = '%s';" % user_uuid)
update_query = "UPDATE ice_engagement SET peer_reviewer_id=%s " +\
"WHERE uuid = '%s';" % (
user_id, engagement_uuid)
DBGeneral.update_query(update_query)
def update_to_el_not_in_engagement():
query_str = "select uuid from ice_user_profile where role_id = 1 ;"
user_uuid = DBGeneral.select_query(query_str)
updatequery = "UPDATE ice_user_profile SET role_id=2 ,full_name" +\
" = 'el_for_test' WHERE uuid = '%s' ;" % (
user_uuid)
DBGeneral.update_query(updatequery)
updatequery = "UPDATE ice_user_profile SET role_id=2 WHERE " +\
"full_name = '%s' ;" % (
'el_for_test')
DBGeneral.update_query(updatequery)
return 'el_for_test'
