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. --- deploy/articles.sql | 14 ------------ deploy/articles_update_timestamp.sql | 12 ---------- .../articles_update_timestamp@v1.0.0-alpha.3.sql | 12 ---------- deploy/items.sql | 13 ----------- deploy/items@v1.0.0-alpha.1.sql | 18 --------------- deploy/items_update_timestamp.sql | 12 ---------- deploy/items_update_timestamp@v1.0.0-alpha.3.sql | 12 ---------- deploy/kakeibo.articles.sql | 14 ++++++++++++ deploy/kakeibo.articles_update_timestamp.sql | 12 ++++++++++ ...bo.articles_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++ deploy/kakeibo.items.sql | 13 +++++++++++ deploy/kakeibo.items@v1.0.0-alpha.1.sql | 18 +++++++++++++++ deploy/kakeibo.items_update_timestamp.sql | 12 ++++++++++ ...keibo.items_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++ deploy/kakeibo.transaction_types.sql | 12 ++++++++++ deploy/kakeibo.transactions.sql | 12 ++++++++++ deploy/kakeibo.transactions@v1.0.0-alpha.1.sql | 15 +++++++++++++ deploy/kakeibo.transactions@v1.0.0-alpha.2.sql | 12 ++++++++++ deploy/kakeibo.transactions_update_timestamp.sql | 12 ++++++++++ ...ransactions_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++ deploy/transaction_types.sql | 12 ---------- deploy/transactions.sql | 12 ---------- deploy/transactions@v1.0.0-alpha.1.sql | 15 ------------- deploy/transactions@v1.0.0-alpha.2.sql | 12 ---------- deploy/transactions_update_timestamp.sql | 12 ---------- ...ransactions_update_timestamp@v1.0.0-alpha.3.sql | 12 ---------- revert/articles.sql | 7 ------ revert/articles_update_timestamp.sql | 12 ---------- .../articles_update_timestamp@v1.0.0-alpha.3.sql | 7 ------ revert/items.sql | 10 --------- revert/items@v1.0.0-alpha.1.sql | 7 ------ revert/items_update_timestamp.sql | 12 ---------- revert/items_update_timestamp@v1.0.0-alpha.3.sql | 7 ------ revert/kakeibo.articles.sql | 7 ++++++ revert/kakeibo.articles_update_timestamp.sql | 12 ++++++++++ ...bo.articles_update_timestamp@v1.0.0-alpha.3.sql | 7 ++++++ revert/kakeibo.items.sql | 10 +++++++++ revert/kakeibo.items@v1.0.0-alpha.1.sql | 7 ++++++ revert/kakeibo.items_update_timestamp.sql | 12 ++++++++++ ...keibo.items_update_timestamp@v1.0.0-alpha.3.sql | 7 ++++++ revert/kakeibo.transaction_types.sql | 7 ++++++ revert/kakeibo.transactions.sql | 8 +++++++ revert/kakeibo.transactions@v1.0.0-alpha.1.sql | 7 ++++++ revert/kakeibo.transactions@v1.0.0-alpha.2.sql | 8 +++++++ revert/kakeibo.transactions_update_timestamp.sql | 12 ++++++++++ ...ransactions_update_timestamp@v1.0.0-alpha.3.sql | 7 ++++++ revert/transaction_types.sql | 7 ------ revert/transactions.sql | 8 ------- revert/transactions@v1.0.0-alpha.1.sql | 7 ------ revert/transactions@v1.0.0-alpha.2.sql | 8 ------- revert/transactions_update_timestamp.sql | 12 ---------- ...ransactions_update_timestamp@v1.0.0-alpha.3.sql | 7 ------ sqitch.plan | 26 +++++++++++----------- verify/articles.sql | 13 ----------- verify/articles_update_timestamp.sql | 14 ------------ .../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 ++++++++++++ ...bo.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 ++++++++++++ ...keibo.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 ++++++++++++ ...ransactions_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 ------------ ...ransactions_update_timestamp@v1.0.0-alpha.3.sql | 14 ------------ 79 files changed, 476 insertions(+), 476 deletions(-) delete mode 100644 deploy/articles.sql delete mode 100644 deploy/articles_update_timestamp.sql delete mode 100644 deploy/articles_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 deploy/items.sql delete mode 100644 deploy/items@v1.0.0-alpha.1.sql delete mode 100644 deploy/items_update_timestamp.sql delete mode 100644 deploy/items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.articles.sql create mode 100644 deploy/kakeibo.articles_update_timestamp.sql create mode 100644 deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.items.sql create mode 100644 deploy/kakeibo.items@v1.0.0-alpha.1.sql create mode 100644 deploy/kakeibo.items_update_timestamp.sql create mode 100644 deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.transaction_types.sql create mode 100644 deploy/kakeibo.transactions.sql create mode 100644 deploy/kakeibo.transactions@v1.0.0-alpha.1.sql create mode 100644 deploy/kakeibo.transactions@v1.0.0-alpha.2.sql create mode 100644 deploy/kakeibo.transactions_update_timestamp.sql create mode 100644 deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 deploy/transaction_types.sql delete mode 100644 deploy/transactions.sql delete mode 100644 deploy/transactions@v1.0.0-alpha.1.sql delete mode 100644 deploy/transactions@v1.0.0-alpha.2.sql delete mode 100644 deploy/transactions_update_timestamp.sql delete mode 100644 deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 revert/articles.sql delete mode 100644 revert/articles_update_timestamp.sql delete mode 100644 revert/articles_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 revert/items.sql delete mode 100644 revert/items@v1.0.0-alpha.1.sql delete mode 100644 revert/items_update_timestamp.sql delete mode 100644 revert/items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.articles.sql create mode 100644 revert/kakeibo.articles_update_timestamp.sql create mode 100644 revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.items.sql create mode 100644 revert/kakeibo.items@v1.0.0-alpha.1.sql create mode 100644 revert/kakeibo.items_update_timestamp.sql create mode 100644 revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.transaction_types.sql create mode 100644 revert/kakeibo.transactions.sql create mode 100644 revert/kakeibo.transactions@v1.0.0-alpha.1.sql create mode 100644 revert/kakeibo.transactions@v1.0.0-alpha.2.sql create mode 100644 revert/kakeibo.transactions_update_timestamp.sql create mode 100644 revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 revert/transaction_types.sql delete mode 100644 revert/transactions.sql delete mode 100644 revert/transactions@v1.0.0-alpha.1.sql delete mode 100644 revert/transactions@v1.0.0-alpha.2.sql delete mode 100644 revert/transactions_update_timestamp.sql delete mode 100644 revert/transactions_update_timestamp@v1.0.0-alpha.3.sql 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 diff --git a/deploy/articles.sql b/deploy/articles.sql deleted file mode 100644 index 08fcb5e..0000000 --- a/deploy/articles.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Deploy kakeibo:articles to pg --- requires: schema - -BEGIN; - -CREATE TABLE kakeibo.articles ( - id SERIAL PRIMARY KEY, - location TEXT UNIQUE, - title TEXT NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/articles_update_timestamp.sql b/deploy/articles_update_timestamp.sql deleted file mode 100644 index 239d80a..0000000 --- a/deploy/articles_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:articles_update_timestamp to pg --- requires: articles --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.articles - FOR EACH ROW - EXECUTE FUNCTION common.update_timestamp(); - -COMMIT; diff --git a/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql b/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 56e4503..0000000 --- a/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:articles_update_timestamp to pg --- requires: articles --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.articles - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/deploy/items.sql b/deploy/items.sql deleted file mode 100644 index d95fbf5..0000000 --- a/deploy/items.sql +++ /dev/null @@ -1,13 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions --- requires: articles - -BEGIN; - -ALTER TABLE kakeibo.items - ADD COLUMN article_id INTEGER, - ADD CONSTRAINT transactions_article_id_fkey - FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id); - -COMMIT; diff --git a/deploy/items@v1.0.0-alpha.1.sql b/deploy/items@v1.0.0-alpha.1.sql deleted file mode 100644 index 0a43f8b..0000000 --- a/deploy/items@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,18 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions - -BEGIN; - -CREATE TABLE kakeibo.items ( - id SERIAL PRIMARY KEY, - transaction_id INTEGER NOT NULL REFERENCES kakeibo.transactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT, - category TEXT NOT NULL, - subcategory TEXT CHECK (note <> ''), - amount INTEGER NOT NULL CHECK (amount > 0), - note TEXT CHECK (note <> '') , - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/items_update_timestamp.sql b/deploy/items_update_timestamp.sql deleted file mode 100644 index d389f8f..0000000 --- a/deploy/items_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:items_update_timestamp to pg --- requires: items --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.items - FOR EACH ROW - EXECUTE FUNCTION common.update_timestamp(); - -COMMIT; diff --git a/deploy/items_update_timestamp@v1.0.0-alpha.3.sql b/deploy/items_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index f9258b2..0000000 --- a/deploy/items_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:items_update_timestamp to pg --- requires: items --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.items - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/deploy/kakeibo.articles.sql b/deploy/kakeibo.articles.sql new file mode 100644 index 0000000..08fcb5e --- /dev/null +++ b/deploy/kakeibo.articles.sql @@ -0,0 +1,14 @@ +-- Deploy kakeibo:articles to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.articles ( + id SERIAL PRIMARY KEY, + location TEXT UNIQUE, + title TEXT NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.articles_update_timestamp.sql b/deploy/kakeibo.articles_update_timestamp.sql new file mode 100644 index 0000000..239d80a --- /dev/null +++ b/deploy/kakeibo.articles_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:articles_update_timestamp to pg +-- requires: articles +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.articles + FOR EACH ROW + EXECUTE FUNCTION common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..56e4503 --- /dev/null +++ b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:articles_update_timestamp to pg +-- requires: articles +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.articles + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.items.sql b/deploy/kakeibo.items.sql new file mode 100644 index 0000000..d95fbf5 --- /dev/null +++ b/deploy/kakeibo.items.sql @@ -0,0 +1,13 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions +-- requires: articles + +BEGIN; + +ALTER TABLE kakeibo.items + ADD COLUMN article_id INTEGER, + ADD CONSTRAINT transactions_article_id_fkey + FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id); + +COMMIT; diff --git a/deploy/kakeibo.items@v1.0.0-alpha.1.sql b/deploy/kakeibo.items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..0a43f8b --- /dev/null +++ b/deploy/kakeibo.items@v1.0.0-alpha.1.sql @@ -0,0 +1,18 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions + +BEGIN; + +CREATE TABLE kakeibo.items ( + id SERIAL PRIMARY KEY, + transaction_id INTEGER NOT NULL REFERENCES kakeibo.transactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT, + category TEXT NOT NULL, + subcategory TEXT CHECK (note <> ''), + amount INTEGER NOT NULL CHECK (amount > 0), + note TEXT CHECK (note <> '') , + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.items_update_timestamp.sql b/deploy/kakeibo.items_update_timestamp.sql new file mode 100644 index 0000000..d389f8f --- /dev/null +++ b/deploy/kakeibo.items_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:items_update_timestamp to pg +-- requires: items +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.items + FOR EACH ROW + EXECUTE FUNCTION common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..f9258b2 --- /dev/null +++ b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:items_update_timestamp to pg +-- requires: items +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.items + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.transaction_types.sql b/deploy/kakeibo.transaction_types.sql new file mode 100644 index 0000000..cf07925 --- /dev/null +++ b/deploy/kakeibo.transaction_types.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transaction_types to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.transaction_types ( + code INTEGER PRIMARY KEY, + name TEXT NOT NULL +); +INSERT INTO kakeibo.transaction_types VALUES (0, 'outgo'), (1, 'income'); + +COMMIT; diff --git a/deploy/kakeibo.transactions.sql b/deploy/kakeibo.transactions.sql new file mode 100644 index 0000000..3a4585a --- /dev/null +++ b/deploy/kakeibo.transactions.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions to pg +-- requires: schema +-- requires: articles + +BEGIN; + +ALTER TABLE kakeibo.transactions + ADD CONSTRAINT transactions_type_code_fkey + FOREIGN KEY (type_code) + REFERENCES kakeibo.transaction_types (code); + +COMMIT; diff --git a/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..e37b276 --- /dev/null +++ b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql @@ -0,0 +1,15 @@ +-- Deploy kakeibo:transactions to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.transactions ( + id SERIAL PRIMARY KEY, + type_code INTEGER, + date DATE NOT NULL, + note TEXT, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql new file mode 100644 index 0000000..0572a23 --- /dev/null +++ b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions to pg +-- requires: schema +-- requires: articles + +BEGIN; + +ALTER TABLE kakeibo.transactions + ADD COLUMN article_id INTEGER, + ADD CONSTRAINT transactions_article_id_fkey + FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id); + +COMMIT; diff --git a/deploy/kakeibo.transactions_update_timestamp.sql b/deploy/kakeibo.transactions_update_timestamp.sql new file mode 100644 index 0000000..74ccee5 --- /dev/null +++ b/deploy/kakeibo.transactions_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions_update_timestamp to pg +-- requires: transactions +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.transactions + FOR EACH ROW + EXECUTE FUNCTION common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..23c126a --- /dev/null +++ b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions_update_timestamp to pg +-- requires: transactions +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.transactions + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/deploy/transaction_types.sql b/deploy/transaction_types.sql deleted file mode 100644 index cf07925..0000000 --- a/deploy/transaction_types.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transaction_types to pg --- requires: schema - -BEGIN; - -CREATE TABLE kakeibo.transaction_types ( - code INTEGER PRIMARY KEY, - name TEXT NOT NULL -); -INSERT INTO kakeibo.transaction_types VALUES (0, 'outgo'), (1, 'income'); - -COMMIT; diff --git a/deploy/transactions.sql b/deploy/transactions.sql deleted file mode 100644 index 3a4585a..0000000 --- a/deploy/transactions.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions to pg --- requires: schema --- requires: articles - -BEGIN; - -ALTER TABLE kakeibo.transactions - ADD CONSTRAINT transactions_type_code_fkey - FOREIGN KEY (type_code) - REFERENCES kakeibo.transaction_types (code); - -COMMIT; diff --git a/deploy/transactions@v1.0.0-alpha.1.sql b/deploy/transactions@v1.0.0-alpha.1.sql deleted file mode 100644 index e37b276..0000000 --- a/deploy/transactions@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Deploy kakeibo:transactions to pg --- requires: schema - -BEGIN; - -CREATE TABLE kakeibo.transactions ( - id SERIAL PRIMARY KEY, - type_code INTEGER, - date DATE NOT NULL, - note TEXT, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/transactions@v1.0.0-alpha.2.sql b/deploy/transactions@v1.0.0-alpha.2.sql deleted file mode 100644 index 0572a23..0000000 --- a/deploy/transactions@v1.0.0-alpha.2.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions to pg --- requires: schema --- requires: articles - -BEGIN; - -ALTER TABLE kakeibo.transactions - ADD COLUMN article_id INTEGER, - ADD CONSTRAINT transactions_article_id_fkey - FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id); - -COMMIT; diff --git a/deploy/transactions_update_timestamp.sql b/deploy/transactions_update_timestamp.sql deleted file mode 100644 index 74ccee5..0000000 --- a/deploy/transactions_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions_update_timestamp to pg --- requires: transactions --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.transactions - FOR EACH ROW - EXECUTE FUNCTION common.update_timestamp(); - -COMMIT; diff --git a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql b/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 23c126a..0000000 --- a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions_update_timestamp to pg --- requires: transactions --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.transactions - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/articles.sql b/revert/articles.sql deleted file mode 100644 index d5177d1..0000000 --- a/revert/articles.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:articles from pg - -BEGIN; - -DROP TABLE kakeibo.articles; - -COMMIT; diff --git a/revert/articles_update_timestamp.sql b/revert/articles_update_timestamp.sql deleted file mode 100644 index 56e4503..0000000 --- a/revert/articles_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:articles_update_timestamp to pg --- requires: articles --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.articles - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql b/revert/articles_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 3ce73d1..0000000 --- a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:articles_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.articles; - -COMMIT; diff --git a/revert/items.sql b/revert/items.sql deleted file mode 100644 index c8cbcd5..0000000 --- a/revert/items.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions - -BEGIN; - -ALTER TABLE kakeibo.items - DROP COLUMN article_id; - -COMMIT; diff --git a/revert/items@v1.0.0-alpha.1.sql b/revert/items@v1.0.0-alpha.1.sql deleted file mode 100644 index b36bf6b..0000000 --- a/revert/items@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:items from pg - -BEGIN; - -DROP TABLE kakeibo.items; - -COMMIT; diff --git a/revert/items_update_timestamp.sql b/revert/items_update_timestamp.sql deleted file mode 100644 index f9258b2..0000000 --- a/revert/items_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:items_update_timestamp to pg --- requires: items --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.items - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/items_update_timestamp@v1.0.0-alpha.3.sql b/revert/items_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 52ce12f..0000000 --- a/revert/items_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:items_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.items; - -COMMIT; diff --git a/revert/kakeibo.articles.sql b/revert/kakeibo.articles.sql new file mode 100644 index 0000000..d5177d1 --- /dev/null +++ b/revert/kakeibo.articles.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:articles from pg + +BEGIN; + +DROP TABLE kakeibo.articles; + +COMMIT; diff --git a/revert/kakeibo.articles_update_timestamp.sql b/revert/kakeibo.articles_update_timestamp.sql new file mode 100644 index 0000000..56e4503 --- /dev/null +++ b/revert/kakeibo.articles_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:articles_update_timestamp to pg +-- requires: articles +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.articles + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..3ce73d1 --- /dev/null +++ b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:articles_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.articles; + +COMMIT; diff --git a/revert/kakeibo.items.sql b/revert/kakeibo.items.sql new file mode 100644 index 0000000..c8cbcd5 --- /dev/null +++ b/revert/kakeibo.items.sql @@ -0,0 +1,10 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions + +BEGIN; + +ALTER TABLE kakeibo.items + DROP COLUMN article_id; + +COMMIT; diff --git a/revert/kakeibo.items@v1.0.0-alpha.1.sql b/revert/kakeibo.items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..b36bf6b --- /dev/null +++ b/revert/kakeibo.items@v1.0.0-alpha.1.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:items from pg + +BEGIN; + +DROP TABLE kakeibo.items; + +COMMIT; diff --git a/revert/kakeibo.items_update_timestamp.sql b/revert/kakeibo.items_update_timestamp.sql new file mode 100644 index 0000000..f9258b2 --- /dev/null +++ b/revert/kakeibo.items_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:items_update_timestamp to pg +-- requires: items +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.items + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..52ce12f --- /dev/null +++ b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:items_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.items; + +COMMIT; diff --git a/revert/kakeibo.transaction_types.sql b/revert/kakeibo.transaction_types.sql new file mode 100644 index 0000000..48df263 --- /dev/null +++ b/revert/kakeibo.transaction_types.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:transaction_types from pg + +BEGIN; + +DROP TABLE kakeibo.transaction_types; + +COMMIT; diff --git a/revert/kakeibo.transactions.sql b/revert/kakeibo.transactions.sql new file mode 100644 index 0000000..c424cc1 --- /dev/null +++ b/revert/kakeibo.transactions.sql @@ -0,0 +1,8 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +ALTER TABLE kakeibo.transactions + DROP CONSTRAINT transactions_type_code_fkey; + +COMMIT; diff --git a/revert/kakeibo.transactions@v1.0.0-alpha.1.sql b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..835ff3d --- /dev/null +++ b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +DROP TABLE kakeibo.transactions; + +COMMIT; diff --git a/revert/kakeibo.transactions@v1.0.0-alpha.2.sql b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql new file mode 100644 index 0000000..d30390a --- /dev/null +++ b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql @@ -0,0 +1,8 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +ALTER TABLE kakeibo.transactions + DROP COLUMN article_id; + +COMMIT; diff --git a/revert/kakeibo.transactions_update_timestamp.sql b/revert/kakeibo.transactions_update_timestamp.sql new file mode 100644 index 0000000..23c126a --- /dev/null +++ b/revert/kakeibo.transactions_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions_update_timestamp to pg +-- requires: transactions +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.transactions + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..c9bee8f --- /dev/null +++ b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:transactions_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.transactions; + +COMMIT; diff --git a/revert/transaction_types.sql b/revert/transaction_types.sql deleted file mode 100644 index 48df263..0000000 --- a/revert/transaction_types.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:transaction_types from pg - -BEGIN; - -DROP TABLE kakeibo.transaction_types; - -COMMIT; diff --git a/revert/transactions.sql b/revert/transactions.sql deleted file mode 100644 index c424cc1..0000000 --- a/revert/transactions.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Revert kakeibo:transactions from pg - -BEGIN; - -ALTER TABLE kakeibo.transactions - DROP CONSTRAINT transactions_type_code_fkey; - -COMMIT; diff --git a/revert/transactions@v1.0.0-alpha.1.sql b/revert/transactions@v1.0.0-alpha.1.sql deleted file mode 100644 index 835ff3d..0000000 --- a/revert/transactions@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:transactions from pg - -BEGIN; - -DROP TABLE kakeibo.transactions; - -COMMIT; diff --git a/revert/transactions@v1.0.0-alpha.2.sql b/revert/transactions@v1.0.0-alpha.2.sql deleted file mode 100644 index d30390a..0000000 --- a/revert/transactions@v1.0.0-alpha.2.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Revert kakeibo:transactions from pg - -BEGIN; - -ALTER TABLE kakeibo.transactions - DROP COLUMN article_id; - -COMMIT; diff --git a/revert/transactions_update_timestamp.sql b/revert/transactions_update_timestamp.sql deleted file mode 100644 index 23c126a..0000000 --- a/revert/transactions_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions_update_timestamp to pg --- requires: transactions --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.transactions - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql b/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index c9bee8f..0000000 --- a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:transactions_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.transactions; - -COMMIT; diff --git a/sqitch.plan b/sqitch.plan index 2ef8efd..3d51e33 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -3,27 +3,27 @@ %uri=https://git.tojo.tokyo/life-archive.git kakeibo 2023-03-11T15:56:41Z Masaya Tojo # Add schema for use in kakeibo. -transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo # Add table for tracking transactions. -items [kakeibo transactions] 2023-03-12T04:48:30Z Masaya Tojo # Add table for tracking items. +kakeibo.transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo # Add table for tracking transactions. +kakeibo.items [kakeibo kakeibo.transactions] 2023-03-12T04:48:30Z Masaya Tojo # Add table for tracking items. update_timestamp [kakeibo] 2023-03-12T13:57:49Z Masaya Tojo # Add function to update timestamp. -transactions_update_timestamp [transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo # Add update_timestamp trigger to transactions table. -items_update_timestamp [items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo # Add update_timestamp trigger to items table. +kakeibo.transactions_update_timestamp [kakeibo.transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo # Add update_timestamp trigger to transactions table. +kakeibo.items_update_timestamp [kakeibo.items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo # Add update_timestamp trigger to items table. @v1.0.0-alpha.1 2023-03-12T14:21:52Z Masaya Tojo # Tag v1.0.0-alpha.1. -articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo # Add table to manage articles. -transactions [transactions@v1.0.0-alpha.1 articles] 2023-03-12T15:06:03Z Masaya Tojo # Add article_id column to transactions table. -items [items@v1.0.0-alpha.1 articles] 2023-03-12T15:12:15Z Masaya Tojo # Add article_id column to items table. +kakeibo.articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo # Add table to manage articles. +kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:06:03Z Masaya Tojo # Add article_id column to transactions table. +kakeibo.items [kakeibo.items@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:12:15Z Masaya Tojo # Add article_id column to items table. @v1.0.0-alpha.2 2023-03-12T15:18:49Z Masaya Tojo # Tag v1.0.0-alpha.2. -transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo # Add table to manage transaction type codes. -articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo # Add update_timestamp trigger to articles table. -transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo # Add foreign key constraint to transactions table referencing types table. +kakeibo.transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo # Add table to manage transaction type codes. +kakeibo.articles_update_timestamp [kakeibo.articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo # Add update_timestamp trigger to articles table. +kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.2 kakeibo.articles] 2023-03-12T15:42:06Z Masaya Tojo # Add foreign key constraint to transactions table referencing types table. common 2023-03-27T15:01:06Z Masaya Tojo # Add common schema. update_timestamp [update_timestamp@v1.0.0-alpha.2] 2023-03-27T15:03:00Z Masaya Tojo # Add update_timestamp to common schema. @v1.0.0-alpha.3 2023-03-27T15:07:33Z Masaya Tojo # Tag v1.0.0-alpha.3. -articles_update_timestamp [articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. -items_update_timestamp [items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. -transactions_update_timestamp [transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. +kakeibo.articles_update_timestamp [kakeibo.articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. +kakeibo.items_update_timestamp [kakeibo.items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. +kakeibo.transactions_update_timestamp [kakeibo.transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. update_timestamp [update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:18:34Z Masaya Tojo # Drop kakeibo.update_timestamp. photo 2023-03-27T15:39:16Z Masaya Tojo # Add photo schema. photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo # Add table for tracking photos. 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