diff options
-rw-r--r-- | server/database/database.go | 8 | ||||
-rw-r--r-- | server/database/users.go | 67 | ||||
-rw-r--r-- | server/router/router.go | 6 | ||||
-rw-r--r-- | server/router/users.go | 33 |
4 files changed, 0 insertions, 114 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 -} -*/ diff --git a/server/router/router.go b/server/router/router.go index 7729dd2..9da6d1e 100644 --- a/server/router/router.go +++ b/server/router/router.go @@ -25,20 +25,14 @@ func InitRouter() { api := myRouter.Group("/api") people := api.Group("/people") items := api.Group("/items") - users := api.Group("/users") // items API routes items.GET("/get-all", getAllItems) items.POST("/register", registerItem) - // people API routes people.GET("/get-all", getAllPeople) people.POST("/register", registerPerson) - // users API routes - users.GET("/get-all", getAllUsers) - // users.POST("/register", registerUser) - myRouter.Run(":8080") } diff --git a/server/router/users.go b/server/router/users.go deleted file mode 100644 index d22c47a..0000000 --- a/server/router/users.go +++ /dev/null @@ -1,33 +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 router - -import ( - "github.com/gin-gonic/gin" - "net/http" - - db "github.com/MikunoNaka/openbills/database" -) - -// users API functions -func getAllUsers(ctx *gin.Context) { - ctx.Header("Content-Type", "application/json") - ctx.JSON(http.StatusOK, db.GetAllUsers()) -} - -// func registerUser(ctx *gin.Context) { -// person := db.Person { -// Name: ctx.Query("name"), -// Address: ctx.Query("address"), -// Phone: ctx.Query("phone"), -// Email: ctx.Query("email"), -// } -// -// db.RegisterPerson(person) -// } |