diff options
Diffstat (limited to 'server/database')
-rw-r--r-- | server/database/main.go | 7 | ||||
-rw-r--r-- | server/database/people.go | 19 |
2 files changed, 13 insertions, 13 deletions
diff --git a/server/database/main.go b/server/database/main.go index de2365c..811a8eb 100644 --- a/server/database/main.go +++ b/server/database/main.go @@ -33,9 +33,10 @@ func StartDB() { init_people, _ := myDatabase.Prepare( `CREATE TABLE IF NOT EXISTS People (id INTEGER PRIMARY KEY AUTOINCREMENT, - Name TEXT, - Phone TEXT, - Email TEXT)`, + Name TEXT, + Address TEXT, + Phone TEXT, + Email TEXT)`, ) init_people.Exec() } diff --git a/server/database/people.go b/server/database/people.go index 01cbba8..e0930b0 100644 --- a/server/database/people.go +++ b/server/database/people.go @@ -14,10 +14,10 @@ import ( _ "github.com/mattn/go-sqlite3" ) type Person struct { - ID int - Name string - Phone string - Email string + Name string + Address string + Phone string + Email string } func GetAllPeople() []Person { @@ -27,13 +27,12 @@ func GetAllPeople() []Person { ) var ( - name, phone, email string - id int + name, address, phone, email string ) for rows.Next() { - rows.Scan(&id, &name, &phone, &email) - allPeople = append(allPeople, Person{id, name, phone, email}) + rows.Scan(&name, &address, &phone, &email) + allPeople = append(allPeople, Person{name, address, phone, email}) } return allPeople @@ -43,12 +42,12 @@ func RegisterPerson(person Person) bool { register_person, _ := myDatabase.Prepare( `INSERT INTO People - (Name, Phone, Email) + (Name, Address, Phone, Email) VALUES (?, ?, ?)`, ) register_person.Exec( - person.Name, person.Phone, person.Email, + person.Name, person.Address, person.Phone, person.Email, ) return true |