home · contact · privacy
ytplom
43 hours agoTo /files view, add filtering by tags.
Christian Heller [Tue, 3 Dec 2024 05:22:44 +0000 (06:22 +0100)]
To /files view, add filtering by tags.

44 hours agoIn /file view, for tag addition propose tags used elsewhere.
Christian Heller [Tue, 3 Dec 2024 05:01:11 +0000 (06:01 +0100)]
In /file view, for tag addition propose tags used elsewhere.

44 hours agoAdd file tagging.
Christian Heller [Tue, 3 Dec 2024 04:21:16 +0000 (05:21 +0100)]
Add file tagging.

45 hours agoIn /file view, move deletion checkbox out of danger zone.
Christian Heller [Tue, 3 Dec 2024 03:34:58 +0000 (04:34 +0100)]
In /file view, move deletion checkbox out of danger zone.

46 hours agoTo fix sync, add comparison and string representation to Hash class.
Christian Heller [Tue, 3 Dec 2024 03:03:33 +0000 (04:03 +0100)]
To fix sync, add comparison and string representation to Hash class.

46 hours agoStore files hash digest as BLOB field .digest, overhaul DB and migrations code.
Christian Heller [Tue, 3 Dec 2024 02:58:45 +0000 (03:58 +0100)]
Store files hash digest as BLOB field .digest, overhaul DB and migrations code.

2 days agoReorganize DB code and especially migrations handling.
Christian Heller [Mon, 2 Dec 2024 13:30:29 +0000 (14:30 +0100)]
Reorganize DB code and especially migrations handling.

2 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.

3 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.

3 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.

3 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.

3 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.

3 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.

4 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.

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

4 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.

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

4 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.

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

4 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.

5 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.

5 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.

5 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.

5 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.

5 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.

6 days 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.

6 days 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.

6 days 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.

6 days 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.

6 days 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.

6 days 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.

6 days 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.

6 days 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.

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

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

6 days 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.

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

7 days 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.

7 days 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.

7 days 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.

7 days 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.

7 days 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.

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

8 days 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.

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

8 days 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.

8 days 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.

9 days 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.

9 days 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.

10 days 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.

10 days 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.

10 days 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.

10 days 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.

10 days 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.

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

10 days 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.

10 days 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.

10 days 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.

10 days 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.

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

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

11 days 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.

11 days 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.

11 days 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.

12 days 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.

12 days 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.

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

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

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

2 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.

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

2 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.

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

2 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.

2 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.

2 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.

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

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

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

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

2 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.

2 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.

2 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.

3 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.

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

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

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

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

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

3 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.

3 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.

3 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.

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

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

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

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

4 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.

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