diff options
| author | Maximilian Möhring | 2019-07-12 02:24:06 +0200 |
|---|---|---|
| committer | Maximilian Möhring | 2019-07-12 02:24:06 +0200 |
| commit | d366ade036ba8889654e5df86d6e2d5072e9f4d4 (patch) | |
| tree | c3d0605ab6ce04cec0edade84be933d9ee29ba4f /crawler | |
| parent | d8472f0de78054d69da2adb04b8f621e82e82158 (diff) | |
| download | alkobote-d366ade036ba8889654e5df86d6e2d5072e9f4d4.tar.gz | |
Improves readability. (crawler)
Diffstat (limited to 'crawler')
| -rw-r--r-- | crawler/database.go | 24 |
1 files changed, 20 insertions, 4 deletions
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 |