diff options
| author | horus | 2018-02-19 21:21:40 +0100 |
|---|---|---|
| committer | horus | 2018-02-19 21:21:40 +0100 |
| commit | f95995af8364ab9fd7106c050455e2d1f71c7ecd (patch) | |
| tree | 01f657ad4bc98aa52b702d2ea547f0c9df159a66 /crawler/database.go | |
| parent | 11fc8bd809d3362fd9be5e5e9bc17c74f538fc07 (diff) | |
| download | alkobote-f95995af8364ab9fd7106c050455e2d1f71c7ecd.tar.gz | |
Improves sanitizing. (crawler)
Diffstat (limited to 'crawler/database.go')
| -rw-r--r-- | crawler/database.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/crawler/database.go b/crawler/database.go index 0d495c8..01813e0 100644 --- a/crawler/database.go +++ b/crawler/database.go @@ -62,7 +62,7 @@ func (app *App) createTables() error { view_query := `CREATE OR REPLACE VIEW ` + v + `_view AS SELECT - angebot.id, angebot.name, angebot.abv, angebot.volume, angebot.url as long_url, angebot.short_url as url, spirit_type, + 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 |