6543/TerabyteTerminator

Tool: DB: Update File State #9

New Issue

Closed

opened 2019-02-07 13:45:11 +00:00 by 6543 · 5 comments

6543 commented

2019-02-07 13:45:11 +00:00

Owner

.. missing infos into DB

.. missing infos into DB

6543 added this to the WatchDog milestone 2019-02-07 13:45:11 +00:00

6543 added the

label 2019-02-07 13:45:11 +00:00

6543 commented

2019-02-11 02:04:32 +00:00

Author

Owner

-> #7 DB Tool AutoImport FileType -> F_Type

-> #7 DB Tool AutoImport FileType -> F_Type

6543 closed this issue

2019-02-11 02:04:37 +00:00

6543 reopened this issue

2019-02-11 02:04:41 +00:00

6543 changed title from ~~Tool: Search & Insert~~ to Tool: DB: Update File State

2019-02-19 22:39:15 +00:00

6543 commented

2019-02-19 22:39:54 +00:00

Author

Owner

added 'tool_db-update-file-state branch'

added 'tool_db-update-file-state branch'

6543 commented

2019-02-20 00:09:21 +00:00

Author

Owner

db_query "SELECT CONCAT(ID,'|$moviedir/', Folder, '/', Name) FROM File WHERE TTSync=$TTSYNC_EXIST;" | while read line; do ID=$(echo $line | cut -d '|' -f 1); FILE="$(echo $line | cut -d '|' -f 2)"; Size=0; [ -f "$FILE" ] && Size=$(($(du -b "$FILE" | cut -f 1)/1024)); echo "UPDATE File SET Size=$Size WHERE ID=$ID;"; db_query "UPDATE File SET Size=$Size WHERE ID=$ID;"; done

db_query "SELECT CONCAT(ID,'|$moviedir/', Folder, '/', Name) FROM File WHERE TTSync=$TTSYNC_EXIST;" | while read line; do ID=$(echo $line | cut -d '|' -f 1); FILE="$(echo $line | cut -d '|' -f 2)"; Size=0; [ -f "$FILE" ] && Size=$(($(du -b "$FILE" | cut -f 1)/1024)); echo "UPDATE File SET Size=$Size WHERE ID=$ID;"; db_query "UPDATE File SET Size=$Size WHERE ID=$ID;"; done

6543 commented

2019-02-20 00:31:40 +00:00

Author

Owner

move case of Existing file & db entry but empty Size to import-md5

move case of Existing file & db entry but empty Size to import-md5

6543 added the

label 2019-03-03 22:56:27 +00:00

6543 commented

2019-05-11 16:08:57 +00:00

Author

Owner

mit #10d8bb1a395265791a745f108d3feb6446546921 erste version vertig

mit #10d8bb1a395265791a745f108d3feb6446546921 erste version vertig

6543 closed this issue

2019-05-11 16:08:57 +00:00

Sign in to join this conversation.

No Label

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: 6543/TerabyteTerminator#9

No description provided.