-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase.js
More file actions
80 lines (36 loc) · 1.2 KB
/
database.js
File metadata and controls
80 lines (36 loc) · 1.2 KB
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
const Sequelize = require("sequelize")
const sequelize = new Sequelize("database", "user", "password", {
dialect: "sqlite",
host: "localhost",
storage: "database/database.sqlite",
logging: false
});
module.exports = sequelize;
//const Keyv = require('keyv');
//const dbItem = new Keyv('sqlite://database/db2.sqlite');
//module.exports = dbItem;
/* // Function to save auction item to the database
async function saveAuctionItem(item) {
try {
// Construct an object with keys corresponding to column names
const auctionItemData = {
'ID': item.id,
'Item Name': item.name,
'Bidder Name': item.bidderName,
'Quantity': item.quantity,
'Final Bid': item.finalBid,
'Total Cost': item.totalCost,
'Date': item.itemDate
};
// Save the item data to the database
await dbItem.set(item.id.toString(), auctionItemData);
return item.id; // Return the ID of the inserted item
} catch (error) {
throw new Error('Error saving auction item to the database: ' + error);
}
} */
/*
module.exports = {
set: saveAuctionItem
};
*/