From 17b685396a34cb1fef8439e1b6802c6b7f59fbe2 Mon Sep 17 00:00:00 2001
From: jloup <jeanloup.jamet@gmail.com>
Date: Tue, 1 May 2018 10:16:53 +0200
Subject: [PATCH] Fix PG migrations + redis config.

---
 cmd/ansible/conf.toml.j2 |  5 +++++
 cmd/app/conf.toml        |  1 +
 db/db.go                 |  3 ++-
 db/migrations.go         | 16 ++++++++--------
 4 files changed, 16 insertions(+), 9 deletions(-)

diff --git a/cmd/ansible/conf.toml.j2 b/cmd/ansible/conf.toml.j2
index 5f08a26..b2c3137 100644
--- a/cmd/ansible/conf.toml.j2
+++ b/cmd/ansible/conf.toml.j2
@@ -9,6 +9,11 @@ password="{{ postgres_password }}"
 database="{{ postgres_database }}"
 address="localhost:5432"
 
+[redis]
+type="{{ redis_adress_type }}"
+address="localhost:6379"
+database=0
+
 [api]
 domain="{{ app_domain }}"
 jwt_secret="{{ jwt_secret }}"
diff --git a/cmd/app/conf.toml b/cmd/app/conf.toml
index bdbf58b..13e3e0b 100644
--- a/cmd/app/conf.toml
+++ b/cmd/app/conf.toml
@@ -11,6 +11,7 @@ address="localhost:5432"
 [redis]
 type="tcp"
 address="cryptoportfolio.immae.eu:7617"
+database=0
 
 [api]
 domain="localhost"
diff --git a/db/db.go b/db/db.go
index 078cd58..2596dcb 100644
--- a/db/db.go
+++ b/db/db.go
@@ -26,6 +26,7 @@ type RedisConfig struct {
 	Type     string // tcp or unix
 	Address  string
 	Password string
+	Database int
 }
 
 func Init(config DBConfig, redisConfig RedisConfig) {
@@ -42,7 +43,7 @@ func Init(config DBConfig, redisConfig RedisConfig) {
 		Network:  redisConfig.Type,
 		Addr:     redisConfig.Address,
 		Password: redisConfig.Password,
-		DB:       0,
+		DB:       redisConfig.Database,
 	})
 
 	_, err = Redis.Ping().Result()
diff --git a/db/migrations.go b/db/migrations.go
index 286fe17..38ea8aa 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -26,22 +26,22 @@ var migrations []Migration = []Migration{
 				config      jsonb,
 				UNIQUE(user_id, market_name)
 			)`,
+			`CREATE TABLE reports (
+				id               BIGSERIAL PRIMARY KEY,
+				date             timestamp with time zone NOT NULL,
+				market_config_id bigint NOT NULL,
+				debug            boolean
+			)`,
+			"CREATE INDEX IF NOT EXISTS reports_market_config_id ON reports (market_config_id)",
 			`CREATE TABLE report_lines (
 				id        BIGSERIAL PRIMARY KEY,
 				date      timestamp with time zone NOT NULL,
-				report_id bigint NOT NULL,
+				report_id bigint NOT NULL REFERENCES reports(id),
 				type      text,
 				payload   jsonb
 			)`,
 			"CREATE INDEX IF NOT EXISTS report_lines_report_id ON report_lines (report_id)",
 			"CREATE INDEX IF NOT EXISTS report_lines_type      ON report_lines (type)",
-			`CREATE TABLE reports (
-				id               BIGSERIAL PRIMARY KEY,
-				date             timestamp with time zone NOT NULL,
-				market_config_id bigint NOT NULL,
-				debug            boolean
-			)`,
-			"CREATE INDEX IF NOT EXISTS reports_market_config_id ON reports (market_config_id)",
 		},
 		Down: []string{"DROP TABLE users", "DROP TABLE market_configs", "DROP TABLE report_lines", "DROP TABLE reports"},
 	},
-- 
2.41.0