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)