From 62f478feda37fb116ccede1481f80b1bea88fc04 Mon Sep 17 00:00:00 2001
From: horus
Date: Tue, 13 Feb 2018 14:14:52 +0100
Subject: Bugfix. (database)

---
 crawler/database.go | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'crawler/database.go')

diff --git a/crawler/database.go b/crawler/database.go
index 4245c4e..278d891 100644
--- a/crawler/database.go
+++ b/crawler/database.go
@@ -48,12 +48,12 @@ func (app *App) createTables() error {
 
 	for _, v := range views {
 		var spirit_type string
-		if v != "misc" {
-			spirit_type = `spirit_type = "` + v + `" AND`
+		if v == "misc" {
+			spirit_type = `spirit_type NOT IN ("` + strings.Join(views, `", "`) + `") AND`
 		} else if v == "all" {
-			spirit_type = ""
+			spirit_type = "1 = 1 AND "
 		} else {
-			spirit_type = `spirit_type NOT IN ("` + strings.Join(views, `", "`) + `") AND`
+			spirit_type = `spirit_type = "` + v + `" AND`
 		}
 
 		view_query := `CREATE OR REPLACE VIEW ` + v + `_view AS
-- 
cgit v1.2.3