Produce charts of component availability at JLCPCB from a BOM Mirrored from
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Gavan Fantom ea2dd4cccb Add some installation instructions, and acknowledgement 2 years ago
jlcchart Use pysqlite3 if available 2 years ago
.gitignore Initial commit 2 years ago
COPYRIGHT Create COPYRIGHT 2 years ago
LICENSE Create LICENSE 2 years ago Add some installation instructions, and acknowledgement 2 years ago Add jlc-chart app 2 years ago
poll Add poll file to enable cron magic 2 years ago Ensure app is found in the right directory 2 years ago


Flask app to chart component stock levels from JLCPCB


This app can be deployed in the same way as any other WSGI application.

With Apache, that looks something like this:

WSGIDaemonProcess jlc-chart user=... group=... threads=2
WSGIScriptAlias /jlc-chart /path/to/jlc-chart/
WSGIScriptReloading On

<Directory /path/to/jlc-chart>
    WSGIProcessGroup jlc-chart
    WSGIApplicationGroup %{GLOBAL}
    AuthType Basic
    AuthName "Restricted Content"
    AuthUserFile /path/to/.htpasswd
    Require valid-user

Once configuration is complete, the database must be initialised:

flask init-db

Once up and running, a cron job must be created to perform the poll:

crontab -e
1   9       *       *       *       /path/to/jlc-chart/poll


With thanks to Unipart Digital for graciously allowing me to retain copyright of this project after it was initially developed as an in-house tool.