handle disappearing packages in the database cache

git-svn-id: svn://svn.r-forge.r-project.org/svnroot/cran2deb@199 edb9625f-4e0d-4859-8d74-9fd3b1da38cb

diff --git a/trunk/R/db.R b/trunk/R/db.R
index 972343e67b5f16f7ba865fbfb3b8147ffb0b50d0..c5ddccae79f7feb0bee43790d3b86fc699699ff1 100644 (file)
--- a/trunk/R/db.R
+++ b/trunk/R/db.R
@@ -281,6 +281,11 @@ db_add_license_hash <- function(name,license_sha1) {
 
 
 db_update_package_versions <- function() {
+    # seems like the quickest way of doing this:
+    con <- db_start()
+    dbGetQuery(con, 'DROP TABLE packages')
+    db_stop(con)
+    # db_start re-makes all tables
     con <- db_start()
     for (package in available[,'Package']) {
         dbGetQuery(con, paste('INSERT OR REPLACE INTO packages (package,latest_r_version)'