diff options
Diffstat (limited to 'database.go')
| -rw-r--r-- | database.go | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/database.go b/database.go index c455d87..ad09e7d 100644 --- a/database.go +++ b/database.go @@ -47,6 +47,7 @@ CREATE TABLE IF NOT EXISTS entry ( stars VARCHAR(255) NOT NULL, update_period INT NOT NULL, created_at TIMESTAMP NOT NULL, + natural_language VARCHAR(255), CONSTRAINT fk_entry_owner FOREIGN KEY (owner) REFERENCES owner(id), CONSTRAINT fk_entry_platform FOREIGN KEY (platform) REFERENCES platform(id), CONSTRAINT fk_entry_language FOREIGN KEY (language) REFERENCES language(id), @@ -76,6 +77,8 @@ JOIN language ON entry.language = language.id JOIN update_period ON entry.update_period = update_period.id + WHERE + natural_language != 'Chinese' ORDER BY created_at DESC; `, } @@ -155,6 +158,7 @@ func (app *App) SaveEntries(entries []Entry) error { url, language, stars, + natural_language, update_period, created_at ) VALUES ( @@ -167,6 +171,7 @@ func (app *App) SaveEntries(entries []Entry) error { ?, ?, ?, + ?, ? ); ` @@ -189,7 +194,7 @@ func (app *App) SaveEntries(entries []Entry) error { if err != nil { continue } - _, err = stmt.Exec(e.Title, e.Synopsis, e.Owner.ID, e.Platform.ID, e.URL, e.Language.ID, e.Stars, e.UpdatePeriod.ID, app.Now) + _, err = stmt.Exec(e.Title, e.Synopsis, e.Owner.ID, e.Platform.ID, e.URL, e.Language.ID, e.Stars, e.NaturalLanguage, e.UpdatePeriod.ID, app.Now) if err != nil { Warn(err, "SaveEntries: Statement execution failed") |