diff options
author | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-06-13 23:57:18 +0530 |
---|---|---|
committer | MikunoNaka <bokuwakanojogahoshii@yahoo.com> | 2021-06-13 23:57:18 +0530 |
commit | 37ead7ea9ca1e0c435c57866c289917e0f488459 (patch) | |
tree | 8213307afb592c574ad80587e0cef55b6d92b9df /server/database/main.go | |
parent | d154e1e37b026679fc76c6708f6b16951ed07dd9 (diff) |
seperated the router into another module
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() -} - |