aboutsummaryrefslogtreecommitdiff
path: root/server/database/main.go
diff options
context:
space:
mode:
Diffstat (limited to 'server/database/main.go')
-rw-r--r--server/database/main.go51
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()
-}
-