require('dotenv').config();
const mysql = require('mysql');
const connection = mysql.createConnection({
connectionLimit: 10,
host: 'localhost',
user: process.env.SQL_USER,
password: process.env.SQL_PASS,
database: 'smart_home'
});
const user_id = process.argv[2].toLowerCase();
const crypto = require('crypto');
crypto.randomBytes(32, function(err, buf) {
if (err) throw err;
const key = buf.toString('hex');
connection.query("UPDATE users SET api_key=? WHERE user_id=?", [key, user_id], function(error) {
if (error) throw error;
console.log("key updated", key);
});
connection.end();
});