()
| 17 | var changeProductCategory *sql.Stmt |
| 18 | |
| 19 | func openDatabase() (db *sql.DB, err error) { |
| 20 | db, err = sql.Open("sqlite", "products.db") |
| 21 | if (err == nil) { |
| 22 | Printfln("Opened database") |
| 23 | insertNewCategory, _ = db.Prepare("INSERT INTO Categories (Name) VALUES (?)") |
| 24 | changeProductCategory, _ = |
| 25 | db.Prepare("UPDATE Products SET Category = ? WHERE Id = ?") |
| 26 | } |
| 27 | return |
| 28 | } |
| 29 | |
| 30 | func scanIntoStruct(rows *sql.Rows, target interface{}) (results interface{}, |
| 31 | err error) { |