server/database/main.go


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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()
}