From d366ade036ba8889654e5df86d6e2d5072e9f4d4 Mon Sep 17 00:00:00 2001
From: Maximilian Möhring
Date: Fri, 12 Jul 2019 02:24:06 +0200
Subject: Improves readability. (crawler)

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

(limited to 'crawler')

diff --git a/crawler/database.go b/crawler/database.go
index 5de0fb2..8b09b09 100644
--- a/crawler/database.go
+++ b/crawler/database.go
@@ -62,10 +62,26 @@ func (app *App) createTables() error {
 
 		view_query := `CREATE OR REPLACE VIEW ` + v + `_view AS
 		SELECT
-			angebot.id, angebot.name, age, angebot.abv, angebot.volume, angebot.url as long_url, angebot.short_url as url, spirit_type,
-			original_price/100 as original_price, discounted_price/100 as discounted_price, angebot.base_price/100 as base_price, image_url,
-			shop.name as shop, shop.id as shop_id, shop.short_url as shop_url, shop.shipping_costs/100 as shipping_costs, shop.free_shipping,
-			ROUND(100-((discounted_price/original_price)*100)) AS procent, created_at
+			angebot.id,
+			angebot.name,
+			angebot.age,
+			angebot.abv,
+			angebot.volume,
+			angebot.url as long_url,
+			angebot.short_url as url,
+			angebot.spirit_type,
+			angebot.original_price/100 as original_price,
+			angebot.discounted_price/100 as discounted_price,
+			(original_price - discounted_price)/100 as absolute_discount,
+			angebot.base_price/100 as base_price,
+			angebot.image_url,
+			shop.name as shop,
+			shop.id as shop_id,
+			shop.short_url as shop_url,
+			shop.shipping_costs/100 as shipping_costs,
+			shop.free_shipping,
+			ROUND(100-((discounted_price/original_price)*100)) AS procent,
+			angebot.created_at
 		FROM angebot
 		JOIN shop ON angebot.shop = shop.id
 		WHERE 
-- 
cgit v1.2.3