diff options
Diffstat (limited to 'server/database')
-rw-r--r-- | server/database/database.go | 8 | ||||
-rw-r--r-- | server/database/users.go | 67 |
2 files changed, 0 insertions, 75 deletions
diff --git a/server/database/database.go b/server/database/database.go index 5e3e940..0499b68 100644 --- a/server/database/database.go +++ b/server/database/database.go @@ -40,14 +40,6 @@ func InitDB() { ) init_people.Exec() - init_users, _ := myDatabase.Prepare( - `CREATE TABLE IF NOT EXISTS Users - (id INTEGER PRIMARY KEY AUTOINCREMENT, - Name TEXT, - Email TEXT)`, - ) - init_users.Exec() - init_invoices, _ := myDatabase.Prepare( `CREATE TABLE IF NOT EXISTS Invoices (id INTEGER PRIMARY KEY AUTOINCREMENT, diff --git a/server/database/users.go b/server/database/users.go deleted file mode 100644 index d31b394..0000000 --- a/server/database/users.go +++ /dev/null @@ -1,67 +0,0 @@ -/* - * OpenBills - Self hosted browser app to generate and keep track of simple invoices - * Version - 0 - * Licensed under the MIT license - https://opensource.org/licenses/MIT - * Copyright (c) 2021 Vidhu Kant Sharma -*/ - -package database - -import ( - _ "github.com/mattn/go-sqlite3" -) - -type User struct { - Name, Email string -} - -func GetAllUsers() []User { - var allUsers []User - rows, _ := myDatabase.Query( - `SELECT Name, Email FROM Users`, - ) - - var ( - name, email string - ) - - for rows.Next() { - rows.Scan(&name, &email) - allUsers = append(allUsers, User{name, email}) - } - - return allUsers -} - -// to be added soon -/* -func RegisterUser(item Item) bool { - itemNames, _ := myDatabase.Query("SELECT model FROM Items") - - register_item, _ := myDatabase.Prepare( - `INSERT INTO Items - (Model, Desc, Price, Hsn, Gst, Category, Brand) - VALUES (?, ?, ?, ?, ?, ?, ?)`, - ) - - // check if item already exists - // probably this should be handled by front end - // so we can check this without need of using api - for itemNames.Next() { - var rModel string - itemNames.Scan(&rModel) - if rModel == item.Model { - return false - } - } - - register_item.Exec( - item.Model, item.Desc, - item.Price, item.HSN, - item.GST, item.Cat, - item.Brand, - ) - - return true -} -*/ |