diff options
author | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-06-15 12:25:46 +0530 |
---|---|---|
committer | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-06-15 12:25:46 +0530 |
commit | ea88466fda6c719caa9daae5ea4698565fa84426 (patch) | |
tree | cf643b82c43a1724aaa3676fcd7f19e386b9435c /server | |
parent | 37ead7ea9ca1e0c435c57866c289917e0f488459 (diff) |
fixed some errors in SelectClientForm
Diffstat (limited to 'server')
-rw-r--r-- | server/database/people.go | 9 | ||||
-rw-r--r-- | server/filled.db | bin | 0 -> 57344 bytes |
2 files changed, 5 insertions, 4 deletions
diff --git a/server/database/people.go b/server/database/people.go index ac2affa..5fc3bf5 100644 --- a/server/database/people.go +++ b/server/database/people.go @@ -14,6 +14,7 @@ import ( _ "github.com/mattn/go-sqlite3" ) type Person struct { + ID string Name string Address string Phone string @@ -23,16 +24,16 @@ type Person struct { func GetAllPeople() []Person { var allPeople []Person rows, _ := myDatabase.Query( - `SELECT Name, Address, Phone, Email FROM People`, + `SELECT ID, Name, Address, Phone, Email FROM People`, ) var ( - name, address, phone, email string + id, name, address, phone, email string ) for rows.Next() { - rows.Scan(&name, &address, &phone, &email) - allPeople = append(allPeople, Person{name, address, phone, email}) + rows.Scan(&id, &name, &address, &phone, &email) + allPeople = append(allPeople, Person{id, name, address, phone, email}) } return allPeople diff --git a/server/filled.db b/server/filled.db Binary files differnew file mode 100644 index 0000000..d9258ed --- /dev/null +++ b/server/filled.db |