X-Git-Url: http://www.git.cypherpunks.ru/?p=gocheese.git;a=blobdiff_plain;f=contrib%2Fpyshop2packages.sh;h=98613f3aa06f67c2b800f24a538981d86a9c89ea;hp=efdfbb3896f1ba0cb0bcf461472c889a89afaab5;hb=60834a0713d5dcc6a9911511cb8618ce7358c824;hpb=948543909470b983c001f13fb267a64070dd20ae diff --git a/contrib/pyshop2packages.sh b/contrib/pyshop2packages.sh index efdfbb3..98613f3 100755 --- 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