def _update_space(self):
# q = "Update tbl_client_groups set total_disk_space_used = %s " + \
# " where client_id = %s "
q = "Update tbl_legal_entities set used_file_space = %s " + \
" where legal_entity_id = %s "
res = self._k_db.execute(q, [self._space_used, self._legal_entity_id])
if res is False:
raise client_process_error("E021")
def send_reset_link(db, user_id, username, short_name):
reset_token = new_uuid()
reset_link = "%sreset_password/%s/%s" % (CLIENT_URL, short_name,
reset_token)
condition = "user_id = %s and verification_type_id = %s"
condition_val = [user_id, 2]
db.delete(tblEmailVerification, condition, condition_val)
q = " INSERT INTO tbl_email_verification(user_id, verification_code, " + \
" verification_type_id) VALUES (%s, %s, %s)"
row = db.execute(q, [user_id, reset_token, 2])
employee_name = get_user_name_by_id(db, user_id)
if (row >= 0):
if email().send_reset_link(db, user_id, username, reset_link,
employee_name):
return True
else:
raise client_process_error("E028")
else:
raise client_process_error("E029")
def process_save_username(self):
try:
self.get_knowledge_connect()
self._k_db._cursor = self._k_db._connection.cursor()
self._update_groupadmin_uname()
self._k_db._cursor.close()
self._k_db._connection.commit()
self._k_db._connection.close()
except Exception, e:
print e
self._k_db._cursor.close()
self._k_db._connection.rollback()
self._k_db._connection.close()
raise client_process_error("E090")
def procee_update_space(self):
try:
self.get_knowledge_connect()
# self._k_db.begin()
self._k_db._cursor = self._k_db._connection.cursor()
self._update_space()
self._k_db.commit()
self._k_db.close()
return True
except Exception, e:
print e
print "e>>>", e
self._k_db.rollback()
self._k_db.close()
raise client_process_error("E021")
def process_opted_status(self):
try:
self.get_knowledge_connect()
# self._k_db.begin()
self._k_db._cursor = self._k_db._connection.cursor()
self._update_opted_status()
self._k_db._cursor.close()
self._k_db._connection.commit()
self._k_db._connection.close()
except Exception, e:
print e
self._k_db._cursor.close()
self._k_db._connection.rollback()
self._k_db._connection.close()
raise client_process_error("E026")
def process_close_unit(self):
try:
self.get_knowledge_connect()
self._k_db._cursor = self._k_db._connection.cursor()
self._close_unit()
self._k_db._cursor.close()
self._k_db._connection.commit()
self._k_db._connection.close()
return True
except Exception, e:
print e
self._k_db._cursor.close()
self._k_db._connection.rollback()
self._k_db._connection.close()
raise client_process_error("E025")
def process_save_user(self):
try:
self.get_knowledge_connect()
self._k_db._cursor = self._k_db._connection.cursor()
self._save_user()
self._k_db._cursor.close()
self._k_db._connection.commit()
self._k_db._connection.close()
return self._user_exists_status
except Exception, e:
print e
self._k_db._cursor.close()
self._k_db._connection.rollback()
self._k_db._connection.close()
raise client_process_error("E022")
def process_update_user_status(self):
try:
self.get_knowledge_connect()
self._k_db.begin()
if self._status_type == "status":
self._update_user_status()
elif self._status_type == "admin":
self._update_admin_status()
self._k_db.commit()
self._k_db.close()
return True
except Exception, e:
print e
self._k_db.rollback()
self._k_db.close()
raise client_process_error("E024")
def process_save_activity(self):
try:
self.get_knowledge_connect()
self._k_db._cursor = self._k_db._connection.cursor()
self._k_db.execute(self._query, self._values)
self._k_db._cursor.close()
self._k_db._connection.commit()
self._k_db._connection.close()
except Exception, e:
print e
print(KNOWLEDGE_DB_HOST, KNOWLEDGE_DB_PORT, KNOWLEDGE_DB_USERNAME,
KNOWLEDGE_DB_PASSWORD, KNOWLEDGE_DATABASE_NAME)
self._k_db._cursor.close()
self._k_db._connection.rollback()
self._k_db._connection.close()
raise client_process_error("E091")
def _is_client_active(self):
try:
self.get_knowledge_connect()
self._k_db.begin()
q = "select count(0) from tbl_client_groups where " + \
" client_id = %s and is_active = 1"
row = self._k_db.select_one(q, [self._client_id])
if row[0] > 0:
status = True
else:
status = False
self._k_db.close()
return status
except Exception, e:
print e
self._k_db.rollback()
self._k_db.close()
raise client_process_error("E027")
def _save_user(self):
q = "select count(0) from tbl_client_users where " + \
" client_id = %s and user_category_id = 1"
row = self._k_db.select_one(q, [self._user_info["client_id"]])
if row is not None:
if row[0] > 0:
self._user_exists_status = False
else:
self._user_exists_status = True
else:
self._user_exists_status = True
if self._user_exists_status is True:
q = "INSERT INTO tbl_client_users(user_id, user_category_id, client_id, " + \
"seating_unit_id, service_provider_id, user_level, email_id, " + \
"employee_name, employee_code, contact_no, mobile_no, address, " + \
"is_service_provider, is_active, status_changed_on, is_disable, disabled_on, " + \
" legal_entity_ids ) " + \
"values(%s, %s, %s, %s, %s, %s, %s, %s, %s , %s, %s, %s, %s, %s, %s, %s, %s, %s)"
values = [
self._user_id, self._user_info["user_category_id"],
self._user_info["client_id"],
self._user_info["seating_unit_id"],
self._user_info["service_provider_id"],
self._user_info["user_level"], self._user_info["email_id"],
self._user_info["employee_name"],
self._user_info["employee_code"],
self._user_info["contact_no"], self._user_info["mobile_no"],
self._user_info["address"],
self._user_info["is_service_provider"],
self._user_info["is_active"],
self._user_info["status_changed_on"],
self._user_info["is_disable"], self._user_info["disabled_on"],
self._user_info["le_ids"]
]
res = self._k_db.execute(q, values)
if res is False:
raise client_process_error("E022")
