From ebdf590b6e4469eb72420634620dcdcf88c5eb1b Mon Sep 17 00:00:00 2001
From: Mattia Rizzolo <mattia@mapreri.org>
Date: Sat, 21 Mar 2015 00:11:21 +0100
Subject: udd: drop udd_list_tables job: there is
 https://udd.debian.org/schema/udd.html for that

---
 TODO             |  1 -
 bin/udd-query.sh | 20 --------------------
 job-cfg/udd.yaml |  9 ---------
 3 files changed, 30 deletions(-)

diff --git a/TODO b/TODO
index a421b15d..deac7911 100644
--- a/TODO
+++ b/TODO
@@ -170,7 +170,6 @@ properties:
 
 * turn udd-versionskew packages names into tracker.d.o links and provide version numbers in output too
 * mention udd.d.o/schema.html in README
-* remove list_table job
 
 === d-i_manual*
 
diff --git a/bin/udd-query.sh b/bin/udd-query.sh
index 2ff50938..9fde6f5a 100755
--- a/bin/udd-query.sh
+++ b/bin/udd-query.sh
@@ -22,23 +22,6 @@ 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
-	echo
-	for TABLE in $(cat $UDD | cut -d "|" -f2) ; do
-		SQL_QUERY="SELECT column_name, data_type, character_maximum_length
-			FROM INFORMATION_SCHEMA.COLUMNS where table_name = '$TABLE';"
-		udd_query
-		cat $UDD
-		echo
-	done
-	rm $UDD
-	echo "Also see https://udd.debian.org/schema/udd.html"
-}
-
 multiarch_versionskew() {
 	if [ -z "$1" ] ; then
 		echo "Warning: no distro supplied, assuming sid."
@@ -120,9 +103,6 @@ orphaned_without_o_bug() {
 #
 UDD=$(mktemp)
 case $1 in
-	list_tables)
-			list_tables
-			;;
 	orphaned_without_o_bug)
 			orphaned_without_o_bug
 			;;
diff --git a/job-cfg/udd.yaml b/job-cfg/udd.yaml
index 8c9cf7b3..3fc39a3d 100644
--- a/job-cfg/udd.yaml
+++ b/job-cfg/udd.yaml
@@ -33,10 +33,6 @@
     triggers:
       - timed: '{my_time}'
 
-- job-template:
-    defaults: udd
-    name: '{name}_list_tables'
-
 - job-template:
     defaults: udd
     name: '{name}_wheezy_multiarch_versionskew'
@@ -60,11 +56,6 @@
 - project:
     name: udd
     jobs:
-        - '{name}_list_tables':
-           my_time: '15 8 * * 1'
-           my_params: 'list_tables'
-           my_description: 'Just list all <a href="https://udd.debian.org" target="_blank">UDD</a> tables.'
-           my_logparser: 'false'
         - '{name}_wheezy_multiarch_versionskew':
            my_time: '2 8 1 * *'
            my_params: 'multiarch_versionskew wheezy'
-- 
cgit v1.2.3-70-g09d2