1 files changed, 51 insertions, 0 deletions
diff --git a/internal/models/person.go b/internal/models/person.go
new file mode 100644
index 0000000..d2b8585
--- /dev/null
+++ b/internal/models/person.go
@@ -0,0 +1,51 @@
+package models
+
+import (
+	"database/sql"
+	"time"
+)
+
+type Person struct {
+	ID               string
+	FirstName        string
+	LastName         string
+	OrganisationName string
+	OrganisationID   int
+	RoleName         string
+	Created          time.Time
+}
+
+type PersonModel struct {
+	DB *sql.DB
+}
+
+func (m *PersonModel) ListAll() ([]Person, error) {
+	stmt := `SELECT p.id, p.first_name, p.last_name, p.role_name, org.name, org.id
+			FROM persons p
+			INNER JOIN organisations org ON p.organisation_id=org.id`
+
+	rows, err := m.DB.Query(stmt)
+	if err != nil {
+		return nil, err
+	}
+
+	defer rows.Close()
+
+	var ps []Person
+
+	for rows.Next() {
+		var p Person
+		err = rows.Scan(&p.ID, &p.FirstName, &p.LastName, &p.RoleName, &p.OrganisationName, &p.OrganisationID)
+		if err != nil {
+			return nil, err
+		}
+
+		ps = append(ps, p)
+	}
+
+	if err = rows.Err(); err != nil {
+		return nil, err
+	}
+
+	return ps, err
+}