aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
Diffstat (limited to 'verify')
-rw-r--r--verify/items.sql3
-rw-r--r--verify/items@v1.0.0-alpha.1.sql16
2 files changed, 18 insertions, 1 deletions
diff --git a/verify/items.sql b/verify/items.sql
index 9a561cf..22a4ee3 100644
--- a/verify/items.sql
+++ b/verify/items.sql
@@ -9,7 +9,8 @@ SELECT id,
amount,
note,
created_at,
- updated_at
+ updated_at,
+ article_id
FROM kakeibo.items
WHERE FALSE;
diff --git a/verify/items@v1.0.0-alpha.1.sql b/verify/items@v1.0.0-alpha.1.sql
new file mode 100644
index 0000000..9a561cf
--- /dev/null
+++ b/verify/items@v1.0.0-alpha.1.sql
@@ -0,0 +1,16 @@
+-- Verify kakeibo:items on pg
+
+BEGIN;
+
+SELECT id,
+ transaction_id,
+ category,
+ subcategory,
+ amount,
+ note,
+ created_at,
+ updated_at
+ FROM kakeibo.items
+ WHERE FALSE;
+
+ROLLBACK;