My query is as follows:
I open a .db file from the cdm of sqlite3, with some queries and I want that same code to be executed as a script from the powershell, so I can create an automated process to execute it in certain time of day.
Is there any command from the cmd of sqlite3 that sends me directly to the shell with all the code changed? Or do I need to learn how to write that code so powershell understands it?
This is the simple code I want to run from PS:
sqlite> .headers on
sqlite> .excel
sqlite> SELECT * FROM analysis;