def delete_all(tableName, condition):
try:
db = db_utility.getDBConnection()
collection = db[tableName]
collection.delete_many(condition)
except Exception as e:
print(e)
return "401"
else:
return "200"
def fetch_last_log(test):
try:
db = db_utility.getDBConnection()
collection = db["log_tracker"]
data = collection.find({
"test_id": test
}, {
"_id": 0
}).sort("tracker_id", -1).limit(1)
except Exception as e:
print(e)
return "401"
else:
return list(data)
def updatingUserInDatabase(validRequest):
lastAdminId = db.fetch_last_one(USER_TABLE)['admin_id']
print("last admin id ", lastAdminId)
dbInsertDocument = {}
print("Document to be updated in the table", dbInsertDocument)
proxyResponse = {}
database = db.getDBConnection()
print("Finding last user id...")
currentUserId = int(db.fetch_next_id(USER_TABLE, "_id"))
# print("previous user id = ",previousUser)
print("Document to be updated in the table before data insert in json = ",
dbInsertDocument)
# previousUserId = previousUser['user_id']
# currentUserId = previousUserId + 1
createdTime = datetime.datetime.now().strftime("%Y-%m-%dT%H:%M:%S")
if (validRequest['typeOfUser'] == RECRUITER
and validRequest['userGroup'] == ADMIN):
dbInsertDocument['organization_id'] = validRequest['organizationId']
dbInsertDocument['user_group_id'] = 2
elif (validRequest['userGroup'] == RECRUITER):
dbInsertDocument['organization_id'] = validRequest['organizationId']
dbInsertDocument['user_group_id'] = 2
else:
dbInsertDocument['user_group_id'] = 1
# Greating document to insert in database
dbInsertDocument['admin_id'] = lastAdminId
dbInsertDocument["_id"] = currentUserId
dbInsertDocument['user_id'] = currentUserId
dbInsertDocument['user_name'] = validRequest['username']
dbInsertDocument['email'] = validRequest['username']
dbInsertDocument['created_at'] = createdTime
dbInsertDocument['last_updated_at'] = createdTime
dbInsertDocument['is_active'] = isActive
dbInsertDocument['first_name'] = validRequest['firstName']
dbInsertDocument['last_name'] = validRequest['lastName']
dbInsertDocument['created_by'] = validRequest['userDBid']
print("Document to be updated in the table", dbInsertDocument)
insertResponse = db.insert_data_one(USER_TABLE, dbInsertDocument)
print("DataBase inserted response = ", insertResponse, " type = ",
type(insertResponse))
return insertResponse