From 0fa16426f56120c4eb18bc18c202703c460daed8 Mon Sep 17 00:00:00 2001
From: MikunoNaka <bokuwakanojogahoshii@yahoo.com>
Date: Sat, 1 May 2021 08:22:47 +0530
Subject: divided package database into multiple files for ease

---
 server/database/main.go | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 server/database/main.go

(limited to 'server/database/main.go')

diff --git a/server/database/main.go b/server/database/main.go
new file mode 100644
index 0000000..ecff904
--- /dev/null
+++ b/server/database/main.go
@@ -0,0 +1,33 @@
+/*
+ * 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_registered_items, _ := myDatabase.Prepare(
+    `CREATE TABLE IF NOT EXISTS registered_items
+    (id INTEGER PRIMARY KEY AUTOINCREMENT,
+    model    TEXT NOT NULL,
+    desc     TEXT,
+    price    REAL,
+    hsn      BLOB,
+    gst      REAL,
+    category TEXT,
+    brand    TEXT)`,
+  )
+  init_registered_items.Exec()
+}
+
-- 
cgit v1.2.3