Check out lnker.me!

Guide to CLI commands for LNKER

Environment

• creating environment: python3 -m venv env
• activating environment: source env/bin/activate
• deactivating environment: deactivate

Pip Packages

• installing from requirements file: python3 -m pip install -r requirements.txt
• backing up to requirements file: python -m pip freeze > requirements.txt

Environment Variables

• setting environment variable: export DATABASE_URL="postgresql://localhost/lnk"

Flask

• Running flask: flask run
• Running flask with auto-reload: FLASK_APP=app.py FLASK_ENV=development flask run
• Alternatively on linux: sudo pg_ctlcluster 12 main start

Jumpstarting Server

• starting postgresql server: sudo service posgresql start
  • alternatively: pg_ctlcluster 12 main start
• stopping postgresql server: sudo service postgresql stop
• restarting postgresql server: sudo service postgresql restart

Finding databases and tables

• starting postgres session: sudo -i -u postgres
• starting psql session: psql
• connect to database: \c lnk
• list tables in database: \dt or \z
• print table: TABLE links