Metadata, mtime support. Massive refactoring

[gocheese.git] / contrib / pyshop2packages.sh

diff --git a/contrib/pyshop2packages.sh b/contrib/pyshop2packages.sh
index efdfbb3896f1ba0cb0bcf461472c889a89afaab5..98613f3aa06f67c2b800f24a538981d86a9c89ea 100755 (executable)
--- a/contrib/pyshop2packages.sh
+++ b/contrib/pyshop2packages.sh
@@ -6,7 +6,7 @@
 # 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).
+# checksums missing in Pyshop). No metadata conversion is performed.
 
 pkgname() {
     perl -ne "s/[-_.]+/-/g ; print lc"
@@ -17,7 +17,7 @@ pkgname() {
 ########################################################################
 ctr=0
 echo "
-SELECT package.name, release_file.filename
+SELECT package.name, release_file.filename, release_file.created_at
 FROM release_file
 JOIN release ON release.id = release_file.release_id
 JOIN package ON release.package_id = package.id
@@ -27,6 +27,7 @@ ORDER BY package.name
     [ $(( $ctr % 100 )) -ne 0 ] || echo $ctr $pkginfo
     pkg=$(echo "$pkginfo" | cut -f1 | pkgname)
     filename=$(echo "$pkginfo" | cut -f2)
+    created=$(echo "$pkginfo" | cut -f3 | sed "s/ /T/")
     [ -n "$pkg" ]
     [ -n "$filename" ]
     src=$(echo $pkg | cut -c1)/$filename
@@ -35,6 +36,7 @@ ORDER BY package.name
     [ -r $dst ] && continue || :
     mkdir -p packages/$pkg
     ln $src $dst
+    touch -d "$created" $dst
 done
 
 ########################################################################
@@ -44,6 +46,7 @@ for pkg in $(echo "SELECT name FROM package WHERE local = true" | sqlite3 pyshop
     cd packages/$(echo $pkg | pkgname)
     for f in * ; do sha256 < $f | xxd -r -p > $f.sha256 ; done
     touch .internal
+    touch -r $f $f.sha256
     cd ../..
 done