summaryrefslogtreecommitdiffstats
path: root/internal/models/operation.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/models/operation.go')
-rw-r--r--internal/models/operation.go52
1 files changed, 0 insertions, 52 deletions
diff --git a/internal/models/operation.go b/internal/models/operation.go
deleted file mode 100644
index ecfd31b..0000000
--- a/internal/models/operation.go
+++ /dev/null
@@ -1,52 +0,0 @@
-package models
-
-import (
- "database/sql"
- "time"
-)
-
-type Operation struct {
- ID int
- Name string
- Description string
- Created time.Time
- OrganisationName string
- EngagementStrategies []EngagementStrategy
-}
-
-type OperationModel struct {
- DB *sql.DB
-}
-
-func (m *OperationModel) ListAll() ([]Operation, error) {
-
- stmt := `SELECT op.id, op.name, op.description, op.created, org.name
- FROM operations op
- INNER JOIN organisations org ON op.organisation_id=org.id`
-
- // stmt := `SELECT * FROM operations`
-
- rows, err := m.DB.Query(stmt)
- if err != nil {
- return nil, err
- }
-
- defer rows.Close()
-
- var ops []Operation
-
- for rows.Next() {
- var o Operation
- err = rows.Scan(&o.ID, &o.Name, &o.Description, &o.Created, &o.OrganisationName)
- if err != nil {
- return nil, err
- }
-
- ops = append(ops, o)
- }
-
- if err = rows.Err(); err != nil {
- return nil, err
- }
- return ops, err
-}