From 37ead7ea9ca1e0c435c57866c289917e0f488459 Mon Sep 17 00:00:00 2001 From: MikunoNaka Date: Sun, 13 Jun 2021 23:57:18 +0530 Subject: seperated the router into another module --- server/database/main.go | 51 ------------------------------------------------- 1 file changed, 51 deletions(-) delete mode 100644 server/database/main.go (limited to 'server/database/main.go') 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() -} - -- cgit v1.2.3