A wrapper to do some easy logging and writing and parsing stuff from and to Google Spreadsheets.

Install

npm install data-drive

Or

Clone the repo to your localhost

git clone git@github.com:RamonGebben/data-drive.git

Quick example

var config = require ( ' ./config.json ' ) ; var DD = require ( ' data-drive ' ) ( config ) ; DD . connect ( function ( ) { DD . create ( { " test " : " testing " , " test2 " : " OK " } , function ( ) { console . log ( " done " ) ; } ) } ) ;

Configurations

First you must create a doc to write to. Open your Drive and sign in.

Use this template to create a new sheet.

Next we need to configure the config.json . The config expects the following values to be present:

" auth " : { " username " : " example@gmail.com " , " password " : " password " } , " sheet " : { " name " : " name of sheet " , " id " : " optional id " , " worksheet " : { " name " : " worksheet name " , " id " : " optional id " } }

The sheet.id and sheet.worksheet.id are optional. These will appear in the console when not given, after that you could add them to make the connection faster.

Mapping the sheet

Because Google sheets provides us with a json we can't really work with the data gets remapped. You can ajust the names of the columns in the config.json . A mapping would look like this:

" mapping " : { " columns " : [ [ " 1 " , " key " ] , [ " 2 " , " key1 " ] , [ " 3 " , " key2 " ] ] }

How we receive the data

{ " 1 " : { " 1 " : " pizza " , " 2 " : " koffie " , " 3 " : " kebab " } }

After mapping

{ " key " : " pizza " , " key1 " : " koffie " , " key2 " : " kebeb " , " id " : 1 }

Actions

The action have a very simple syntax:

DD . name_of_action ( [ id ] , data , function ( ) { } ) ;

Although some action may require an id like:

GET

UPDATE

DESTROY

Because else we wouldn't not know which record to update.

GET

The GET action requires an id or an query to find a array of records to match the query.

DD . get ( id , function ( ) { } ) ; DD . get ( ' key === pizza ' , data , function ( ) { } ) ;

CREATE

Adds a new record field to the db and updates it with the data that is given.

DD . create ( data , function ( ) { } ) ;

UPDATE

Update a record.

DD . update ( id , data , function ( ) { } ) ;

DESTROY

Removal is not possible. The record field will be made empty so count as inactive.

DD . destroy ( id , function ( ) { } ) ;

DB

If you want to provide al the info to a client side application you can just dump the entire db.

DD . db ( )

Testing

To run the tests, first cd into the test dir, edit the test_config.json and run: