EpisodeNames - a copy paste experience

This is a needlessly complicated tool for a simple job.

The situation was as follows: since 14 years do I make Youtube videos, mostly start-stop lets plays that honestly barely anyone watches. But, I do care and its a good way to get single player games done. Anyway, what I also care about is a proper naming scheme and numbering of all those videos and their description. Over the years I amassed over 10000 videos. My biggest project is Elder Scrolls Online which alone will reach 2000 Videos soon. The naming scheme for each episode is quite complicated and i have to iterate some numbers for every single video, some for sessions.

The solution is this over engineered piece of equipment:

tl;dr: this is a textual testing ground slash pattern mine for future projects. Think Factorio when you first build a base to have the resource to get to the real base

On the left a tree view with all my projects, on the right the currently active view of all the episodes. A simple key combination copies the assigned template text to the clipboard (using pyperclip currently). There is also a screen to edit templates and projects.

If this is the only thing I wanted I could have just used some scripts that use an SQLite database directly and I would have inputed the data via an database explorer. Or some pre-fabbed input mask. But i like TUIs and I cannot lie.

So here we are now, mostly this is a big learning experience for me to try different TUI design patterns.

Currently I got ModalScreens, ScreenModes, Notify and one TextArea going for me. There is some other experimentation as well. I use the peeweeORM for this one, I never touched it before and I saw it in some random project and wanted to try it. I am not so sure if its the right way, but I hope my software stack is sound and allows, if the need arises, to replace everything under the hood.

How to install

1. Check out git
2. Change to folder
3. Create virtual environment $ python3 -m venv venv
4. Activate venv $ source venv/bin/activate
5. $ pip install -e . for editable module installation, this should, hopefully resolve all dependencies
6. $ python3 episode_names/Utility/order.py to create dummy data
7. $ python3 episode_names/app.py

Todos

• Making the entire workflow in interface possible
  • Creating, Editing, Deleting Templates
  • Assigning Templates to Episodes
  • Creating Projects
• Logic functions that keep internal numbering consistent
• Styling - different colors than default partially solved by textual 0.86?
• Import/Export of data
• Use proper tools for i18n and not some thrown together gobbligob
• Use proper user folders
• add some cli flags for db folders and stuff (user profiles? why though?)
• rearrange files by screens and modals
• make project tree view more sophisticated
• sort projects by episode edited data and category alphabetical

Ideas

• Import of all existing stuff I got on Youtube, separate descriptions from rest and make this the one-stop management solution for all my videos
• Find title duplicates
• save additonal meta data
• make the interface more sleek and faster to use for the haxxor experience
• hide currently not working keyboard shortcuts

Know Issues

• Cannot duplicate template yet
• Some number inconsistency, sometimes -1 is assigned which is a bad way
• Per default, a new project has no template assigned, which might go haywire. Currently, dummy data creates a manual template 0 which should sidestep this
• all the database stuff always happens in the current working directory