-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathSqlConnection.js
More file actions
40 lines (33 loc) · 1.06 KB
/
SqlConnection.js
File metadata and controls
40 lines (33 loc) · 1.06 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
//var sql = 'INSERT INTO webdrama(Field 명들) VALUES(테이블에 넣을 값 이걸 파일로해서 넣어야하는데 문제)';
var mysql = require('mysql');
var test = require('./Video.js');
var con = mysql.createConnection({
host: "127.0.0.1",
user: "root",
password: "111111",
database : "webdrama",
charset : 'utf8mb4'
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
test.AngryDoyoon(function (response) {
let data = response.snippet;
let likecount = response.statistics;
var sql = 'INSERT INTO episode_video(title, description, channelId, likeCount) VALUES(?,?,?,?)'
var params = [];
let a = params.push(data.title);
let b = params.push(data.description);
let s = params.push(data.channelId);
let c = params.push(likecount.likeCount);
console.log(params);
con.query(sql, params,function(err, rows, fields){
if(err){
console.log(err);
}
else{
console.log(rows);
}
})
});