summaryrefslogtreecommitdiffstats
path: root/bin/udd-query.sh
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-01-06 01:39:30 +0100
committerHolger Levsen <holger@layer-acht.org>2015-01-06 01:39:30 +0100
commit05c2b419071da0aaa48ea6cfefaa3b527dd8822a (patch)
treef942a661f8670d2928942b3e72a611bb02da9cfc /bin/udd-query.sh
parent26e779499fd96eff94184ec03afd1218cadb2d30 (diff)
downloadjenkins.debian.net-05c2b419071da0aaa48ea6cfefaa3b527dd8822a.tar.xz
udd: add job to just list all UDD tables
Diffstat (limited to 'bin/udd-query.sh')
-rwxr-xr-xbin/udd-query.sh12
1 files changed, 12 insertions, 0 deletions
diff --git a/bin/udd-query.sh b/bin/udd-query.sh
index 9fde6f5a..50ac1de8 100755
--- a/bin/udd-query.sh
+++ b/bin/udd-query.sh
@@ -22,6 +22,15 @@ udd_query() {
udd -c"${SQL_QUERY}" > $UDD
}
+list_tables() {
+ SQL_QUERY="SELECT table_schema,table_name
+ FROM information_schema.tables
+ ORDER BY table_schema,table_name;"
+ udd_query
+ cat $UDD
+ rm $UDD
+}
+
multiarch_versionskew() {
if [ -z "$1" ] ; then
echo "Warning: no distro supplied, assuming sid."
@@ -103,6 +112,9 @@ orphaned_without_o_bug() {
#
UDD=$(mktemp)
case $1 in
+ list_tables)
+ list_tables
+ ;;
orphaned_without_o_bug)
orphaned_without_o_bug
;;