loutility development process documentation

Contents:

• Linux User Account Creation
  • Add to digitalocean team
• Database Migration Handling
  • Getting Started with alembic
  • Database Migration
• python Package Release Procedures
  • release to github
  • sync your fork
  • release to PyPi
  • Initial deploy to server
  • Ongoing Development
  • PyCharm Licencing
• Python 3
  • Install on Centos
  • Install on Windows
  • Upgrade to newer version of python 3
• Linux - Random Procedures
  • Set Script as Service
• Development Environment
  • Required Software
  • Required account access
  • Development System Configuration
  • Supporting images
  • Shell file permissions
  • Create admin users
  • vscode launch.json
  • Development vs Production via docker compose
  • Kanban Board
  • Development Workflow
• Docker Development
  • Installation
  • Useful Links
  • Network Troubleshooting
  • MySQL
  • CI/CD Workflow
  • Compose repository
  • strconv.Atoi: parsing “”: invalid syntax
  • secrets management
  • security
  • deploy compose application
  • Debugging a Docker Service Locally
  • Caddy Configuration
  • Apache Configuration (obsolete)
  • flask db migrations
  • Initial Deploy of Docker Web App to Server
• Docker Based Server Setup
  • Some initial housekeeping
  • Set up firewall
  • Install and start docker
  • Create application user and set them up for docker
  • Set up rsnapshot backups
  • Set up caddy
  • Set up fail2ban
  • Set up web site
• MySQL Database Management
  • Install and access phpMyAdmin
  • Create MySQL Database
  • Create MySQL Database User
  • Give MySQL User Access to MySQL Database
  • database dump / restore
• Linux Virtual Host Setup
  • Create user for VHOST update
  • Update DNS (optional)
  • Create VHOST
  • Set up VHOST SSL
  • caddy setup (Apache alternative)
• LAMP Server Create
  • Create Droplet
  • Some Upkeep [root]
  • sudo user
  • history should display date/time
  • Set local time and keep in sync
  • Turn off cron information to /var/log/messages
  • Set /usr/local/lib in library path
  • LAMP and Security Stack
  • Install and start Docker
  • Set up VHOST
  • Backups
  • Set up swap volume
  • Security
• HTTPS Support Notes
  • Prepare for SSL Certificate
  • Get certificates from letsencrypt.com
  • Notes
  • Security Tips
• Patterns
  • loutilities.tables-assets
  • loutilities.user single sign-on
  • interests task with single sign-on
  • optimistic concurrency control for edit window
  • show popup after edit update
  • spoof id for database behavior on composite records
  • button icon for table action on row
  • standalone Editor popup for datatables button handler
  • datatable child row
  • data dependent columns
  • data dependent select options
  • row reorder control
  • add filters to table view
• Definitions

Indices and tables

• Index

• Module Index

• Search Page