#!/bin/sh -e
+# WARNING: it may fail if ~/.sqliterc exists!
# 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
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
+" | sqlite3 -separator " " pyshop.db | while read pkginfo ; do
ctr=$(( $ctr + 1 ))
[ $(( $ctr % 100 )) -ne 0 ] || echo $ctr $pkginfo
pkg=$(echo "$pkginfo" | cut -f1 | pkgname)