From 05c2b419071da0aaa48ea6cfefaa3b527dd8822a Mon Sep 17 00:00:00 2001
From: Holger Levsen <holger@layer-acht.org>
Date: Tue, 6 Jan 2015 01:39:30 +0100
Subject: udd: add job to just list all UDD tables

---
 bin/udd-query.sh | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'bin/udd-query.sh')

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
 			;;
-- 
cgit v1.2.3-70-g09d2