From a5bda60647639e787a777446dce693ac330fe940 Mon Sep 17 00:00:00 2001 From: horus_arch Date: Thu, 1 Feb 2018 12:06:16 +0100 Subject: Initial commit. --- drankdozijnnl.go | 18 ++++++++++++++++++ schema.txt | 20 ++++++++++++++++++++ 2 files changed, 38 insertions(+) create mode 100644 drankdozijnnl.go create mode 100644 schema.txt diff --git a/drankdozijnnl.go b/drankdozijnnl.go new file mode 100644 index 0000000..9c1a9f2 --- /dev/null +++ b/drankdozijnnl.go @@ -0,0 +1,18 @@ +package main + +import ( + "log" + + "github.com/PuerkitoBio/goquery" +) + +func ScrapeHtml(url string) { + doc, err := goquery.NewDocument(url) + if err != nil { + log.Fatal(err) + } + +} + +func main() { +} diff --git a/schema.txt b/schema.txt new file mode 100644 index 0000000..a21b69a --- /dev/null +++ b/schema.txt @@ -0,0 +1,20 @@ +CREATE TABLE whisky ( + id int PRIMARY KEY auto_increment, + shop int, + name text, + url text, + price text, + original_price text, + valid_until int, + image_url text, + created_at int +); + +CREATE TABLE shop ( + id int PRIMARY KEY auto_increment, + name text, + website_url text, + logo_url text, + shipping_costs text, + free_shipping text +); -- cgit v1.2.3