[Qa-jenkins-scm] [jenkins.debian.net] 01/02: udd: drop udd_list_tables job: there is https://udd.debian.org/schema/udd.html for that

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit ebdf590b6e4469eb72420634620dcdcf88c5eb1b
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Sat Mar 21 00:11:21 2015 +0100

    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 a421b15..deac791 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 2ff5093..9fde6f5 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 8c9cf7b..3fc39a3 100644
--- a/job-cfg/udd.yaml
+++ b/job-cfg/udd.yaml
@@ -35,10 +35,6 @@
 
 - job-template:
     defaults: udd
-    name: '{name}_list_tables'
-
-- job-template:
-    defaults: udd
     name: '{name}_wheezy_multiarch_versionskew'
 
 - job-template:
@@ -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'

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git