DIMMiN

Created at: July 1, 2026, noon Updated at: July 1, 2026, 2:17 a.m.

2026-07-01-Wednesday

Created at: July 1, 2026, noon Updated at: June 30, 2026, 12:30 p.m.

Implemented a fix using a Django Management Command to de-dupe / merge TwitchUser objects that had the same user_id
Included the psql installation in my Dockerfile so I can use Django DBShell to log into the PostgreSQL database directly for each user with their respective scoped permissions (i.e the dev account can only access the dev database, the test account can only access and alter the test database, etc.)
Integrated TwitchFollow, TwitchChannelPointsRedemption, TwitchShoutOut, and TwitchAdBreak
Pushed changes to Production, specifically including integration tests into the workflow as a final check.

Created at: July 1, 2026, noon Updated at: June 30, 2026, 3:14 a.m.

Implemented caching for broadcaster TwitchUser model so I don't have to get it from the database each time
Started parsing twitchbot logs in Integration Tests allowing me to automatically catch twitchbot errors during testing
Began storing logs for each app in the /app/logs/APP_NAME.log directory.
Attempted to push through to Production but realized I needed to correct the duplicate User IDs before migrating.
Accidentally attempted to merge a failed test deployment into the master branch, but thankfully my CICD Pipeline blocked it since test failed deployment. Cool!

Created at: July 1, 2026, noon Updated at: June 28, 2026, 1:02 p.m.

Woke up this morning to see that OAuth tokens were rotated and seem to be properly handled in test and production environments now.
Used this ErrorComponent from the twitchio docs to handle the command errors regardless of HOST_TYPE (so that the test environment could also handle errors in the same way)
Installed the Twitch CLI and managed to create and send test events directly to the application (which can be picked up by the dev bot) so I can test data extraction from data payload objects
Worked on updating Unit Tests and developing Integration Tests to test data collection before it goes to Production
Saved my first event (a TwitchRaid) using Django's Asynchronous save (asave) command instead of sync_to_async

Created at: July 1, 2026, noon Updated at: June 27, 2026, 11:47 a.m.

Completed OAuth flow setup
Realized that a single twitch application can support and monitor many different users
Pushed updated code through to Production
Reached out to catalixia to ask her to authorize the apps for the test and Production environments
catalixia authorized both test and production apps, bot worked in production
Identified and fixed a bug when extracting from a Token payload during auto-refresh, now this bot should handle any necessary
Created utility functions that can check the validity of access tokens and also revoke them

Created at: July 1, 2026, noon Updated at: June 26, 2026, 10:41 p.m.

Created a script to automate the database migration process from SQLlite to PostgreSQL from the running Portainer server (including wiping existing database and authorizing scoped users)
Updated TwitchCredentials so that all information required for an app is associated with the same object
Updated the OAuth flow so that refresh tokens and access tokens wait for user to authenticate before starting the bot
Pushed new OAuth flow through to production, set up catalixia's credentials so we can start testing data there.

Created at: July 1, 2026, noon Updated at: June 25, 2026, 11:04 a.m.

Fixed the Python django-axes lock out issue by using Python django-ipware and forwarding the real user IP Address through the Cloudflare Tunnel
Routed true IP Address from the Cloudflare Tunnel to Python django-axes so that I don't keep getting locked out of the account.
Figured out OAuth token collection for test and production sites, successfully deployed to both environments
Updated OAuth token so that oauth flow goes through the /twitchbot/ Django Route (keeping it separate from any future oauth processes)
Updated GitHub Actions so that migrations and collecting staticfiles only spins up the docker's web (Django) process instead of spinning up all services to speed up deployment

Created at: June 25, 2026, noon Updated at: June 24, 2026, 2:56 p.m.

Pushed code through CICD Pipeline to Production
Deployed test and prod environments to the appropriate Web Domain and configured each with its own respective Cloudflare Tunnel
Fixed Static Files not rendering by applying collectstatic and migrations before officially spinning up the Docker Container

Created at: June 25, 2026, noon Updated at: June 24, 2026, 3:20 a.m.

Completed OAuth token handling so that tokens are stored in the actual PostgreSQL database (not a separate tokens.db file)
Created the streamer user group
Implemented an admin Mixin so that only users who are logged in can access the actual dashboard
Installed Python django-extensions for some useful Django tools that make development easier
Installed Python django-axes to track and apply Rate Limits to user login attempts
Pushed the new code through to test but hit some errors with the Static Files before pushing to prod
Fixed the EACCESS error by re-assigning permissions to all Docker created files to files that the GitHub Runner can alter

Created at: June 25, 2026, noon Updated at: June 21, 2026, 12:22 p.m.

Created databases and roles on the PostgreSQL server that could programattically access their respective databases, preparing for the migration from SQLlite