This is the first version of a node module to access the google sql (fusion tables) api.
Please get in touch if you use this or would like more information.
More to follow
npm install node-google-sql
I have included a small test file. It should let you know that everything is up and running
node test.js <username> <password>
Some example usage to get you started...
googleSql.login('<user>','<password>', function () {
googleSql.getTables(function (d) {
console.log(JSON.stringify(d));
});
});
var data =
[
[['name','test'],['location','53.48214672 -2.237863541']],
[['name','test2'],['location','53.48417373 -2.237230539']]
];
googleSql.insertRow(1307518,data,
function (d) {
console.log(JSON.stringify(d));
});
var tableDesc = [
['name','STRING'],
['location','LOCATION']
];
googleSql.createTable('testTable',tableDesc,
function (d) {
console.log(JSON.stringify(d));
});