README
Log to an SQL database from multiple threads.
This program allows you to log information to different topics stored in a database file, extract subsets based on certain condition, as well as converting such selections into dataframes.
Run instructions
Note, only tested with Python 3
-
Create an account with Amazon Web Services and create a MySQL RDS database instance
-
Clone the repository
git clone https://github.com/robotpt/sql-logger
-
Install the dependencies and setup the project with your Python path
pip install -e sql-logger
-
Go into the sql-logger
cd sql-logger
-
Create a
config.yml
file in the home directory that mirrors the following. Ifid
is left blank, then one is assigned based on the next availableid
in the database.log_info: database_name: my_database id: sql_database: host: <url> password: mysecretpassword port: 3306 user: <user name>
-
Tests can be run with the following commands.
python3 -m unittest