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