From b46fb496ee7425fdee5e1b743e772184e27e71f7 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 16 Apr 2018 11:54:15 +0200
Subject: remove `files` and `file_providers` - they're not practicable in the
 database

---
 bin/bootstrap-mysql   | 12 +-----------
 bin/return-assignment | 22 ----------------------
 2 files changed, 1 insertion(+), 33 deletions(-)

(limited to 'bin')

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index ca84bcf..822d995 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -165,17 +165,7 @@ if [ ! "$1" = 'slim' ]; then
       ' locked_tasks_count MEDIUMINT' \
       ' blocked_tasks_count MEDIUMINT' \
       ' next_tasks_count MEDIUMINT' \
-      ' UNIQUE date' \
-      'files BIGINT' \
-      ' path TEXT' \
-      ' name TEXT' \
-      ' name_hash VARCHAR(128)' \
-      ' absolute_name_hash VARCHAR(128)' \
-      'file_providers BIGINT' \
-      ' package BIGINT :binary_packages' \
-      ' file BIGINT :files'
-      # TODO: files and file_providers is currently not represented
-      # correctly, because they are not representable in this form
+      ' UNIQUE date'
   )
 
   # shellcheck disable=SC2016
diff --git a/bin/return-assignment b/bin/return-assignment
index 630349c..3c6e3d1 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -426,25 +426,6 @@ find . -maxdepth 1 -name '*.pkg.tar.xz' \
   ' > \
   "${tmp_dir}/sha512sums"
 
-# generate file lists
-find . -maxdepth 1 -name '*.pkg.tar.xz' \
-  -printf '%f %p\n' | \
-  while read -r pkgfile path; do \
-    pacman -Qqlp "${path}" | \
-      sed '
-        s/^/'"${pkgfile}"'\t/
-      '
-  done | \
-  sed -n '
-    s/-\(\([^-:]\+\):\)\?\([^-:]\+\)-\([^-.]\+\)\(\.\([^-.]\+\)\)\?-\([^-]\+\)\.pkg\.tar\.xz\t/\t\2\t\3\t\4\t\6\t\7\t/
-    T
-    s/\t\t/\t0\t/g
-    s,/$,,
-    s,/\([^\t/]\+\)$,/\t\1,
-    p
-  ' > \
-  "${tmp_dir}/files"
-
 # move namcap.logs
 find . -maxdepth 1 -name '*.pkg.tar.xz-namcap.log.gz' -execdir mv '{}' "${build_log_directory}/success/" \;
 
@@ -470,9 +451,6 @@ trigger_mirror_refreshs
 
 # shellcheck disable=SC2016
 {
-  # insert file lists into database
-#  mysql_insert_package_files_query "${tmp_dir}/files"
-
   # insert checksums into database
   printf 'CREATE TEMPORARY TABLE `pkg_hashes` (`sha512sum` VARCHAR(128), `pkgfile` VARCHAR(128));\n'
   printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `pkg_hashes`;\n' \
-- 
cgit v1.2.3-54-g00ecf