Read sqlite database using Sqlite.jsm module.

read_sqlite

var {Cc, Ci, Cu} = require("chrome");

Cu.import("resource://gre/modules/Sqlite.jsm");
Cu.import("resource://gre/modules/Task.jsm");

Task.spawn(function* () {
    let db = yield Sqlite.openConnection({ path: filePath});
    
    try {        
        // query to select all cols where plate attribute lives
        let row = yield db.execute(
            "SELECT plate FROM 'myTable'");

        // print out all plates
        for(i=0; i < row.length; i++)
        {
            result = row[i];
            console.log("Car plate :"+ i +" : "+ result.getResultByIndex(0));
        }
    }
    finally {
        yield db.close();
    }
});