weather

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('weather.db');

var cw = {
    "coord":{"lon":-56.17,"lat":-34.83},
    "weather":{"id":802,"main":"Clouds","description":"scattered clouds","icon":"03d"}, // original [] brackets left out
    "base":"cmc stations",
    "main":{"temp":57.38,"pressure":1007,"humidity":67,"temp_min":55.99,"temp_max":59},
    "wind":{"speed":17.22,"deg":290},
    "clouds":{"all":40},
    "dt":1464720604,
    "sys":{"type":1,"id":4623,"message":0.0052,"country":"UY","sunrise":1464691421,"sunset":1464727278},
    "id":3441575,
    "name":"Montevideo",
    "cod":200
};

db.serialize(function() {
    db.run('CREATE TABLE IF NOT EXISTS current (City_ID integer, City_name text, Country text, Date_Time integer, W_main text, W_desc text, Temp integer, Wind_Sp integer, Wind_Dir integer, Humidity integer, Pressure integer, Sunrise integer, Sunset integer)');

    db.run('INSERT INTO current VALUES (cw.id, cw.name, cw.sys.country, cw.dt, cw.weather.main, cw.weather.description, cw.main.temp, cw.wind.speed, cw.wind.deg, cw.main.humidity, cw.main.pressure, cw.sys.sunrise, cw.sys.sunset)');

    db.all('SELECT * FROM current', function(err, row) {
        console.log(row);
    });
});

db.close();