-
-
Notifications
You must be signed in to change notification settings - Fork 10
/
plex_stuckers.sh
23 lines (17 loc) · 776 Bytes
/
plex_stuckers.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
#!/usr/bin/env bash
PLEXDOCKER=plex
PLEXDBPATH="/opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/"
PLEXDB="com.plexapp.plugins.library.db"
PLEXSQL="/opt/plexsql/Plex Media Server"
TODAY=$(date '+%Y_%d_%m__%H_%M_%S')
docker stop "${PLEXDOCKER}"
cd "${PLEXDBPATH}" || return
cp "${PLEXDB}" "${PLEXDB}_${TODAY}.bak"
([ -e "com.plexapp.plugins.library.db-shm" ] && rm com.plexapp.plugins.library.db-shm)
([ -e "rm com.plexapp.plugins.library.db-wal" ] && rm rm com.plexapp.plugins.library.db-wal)
"${PLEXSQL}" --sqlite "${PLEXDB}" <<END_SQL
.timeout 2000
UPDATE metadata_items SET added_at = originally_available_at WHERE added_at <> originally_available_at AND originally_available_at IS NOT NULL;
END_SQL
docker start "${PLEXDOCKER}"
#eof