node package manager

node-google-sql

Access to the google sql (fusion table) api

node-google-sql

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

Install

npm install node-google-sql

Test script

I have included a small test file. It should let you know that everything is up and running

node test.js <username> <password>

Usage

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));
    });