diff options
Diffstat (limited to 'server/database/main.go')
-rw-r--r-- | server/database/main.go | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/server/database/main.go b/server/database/main.go deleted file mode 100644 index 4eb1a91..0000000 --- a/server/database/main.go +++ /dev/null @@ -1,51 +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 ( - "database/sql" - _ "github.com/mattn/go-sqlite3" -) - -var myDatabase *sql.DB -func StartDB() { - myDatabase, _ = sql.Open("sqlite3", "./openbills.db") - - init_items, _ := myDatabase.Prepare( - `CREATE TABLE IF NOT EXISTS Items - (id INTEGER PRIMARY KEY AUTOINCREMENT, - Model TEXT NOT NULL, - Desc TEXT, - Price REAL, - Hsn BLOB, - Gst REAL, - Category TEXT, - Brand TEXT)`, - ) - init_items.Exec() - - init_people, _ := myDatabase.Prepare( - `CREATE TABLE IF NOT EXISTS People - (id INTEGER PRIMARY KEY AUTOINCREMENT, - Name TEXT, - Address TEXT, - Phone TEXT, - Email TEXT)`, - ) - 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() -} - |