SQL Execution Support about atom-script HOT 5 CLOSED

First I've heard. It's all yours!

The primary issue you're going to run into is what SQL shell the user is working with (psql, sqlite3). Not sure it can be inferred.

from atom-script.

OK. I'll take a look. I figured there might be a 'what-sql' issue, but that could be addressed in a configuration file somewhere (as we'd also need to store database name, username, etc).

from atom-script.

Piggybacking on this thread since it seems to be main/original SQL discussion:

It is currently possible to run a file with SQL commands by creating a "Script: Run Options" profile containing (PostgreSQL as example, assuming passwords are set accordingly):

Command: psql
Command Arguments: -h server -U user -d database -f {FILE_ACTIVE}

While a better way to input the login data would be great, this current state is sufficient for most use cases (at least for me).

HOWEVER: Since atom-script does not support SQL, running with this "Run Option" fails due to "Command not configured for SQL". The workaround is to set the language of the current buffer (CTRL+SHIFT+L on Windows) to a supported language (for example C). This, in turn, ruins syntax highlighting, toggle-comment etc. and consequently forces me to switch between SQL, C and back to SQL quite often.

Enabling support for SQL files and maybe adding some helpful information in the readme/when running SQL files would go a long way to make atom-script useable for SQL in general.

from atom-script.

@MrTrustworthy thanks for outlining a solution. Want to create a dummy runner that runs e.g. echo "SQL requires setting Script: Run Options directly"?

from atom-script.

Sure! I'll send a pull request once I'm done.

from atom-script.