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/database.go | 51 +++++++++++++++++++++++++++++++++++++++++++++ server/database/main.go | 51 --------------------------------------------- 2 files changed, 51 insertions(+), 51 deletions(-) create mode 100644 server/database/database.go delete mode 100644 server/database/main.go (limited to 'server/database') diff --git a/server/database/database.go b/server/database/database.go new file mode 100644 index 0000000..c2c0dfe --- /dev/null +++ b/server/database/database.go @@ -0,0 +1,51 @@ +/* + * 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 InitDB() { + 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() +} + 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