diff options
Diffstat (limited to 'getdata.go')
| -rw-r--r-- | getdata.go | 19 |
1 files changed, 16 insertions, 3 deletions
@@ -5,7 +5,7 @@ func (app *App) GetPlatforms() []Platform { platforms := []Platform{} query := ` - SELECT id, name, FROM Platform; + SELECT id, name, url FROM platform; ` rows, err := app.DB.Queryx(query) @@ -30,7 +30,7 @@ func (app *App) GetLanguages() []Language { languages := []Language{} query := ` - SELECT id, name, FROM language; + SELECT id, name FROM language; ` rows, err := app.DB.Queryx(query) @@ -55,7 +55,7 @@ func (app *App) GetUpdatePeriods() []UpdatePeriod { periods := []UpdatePeriod{} query := ` - SELECT id, name, FROM update_period; + SELECT id, name FROM update_period; ` rows, err := app.DB.Queryx(query) @@ -74,3 +74,16 @@ func (app *App) GetUpdatePeriods() []UpdatePeriod { return periods } + +func (app *App) GetOwnerID(owner *Owner) (*Owner, error) { + + query := `SELECT id, name, url FROM owner WHERE url = ?` + + err := app.DB.QueryRowx(query, owner.URL).StructScan(owner) + if err != nil { + Warn(err, "GetOwnerID: Query or StructScan failed") + return &Owner{}, err + } + + return owner, nil +} |
