diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:39:59 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:39:59 +0100 |
| commit | 7e1b697efdf5b929c26ecf42ce8f83e36d996ba2 (patch) | |
| tree | 2cfb398738ccf5a4a0f5872ed701ac14b4577c9d | |
| parent | 79390ad4477dfef9660c40544d5afc23700c4009 (diff) | |
bugfixes
| -rw-r--r-- | sqlQueries.go | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sqlQueries.go b/sqlQueries.go index f9003a4..efaffba 100644 --- a/sqlQueries.go +++ b/sqlQueries.go @@ -187,7 +187,10 @@ func removeASNIP(db *sql.DB, asn int, ipBlock string) error { // database that is older than t and haven't had // differential privacy added to them yet. func privatizeCleaned(db *sql.DB, t time.Time, conf Config) (err error) { - query, err := db.Prepare("SELECT ipb_src,ipb_dst,as_src,as_dst,port_src,port_dst,volume,time,occurences FROM clean_data WHERE time_added < ? FOR UPDATE") + if conf.Epsilon <= 0 { + return + } + query, err := db.Prepare("SELECT ipb_src,ipb_dst,as_src,as_dst,port_src,port_dst,volume,time_added,occurences FROM clean_data WHERE time_added < ?") if err != nil { log.Println("Failed to prepare query") return @@ -198,6 +201,7 @@ func privatizeCleaned(db *sql.DB, t time.Time, conf Config) (err error) { log.Println("Failed to query for unprivitized rows") return } + defer rows.Close() update, err := db.Prepare("UPDATE clean_data SET occurences = ? , time_privatized = ? WHERE ipb_src = ? AND ipb_dst = ? AND as_src = ? AND as_dst = ? AND port_src = ? AND port_dst = ? AND volume = ? AND time_added = ? ") if err != nil { |
