def insertTrack(track_data, date_current, time_current, location): track_data.pop("mediaType", None) track_data.pop("message", None) track_data.pop("t_type", None) cursor = connection.cursor() cursor.execute("SELECT * from pahera_modularisedtracks") track_list_Data = DictFetchAll.dictfetchall(cursor) fName = track_list_Data[0]['json_file_path'] js_data = {} js_data = track_data js_data['date'] = date_current js_data['time'] = time_current json_file = open(fName, 'r+') json_data = json.load(json_file) json_file.close() if json_data : # To Check if there is a entry o not..!!! for post in json_data: for post1 in post: # Looping through countries..!!! if post1 == track_data['country']: for post2 in post[track_data['country']]: for j in post2: # Looping through States..!!! if j == track_data['state']: for post3 in post2.values(): for i in post3: # Looping through Cities..!!! for k in i.keys(): if k == track_data['state_district']: i[track_data['state_district']].append(track_data) json_file = open(fName, 'w+') json_file.write(json.dumps(json_data, sort_keys=True, indent=4, separators=(',', ': '))) json_file.close() return else: # If no record with a particular city..!!! post3.append({track_data['state_district'] : [ track_data ] } ) json_file = open(fName, 'w+') json_file.write(json.dumps(json_data, sort_keys=True, indent=4, separators=(',', ': '))) json_file.close() return else: # If no record with a particular State..!!! post[track_data['country']].append( { track_data['state'] : [ { track_data['state_district'] : [ track_data ] } ] } ) json_file = open(fName, 'w+') json_file.write(json.dumps(json_data, sort_keys=True, indent=4, separators=(',', ': '))) json_file.close() return else: # If no record with a particular Country..!!! json_data.append({ track_data['country'] : [ { track_data['state'] : [ { track_data['state_dist'] : [ track_data ] } ] } ] } ) json_file = open(fName, 'w+') json_file.write(json.dumps(json_data, sort_keys=True, indent=4, separators=(',', ': '))) json_file.close() return else: # If no record in the file at all..!!! js_file_data = {} js_file_data = [ { track_data['country'] : [ { track_data['state'] : [ { track_data['state_district'] : [ js_data ] } ] } ] } ] json_file = open(fName, 'w+') json_file.write(json.dumps(js_file_data, sort_keys=True, indent=4, separators=(',', ': '))) return
def VerifyTheUser(data): cursor = connection.cursor() email = data['email'] phone = data['phone'] cursor.execute("SELECT * from pahera_person WHERE email = %s OR phone_no = %s", [email, phone]) person_Data = {} person_Data = DictFetchAll.dictfetchall(cursor) if person_Data: if person_Data[0]['email'] == email or person_Data[0]['phone_no'] == phone: return False else: return True else: return True
def fetch_contacts(person): data_new = {} dataDB = {"result": []} count = {} value = 0 count["count"] = "0" cursor = connection.cursor() cursor.execute("SELECT * from pahera_trusted_friends WHERE person_id = %s", [person.id]) friend_Data = {} friend_Data = DictFetchAll.dictfetchall(cursor) for post in friend_Data: value += 1 post["count"] = value dataDB["result"].append(post) count["count"] = value scriptpath = os.path.dirname("./static/JSON/temp/") fName = os.path.join(scriptpath, "MyContacts.json") WritingToJson.writeJSON2(dataDB, fName)