forked from Coalery/FoodNotifierBE_NoSQL
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathupload_data.js
More file actions
178 lines (168 loc) · 6.32 KB
/
upload_data.js
File metadata and controls
178 lines (168 loc) · 6.32 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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
const AWS = require('aws-sdk');
const sqlite3 = require('sqlite3').verbose();
AWS.config.update({
region: "us-west-2",
endpoint: "http://localhost:8000"
});
var docClient = new AWS.DynamoDB.DocumentClient();
let data = new sqlite3.Database('./db/data.db');
let recipe = new sqlite3.Database('./db/recipe.db');
let dataSql = `select * from Food`;
let recipeSql = `select * from Recipe`;
data.all(dataSql, [], (err, rows) => {
console.log('Data getting completed.');
if(err) {
throw err;
}
rows.forEach((row) => {
var id = row.PRDLST_REPORT_NO;
var name = row.PRDLST_NM;
var shelf_life = row.POG_DAYCNT;
var food_type = row.PRDLST_DCNM;
var maker_name = row.BSSH_NM;
var barcode = row.BAR_CD;
var params = {
TableName: "Barcode",
Item: {
"id" : id,
"name" : name,
"shelf_life" : shelf_life,
"food_type" : food_type,
"maker_name" : maker_name,
"barcode" : barcode
}
};
docClient.put(params, (err, data) => {
if(err) {
console.error("Unable to add barcode", name, ". Error JSON:", JSON.stringify(err, null, 2));
} else {
console.log("PutItem succeeded:", name);
}
})
});
});
// recipe.all(recipeSql, [], (err, rows) => {
// if(err) {
// throw err;
// }
// rows.forEach((row) => {
// var id = row.RCP_SEQ;
// var name = row.RCP_NM;
// var way = row.RCP_WAY2;
// var type = row.RCP_PAT2;
// var wgt = row.INFO_WGT;
// var eng = row.INFO_ENG;
// var car = row.INFO_CAR;
// var pro = row.INFO_PRO;
// var fat = row.INFO_FAT;
// var nat = row.INFO_NA;
// var hash_tag = row.HASH_TAG;
// var image_small = row.ATT_FILE_NO_MAIN;
// var image_big = row.ATT_MILE_NO_MK;
// var ingredients = row.RCP_PARTS_DTLS;
// var manual01 = row.MANUAL01;
// var manual_img01 = row.MANUAL_IMG01;
// var manual02 = row.MANUAL02;
// var manual_img02 = row.MANUAL_IMG02;
// var manual03 = row.MANUAL03;
// var manual_img03 = row.MANUAL_IMG03;
// var manual04 = row.MANUAL04;
// var manual_img04 = row.MANUAL_IMG04;
// var manual05 = row.MANUAL05;
// var manual_img05 = row.MANUAL_IMG05;
// var manual06 = row.MANUAL06;
// var manual_img06 = row.MANUAL_IMG06;
// var manual07 = row.MANUAL07;
// var manual_img07 = row.MANUAL_IMG07;
// var manual08 = row.MANUAL08;
// var manual_img08 = row.MANUAL_IMG08;
// var manual09 = row.MANUAL09;
// var manual_img09 = row.MANUAL_IMG09;
// var manual10 = row.MANUAL10;
// var manual_img10 = row.MANUAL_IMG10;
// var manual11 = row.MANUAL11;
// var manual_img11 = row.MANUAL_IMG11;
// var manual12 = row.MANUAL12;
// var manual_img12 = row.MANUAL_IMG12;
// var manual13 = row.MANUAL13;
// var manual_img13 = row.MANUAL_IMG13;
// var manual14 = row.MANUAL14;
// var manual_img14 = row.MANUAL_IMG14;
// var manual15 = row.MANUAL15;
// var manual_img15 = row.MANUAL_IMG15;
// var manual16 = row.MANUAL16;
// var manual_img16 = row.MANUAL_IMG16;
// var manual17 = row.MANUAL17;
// var manual_img17 = row.MANUAL_IMG17;
// var manual18 = row.MANUAL18;
// var manual_img18 = row.MANUAL_IMG18;
// var manual19 = row.MANUAL19;
// var manual_img19 = row.MANUAL_IMG19;
// var manual20 = row.MANUAL20;
// var manual_img20 = row.MANUAL_IMG20;
// var params = {
// TableName: "Recipe",
// Items : {
// "id" : id,
// "name" : name,
// "way" : way,
// "type" : type,
// "wgt" : wgt,
// "eng" : eng,
// "car" : car,
// "pro" : pro,
// "fat" : fat,
// "nat" : nat,
// "hash_tag" : hash_tag,
// "image_small" : image_small,
// "image_big" : image_big,
// "ingredients" : ingredients,
// "manual01" : manual01,
// "manual_img01" : manual_img01,
// "manual02" : manual02,
// "manual_img02" : manual_img02,
// "manual03" : manual03,
// "manual_img03" : manual_img03,
// "manual04" : manual04,
// "manual_img04" : manual_img04,
// "manual05" : manual05,
// "manual_img05" : manual_img05,
// "manual06" : manual06,
// "manual_img06" : manual_img06,
// "manual07" : manual07,
// "manual_img07" : manual_img07,
// "manual08" : manual08,
// "manual_img08" : manual_img08,
// "manual09" : manual09,
// "manual_img09" : manual_img09,
// "manual10" : manual10,
// "manual_img10" : manual_img10,
// "manual11" : manual11,
// "manual_img11" : manual_img11,
// "manual12" : manual12,
// "manual_img12" : manual_img12,
// "manual13" : manual13,
// "manual_img13" : manual_img13,
// "manual14" : manual14,
// "manual_img14" : manual_img14,
// "manual15" : manual15,
// "manual_img15" : manual_img15,
// "manual16" : manual16,
// "manual_img16" : manual_img16,
// "manual17" : manual17,
// "manual_img17" : manual_img17,
// "manual18" : manual18,
// "manual_img18" : manual_img18,
// "manual19" : manual19,
// "manual_img19" : manual_img19,
// "manual20" : manual20,
// "manual_img20" : manual_img20
// }
// };
// docClient.put(params, (err, data) => {
// if(err) {
// console.error("Unable to add barcode. :", name);
// }
// });
// });
// });