Add migration test and improve SQL drop script

1 files changed, 7 insertions, 4 deletions

diff --git a/database-versioning/libeufin-nexus-drop.sql b/database-versioning/libeufin-nexus-drop.sql
index 199f1cb9..4eed7f3c 100644
--- a/database-versioning/libeufin-nexus-drop.sql
+++ b/database-versioning/libeufin-nexus-drop.sql
@@ -5,11 +5,14 @@ $do$
 DECLARE
     patch text;
 BEGIN
-    for patch in SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_nexus_%' loop 
-        PERFORM _v.unregister_patch(patch);
-    end loop;
+    IF EXISTS(SELECT 1 FROM information_schema.schemata WHERE schema_name='_v') THEN
+        FOR patch IN SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_nexus_%' LOOP 
+            PERFORM _v.unregister_patch(patch);
+        END LOOP;
+    END IF;
 END
 $do$;
-DROP SCHEMA libeufin_nexus CASCADE;
+
+DROP SCHEMA IF EXISTS libeufin_nexus CASCADE;
 
 COMMIT;