Skip to content

Instantly share code, notes, and snippets.

@snit-ram
Last active September 29, 2016 13:59
Show Gist options
  • Save snit-ram/c9ad294f23b5f220eceb to your computer and use it in GitHub Desktop.
Save snit-ram/c9ad294f23b5f220eceb to your computer and use it in GitHub Desktop.
var fetch = require('node-fetch');
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});
connection.connect();
fetch('https://cloud.tanaza.com/apis/v1/5ED6A320FB7BD45BA5A283EE5A0A76F7/449E22BDD06323E517D5C665ADA7D507/status').then(function(res) {
var dados = res.json();
dados.payload.networks.forEach(function(rede){
connection.query('INSERT INTO "tabela" SET ?', {
"campo_no_mysql": rede.label,
"outro_campo_no_mysql": rede.status,
});
})
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment