From e3312da52d0ede1c5f783feba0840c53eeca723d Mon Sep 17 00:00:00 2001
From: horus_arch
Date: Mon, 19 Feb 2018 15:15:45 +0100
Subject: Bugfix + detects age. (crawler)

---
 crawler/database.go | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'crawler/database.go')

diff --git a/crawler/database.go b/crawler/database.go
index cf8989a..c1e0dd7 100644
--- a/crawler/database.go
+++ b/crawler/database.go
@@ -23,12 +23,13 @@ func (app *App) createTables() error {
 
 	query2 := `CREATE TABLE IF NOT EXISTS angebot (
 		id INTEGER PRIMARY KEY AUTO_INCREMENT,
-		shop INT NOT NULL,
 		name VARCHAR(255) NOT NULL,
-		url VARCHAR(255) NOT NULL,
-		short_url TEXT,
 		abv DECIMAL(10,2) NOT NULL,
 		volume DECIMAL(10,2) NOT NULL,
+		age INT NOT NULL DEFAULT 0,
+		shop INT NOT NULL,
+		url VARCHAR(255) NOT NULL,
+		short_url TEXT,
 		original_price INT NOT NULL,
 		discounted_price INT NOT NULL,
 		base_price INT NOT NULL,
@@ -99,7 +100,7 @@ func (app *App) save_offer(W []Angebot) error {
 
 		// resembles UNIQUE constraint
 		detect_duplicate_query := `SELECT 1 FROM all_view WHERE name = ? AND shop_id = ? AND 
-		volume = ? AND abv = ? AND original_price = ? AND discounted_price = ? AND valid_until = ?`
+		volume = ? AND abv = ? AND original_price = ? AND discounted_price = ? AND valid_until > ?`
 
 		err := app.DB.QueryRow(detect_duplicate_query, o.Name, o.Shop, o.Volume, o.Abv, o.Original_price, o.Discounted_price, o.Valid_until).Scan(&found)
 
-- 
cgit v1.2.3