mirror of
https://github.com/lrnselfreliance/wrolpi.git
synced 2026-10-26 19:01:39 -04:00
* Track how far the user is through a file, kept in recently_viewed.yaml FileGroup gains `progress` (0.0 to 1.0, 1.0 is finished) and `position` (where to resume: a time, a page, or an EPUB CFI). Both are returned with the file, including by POST /api/files/file. POST /api/files/progress records progress and is also a view. A file 95% through is finished and keeps no position; one barely started (under 10 s, the first page, under 1%) is not worth resuming. The write happens before the response, so the next request sees it. POST /api/files/progress/clear starts a file over. Both refuse files outside the media directory. recently_viewed.yaml keeps the 1000 most recently viewed files so viewing history and positions survive a database rebuild. On import the newer `viewed` wins, so a file viewed while WROLPi was starting keeps its newer position. The config is saved when a file is opened, when progress is final (paused or closed), when it is cleared, and after refresh cleanup (moves, renames, deletes); heartbeats during playback only write the database. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> * Progress: write as a writer, confine and merge the import, keep FTS on downgrade - The progress endpoints begin as writers (request.ctx.db.write()), so a heartbeat during a refresh waits instead of failing a lock upgrade. The config switch fires after the commit. - `..` is collapsed before the ignored-directory check. Clear only resets an existing FileGroup; it never indexes a file. - Import confines config paths to the media directory. A newer plain view keeps its `viewed` but takes the config's position; only progress written after the config wins. Files are globbed before the write transaction. - The dump skips a row outside the media directory instead of failing. - The downgrade drops the columns with ALTER TABLE, which keeps file_group's FTS triggers. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> --------- Co-authored-by: Claude Opus 5.5 <noreply@anthropic.com>
24 lines
770 B
Python
24 lines
770 B
Python
"""A FileGroup records how far the user is through it: file_group.progress and file_group.position.
|
|
|
|
Revision ID: 2026_10_08_1200
|
|
Revises: 2026_10_06_1500
|
|
"""
|
|
import sqlalchemy as sa
|
|
from alembic import op
|
|
|
|
# revision identifiers, used by Alembic.
|
|
revision = '2026_10_08_1200'
|
|
down_revision = '2026_10_06_1500'
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade():
|
|
op.add_column('file_group', sa.Column('progress', sa.Float(), nullable=True))
|
|
op.add_column('file_group', sa.Column('position', sa.JSON(), nullable=True))
|
|
|
|
|
|
def downgrade():
|
|
# Not batch_alter_table: rebuilding file_group drops its FTS triggers (see 2026_09_20_1200).
|
|
op.execute('ALTER TABLE file_group DROP COLUMN position')
|
|
op.execute('ALTER TABLE file_group DROP COLUMN progress')
|