From 1e54d0951f0183cc750f0a8b596c3b830dab43ff Mon Sep 17 00:00:00 2001 From: James Troup Date: Tue, 12 Feb 2002 23:13:49 +0000 Subject: [PATCH] add fingerprint helper function --- db_access.py | 26 +++++++++++++++++++++++--- 1 file changed, 23 insertions(+), 3 deletions(-) diff --git a/db_access.py b/db_access.py index afbddeeb..216f4e76 100644 --- a/db_access.py +++ b/db_access.py @@ -1,6 +1,6 @@ # DB access fucntions # Copyright (C) 2000, 2001 James Troup -# $Id: db_access.py,v 1.10 2001-11-24 18:42:05 troup Exp $ +# $Id: db_access.py,v 1.11 2002-02-12 23:13:49 troup Exp $ # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by @@ -16,7 +16,9 @@ # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA -import pg, string +############################################################################################ + +import string ############################################################################################ @@ -33,7 +35,8 @@ location_id_cache = {}; maintainer_id_cache = {}; source_id_cache = {}; files_id_cache = {}; -maintainer_cache = {} +maintainer_cache = {}; +fingerprint_id_cache = {}; ############################################################################################ @@ -220,6 +223,23 @@ def get_or_set_maintainer_id (maintainer): ########################################################################################## +def get_or_set_fingerprint_id (fingerprint): + global fingerprint_id_cache + + if fingerprint_id_cache.has_key(fingerprint): + return fingerprint_id_cache[fingerprint] + + q = projectB.query("SELECT id FROM fingerprint WHERE fingerprint = '%s'" % (fingerprint)) + if not q.getresult(): + projectB.query("INSERT INTO fingerprint (fingerprint) VALUES ('%s')" % (fingerprint)) + q = projectB.query("SELECT id FROM fingerprint WHERE fingerprint = '%s'" % (fingerprint)) + fingerprint_id = q.getresult()[0][0] + fingerprint_id_cache[fingerprint] = fingerprint_id + + return fingerprint_id + +########################################################################################## + def get_files_id (filename, size, md5sum, location_id): global files_id_cache -- 2.39.5