From 1a57267a17c2fc17fb6e104846fabc3e363c326c Mon Sep 17 00:00:00 2001 From: Emile Date: Fri, 16 Aug 2024 19:50:26 +0200 Subject: initial commit --- src/bit.go | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 src/bit.go (limited to 'src/bit.go') diff --git a/src/bit.go b/src/bit.go new file mode 100644 index 0000000..33c693a --- /dev/null +++ b/src/bit.go @@ -0,0 +1,42 @@ +package main + +// struct element names can't start with nums... +type Bit struct { + ID int + Name string + Enabled bool +} + +////////////////////////////////////////////////////////////////////////////// +// GENERAL PURPOSE + +func BitGetAll() ([]Bit, error) { + return globalState.GetAllBits() +} + +////////////////////////////////////////////////////////////////////////////// +// DATABASE + +func (s *State) GetAllBits() ([]Bit, error) { + rows, err := s.db.Query("SELECT id, name FROM bits") + defer rows.Close() + if err != nil { + return nil, err + } + + var bit []Bit + for rows.Next() { + var arch Bit + if err := rows.Scan(&arch.ID, &arch.Name); err != nil { + return bit, err + } + bit = append(bit, arch) + } + if err = rows.Err(); err != nil { + return bit, err + } + return bit, nil +} + +////////////////////////////////////////////////////////////////////////////// +// HTTP -- cgit 1.4.1