Skip to main content

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

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

  2. Clone the repository

    git clone https://github.com/robotpt/sql-logger
    
  3. Install the dependencies and setup the project with your Python path

    pip install -e sql-logger
    
  4. Go into the sql-logger

    cd sql-logger
    
  5. 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>
    
  6. Tests can be run with the following commands.

    python3 -m unittest
    

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sql-logger, version 0.0.2
Filename, size File type Python version Upload date Hashes
Filename, size sql-logger-0.0.2.tar.gz (5.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page