Log to an SQL database from multiple threads.
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.