diff options
| -rwxr-xr-x | bin/udd-query.sh | 12 | ||||
| -rw-r--r-- | job-cfg/udd.yaml | 8 |
2 files changed, 20 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 ;; diff --git a/job-cfg/udd.yaml b/job-cfg/udd.yaml index 7e6398c7..dfa5ee1f 100644 --- a/job-cfg/udd.yaml +++ b/job-cfg/udd.yaml @@ -34,6 +34,10 @@ - job-template: defaults: udd + name: '{name}_list_tables' + +- job-template: + defaults: udd name: '{name}_wheezy_multiarch_versionskew' - job-template: @@ -55,6 +59,10 @@ - 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.' - '{name}_wheezy_multiarch_versionskew': my_time: '2 8 1 * *' my_params: 'multiarch_versionskew wheezy' |