[libeufin] branch master updated: Deleting obsolete Sandbox SQL files.

[gnunet]

This is an automated email from the git hooks/post-receive script.

ms pushed a commit to branch master
in repository libeufin.

The following commit(s) were added to refs/heads/master by this push:
     new 411a194c Deleting obsolete Sandbox SQL files.
411a194c is described below

commit 411a194c924947c3ebb7f0ec9da17abb05291f65
Author: MS <ms@taler.net>
AuthorDate: Mon Sep 11 15:43:34 2023 +0200

    Deleting obsolete Sandbox SQL files.
    
    Warning about obsolete Nexus SQL.
---
 contrib/libeufin-load-sql                       |   9 +-
 database-versioning/new/nexus-0001-refactor.sql |   3 +
 database-versioning/nexus-0001.sql              |   3 +
 database-versioning/sandbox-0001.sql            | 253 ------------------------
 database-versioning/sandbox-drop.sql            |  30 ---
 5 files changed, 10 insertions(+), 288 deletions(-)

diff --git a/contrib/libeufin-load-sql b/contrib/libeufin-load-sql
index 963ad22e..8a0f39de 100755
--- a/contrib/libeufin-load-sql
+++ b/contrib/libeufin-load-sql
@@ -1,9 +1,10 @@
 #!/bin/bash
 
-set -eu
+# NOTE: THIS FILE CONSIDERS _ONLY_ THE OBSOLETE NEXUS
+# SQL FILES.  THIS FILE WILL BE DISCARDED AS SOON AS NEXUS
+# WILL GET ITS SQL REFACTORED.
 
-# The only CLI argument is 'nexus' or 'sandbox',
-# indicating which service will get its database prepared.
+set -eu
 
 fail () {
   echo $1
@@ -108,11 +109,9 @@ run_sql_file $(get_patch_path "versioning.sql")
 if test -z "${SERVICE:-}"; then # impact both services.
   # Maybe drop.
   if test "${DROP:-}" = "YES"; then
-    run_sql_file $(get_patch_path "sandbox-drop.sql")
     run_sql_file $(get_patch_path "nexus-drop.sql")
     exit 0
   fi
-  iterate_over_patches sandbox
   iterate_over_patches nexus
   exit 0
 fi
diff --git a/database-versioning/new/nexus-0001-refactor.sql 
b/database-versioning/new/nexus-0001-refactor.sql
index e2a66182..92c6f947 100644
--- a/database-versioning/new/nexus-0001-refactor.sql
+++ b/database-versioning/new/nexus-0001-refactor.sql
@@ -1,3 +1,6 @@
+-- NOTE: REFACTORING IN PROGRESS IN THIS FILE.  THIS
+-- FILE IS NOT EMPLOYED YET.
+
 --
 -- This file is part of TALER
 -- Copyright (C) 2023 Taler Systems SA
diff --git a/database-versioning/nexus-0001.sql 
b/database-versioning/nexus-0001.sql
index 00197265..7ba9e269 100644
--- a/database-versioning/nexus-0001.sql
+++ b/database-versioning/nexus-0001.sql
@@ -1,3 +1,6 @@
+-- NOTE: SOON TO BE OBSOLETED VERSION.
+-- NOTE REFER TO THE new/ SUBFOLDER TO REFACTOR NEXUS SQL FILES.
+
 -- Compatible with LibEuFin version: 1fe2687aaf696c8566367fe7ed082f1d78e6b78d
 
 BEGIN;
diff --git a/database-versioning/sandbox-0001.sql 
b/database-versioning/sandbox-0001.sql
deleted file mode 100644
index 7fa9bbd7..00000000
--- a/database-versioning/sandbox-0001.sql
+++ /dev/null
@@ -1,253 +0,0 @@
--- Compatible with LibEuFin version: 1fe2687aaf696c8566367fe7ed082f1d78e6b78d
-
-BEGIN;
-
-SELECT _v.register_patch('sandbox-0001', NULL, NULL);
-
-CREATE TABLE IF NOT EXISTS demobankconfigs 
-  (id BIGSERIAL PRIMARY KEY
-  ,hostname TEXT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS bankaccounts 
-  (id SERIAL PRIMARY KEY
-  ,iban TEXT NOT NULL
-  ,bic TEXT DEFAULT 'SANDBOXX' NOT NULL
-  ,"label" TEXT NOT NULL
-  ,"owner" TEXT NOT NULL
-  ,"isPublic" BOOLEAN DEFAULT false NOT NULL
-  ,"demoBank" BIGINT NOT NULL
-  ,"lastTransaction" BIGINT NULL
-  ,"lastFiatSubmission" BIGINT NULL
-  ,"lastFiatFetch" TEXT DEFAULT '0' NOT NULL
-  );
-
-ALTER TABLE
-  bankaccounts ADD CONSTRAINT accountLabelIndex UNIQUE ("label");
-
-ALTER TABLE
-  bankaccounts ADD COLUMN balance TEXT DEFAULT ('0');
-
-CREATE TABLE IF NOT EXISTS bankaccounttransactions 
-  (id BIGSERIAL PRIMARY KEY
-  ,"creditorIban" TEXT NOT NULL
-  ,"creditorBic" TEXT NULL
-  ,"creditorName" TEXT NOT NULL
-  ,"debtorIban" TEXT NOT NULL
-  ,"debtorBic" TEXT NULL
-  ,"debtorName" TEXT NOT NULL
-  ,subject TEXT NOT NULL
-  ,amount TEXT NOT NULL
-  ,currency TEXT NOT NULL
-  ,"date" BIGINT NOT NULL
-  ,"accountServicerReference" TEXT NOT NULL
-  ,"pmtInfId" TEXT NULL
-  ,"EndToEndId" TEXT NULL
-  ,direction TEXT NOT NULL
-  ,account INT NOT NULL
-  ,demobank BIGINT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS cashoutsubmissions 
-  (id BIGSERIAL PRIMARY KEY
-  ,"localTransaction" BIGINT NOT NULL
-  ,"maybeNexusResponse" TEXT NULL
-  ,"submissionTime" BIGINT NULL
-  );
-
-ALTER TABLE
-  cashoutsubmissions ADD CONSTRAINT cashoutsubmissions_localtransaction_unique 
UNIQUE ("localTransaction");
-
-CREATE TABLE IF NOT EXISTS demobankconfigpairs 
-  (id BIGSERIAL PRIMARY KEY
-  ,"demobankName" TEXT NOT NULL
-  ,"configKey" TEXT NOT NULL
-  ,"configValue" TEXT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicssubscribers 
-  (id SERIAL PRIMARY KEY
-  ,"userID" TEXT NOT NULL
-  ,"partnerID" TEXT NOT NULL
-  ,"systemID" TEXT NULL
-  ,"hostID" TEXT NOT NULL
-  ,"signatureKey" INT NULL
-  ,"encryptionKey" INT NULL
-  ,"authorizationKey" INT NULL
-  ,"nextOrderID" INT NOT NULL
-  ,"state" INT NOT NULL
-  ,"bankAccount" INT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicssubscriberpublickeys
-  (id SERIAL PRIMARY KEY
-   ,"rsaPublicKey" bytea NOT NULL
-   ,"state" INT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicshosts 
-  (id SERIAL PRIMARY KEY
-  ,"hostID" TEXT NOT NULL
-  ,"ebicsVersion" TEXT NOT NULL
-  ,"signaturePrivateKey" bytea NOT NULL
-  ,"encryptionPrivateKey" bytea NOT NULL
-  ,"authenticationPrivateKey" bytea NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicsdownloadtransactions 
-  ("transactionID" TEXT NOT NULL
-  ,"orderType" TEXT NOT NULL
-  ,host INT NOT NULL
-  ,subscriber INT NOT NULL
-  ,"encodedResponse" TEXT NOT NULL
-  ,"transactionKeyEnc" bytea NOT NULL
-  ,"numSegments" INT NOT NULL
-  ,"segmentSize" INT NOT NULL
-  ,"receiptReceived" BOOLEAN NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicsuploadtransactions 
-  ("transactionID" TEXT NOT NULL
-  ,"orderType" TEXT NOT NULL
-  ,"orderID" TEXT NOT NULL
-  ,host INT NOT NULL
-  ,subscriber INT NOT NULL
-  ,"numSegments" INT NOT NULL
-  ,"lastSeenSegment" INT NOT NULL
-  ,"transactionKeyEnc" bytea NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicsuploadtransactionchunks 
-  ("transactionID" TEXT NOT NULL
-  ,"chunkIndex" INT NOT NULL
-  ,"chunkContent" bytea NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS ebicsordersignatures 
-  (id SERIAL PRIMARY KEY
-  ,"orderID" TEXT NOT NULL
-  ,"orderType" TEXT NOT NULL
-  ,"partnerID" TEXT NOT NULL
-  ,"userID" TEXT NOT NULL
-  ,"signatureAlgorithm" TEXT NOT NULL
-  ,"signatureValue" bytea NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS bankaccountfreshtransactions 
-  (id BIGSERIAL PRIMARY KEY
-  ,"transaction" BIGINT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS bankaccountreports 
-  (id SERIAL PRIMARY KEY
-  ,"reportId" TEXT NOT NULL
-  ,"creationTime" BIGINT NOT NULL
-  ,"xmlMessage" TEXT NOT NULL
-  ,"bankAccount" INT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS bankaccountstatements 
-  (id SERIAL PRIMARY KEY
-  ,"statementId" TEXT NOT NULL
-  ,"creationTime" BIGINT NOT NULL
-  ,"xmlMessage" TEXT NOT NULL
-  ,"bankAccount" INT NOT NULL
-  ,"balanceClbd" TEXT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS talerwithdrawals 
-  (id BIGSERIAL PRIMARY KEY
-  ,wopid uuid NOT NULL
-  ,amount TEXT NOT NULL
-  ,"selectionDone" BOOLEAN DEFAULT false NOT NULL
-  ,aborted BOOLEAN DEFAULT false NOT NULL
-  ,"confirmationDone" BOOLEAN DEFAULT false NOT NULL
-  ,"reservePub" TEXT NULL
-  ,"selectedExchangePayto" TEXT NULL
-  ,"walletBankAccount" INT NOT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS demobankcustomers 
-  (id BIGSERIAL PRIMARY KEY
-  ,username TEXT NOT NULL
-  ,"passwordHash" TEXT NOT NULL
-  ,"name" TEXT NULL
-  ,email TEXT NULL
-  ,phone TEXT NULL
-  ,cashout_address TEXT NULL
-  );
-
-CREATE TABLE IF NOT EXISTS cashoutoperations 
-  (id BIGSERIAL PRIMARY KEY
-  ,uuid uuid NOT NULL
-  ,"amountDebit" TEXT NOT NULL
-  ,"amountCredit" TEXT NOT NULL
-  ,"buyAtRatio" TEXT NOT NULL
-  ,"buyInFee" TEXT NOT NULL
-  ,"sellAtRatio" TEXT NOT NULL
-  ,"sellOutFee" TEXT NOT NULL
-  ,subject TEXT NOT NULL
-  ,"creationTime" BIGINT NOT NULL
-  ,"confirmationTime" BIGINT NULL
-  ,"tanChannel" INT NOT NULL
-  ,account TEXT NOT NULL
-  ,"cashoutAddress" TEXT NOT NULL
-  ,tan TEXT NOT NULL
-  ,status INT DEFAULT 1 NOT NULL
-  );
-
-ALTER TABLE
-  bankaccounts ADD CONSTRAINT fk_bankaccounts_demobank_id FOREIGN KEY 
("demoBank") REFERENCES demobankconfigs(id) ON DELETE RESTRICT ON UPDATE 
RESTRICT;
-
-ALTER TABLE
-  bankaccounts ADD CONSTRAINT fk_bankaccounts_lasttransaction_id FOREIGN KEY 
("lastTransaction") REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT 
ON UPDATE RESTRICT;
-
-ALTER TABLE
-  bankaccounts ADD CONSTRAINT fk_bankaccounts_lastfiatsubmission_id FOREIGN 
KEY ("lastFiatSubmission") REFERENCES bankaccounttransactions(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  bankaccounttransactions ADD CONSTRAINT fk_bankaccounttransactions_account_id 
FOREIGN KEY (account) REFERENCES bankaccounts(id) ON DELETE CASCADE ON UPDATE 
RESTRICT;
-
-ALTER TABLE
-  bankaccounttransactions ADD CONSTRAINT 
fk_bankaccounttransactions_demobank_id FOREIGN KEY (demobank) REFERENCES 
demobankconfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  cashoutsubmissions ADD CONSTRAINT fk_cashoutsubmissions_localtransaction_id 
FOREIGN KEY ("localTransaction") REFERENCES bankaccounttransactions(id) ON 
DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicssubscribers ADD CONSTRAINT fk_ebicssubscribers_signaturekey_id FOREIGN 
KEY ("signatureKey") REFERENCES ebicssubscriberpublickeys(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicssubscribers ADD CONSTRAINT fk_ebicssubscribers_encryptionkey_id FOREIGN 
KEY ("encryptionKey") REFERENCES ebicssubscriberpublickeys(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicssubscribers ADD CONSTRAINT fk_ebicssubscribers_authorizationkey_id 
FOREIGN KEY ("authorizationKey") REFERENCES ebicssubscriberpublickeys(id) ON 
DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicssubscribers ADD CONSTRAINT fk_ebicssubscribers_bankaccount_id FOREIGN 
KEY ("bankAccount") REFERENCES bankaccounts(id) ON DELETE CASCADE ON UPDATE 
RESTRICT;
-
-ALTER TABLE
-  ebicsdownloadtransactions ADD CONSTRAINT 
fk_ebicsdownloadtransactions_host_id FOREIGN KEY (host) REFERENCES 
ebicshosts(id) ON DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicsdownloadtransactions ADD CONSTRAINT 
fk_ebicsdownloadtransactions_subscriber_id FOREIGN KEY (subscriber) REFERENCES 
ebicssubscribers(id) ON DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  ebicsuploadtransactions ADD CONSTRAINT fk_ebicsuploadtransactions_host_id 
FOREIGN KEY (host) REFERENCES ebicshosts(id) ON DELETE RESTRICT ON UPDATE 
RESTRICT;
-
-ALTER TABLE
-  ebicsuploadtransactions ADD CONSTRAINT 
fk_ebicsuploadtransactions_subscriber_id FOREIGN KEY (subscriber) REFERENCES 
ebicssubscribers(id) ON DELETE RESTRICT ON UPDATE RESTRICT;
-
-ALTER TABLE
-  bankaccountfreshtransactions ADD CONSTRAINT 
fk_bankaccountfreshtransactions_transaction_id FOREIGN KEY ("transaction") 
REFERENCES bankaccounttransactions(id) ON DELETE CASCADE ON UPDATE RESTRICT;
-
-ALTER TABLE
-  bankaccountreports ADD CONSTRAINT fk_bankaccountreports_bankaccount_id 
FOREIGN KEY ("bankAccount") REFERENCES bankaccounts(id) ON DELETE RESTRICT ON 
UPDATE RESTRICT;
-
-ALTER TABLE
-  bankaccountstatements ADD CONSTRAINT fk_bankaccountstatements_bankaccount_id 
FOREIGN KEY ("bankAccount") REFERENCES bankaccounts(id) ON DELETE RESTRICT ON 
UPDATE RESTRICT;
-
-ALTER TABLE
-  talerwithdrawals ADD CONSTRAINT fk_talerwithdrawals_walletbankaccount_id 
FOREIGN KEY ("walletBankAccount") REFERENCES bankaccounts(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT;
-
-COMMIT;
diff --git a/database-versioning/sandbox-drop.sql 
b/database-versioning/sandbox-drop.sql
deleted file mode 100644
index de226b09..00000000
--- a/database-versioning/sandbox-drop.sql
+++ /dev/null
@@ -1,30 +0,0 @@
-BEGIN;
-
--- This script DROPs all of the tables we create, including the
--- versioning schema!
---
--- Unlike the other SQL files, it SHOULD be updated to reflect the
--- latest requirements for dropping tables.
-
-SELECT _v.unregister_patch('sandbox-0001');
-
-DROP TABLE IF EXISTS demobankconfigs CASCADE;
-DROP TABLE IF EXISTS bankaccounts CASCADE;
-DROP TABLE IF EXISTS bankaccounttransactions CASCADE;
-DROP TABLE IF EXISTS cashoutsubmissions CASCADE;
-DROP TABLE IF EXISTS demobankconfigpairs CASCADE;
-DROP TABLE IF EXISTS ebicssubscribers CASCADE;
-DROP TABLE IF EXISTS ebicssubscriberpublickeysCASCADE;
-DROP TABLE IF EXISTS ebicshosts CASCADE;
-DROP TABLE IF EXISTS ebicsdownloadtransactions CASCADE;
-DROP TABLE IF EXISTS ebicsuploadtransactions CASCADE;
-DROP TABLE IF EXISTS ebicsuploadtransactionchunks CASCADE;
-DROP TABLE IF EXISTS ebicsordersignatures CASCADE;
-DROP TABLE IF EXISTS bankaccountfreshtransactions CASCADE;
-DROP TABLE IF EXISTS bankaccountreports CASCADE;
-DROP TABLE IF EXISTS bankaccountstatements CASCADE;
-DROP TABLE IF EXISTS talerwithdrawals CASCADE;
-DROP TABLE IF EXISTS demobankcustomers CASCADE;
-DROP TABLE IF EXISTS cashoutoperations CASCADE;
-
-COMMIT;

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.