summaryrefslogtreecommitdiff
path: root/tests/queries.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/queries.sql')
-rw-r--r--tests/queries.sql79
1 files changed, 40 insertions, 39 deletions
diff --git a/tests/queries.sql b/tests/queries.sql
index 2515778..c821e25 100644
--- a/tests/queries.sql
+++ b/tests/queries.sql
@@ -1,6 +1,6 @@
-- createTables.sql:
--- write:
+-- write:
CREATE TABLE IF NOT EXISTS "q_payloads" (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
timestamp TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%f000000Z', 'now')),
@@ -60,42 +60,43 @@
) STRICT;
--- read:
+-- read:
--- owner:
+-- owner:
-- take.sql:
--- write:
+-- write:
INSERT INTO "q_owners" (topic, consumer, owner_id)
VALUES (?, ?, ?)
ON CONFLICT (topic, consumer) DO
UPDATE SET owner_id=excluded.owner_id;
--- read:
+-- read:
--- owner:
+-- owner:
-- publish.sql:
--- write:
+-- write:
INSERT INTO "q_payloads" (topic, payload)
VALUES (?, ?);
+ -- FIXME: must be inside a trnsaction
INSERT INTO "q_messages" (uuid, flow_id, payload_id)
VALUES (?, ?, last_insert_rowid());
--- read:
+-- read:
SELECT id, timestamp FROM "q_messages"
WHERE uuid = ?;
--- owner:
+-- owner:
-- find.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
"q_messages".id,
"q_messages".timestamp,
@@ -111,12 +112,12 @@
LIMIT 1;
--- owner:
+-- owner:
-- pending.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
"q_messages".id,
"q_messages".timestamp,
@@ -136,7 +137,7 @@
ORDER BY "q_messages".id ASC;
--- owner:
+-- owner:
SELECT owner_id FROM "q_owners"
WHERE
topic = ? AND
@@ -144,19 +145,19 @@
-- commit.sql:
--- write:
+-- write:
INSERT INTO "q_offsets" (consumer, message_id)
VALUES (?, (SELECT id FROM "q_messages" WHERE uuid = ?));
--- read:
+-- read:
SELECT "q_payloads".topic from "q_payloads"
JOIN "q_messages" ON
"q_payloads".id = "q_messages".payload_id
WHERE "q_messages".uuid = ?;
--- owner:
+-- owner:
SELECT owner_id FROM "q_owners"
WHERE
topic = ? AND
@@ -164,7 +165,7 @@
-- toDead.sql:
--- write:
+-- write:
INSERT INTO "q_offsets" ( consumer, message_id)
VALUES ( ?, (SELECT id FROM "q_messages" WHERE uuid = ?));
@@ -172,14 +173,14 @@
VALUES (?, ?, (SELECT id FROM "q_messages" WHERE uuid = ?));
--- read:
+-- read:
SELECT "q_payloads".topic FROM "q_payloads"
JOIN "q_messages" ON
"q_payloads".id = "q_messages".payload_id
WHERE "q_messages".uuid = ?;
--- owner:
+-- owner:
SELECT owner_id FROM "q_owners"
WHERE
topic = ? AND
@@ -187,7 +188,7 @@
-- replay.sql:
--- write:
+-- write:
INSERT INTO "q_messages" (uuid, flow_id, payload_id)
SELECT
?,
@@ -205,7 +206,7 @@
);
--- read:
+-- read:
SELECT
"q_messages".id,
"q_messages".timestamp,
@@ -218,12 +219,12 @@
WHERE "q_messages".uuid = ?;
--- owner:
+-- owner:
-- oneDead.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
"q_deadletters".uuid,
"q_offsets".timestamp,
@@ -246,12 +247,12 @@
LIMIT 1;
--- owner:
+-- owner:
-- allDead.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
"q_deadletters".uuid,
"q_deadletters".message_id,
@@ -279,12 +280,12 @@
ORDER BY "q_deadletters".id ASC;
--- owner:
+-- owner:
-- size.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
COUNT(1) as size
FROM "q_messages"
@@ -293,12 +294,12 @@
WHERE "q_payloads".topic = ?;
--- owner:
+-- owner:
-- count.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT
COUNT(1) as count
FROM "q_messages"
@@ -311,12 +312,12 @@
"q_offsets".consumer = ?;
--- owner:
+-- owner:
-- hasData.sql:
--- write:
+-- write:
--- read:
+-- read:
SELECT 1 as data
FROM "q_messages"
JOIN "q_payloads" ON
@@ -330,4 +331,4 @@
LIMIT 1;
--- owner:
+-- owner: