aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--server/database/database.go8
-rw-r--r--server/database/users.go67
-rw-r--r--server/router/router.go6
-rw-r--r--server/router/users.go33
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)
-// }