Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs17:/tmp/cvs-serv11542
Modified Files:
Tag: redesign_pdb
dump
Log Message:
Use proper transaction handling
Index: dump
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/dump,v
retrieving revision 1.32.2.15
retrieving revision 1.32.2.16
diff -u -d -r1.32.2.15 -r1.32.2.16
--- dump 10 Sep 2007 18:02:20 -0000 1.32.2.15
+++ dump 10 Sep 2007 19:36:24 -0000 1.32.2.16
@@ -180,10 +180,12 @@
# restore stdout
open(STDOUT, ">&OLDOUT");
-### drop the previous data
+### first drop the previous data, then add packages again, doing one
+### release at a time, in one transaction
+print "# Begin dump release id = $rel_id\n";
+print "START TRANSACTION;\n";
print "# delete old rows\n";
-print "BEGIN;\n";
print "DELETE FROM `package` WHERE rel_id='$rel_id';\n";
### loop over packages
@@ -271,6 +273,8 @@
print "# $package-$version\n";
print "$q\n";
}
+print "COMMIT;\n";
+print "# End dump release id = $rel_id\n";
if (defined $treelink) {
rm_f $treelink or print "Could not remove $treelink\n";
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
