def test_updating_lists_works(self):
uris = [
("http://localhost", 1, "etag", int(time.time() * 1000),
int(time.time() * 1000), 1),
]
q = SQLiteMultipleHostUriQueue(":memory:")
q.add_uris(uris)
uris = [
("http://localhost", 1, "etag", int(time.time() * 1000),
int(time.time() * 1000), 2),
]
q.update_uris(uris)
cursor = q._connection.execute("SELECT * FROM queues WHERE queue=1")
uri_res = cursor.fetchone()
(url, queue, etag, mod_date, next_date, prio) = uris[0]
(url_res, queue_res, etag_res, mod_date_res, next_date_res,
prio_res) = uri_res
self.assertEqual(url, url_res)
self.assertEqual(etag, etag_res)
self.assertEqual(mod_date, mod_date_res)
self.assertEqual(prio, prio_res)
self.assertEqual(next_date, next_date_res)