home · contact · privacy
ytplom
10 days agoEnsure DbConn encapsulates its executions into rollbackable transactions.
Christian Heller [Mon, 2 Dec 2024 11:12:04 +0000 (12:12 +0100)]
Ensure DbConn encapsulates its executions into rollbackable transactions.

11 days agoFrom sync script, remove no-longer-necessary ID name differentiation.
Christian Heller [Sun, 1 Dec 2024 07:48:57 +0000 (08:48 +0100)]
From sync script, remove no-longer-necessary ID name differentiation.

11 days agoTurn files.sha512_digest into new primary key, get rid of .rel_path base64-encoding...
Christian Heller [Sun, 1 Dec 2024 07:42:28 +0000 (08:42 +0100)]
Turn files.sha512_digest into new primary key, get rid of .rel_path base64-encoding shenanigans.

11 days agoTo files table, add sha512 checksum field.
Christian Heller [Sun, 1 Dec 2024 07:07:59 +0000 (08:07 +0100)]
To files table, add sha512 checksum field.

12 days agoMove "delete" flag in files.flags into highest bit.
Christian Heller [Sun, 1 Dec 2024 01:43:50 +0000 (02:43 +0100)]
Move "delete" flag in files.flags into highest bit.

12 days agoFix sync script bug of trying to JSONize pathlib.Path objects.
Christian Heller [Sun, 1 Dec 2024 01:35:21 +0000 (02:35 +0100)]
Fix sync script bug of trying to JSONize pathlib.Path objects.

12 days agoMinor DbConnection usage fixes, a renaming for convenience.
Christian Heller [Sat, 30 Nov 2024 22:55:21 +0000 (23:55 +0100)]
Minor DbConnection usage fixes, a renaming for convenience.

12 days agoRefactor DbConnection into context manager.
Christian Heller [Sat, 30 Nov 2024 22:45:10 +0000 (23:45 +0100)]
Refactor DbConnection into context manager.

12 days agoIn http module, mark with underscore constants not used outside.
Christian Heller [Sat, 30 Nov 2024 18:44:13 +0000 (19:44 +0100)]
In http module, mark with underscore constants not used outside.

12 days agoRefactor YoutubeQuery creation.
Christian Heller [Sat, 30 Nov 2024 18:40:55 +0000 (19:40 +0100)]
Refactor YoutubeQuery creation.

12 days agoFix /yt_result showing file path even if file not .present.
Christian Heller [Sat, 30 Nov 2024 18:23:21 +0000 (19:23 +0100)]
Fix /yt_result showing file path even if file not .present.

12 days agoRefactor VideoFile.flags setting.
Christian Heller [Sat, 30 Nov 2024 18:18:36 +0000 (19:18 +0100)]
Refactor VideoFile.flags setting.

12 days agoStart moving HTTP-related code to dedicated file.
Christian Heller [Sat, 30 Nov 2024 18:05:21 +0000 (19:05 +0100)]
Start moving HTTP-related code to dedicated file.

13 days agoFrom /files path filtering, remove case sensitivity.
Christian Heller [Fri, 29 Nov 2024 06:29:49 +0000 (07:29 +0100)]
From /files path filtering, remove case sensitivity.

13 days agoIn /files view, also show file sizes.
Christian Heller [Fri, 29 Nov 2024 06:27:09 +0000 (07:27 +0100)]
In /files view, also show file sizes.

13 days agoTo /files view, add "play" button for immediate playing of (present) files.
Christian Heller [Fri, 29 Nov 2024 05:58:26 +0000 (06:58 +0100)]
To /files view, add "play" button for immediate playing of (present) files.

13 days agoFix sync script bug of adding paths rather than lists of paths to missings.
Christian Heller [Fri, 29 Nov 2024 05:10:15 +0000 (06:10 +0100)]
Fix sync script bug of adding paths rather than lists of paths to missings.

13 days agoReplace PathStr hassles with pathlib.Path.
Christian Heller [Fri, 29 Nov 2024 05:06:14 +0000 (06:06 +0100)]
Replace PathStr hassles with pathlib.Path.

2 weeks agoOn playlist view, if playlist empty, force Player (re-)loading files.
Christian Heller [Fri, 29 Nov 2024 01:11:25 +0000 (02:11 +0100)]
On playlist view, if playlist empty, force Player (re-)loading files.

2 weeks agoGet rid of unnecessary "./" prefixes to VideoFile.rel_path.
Christian Heller [Fri, 29 Nov 2024 01:06:21 +0000 (02:06 +0100)]
Get rid of unnecessary "./" prefixes to VideoFile.rel_path.

2 weeks agoTo files view, add VideoFile.present filter.
Christian Heller [Fri, 29 Nov 2024 00:48:37 +0000 (01:48 +0100)]
To files view, add VideoFile.present filter.

2 weeks agoDon't try to sync file missing on both sides.
Christian Heller [Thu, 28 Nov 2024 22:45:57 +0000 (23:45 +0100)]
Don't try to sync file missing on both sides.

2 weeks agoAdd basic filtering by filename to /files view.
Christian Heller [Thu, 28 Nov 2024 21:14:53 +0000 (22:14 +0100)]
Add basic filtering by filename to /files view.

2 weeks agoEnforce proper mpv window closing even on direct keystroke input.
Christian Heller [Thu, 28 Nov 2024 18:53:29 +0000 (19:53 +0100)]
Enforce proper mpv window closing even on direct keystroke input.

2 weeks agoAdd up/down movement of playlist entries.
Christian Heller [Thu, 28 Nov 2024 16:32:13 +0000 (17:32 +0100)]
Add up/down movement of playlist entries.

2 weeks agoAllow greater playlist control even if mpv not directly running.
Christian Heller [Thu, 28 Nov 2024 15:41:41 +0000 (16:41 +0100)]
Allow greater playlist control even if mpv not directly running.

2 weeks agoAdd playlist jumping.
Christian Heller [Thu, 28 Nov 2024 14:52:54 +0000 (15:52 +0100)]
Add playlist jumping.

2 weeks agoImprove/simplify templating.
Christian Heller [Thu, 28 Nov 2024 14:27:34 +0000 (15:27 +0100)]
Improve/simplify templating.

2 weeks agoReduce reliance on mpv.py conveniences for raw libmpv command access.
Christian Heller [Thu, 28 Nov 2024 13:57:36 +0000 (14:57 +0100)]
Reduce reliance on mpv.py conveniences for raw libmpv command access.

2 weeks agoRefactor redirects.
Christian Heller [Wed, 27 Nov 2024 06:54:10 +0000 (07:54 +0100)]
Refactor redirects.

2 weeks agoReduce dependency on DownloadsManager for mere VideoFile data retrievals.
Christian Heller [Wed, 27 Nov 2024 06:49:42 +0000 (07:49 +0100)]
Reduce dependency on DownloadsManager for mere VideoFile data retrievals.

2 weeks agoLink playlist entries to file data pages.
Christian Heller [Wed, 27 Nov 2024 06:24:17 +0000 (07:24 +0100)]
Link playlist entries to file data pages.

2 weeks agoMore broadly use .rel_path for ID'ing VideoFiles, base64-encode where necessary.
Christian Heller [Wed, 27 Nov 2024 05:40:05 +0000 (06:40 +0100)]
More broadly use .rel_path for ID'ing VideoFiles, base64-encode where necessary.

2 weeks agoSome variable renamings for better clarity.
Christian Heller [Wed, 27 Nov 2024 04:53:51 +0000 (05:53 +0100)]
Some variable renamings for better clarity.

2 weeks agoAdd Config class reading from DEFAULTS, environ, and config file.
Christian Heller [Wed, 27 Nov 2024 03:41:13 +0000 (04:41 +0100)]
Add Config class reading from DEFAULTS, environ, and config file.

2 weeks agoRefactor DownloadsDb (now DownloadsManager).
Christian Heller [Wed, 27 Nov 2024 01:45:09 +0000 (02:45 +0100)]
Refactor DownloadsDb (now DownloadsManager).

2 weeks agoFix breakages due to previous unfinished commit.
Christian Heller [Tue, 26 Nov 2024 23:37:43 +0000 (00:37 +0100)]
Fix breakages due to previous unfinished commit.

2 weeks agoRefactor page naming.
Christian Heller [Tue, 26 Nov 2024 23:07:49 +0000 (00:07 +0100)]
Refactor page naming.

2 weeks agoUpdate sync script, prefer rows with newer .last_update.
Christian Heller [Tue, 26 Nov 2024 14:15:28 +0000 (15:15 +0100)]
Update sync script, prefer rows with newer .last_update.

2 weeks agoFix installer breaking on new install due to missing migrations dir.
Christian Heller [Tue, 26 Nov 2024 14:15:13 +0000 (15:15 +0100)]
Fix installer breaking on new install due to missing migrations dir.

2 weeks agoAdd files.last_update field to renew on file.flags changes, and migration mechanism...
Christian Heller [Mon, 25 Nov 2024 05:40:12 +0000 (06:40 +0100)]
Add files.last_update field to renew on file.flags changes, and migration mechanism to allow addition of field to table.

2 weeks agoFor sync script, download remote DB temporarily into PATH_TEMP.
Christian Heller [Mon, 25 Nov 2024 02:40:47 +0000 (03:40 +0100)]
For sync script, download remote DB temporarily into PATH_TEMP.

2 weeks agoInclude sync script in installation, denoise shell script outputs.
Christian Heller [Mon, 25 Nov 2024 00:34:20 +0000 (01:34 +0100)]
Include sync script in installation, denoise shell script outputs.

2 weeks agoFix mypy issue with jinja2 import.
Christian Heller [Sun, 24 Nov 2024 23:29:56 +0000 (00:29 +0100)]
Fix mypy issue with jinja2 import.

2 weeks agoEnsure thumbnail directory exists when retrieving on query.
Christian Heller [Sun, 24 Nov 2024 23:21:18 +0000 (00:21 +0100)]
Ensure thumbnail directory exists when retrieving on query.

2 weeks agoHave install.sh also place executable code, including ~/.config/bin/ytplom wrapping...
Christian Heller [Sun, 24 Nov 2024 23:11:39 +0000 (00:11 +0100)]
Have install.sh also place executable code, including ~/.config/bin/ytplom wrapping necessary venv stuff.

2 weeks agoReplace install.py by a short shell script.
Christian Heller [Sun, 24 Nov 2024 17:55:31 +0000 (18:55 +0100)]
Replace install.py by a short shell script.

2 weeks agoCreate initial migration.
Christian Heller [Sun, 24 Nov 2024 17:46:58 +0000 (18:46 +0100)]
Create initial migration.

2 weeks agoRemove exception type not used for any actual differentiation.
Christian Heller [Sun, 24 Nov 2024 17:27:37 +0000 (18:27 +0100)]
Remove exception type not used for any actual differentiation.

2 weeks agoTo prepare for migrations, add database version check.
Christian Heller [Sun, 24 Nov 2024 17:25:54 +0000 (18:25 +0100)]
To prepare for migrations, add database version check.

2 weeks agoMove app-relevant data into ~/.local/share/, add installer script for this.
Christian Heller [Sun, 24 Nov 2024 17:11:37 +0000 (18:11 +0100)]
Move app-relevant data into ~/.local/share/, add installer script for this.

2 weeks agoRefactor checks and reactions to paths existing, possibly as wrong entry type.
Christian Heller [Sun, 24 Nov 2024 16:26:14 +0000 (17:26 +0100)]
Refactor checks and reactions to paths existing, possibly as wrong entry type.

2 weeks agoImprove exception handling.
Christian Heller [Sun, 24 Nov 2024 16:15:19 +0000 (17:15 +0100)]
Improve exception handling.

2 weeks agoImprove templating modularity.
Christian Heller [Sun, 24 Nov 2024 15:29:27 +0000 (16:29 +0100)]
Improve templating modularity.

2 weeks agoAdd file deletion via "delete" flag.
Christian Heller [Sat, 23 Nov 2024 08:19:56 +0000 (09:19 +0100)]
Add file deletion via "delete" flag.

2 weeks agoAdd .flags field to VideoFile and their table, page with checkboxes to set.
Christian Heller [Sat, 23 Nov 2024 06:56:34 +0000 (07:56 +0100)]
Add .flags field to VideoFile and their table, page with checkboxes to set.

2 weeks agoChange "video_about" namens into "yt_video" or variation thereof.
Christian Heller [Sat, 23 Nov 2024 05:33:29 +0000 (06:33 +0100)]
Change "video_about" namens into "yt_video" or variation thereof.

2 weeks agoAdd script for syncing between local and remote instances.
Christian Heller [Fri, 22 Nov 2024 23:34:46 +0000 (00:34 +0100)]
Add script for syncing between local and remote instances.

2 weeks agoThrow out unfinished broadcasts from query results.
Christian Heller [Fri, 22 Nov 2024 23:13:52 +0000 (00:13 +0100)]
Throw out unfinished broadcasts from query results.

3 weeks agoPrepare sync infrastructure.
Christian Heller [Thu, 21 Nov 2024 06:27:07 +0000 (07:27 +0100)]
Prepare sync infrastructure.

3 weeks agoModularize.
Christian Heller [Thu, 21 Nov 2024 02:08:15 +0000 (03:08 +0100)]
Modularize.

3 weeks agoUpdate requirements.
Christian Heller [Wed, 20 Nov 2024 23:08:39 +0000 (00:08 +0100)]
Update requirements.

3 weeks agoUse UUID for queries table .id field, to reduce reliance on chronology.
Christian Heller [Wed, 20 Nov 2024 22:56:41 +0000 (23:56 +0100)]
Use UUID for queries table .id field, to reduce reliance on chronology.

3 weeks agoClean up code, path references.
Christian Heller [Wed, 20 Nov 2024 13:37:08 +0000 (14:37 +0100)]
Clean up code, path references.

3 weeks agoAdd "files" table to store what files to expect in downloads directory.
Christian Heller [Wed, 20 Nov 2024 12:56:50 +0000 (13:56 +0100)]
Add "files" table to store what files to expect in downloads directory.

3 weeks agoRefactor ensurance of expected directories.
Christian Heller [Tue, 19 Nov 2024 05:24:51 +0000 (06:24 +0100)]
Refactor ensurance of expected directories.

3 weeks agoTry retrieving thumbnails if not stored locally yet.
Christian Heller [Tue, 19 Nov 2024 05:19:39 +0000 (06:19 +0100)]
Try retrieving thumbnails if not stored locally yet.

3 weeks agoRefactor download stuff into DownloadsDb class.
Christian Heller [Tue, 19 Nov 2024 01:58:36 +0000 (02:58 +0100)]
Refactor download stuff into DownloadsDb class.

3 weeks agoProperly handle download options where download is already happening or scheduled.
Christian Heller [Fri, 15 Nov 2024 05:52:28 +0000 (06:52 +0100)]
Properly handle download options where download is already happening or scheduled.

3 weeks agoImprove video_about page.
Christian Heller [Fri, 15 Nov 2024 05:06:18 +0000 (06:06 +0100)]
Improve video_about page.

4 weeks agoRemove unused TypeVar.
Christian Heller [Fri, 15 Nov 2024 04:11:41 +0000 (05:11 +0100)]
Remove unused TypeVar.

4 weeks agoFix broken SQL code.
Christian Heller [Fri, 15 Nov 2024 04:09:39 +0000 (05:09 +0100)]
Fix broken SQL code.

4 weeks agoRemove unused directory.
Christian Heller [Fri, 15 Nov 2024 04:09:24 +0000 (05:09 +0100)]
Remove unused directory.

4 weeks agoMove quota logging into sqlite DB, too.
Christian Heller [Fri, 15 Nov 2024 04:06:37 +0000 (05:06 +0100)]
Move quota logging into sqlite DB, too.

4 weeks agoTreat absence of yt_videos row and thumbnail files more forgivingly.
Christian Heller [Fri, 15 Nov 2024 03:24:30 +0000 (04:24 +0100)]
Treat absence of yt_videos row and thumbnail files more forgivingly.

4 weeks agoMove query and query result/video data into sqlite DB.
Christian Heller [Fri, 15 Nov 2024 02:10:47 +0000 (03:10 +0100)]
Move query and query result/video data into sqlite DB.

4 weeks agoIn playlist view, autofocus pause/resume button.
Christian Heller [Tue, 12 Nov 2024 21:22:46 +0000 (22:22 +0100)]
In playlist view, autofocus pause/resume button.

4 weeks agoFix template reference.
Christian Heller [Tue, 12 Nov 2024 21:22:36 +0000 (22:22 +0100)]
Fix template reference.

4 weeks agoAdd previously forgotten template.
Christian Heller [Tue, 12 Nov 2024 16:33:23 +0000 (17:33 +0100)]
Add previously forgotten template.

4 weeks agoAdd MPV playlisting.
Christian Heller [Tue, 12 Nov 2024 16:33:00 +0000 (17:33 +0100)]
Add MPV playlisting.

4 weeks agoMinor formal fixes.
Christian Heller [Mon, 11 Nov 2024 07:49:21 +0000 (08:49 +0100)]
Minor formal fixes.

4 weeks agoMinor typing fix.
Christian Heller [Mon, 11 Nov 2024 07:42:00 +0000 (08:42 +0100)]
Minor typing fix.

4 weeks agoRefactor and add single video data view, only allow downloading from here.
Christian Heller [Mon, 11 Nov 2024 07:37:30 +0000 (08:37 +0100)]
Refactor and add single video data view, only allow downloading from here.

4 weeks agoFix bug of queries index getting appended to all other page views.
Christian Heller [Mon, 11 Nov 2024 03:36:41 +0000 (04:36 +0100)]
Fix bug of queries index getting appended to all other page views.

4 weeks agoAdd /videos listing of downloaded videos.
Christian Heller [Mon, 11 Nov 2024 03:35:47 +0000 (04:35 +0100)]
Add /videos listing of downloaded videos.

4 weeks agoFurther harden type safety.
Christian Heller [Sun, 10 Nov 2024 15:41:38 +0000 (16:41 +0100)]
Further harden type safety.

4 weeks agoRefactor code.
Christian Heller [Sun, 10 Nov 2024 15:23:51 +0000 (16:23 +0100)]
Refactor code.

4 weeks agoImprove code.
Christian Heller [Sat, 9 Nov 2024 07:43:31 +0000 (08:43 +0100)]
Improve code.

4 weeks agoImprove code style.
Christian Heller [Sat, 9 Nov 2024 03:07:20 +0000 (04:07 +0100)]
Improve code style.

5 weeks agoLimit download video resolution to max. full HD.
Christian Heller [Tue, 5 Nov 2024 03:40:59 +0000 (04:40 +0100)]
Limit download video resolution to max. full HD.

7 weeks agoInitial commit.
Christian Heller [Sun, 20 Oct 2024 13:27:36 +0000 (15:27 +0200)]
Initial commit.