From 4dc18e3691127e058833fd9c7a5bbee333c3a66c Mon Sep 17 00:00:00 2001
From: Max
Date: Wed, 17 Apr 2019 09:44:56 +0200
Subject: Initial commit.

---
 getdata.go | 76 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 76 insertions(+)
 create mode 100644 getdata.go

(limited to 'getdata.go')

diff --git a/getdata.go b/getdata.go
new file mode 100644
index 0000000..f9e5844
--- /dev/null
+++ b/getdata.go
@@ -0,0 +1,76 @@
+package main
+
+func (app *App) GetPlatforms() []Platform {
+
+	platforms := []Platform{}
+
+	query := `
+		SELECT id, name, FROM Platform;
+	`
+
+	rows, err := app.DB.Queryx(query)
+	if err != nil {
+		Fatal(err, "GetPlatforms: Query failed")
+	}
+	for rows.Next() {
+		var p Platform
+		err = rows.StructScan(&p)
+		if err != nil {
+			Fatal(err, "GetPlatforms: StructScan failed")
+		}
+
+		platforms = append(platforms, p)
+	}
+
+	return platforms
+}
+
+func (app *App) GetLanguages() []Language {
+
+	languages := []Language{}
+
+	query := `
+		SELECT id, name, FROM language;
+	`
+
+	rows, err := app.DB.Queryx(query)
+	if err != nil {
+		Fatal(err, "GetLanguages: Query failed")
+	}
+	for rows.Next() {
+		var l Language
+		err = rows.StructScan(&l)
+		if err != nil {
+			Fatal(err, "GetLanguages: StructScan failed")
+		}
+
+		languages = append(languages, l)
+	}
+
+	return languages
+}
+
+func (app *App) GetUpdatePeriods() []UpdatePeriod {
+
+	periods := []UpdatePeriod{}
+
+	query := `
+		SELECT id, name, FROM update_period;
+	`
+
+	rows, err := app.DB.Queryx(query)
+	if err != nil {
+		Fatal(err, "GetUpdatePeriods: Query failed")
+	}
+	for rows.Next() {
+		var p UpdatePeriod
+		err = rows.StructScan(&p)
+		if err != nil {
+			Fatal(err, "GetUpdatePeriods: StructScan failed")
+		}
+
+		periods = append(periods, p)
+	}
+
+	return periods
+}
-- 
cgit v1.2.3