-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.js
More file actions
35 lines (28 loc) · 1.06 KB
/
Copy pathindex.js
File metadata and controls
35 lines (28 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
const uuid = require("uuid/v4");
var mysql = require('mysql');
const connection = mysql.createConnection({
host : process.env.RDS_HOSTNAME,
user : process.env.RDS_USERNAME,
password : process.env.RDS_PASSWORD,
port : process.env.RDS_PORT,
database : process.env.RDS_DATABASE
});
exports.handler = (event, context, callback) => {
console.log('Init');
let body = event;
console.log('Received data:', body);
connection.connect(function(err) {
if (err) throw err;
console.log("Connected!");
var id = uuid();
var created = Date.now();
var sql = `INSERT INTO ${process.env.RDS_DB_TABLE} (id,created,name,surname,dni) VALUES ('${id}', ${created}, '${body.name}', '${body.surName}', '${body.dni}')`;
console.log("Sql:",sql);
connection.query(sql, function (err, result) {
if (err) throw err;
console.log("Number of records inserted: " + result.affectedRows);
connection.end();
callback(null, result);
});
});
};