loutility development process documentation
Contents:
Linux User Account Creation
Add to digitalocean team
Database Migration Handling
Getting Started with alembic
Database Migration
Column update during upgrade
Export Database from MAMP Server
python Package Release Procedures
release to github
sync your fork
release to PyPi
test release with editable install
create .pypirc
release
Initial deploy to server
Ongoing Development
PyCharm Licencing
Python 3
Install on Centos
Convert production project from python 2 to python 3
Install on Windows
Convert development project from python 2 to python 3
Upgrade to newer version of python 3
Development Environment
Target Environment
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
Build and start app in development, no debugging
Build and start app in development, with debugging
Build and start app in Production
Kanban Board
Development Workflow
Docker Development
Installation
Useful Links
Network Troubleshooting
MySQL
Backup / restore from docker container
CI/CD Workflow
Compose repository
strconv.Atoi: parsing “”: invalid syntax
secrets management
security
deploy compose application
Debugging a Docker Service Locally
Some Required Files
Launch Debugger from vscode
Debug pypi Package Stored Locally
Restart Service
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
Enable VHOST
Set up VHOST SSL
caddy setup (Apache alternative)
LAMP Server Create
Create Droplet
Some Upkeep [root]
Additional repos
sudo user
Create non-root user and give sudo access [root]
Set sudo timeout (minutes)
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
Set up Apache
Firewall: allow certain access
Set up HTTPS / certbot
Set up git
Create a2ensite, a2dissite
Set up mysql
Set up PHP
install additional PHP versions
Install and start Docker
Set up VHOST
Backups
Create backup volume
Set up backup
Resize backup volume (only if necessary)
Set up swap volume
Security
Set up server level security
HTTPS Support Notes
Prepare for SSL Certificate
Get certificates from letsencrypt.com
Notes
admin vs. apache user
steps
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
without embedded table(s)
with embedded table(s)
data dependent columns
data dependent select options
row reorder control
add filters to table view
Definitions
loutility development process documentation
Search
Please activate JavaScript to enable the search functionality.