--- /dev/null
+#!/bin/sh -e
+# Convert Pyshop working directory to GoCheese friendly one.
+# Script expects to be run in packages repository (a/, b/, ...)
+# with pyshop.db database file. It will create packages/ directory
+# with all Pyshop-downloaded/uploaded files, SHA256 checksums,
+# private package marks. Also it will call GoCheese's /simple/ API
+# for forcing metainformation update (necessary for storing SHA256
+# checksums missing in Pyshop).
+
+pkgname() {
+ perl -ne "s/[-_.]+/-/g ; print lc"
+}
+
+########################################################################
+# Copy all already existing files
+########################################################################
+ctr=0
+echo "
+SELECT package.name, release_file.filename
+FROM release_file
+JOIN release ON release.id = release_file.release_id
+JOIN package ON release.package_id = package.id
+ORDER BY package.name
+" | sqlite3 --separator " " pyshop.db | while read pkginfo ; do
+ ctr=$(( $ctr + 1 ))
+ [ $(( $ctr % 100 )) -ne 0 ] || echo $ctr $pkginfo
+ pkg=$(echo "$pkginfo" | cut -f1 | pkgname)
+ filename=$(echo "$pkginfo" | cut -f2)
+ [ -n "$pkg" ]
+ [ -n "$filename" ]
+ src=$(echo $pkg | cut -c1)/$filename
+ dst=packages/$pkg/$filename
+ [ -r $src ] || continue
+ [ -r $dst ] && continue || :
+ mkdir -p packages/$pkg
+ ln $src $dst
+done
+
+########################################################################
+# Mark all private packages
+########################################################################
+for pkg in $(echo "SELECT name FROM package WHERE local = true" | sqlite3 pyshop.db); do
+ cd packages/$(echo $pkg | pkgname)
+ for f in * ; do sha256 < $f | xxd -r -p > $f.sha256 ; done
+ touch .internal
+ cd ../..
+done
+
+########################################################################
+# Force all metainformation update from upstream
+########################################################################
+cd packages
+for pkg in * ; do
+ # Assume gocheese -gpgupdate /gpgupdate/
+ curl http://localhost:8080/gpgupdate/$pkg/ > /dev/null
+done
+
+########################################################################
+# Assure ckecksums are good
+########################################################################
+gocheese -fsck