def insert_many_queries(call_queries, text_queries, voicemail_queries):
if len(call_queries) >= num_before_insert:
Call.insert_many(call_queries).execute()
# Remove all the stored ones
del call_dict[:]
print("Inserted " + str(num_before_insert) + " or more Calls")
if len(text_queries) >= num_before_insert:
for text_message in text_queries:
Message.insert(text_message).execute()
# Message.insert_many(text_queries).execute()
del text_dict[:]
print("Inserted " + str(num_before_insert) + " or more Texts")
if len(voicemail_queries) >= num_before_insert:
Voicemail.insert_many(voicemail_queries).execute()
del voicemail_dict[:]
print("Inserted " + str(num_before_insert) + " or more Voicemails")
text = voicemail.find_all("span", {"class": "full-text"})[0].text
# Voicemail length
if len(voicemail.find_all("abbr", {"class": "duration"})) >= 1:
duration = voicemail.find_all("abbr", {"class": "duration"})[0].text
yaml_data.append(
{
"type": "voicemail",
"time": date_string,
"caller": caller,
"duration": duration,
"phone number": phone_number[1],
"message": text,
}
)
voicemail2SQLite(caller=caller, number=phone_number[1], time=date_string, message=text)
yaml_array = yaml.dump(yaml_data, yaml_output, default_flow_style=False)
###################################################################
#
# End of Voicemail to yaml script
#
###################################################################
# Insert any remaining entries
if len(call_dict) != 0:
Call.insert_many(call_dict)
if len(text_dict) != 0:
Message.insert_many(text_dict)
if len(voicemail_dict) != 0:
Voicemail.insert_many(voicemail_dict)
