CLI Reference#
Installing MACPie also installs a number of command line tools. The main
command line tool is called macpie
, and it provides commands that you
can use to analyze data contained in Excel and/or CSV/text files. Other
commands include mpsql
, commands that work with SQL databases, respectively.
All commands should be executed inside your activated virtual environment
(or conda environment) that you created in the Installation section.
The --help
option will give more information about any commands and options.
To install all command line tool dependencies:
$ pip install macpie[cli]
Environment Variables#
Some commands (e.g. mpsql
) support environment variables, which can be
manually set (e.g. export ENV_VAR=ENV_VALUE
), or loaded from a dotenv
file named .macpieenv
located in your home directory.
For example, instead of typing in your database password every time to the
mpsql
command, like so:
$ mpsql -u lava_mac -p lava_mac_dev createtable faq
you can create a file in your home directory called .macpieenv
, and
set the database username and passwords using the proper environment variables
names, like so:
MACPIE_MYSQL_USER = lava_mac_dev
MACPIE_MYSQL_PWD = somepassword
Now, the same command above can be executed with the following command:
$ mpsql lava_mac_dev createtable faq