Author: fw
Date: 2005-12-15 13:44:01 +0000 (Thu, 15 Dec 2005)
New Revision: 3056
Modified:
Makefile
bin/update-db
Log:
bin/update-db:
Do not hard-code the database name. Use SQLite in non-synchronous
mode.
Makefile (all):
Run bin/update-db on a copy of the database, so that we can continue
to serve requests while the database is being updated.
Modified: Makefile
==================================================================--- Makefile
2005-12-15 13:28:57 UTC (rev 3055)
+++ Makefile 2005-12-15 13:44:01 UTC (rev 3056)
@@ -11,7 +11,10 @@
ETCH_ARCHS = $(SARGE_ARCHS)
all:
- $(PYTHON) bin/update-db
+ rm -f data/security-new.db data/security-new.db.journal
+ cp data/security.db data/security-new.db
+ $(PYTHON) bin/update-db data/security-new.db
+ mv data/security-new.db data/security.db
clean:
-rm data/security.db lib/python/test_security.db
Modified: bin/update-db
==================================================================---
bin/update-db 2005-12-15 13:28:57 UTC (rev 3055)
+++ bin/update-db 2005-12-15 13:44:01 UTC (rev 3056)
@@ -22,7 +22,7 @@
import debian_support
import security_db
-db_file = ''data/security.db''
+db_file = sys.argv[1]
try:
db = security_db.DB(db_file)
new_file = False
@@ -31,6 +31,7 @@
db = security_db.DB(db_file, verbose=True)
new_file = True
+db.cursor().execute("PRAGMA synchronous = OFF")
cursor = db.writeTxn()
# Bug lists (CAN/CVE/DSA/DTSA)