From 70304b1903cc5b1accd9caea229e59901384203a Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Mar 2023 01:29:08 +0900 Subject: Add `kakeibo.` prefix. --- verify/articles.sql | 13 ------------- verify/articles_update_timestamp.sql | 14 -------------- verify/articles_update_timestamp@v1.0.0-alpha.3.sql | 14 -------------- verify/items.sql | 17 ----------------- verify/items@v1.0.0-alpha.1.sql | 16 ---------------- verify/items_update_timestamp.sql | 14 -------------- verify/items_update_timestamp@v1.0.0-alpha.3.sql | 14 -------------- verify/kakeibo.articles.sql | 13 +++++++++++++ verify/kakeibo.articles_update_timestamp.sql | 14 ++++++++++++++ ...kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql | 14 ++++++++++++++ verify/kakeibo.items.sql | 17 +++++++++++++++++ verify/kakeibo.items@v1.0.0-alpha.1.sql | 16 ++++++++++++++++ verify/kakeibo.items_update_timestamp.sql | 14 ++++++++++++++ .../kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql | 14 ++++++++++++++ verify/kakeibo.transaction_types.sql | 10 ++++++++++ verify/kakeibo.transactions.sql | 15 +++++++++++++++ verify/kakeibo.transactions@v1.0.0-alpha.1.sql | 14 ++++++++++++++ verify/kakeibo.transactions@v1.0.0-alpha.2.sql | 15 +++++++++++++++ verify/kakeibo.transactions_update_timestamp.sql | 14 ++++++++++++++ ...ibo.transactions_update_timestamp@v1.0.0-alpha.3.sql | 14 ++++++++++++++ verify/transaction_types.sql | 10 ---------- verify/transactions.sql | 15 --------------- verify/transactions@v1.0.0-alpha.1.sql | 14 -------------- verify/transactions@v1.0.0-alpha.2.sql | 15 --------------- verify/transactions_update_timestamp.sql | 14 -------------- verify/transactions_update_timestamp@v1.0.0-alpha.3.sql | 14 -------------- 26 files changed, 184 insertions(+), 184 deletions(-) delete mode 100644 verify/articles.sql delete mode 100644 verify/articles_update_timestamp.sql delete mode 100644 verify/articles_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 verify/items.sql delete mode 100644 verify/items@v1.0.0-alpha.1.sql delete mode 100644 verify/items_update_timestamp.sql delete mode 100644 verify/items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 verify/kakeibo.articles.sql create mode 100644 verify/kakeibo.articles_update_timestamp.sql create mode 100644 verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 verify/kakeibo.items.sql create mode 100644 verify/kakeibo.items@v1.0.0-alpha.1.sql create mode 100644 verify/kakeibo.items_update_timestamp.sql create mode 100644 verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 verify/kakeibo.transaction_types.sql create mode 100644 verify/kakeibo.transactions.sql create mode 100644 verify/kakeibo.transactions@v1.0.0-alpha.1.sql create mode 100644 verify/kakeibo.transactions@v1.0.0-alpha.2.sql create mode 100644 verify/kakeibo.transactions_update_timestamp.sql create mode 100644 verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 verify/transaction_types.sql delete mode 100644 verify/transactions.sql delete mode 100644 verify/transactions@v1.0.0-alpha.1.sql delete mode 100644 verify/transactions@v1.0.0-alpha.2.sql delete mode 100644 verify/transactions_update_timestamp.sql delete mode 100644 verify/transactions_update_timestamp@v1.0.0-alpha.3.sql (limited to 'verify') diff --git a/verify/articles.sql b/verify/articles.sql deleted file mode 100644 index 355d20f..0000000 --- a/verify/articles.sql +++ /dev/null @@ -1,13 +0,0 @@ --- Verify kakeibo:articles on pg - -BEGIN; - -SELECT id, - location, - title, - created_at, - updated_at - FROM kakeibo.articles - WHERE FALSE; - -ROLLBACK; diff --git a/verify/articles_update_timestamp.sql b/verify/articles_update_timestamp.sql deleted file mode 100644 index f1952b3..0000000 --- a/verify/articles_update_timestamp.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:articles_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'articles' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; diff --git a/verify/articles_update_timestamp@v1.0.0-alpha.3.sql b/verify/articles_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index f1952b3..0000000 --- a/verify/articles_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:articles_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'articles' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; diff --git a/verify/items.sql b/verify/items.sql deleted file mode 100644 index 22a4ee3..0000000 --- a/verify/items.sql +++ /dev/null @@ -1,17 +0,0 @@ --- 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; diff --git a/verify/items@v1.0.0-alpha.1.sql b/verify/items@v1.0.0-alpha.1.sql deleted file mode 100644 index 9a561cf..0000000 --- a/verify/items@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,16 +0,0 @@ --- Verify kakeibo:items on pg - -BEGIN; - -SELECT id, - transaction_id, - category, - subcategory, - amount, - note, - created_at, - updated_at - FROM kakeibo.items - WHERE FALSE; - -ROLLBACK; diff --git a/verify/items_update_timestamp.sql b/verify/items_update_timestamp.sql deleted file mode 100644 index c7fe432..0000000 --- a/verify/items_update_timestamp.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:items_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'transactions' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; diff --git a/verify/items_update_timestamp@v1.0.0-alpha.3.sql b/verify/items_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index c7fe432..0000000 --- a/verify/items_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:items_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'transactions' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; diff --git a/verify/kakeibo.articles.sql b/verify/kakeibo.articles.sql new file mode 100644 index 0000000..355d20f --- /dev/null +++ b/verify/kakeibo.articles.sql @@ -0,0 +1,13 @@ +-- Verify kakeibo:articles on pg + +BEGIN; + +SELECT id, + location, + title, + created_at, + updated_at + FROM kakeibo.articles + WHERE FALSE; + +ROLLBACK; diff --git a/verify/kakeibo.articles_update_timestamp.sql b/verify/kakeibo.articles_update_timestamp.sql new file mode 100644 index 0000000..f1952b3 --- /dev/null +++ b/verify/kakeibo.articles_update_timestamp.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:articles_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'articles' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; diff --git a/verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..f1952b3 --- /dev/null +++ b/verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:articles_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'articles' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; 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; diff --git a/verify/kakeibo.items@v1.0.0-alpha.1.sql b/verify/kakeibo.items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..9a561cf --- /dev/null +++ b/verify/kakeibo.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; diff --git a/verify/kakeibo.items_update_timestamp.sql b/verify/kakeibo.items_update_timestamp.sql new file mode 100644 index 0000000..c7fe432 --- /dev/null +++ b/verify/kakeibo.items_update_timestamp.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:items_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'transactions' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; diff --git a/verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..c7fe432 --- /dev/null +++ b/verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:items_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'transactions' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; diff --git a/verify/kakeibo.transaction_types.sql b/verify/kakeibo.transaction_types.sql new file mode 100644 index 0000000..49aa2f6 --- /dev/null +++ b/verify/kakeibo.transaction_types.sql @@ -0,0 +1,10 @@ +-- Verify kakeibo:transaction_types on pg + +BEGIN; + +SELECT code, + name + FROM kakeibo.transaction_types + WHERE FALSE; + +ROLLBACK; diff --git a/verify/kakeibo.transactions.sql b/verify/kakeibo.transactions.sql new file mode 100644 index 0000000..3f5b58f --- /dev/null +++ b/verify/kakeibo.transactions.sql @@ -0,0 +1,15 @@ +-- Verify kakeibo:transactions on pg + +BEGIN; + +SELECT id, + type_code, + date, + note, + created_at, + updated_at, + article_id + FROM kakeibo.transactions + WHERE FALSE; + +ROLLBACK; diff --git a/verify/kakeibo.transactions@v1.0.0-alpha.1.sql b/verify/kakeibo.transactions@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..0cc1b2d --- /dev/null +++ b/verify/kakeibo.transactions@v1.0.0-alpha.1.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:transactions on pg + +BEGIN; + +SELECT id, + type_code, + date, + note, + created_at, + updated_at + FROM kakeibo.transactions + WHERE FALSE; + +ROLLBACK; diff --git a/verify/kakeibo.transactions@v1.0.0-alpha.2.sql b/verify/kakeibo.transactions@v1.0.0-alpha.2.sql new file mode 100644 index 0000000..3f5b58f --- /dev/null +++ b/verify/kakeibo.transactions@v1.0.0-alpha.2.sql @@ -0,0 +1,15 @@ +-- Verify kakeibo:transactions on pg + +BEGIN; + +SELECT id, + type_code, + date, + note, + created_at, + updated_at, + article_id + FROM kakeibo.transactions + WHERE FALSE; + +ROLLBACK; diff --git a/verify/kakeibo.transactions_update_timestamp.sql b/verify/kakeibo.transactions_update_timestamp.sql new file mode 100644 index 0000000..50f348e --- /dev/null +++ b/verify/kakeibo.transactions_update_timestamp.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:transactions_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'transactions' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; diff --git a/verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..50f348e --- /dev/null +++ b/verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,14 @@ +-- Verify kakeibo:transactions_update_timestamp on pg + +BEGIN; + +DO $$ + BEGIN + ASSERT (SELECT 1 from information_schema.triggers + WHERE trigger_schema = 'kakeibo' + AND event_object_table = 'transactions' + AND trigger_name = 'update_timestamp'); + END +$$; + +ROLLBACK; diff --git a/verify/transaction_types.sql b/verify/transaction_types.sql deleted file mode 100644 index 49aa2f6..0000000 --- a/verify/transaction_types.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Verify kakeibo:transaction_types on pg - -BEGIN; - -SELECT code, - name - FROM kakeibo.transaction_types - WHERE FALSE; - -ROLLBACK; diff --git a/verify/transactions.sql b/verify/transactions.sql deleted file mode 100644 index 3f5b58f..0000000 --- a/verify/transactions.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Verify kakeibo:transactions on pg - -BEGIN; - -SELECT id, - type_code, - date, - note, - created_at, - updated_at, - article_id - FROM kakeibo.transactions - WHERE FALSE; - -ROLLBACK; diff --git a/verify/transactions@v1.0.0-alpha.1.sql b/verify/transactions@v1.0.0-alpha.1.sql deleted file mode 100644 index 0cc1b2d..0000000 --- a/verify/transactions@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:transactions on pg - -BEGIN; - -SELECT id, - type_code, - date, - note, - created_at, - updated_at - FROM kakeibo.transactions - WHERE FALSE; - -ROLLBACK; diff --git a/verify/transactions@v1.0.0-alpha.2.sql b/verify/transactions@v1.0.0-alpha.2.sql deleted file mode 100644 index 3f5b58f..0000000 --- a/verify/transactions@v1.0.0-alpha.2.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Verify kakeibo:transactions on pg - -BEGIN; - -SELECT id, - type_code, - date, - note, - created_at, - updated_at, - article_id - FROM kakeibo.transactions - WHERE FALSE; - -ROLLBACK; diff --git a/verify/transactions_update_timestamp.sql b/verify/transactions_update_timestamp.sql deleted file mode 100644 index 50f348e..0000000 --- a/verify/transactions_update_timestamp.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:transactions_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'transactions' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; diff --git a/verify/transactions_update_timestamp@v1.0.0-alpha.3.sql b/verify/transactions_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 50f348e..0000000 --- a/verify/transactions_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify kakeibo:transactions_update_timestamp on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'kakeibo' - AND event_object_table = 'transactions' - AND trigger_name = 'update_timestamp'); - END -$$; - -ROLLBACK; -- cgit v1.2.3