· 8 years ago · Feb 07, 2018, 09:32 PM
1package storage
2
3const createTableProductStmt = `
4CREATE TABLE IF NOT EXISTS product (
5 id INTEGER PRIMARY KEY AUTOINCREMENT
6, name varchar(50)
7, desc TEXT
8, attributes TEXT
9, images TEXT
10, created timestamp
11);
12`
13
14const insertProductStmt = `
15INSERT INTO product (
16 id
17, name
18, desc
19, attributes
20, images
21, created
22) VALUES (?,?,?,?,?,?)
23`
24
25const selectProductsStmt = `
26SELECT
27 id
28, name
29, desc
30, attributes
31, images
32, created
33FROM users
34`
35
36const selectProductByIDStmt = `
37SELECT
38 id
39, name
40, desc
41, attributes
42, images
43, created
44FROM product
45WHERE id=?
46`