summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJudd Vinet <judd@archlinux.org>2003-05-22 01:07:33 +0200
committerJudd Vinet <judd@archlinux.org>2003-05-22 01:07:33 +0200
commitc6a78c714e6dc0a814d954eb55ec0028e897f1f9 (patch)
tree5eee6000e3d5c23c9d091fed8490ead975e75a9b
parentdc73d5af70bbcd1cfa8515e34478c3eb33d15749 (diff)
downloaddbscripts-c6a78c714e6dc0a814d954eb55ec0028e897f1f9.tar.gz
dbscripts-c6a78c714e6dc0a814d954eb55ec0028e897f1f9.tar.xz
added/updated scripts for the new website
-rwxr-xr-xdb-arch8
-rwxr-xr-xdb-unstable5
-rwxr-xr-xgenpkglist4
-rwxr-xr-xpkgdb70
4 files changed, 80 insertions, 7 deletions
diff --git a/db-arch b/db-arch
index 95f5d71..c6a7339 100755
--- a/db-arch
+++ b/db-arch
@@ -1,18 +1,20 @@
#!/bin/bash
-# $Id: db-arch,v 1.4 2003/01/24 19:27:35 judd Exp $
+# $Id: db-arch,v 1.5 2003/05/21 23:07:33 judd Exp $
echo "==> Updating ABS Tree..." >&2
cd /tmp
+rm -rf arch
CVSROOT=:ext:judd@cvs.archlinux.org:/home/cvs-arch cvs -q export -r CURRENT -f arch/build
echo "==> Rebuilding HTML Package List..." >&2
cd /tmp/arch/build
rm -f packages.txt
-/root/bin/htmlpkglist arch
+/arch/htmlpkglist arch
mv pkgs_arch_name.html pkgs_arch_cat.html /home/sites/archlinux/htdocs/pkglists
+/arch/pkgdb 1
echo "==> Generating Text Package List..." >&2
-/root/bin/genpkglist
+/arch/genpkglist
mv packages.txt /home/ftp/current/setup/packages.txt
echo "==> Generating pacsync2 Database for ARCH..." >&2
diff --git a/db-unstable b/db-unstable
index 7e3431f..4d76d9e 100755
--- a/db-unstable
+++ b/db-unstable
@@ -1,5 +1,5 @@
#!/bin/bash
-# $Id: db-unstable,v 1.1 2003/02/24 00:54:29 judd Exp $
+# $Id: db-unstable,v 1.2 2003/05/21 23:07:33 judd Exp $
echo "==> Generating pacsync2 Database for UNSTABLE..." >&2
cd /tmp
@@ -10,10 +10,11 @@ CVS_RSH=ssh CVSROOT=:ext:cvs.archlinux.org:/home/cvs-unstable cvs -q export -r C
echo "==> Rebuilding HTML Package List..." >&2
cd /tmp/unstable
rm -f packages.txt
-$HOME/htmlpkglist unstable
+/arch/htmlpkglist unstable
cp -f pkgs_unstable_name.html /home/sites/archlinux/htdocs/pkglists
cp -f pkgs_unstable_cat.html /home/sites/archlinux/htdocs/pkglists
rm pkgs_unstable_name.html pkgs_unstable_cat.html
+/arch/pkgdb 3
rm -rf /tmp/unstable
diff --git a/genpkglist b/genpkglist
index 67f384e..ee4298b 100755
--- a/genpkglist
+++ b/genpkglist
@@ -1,5 +1,5 @@
#!/bin/bash
-# $Id: genpkglist,v 1.5 2002/11/28 08:28:13 judd Exp $
+# $Id: genpkglist,v 1.6 2003/05/21 23:07:33 judd Exp $
#
# genpkglist
@@ -9,7 +9,7 @@
pkgfile="`pwd`/packages.txt"
-cd /usr/abs
+cd /tmp/arch/build
rm -f $pkgfile
for category in `find * -type d -maxdepth 0 | grep -v CVS`; do
cd $category
diff --git a/pkgdb b/pkgdb
new file mode 100755
index 0000000..b063da7
--- /dev/null
+++ b/pkgdb
@@ -0,0 +1,70 @@
+#!/bin/bash
+# $Id: pkgdb,v 1.1 2003/05/21 23:07:33 judd Exp $
+
+tl=`pwd`
+TMPFILE=/tmp/.mysqltmp
+repoid=$1
+dbuser='archweb'
+dbname='archweb'
+dbpass='14xuk0Gi'
+
+if [ "$repoid" = "" ]; then
+ me=`basename $0`
+ echo "usage: $me <repoid>"
+ exit 1
+fi
+
+echo "==> Updating Package Entries in Database..."
+
+for category in `find * -type d -maxdepth 0 | grep -v CVS | grep -v "^unofficial" | grep -v "^unstable"`; do
+ for pkg in `ls $category | sort`; do
+ cd $tl/$category/$pkg
+ if [ -f PKGBUILD ]; then
+ . PKGBUILD
+ deplist=${depends[@]}
+ deplist=`php -r "echo addslashes(\"$deplist\");"`
+ sources=${source[@]}
+ sources=`php -r "echo addslashes(\"$sources\");"`
+ pkgname=`php -r "echo addslashes(\"$pkgname\");"`
+ pkgver=`php -r "echo addslashes(\"$pkgver\");"`
+ pkgrel=`php -r "echo addslashes(\"$pkgrel\");"`
+ pkgdesc=`php -r "echo addslashes(\"$pkgdesc\");"`
+ mysql -u $dbuser -p$dbpass $dbname >$TMPFILE <<_EOF
+SELECT id FROM packages WHERE repoid=$repoid AND pkgname='$pkgname';
+_EOF
+ id=`tail -1 $TMPFILE`
+ if [ "$id" != "" ]; then
+ mysql -u $dbuser -p$dbpass $dbname >$TMPFILE <<_EOF
+SELECT pkgver,pkgrel FROM packages WHERE repoid=$repoid AND pkgname='$pkgname';
+_EOF
+ oldver=`tail -1 $TMPFILE | awk '{print $1}'`
+ oldrel=`tail -1 $TMPFILE | awk '{print $2}'`
+ if [ "$oldver" != "$pkgver" -o "$oldrel" != "$pkgrel" ]; then
+ mysql -u $dbuser -p$dbpass $dbname <<_EOF
+UPDATE packages SET category='$category',pkgname='$pkgname',pkgver='$pkgver',
+pkgrel='$pkgrel',pkgdesc='$pkgdesc',url='$url',sources='$sources',
+depends='$deplist',lastupdate=NOW() WHERE id='$id';
+_EOF
+ else
+ mysql -u $dbuser -p$dbpass $dbname <<_EOF
+UPDATE packages SET category='$category',pkgname='$pkgname',pkgver='$pkgver',
+pkgrel='$pkgrel',pkgdesc='$pkgdesc',url='$url',sources='$sources',
+depends='$deplist' WHERE id='$id';
+_EOF
+
+ fi
+ else
+ mysql -u $dbuser -p$dbpass $dbname <<_EOF
+INSERT INTO packages (id,repoid,category,pkgname,pkgver,pkgrel,
+pkgdesc,url,sources,depends,lastupdate) VALUES (NULL,$repoid,
+'$category','$pkgname','$pkgver','$pkgrel','$pkgdesc','$url',
+'$sources','$deplist',NOW());
+_EOF
+ fi
+ fi
+ done
+ cd $tl
+done
+
+rm -f $TMPFILE
+