From 12581478b719abb123961b29aebe065ad6d4a3ef Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 30 Jan 2024 09:44:12 -0600 Subject: [PATCH] Automatically generate statements to drop views --- make_files/things.mk | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/make_files/things.mk b/make_files/things.mk index 8515e0d..38a387b 100644 --- a/make_files/things.mk +++ b/make_files/things.mk @@ -1,4 +1,4 @@ -# Copyright (C) 2023 The Meme Factory, Inc. http://www.karlpinc.com/ +# Copyright (C) 2023, 2024 The Meme Factory, Inc. http://www.karlpinc.com/ # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as published by @@ -75,7 +75,8 @@ check: || { printf "Target %s.%s has no m4 file to create it\n" \ $${schema} $${target} \ ; exit 1 ; } ; \ - if [ $$(basename $$(pwd)) != 'tables' ] ; then \ + if [ $$(basename $$(pwd)) != 'tables' \ + -a $$(basename $$(pwd)) != 'views' ] ; then \ [ -f drop/$${target}.m4 ] \ || { printf "Target %s.%s has no m4 file to drop it\n" \ $${schema} $${target} \ @@ -165,7 +166,7 @@ droptables.sql dropviews.sql: $(DB_DEPENDS) export "REVERSE=$$(printf '%s ' '$(ORDER)' | tac -s ' ')" ; \ for relation in $${REVERSE} ; do \ printf 'DROP %s IF EXISTS %s CASCADE;\n' \ - $(if $($filter droptables.sql,$@),TABLE,VIEW) \ + $(if $(filter droptables.sql,$@),TABLE,VIEW) \ $${relation} \ >> $@ ; \ done -- 2.34.1