From b08061b28fbbe14209763c59e271884ea9d4e782 Mon Sep 17 00:00:00 2001
From: blundellc <blundellc@edb9625f-4e0d-4859-8d74-9fd3b1da38cb>
Date: Mon, 16 Mar 2009 20:16:48 +0000
Subject: [PATCH] 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
---
 trunk/R/db.R | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/trunk/R/db.R b/trunk/R/db.R
index 972343e..c5ddcca 100644
--- 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)'
-- 
2.39.5