diff options
| -rw-r--r-- | crawler/database.go | 8 |
1 files changed, 4 insertions, 4 deletions
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 |