Adds the Get handler for organisation model and fixes

Also fixes the NotAuthorised response I was mistakenly getting when it
should have been a 404.

2 files changed, 24 insertions, 1 deletions

diff --git a/internal/models/errors.go b/internal/models/errors.go
new file mode 100644
index 0000000..a70c7dc
--- /dev/null
+++ b/internal/models/errors.go
@@ -0,0 +1,7 @@
+package models
+
+import (
+	"errors"
+)
+
+var ErrNoRecord = errors.New("models: no matching record found")
diff --git a/internal/models/organisations.go b/internal/models/organisations.go
index 291562b..edaa992 100644
--- a/internal/models/organisations.go
+++ b/internal/models/organisations.go
@@ -2,6 +2,7 @@ package models
 
 import (
 	"database/sql"
+	"errors"
 	"time"
 )
 
@@ -32,7 +33,22 @@ func (m *OrganisationModel) Insert(name string) (int, error) {
 }
 
 func (m *OrganisationModel) Get(id int) (Organisation, error) {
-	return Organisation{}, nil
+	stmt := `SELECT id, name, created FROM organisations
+            WHERE id = ?`
+
+	row := m.DB.QueryRow(stmt, id)
+
+	var o Organisation
+
+	err := row.Scan(&o.ID, &o.Name, &o.Created)
+	if err != nil {
+		if errors.Is(err, sql.ErrNoRows) {
+			return Organisation{}, ErrNoRecord
+		} else {
+			return Organisation{}, err
+		}
+	}
+	return o, nil
 }
 
 // Ten most recent...