diff options
Diffstat (limited to 'internal/models/operation.go')
-rw-r--r-- | internal/models/operation.go | 52 |
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 -} |