improved package db handling to delete packages

1 files changed, 102 insertions, 30 deletions

diff --git a/pkgdb b/pkgdb
index b394e3a..1f71162 100755
--- a/pkgdb
+++ b/pkgdb
@@ -1,28 +1,80 @@
 #!/bin/bash
-# $Id: pkgdb,v 1.2 2003/05/23 05:08:57 judd Exp $
+# $Id: pkgdb,v 1.3 2003/05/25 23:51:25 judd Exp $
 
 tl=`pwd`
-TMPFILE=/tmp/.mysqltmp
+
+# we use this instead of mktemp cuz the RH server's mktemp is broken :(
+uid=`id -u`
+TMPFILE="/tmp/.mysqltmp.$uid"
+
 repoid=$1
 dbuser='archweb'
 dbname='archweb'
 dbpass='14xuk0Gi'
 
+dbuser='arch'
+dbname='arch'
+dbpass='arch'
+
 if [ "$repoid" = "" ]; then
 	me=`basename $0`
 	echo "usage: $me <repoid>"
 	exit 1
 fi
 
-echo "==> Updating Package Entries in Database..."
+deletepkg()
+{
+	echo "Deleting $pkgname"
+	mysql -u $dbuser -p$dbpass $dbname <<_EOF
+DELETE FROM packages WHERE id='$id';
+_EOF
+}
+
+updatepkg()
+{
+	echo "Updating $pkgname"
+	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
+}
+
+insertpkg()
+{
+	echo "Inserting $pkgname"
+	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
+}
 
-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
+process() {
+	pkg=$1
+
+	id=`echo $pkg | awk '{print $1}'`
+	pkgname=`echo $pkg | awk '{print $2}'`
+	oldver=`echo $pkg | awk '{print $3}'`
+	oldrel=`echo $pkg | awk '{print $4}'`
+	[ "$pkgname" = "" ] && return;
+	cd $tl
+	pkgdir=`find . -type d -name "$pkgname" -maxdepth 2 -mindepth 1 | head -1`
+	if [ "$pkgdir" = "" ]; then
+		deletepkg
+	else
+		cd $pkgdir
+		if [ ! -f PKGBUILD ]; then
+			echo "WARNING: missing PKGBUILD in `pwd`" >&2
+		else
 			unset depends source deplist sources
 			unset pkgname pkgver pkgrel pkgdesc url
-      . PKGBUILD
+			. PKGBUILD
+			# tag it
+			touch .tag
+			category=`pwd | sed 's|^.*/||g'`			
+			cd - &>/dev/null
 			deplist=${depends[@]}
 			deplist=`php -r "echo addslashes(\"$deplist\");"`
 			sources=${source[@]}
@@ -32,32 +84,52 @@ for category in `find * -type d -maxdepth 0 | grep -v CVS | grep -v "^unofficial
 			pkgrel=`php -r "echo addslashes(\"$pkgrel\");"`
 			pkgdesc=`php -r "echo addslashes(\"$pkgdesc\");"`
 			url=`php -r "echo addslashes(\"$url\");"`
-			mysql -u $dbuser -p$dbpass $dbname >$TMPFILE <<_EOF
-SELECT id,pkgver,pkgrel FROM packages WHERE repoid=$repoid AND pkgname='$pkgname';
-_EOF
-			id=`tail -1 $TMPFILE | awk '{print $1}'`
-			if [ "$id" != "" ]; then
-				oldver=`tail -1 $TMPFILE | awk '{print $2}'`
-				oldrel=`tail -1 $TMPFILE | awk '{print $3}'`
-				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
-				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());
+
+			if [ "$oldver" != "$pkgver" -o "$oldrel" != "$pkgrel" ]; then
+				updatepkg
+			fi							
+		fi
+	fi
+}
+
+echo "==> Updating Package Entries in Database..."
+mysql --skip-column-names -u $dbuser -p$dbpass $dbname >$TMPFILE <<_EOF
+SELECT id,pkgname,pkgver,pkgrel FROM packages WHERE repoid=$repoid
 _EOF
+
+cat $TMPFILE | ( \
+	ln='a'
+	while [ "$ln" != "" ]; do
+		read ln
+		process "$ln"
+	done
+)
+
+cd $tl
+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 .tag ]; then
+			# already processed
+			rm -f .tag
+		else
+			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\");"`
+				url=`php -r "echo addslashes(\"$url\");"`
+				insertpkg
 			fi
 		fi
-  done
-  cd $tl
+	done
 done
 
 rm -f $TMPFILE
+exit 0