def get_read_messages_query(self, **kwargs):
"""
"""
return self.wrap_adb_shell("sqlite3 {} \"{}\"").format(
WA_SQLITE.DATABASE_PATH, WA_SQLITE.get_messages(**kwargs))
pass
def get_insert_into_messages_query(self, wa_number_id, message):
return self.wrap_adb_shell("sqlite3 {} \"{}\"").format(
WA_SQLITE.DATABASE_PATH,
WA_SQLITE.get_insert_into_messages_query(wa_number_id, message))
pass
def get_update_chatlist_query(self, wa_number_id):
return self.wrap_adb_shell("sqlite3 {} \"{}\"").format(
WA_SQLITE.DATABASE_PATH,
WA_SQLITE.get_update_chatlist_query(wa_number_id))
def test_get_messages_query_filter_to_date():
"""
"""
t = time.time()
assert WA_SQLITE.get_messages(to_date=t) == \
f"SELECT _id, key_remote_jid, key_from_me, key_id, status, data, timestamp FROM {WA_SQLITE.MESSAGES_TABLE_NAME} WHERE{WA_SQLITE.FILTER_TO_DATE.format(filter_to_date_epoch=t)};"
def test_get_messages_query_filter_jid_and_from_date():
"""
"""
t = time.time()
assert WA_SQLITE.get_messages(key_remote_jid=TEST_JID, from_date=t) == \
f"SELECT _id, key_remote_jid, key_from_me, key_id, status, data, timestamp FROM {WA_SQLITE.MESSAGES_TABLE_NAME} WHERE{WA_SQLITE.FILTER_FROM_JID.format(key_remote_jid=TEST_JID)}AND{WA_SQLITE.FILTER_FROM_DATE.format(filter_from_date_epoch=t)};"
def test_get_messages_query_filter_jid():
assert WA_SQLITE.get_messages(key_remote_jid=TEST_JID) == \
f"SELECT _id, key_remote_jid, key_from_me, key_id, status, data, timestamp FROM {WA_SQLITE.MESSAGES_TABLE_NAME} WHERE{WA_SQLITE.FILTER_FROM_JID.format(key_remote_jid=TEST_JID)};"
def test_get_messages_query():
assert WA_SQLITE.get_messages(
) == f"SELECT _id, key_remote_jid, key_from_me, key_id, status, data, timestamp FROM {WA_SQLITE.MESSAGES_TABLE_NAME};"
def test_get_update_chatlist_query():
"""
"""
WA_SQLITE.get_update_chatlist_query(TEST_JID)
pass
def test_get_insert_into_chat_list_query():
WA_SQLITE.get_insert_into_chat_list_query(TEST_JID)
pass
def test_get_insert_into_messages_query():
WA_SQLITE.get_insert_into_messages_query(TEST_JID, "test message")
pass