Create CLI

[jlord]

So that you don't have to edit server.js to set the expiration time or spreadsheet key.

[jlord]

Goals/intended workflow of Sheetsee-cache as a command line node module.

• sheetsee init <spreadsheetkey> <filename.html> to initialize a full instance of sheetsee; this includes building out a directory for required libraries and making a .html file with the minimum elements for getting started.
  • ideally you could then add your own html and css then push the directory to Heroku or something and voila.
• sheetsee update will force a fetch of the latest data from the spreadsheet and overwrite the existing spreadsheet data
  • while you're developing the site, you don't have to go fetch the data from Google (and therefore can develop offline in airport terminals) unless you want to go get new data.
• sheetsee expire <miliseconds> set an expiration data for your data upon which time a request to your .html file will trigger fetching new data. this defaults to never expire.
  • if you have data that will be updating during the lifetime of your site, you'll want to have it update every now and again on it's own instead of using update and pushing changes again.

also

• sheetsee <spreadsheetkey> to write data from spreadsheet to a file in current directory without starting an instance (basically, just a transform of your remote spreadsheet data into json saved locally).

cc @SaraJo - realized this wasn't as quick of a project as I initially thought. Want to also get your thoughts on what the module should do.

cc @maxogden in case i forgot something

[SaraJo]

Why does there need to be a copy of the spreadsheet serverside? Can you not make a request from the server? Is is it a cross domain limitation?

Asking for context purposes.

[jlord]

The purpose of the copy on the server is because sometimes going to Google to get the data can take a while*. Storing it on your server eliminates that step and means your page will probably load faster.

• If your spreadsheet is really popular it could never return your spreadsheet data. This happened after a spreadsheet was made of people offering places to stay after the Boston Marathon bombings and what got my mind thinking this way, wanting to prevent people from not being able to get no information because it was being hit so much.
• If you're designing the page and refreshing a lot in your page it's annoying to have to wait for Google to return the data.
• If you run it once locally, you can use that snapshot of data to develop locally offline!