sql-logger 0.0.2

Log to an SQL database from multiple threads.

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

0. Create an account with Amazon Web Services and create a MySQL RDS database instance

1. Clone the repository

   git clone https://github.com/robotpt/sql-logger
   

2. Install the dependencies and setup the project with your Python path

   pip install -e sql-logger
   

3. Go into the sql-logger

   cd sql-logger
   

4. Create a config.yml file in the home directory that mirrors the following. If id is left blank, then one is assigned based on the next available id in the database.

   log_info:
     database_name: my_database
     id: 
   sql_database:
     host: <url>
     password: mysecretpassword
     port: 3306
     user: <user name>
   

5. Tests can be run with the following commands.

   python3 -m unittest