Add shop short url. (crawler)

1 files changed, 12 insertions, 4 deletions

diff --git a/crawler/shops.go b/crawler/shops.go
index 06b2b60..63c98ba 100644
--- a/crawler/shops.go
+++ b/crawler/shops.go
@@ -7,11 +7,11 @@ import (
 func (app *App) insertShops() error {
 	shops := getShopsFromStruct()
 
-	query := `INSERT IGNORE INTO shop (name, url, logo_url, shipping_costs, free_shipping) VALUES(?, ?, ?, ?, ?)`
+	query := `INSERT IGNORE INTO shop (name, url, short_url, logo_url, shipping_costs, free_shipping) VALUES(?, ?, ?, ?, ?)`
 
 	for _, v := range shops {
 
-		_, err := app.DB.Exec(query, v.Name, v.Url, v.Logo_url, v.Shipping_costs, v.Free_shipping)
+		_, err := app.DB.Exec(query, v.Name, v.Url, v.Short_url, v.Logo_url, v.Shipping_costs, v.Free_shipping)
 		if err != nil {
 			return err
 		}
@@ -26,7 +26,8 @@ func getShopsFromStruct() []Shop {
 
 	Shops = append(Shops, Shop{
 		Name:           "Bottleworld",
-		Url:            "https://www.bottleword.de",
+		Url:            "https://www.bottleworld.de",
+		Short_url:      "https://l.fuselkoenig.de/bottleworld",
 		Logo_url:       "",
 		Shipping_costs: 599,
 		Free_shipping:  "130€",
@@ -34,6 +35,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "MC Whisky",
 		Url:            "https://www.mcwhisky.com",
+		Short_url:      "https://l.fuselkoenig.de/mcwhisky",
 		Logo_url:       "",
 		Shipping_costs: 590,
 		Free_shipping:  "75€",
@@ -41,6 +43,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Rum & Co",
 		Url:            "https://www.rumundco.de",
+		Short_url:      "https://l.fuselkoenig.de/rumundco",
 		Logo_url:       "",
 		Shipping_costs: 595,
 		Free_shipping:  "100€",
@@ -48,6 +51,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Whic",
 		Url:            "https://whic.de",
+		Short_url:      "https://l.fuselkoenig.de/whic",
 		Logo_url:       "",
 		Shipping_costs: 590,
 		Free_shipping:  "79€",
@@ -55,6 +59,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Whisky.de",
 		Url:            "https://www.whisky.de",
+		Short_url:      "https://l.fuselkoenig.de/whiskyde",
 		Logo_url:       "",
 		Shipping_costs: 395,
 		Free_shipping:  "50€",
@@ -62,6 +67,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Whiskysite.nl",
 		Url:            "https://www.whiskysite.nl",
+		Short_url:      "https://l.fuselkoenig.de/whiskysite",
 		Logo_url:       "",
 		Shipping_costs: 795,
 		Free_shipping:  "",
@@ -69,6 +75,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Whisky World",
 		Url:            "https://www.whiskyworld.de",
+		Short_url:      "https://l.fuselkoenig.de/whiskyworld",
 		Logo_url:       "",
 		Shipping_costs: 460,
 		Free_shipping:  "77€",
@@ -76,6 +83,7 @@ func getShopsFromStruct() []Shop {
 	Shops = append(Shops, Shop{
 		Name:           "Whiskyzone",
 		Url:            "https://www.whiskyzone.de",
+		Short_url:      "https://l.fuselkoenig.de/whiskyzone",
 		Logo_url:       "",
 		Shipping_costs: 495,
 		Free_shipping:  "75€",
@@ -88,7 +96,7 @@ func (app *App) getShops() ([]Shop, error) {
 
 	Shops := []Shop{}
 
-	query := `SELECT id,name,url,logo_url,shipping_costs,free_shipping FROM shop`
+	query := `SELECT id,name,short_url,url,logo_url,shipping_costs,free_shipping FROM shop`
 
 	rows, err := app.DB.Queryx(query)
 	if err != nil {