unique_in_2k12.js

var fs = require('fs');
var moment = require('moment');
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('sometime.sqlite');

var day = moment("01-01-2012", "MM-DD-YYYY");
var last = moment("01-02-2012", "MM-DD-YYYY");
var end = moment("01-01-2013", "MM-DD-YYYY");

var allusers = {};

db.all(('select distinct(user_id) as u '+
   'FROM osm_changeset WHERE '+
   'closed_at > {start} AND closed_at < {end}')
    .replace(/{start}/g, day.unix())
    .replace(/{end}/g, end.unix()),
function(err, rows) {
    for (var i = 0; i < rows.length; i++) {
        allusers[rows[i].u] = true;
    }
    // console.log('unique users who edited before 01-01-2012: ' + Object.keys(allusers).length);
    console.log('uniques in 2012 ' + Object.keys(allusers).length);
    run();
});