Command line utility to write to Google Docs Spreadsheet
$30-50 USD
En curso
Publicado hace alrededor de 11 años
$30-50 USD
Pagado a la entrega
I need a command line utility written that does the following:
1) Accepts on the command line
---- host name of mysql machine
---- username and password of mysql account
---- a SQL select string
---- the URL of a google docs spreadsheet (will already exist)
---- credentials for the google docs spreadsheet
2) Issues the SQL string to the MySQL database
3) Erases everything in the google docs spreadsheet -- EXCEPT for the first row (which is a header row)
4) Writes each row of the SQL results to a row in the spreadsheet
Then exits.
The utility should be either 1) A groovy shell script or 2) Java code that compiles down into a self-contained .jar file