v0.1

1 files changed, 16 insertions, 3 deletions

diff --git a/getdata.go b/getdata.go
index f9e5844..54577c6 100644
--- a/getdata.go
+++ b/getdata.go
@@ -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
+}