def get_domains_for_user_bu(db, user_id):
_source_db_con = connectKnowledgeDB()
_source_db = Database(_source_db_con)
_source_db.begin()
result = _source_db.call_proc_with_multiresult_set(
'sp_tbl_domains_for_user', (user_id, ), 3)
result.pop(0)
return return_domains_bu(result)
def get_countries_for_user_bu(db, user_id):
_source_db_con = connectKnowledgeDB()
_source_db = Database(_source_db_con)
_source_db.begin()
result = _source_db.call_proc_with_multiresult_set("sp_countries_for_user",
[user_id], 2)
print "Result->> ", result
if len(result) > 1:
result = result[1]
return return_countries_bu(result)
def get_cliens_for_client_unit_bulk_upload(db, session_user):
_source_db_con = connect_knowledge_db()
_source_db = Database(_source_db_con)
_source_db.begin()
groups = _source_db.call_proc_with_multiresult_set(
"sp_client_groups_for_client_unit_bulk_upload", (session_user, ), 2)
_source_db.close()
print "groups"
print groups
return return_client_group(groups[1])
