update-db.sh 399 B

123456789101112
  1. #!/bin/sh
  2. db=${1:-/var/lib/jellyfin/data/library.db}
  3. embypath=${2:-/var/lib/emby-server}
  4. jellyfinpath=${3:-/var/lib/jellyfin}
  5. sqlite3 ${db} << SQL
  6. UPDATE Chapters2
  7. SET ImagePath=REPLACE(ImagePath, '${embypath}', '${jellyfinpath}');
  8. UPDATE TypedBaseItems
  9. SET Path=REPLACE(Path, '${embypath}', '${jellyfinpath}');
  10. UPDATE TypedBaseItems
  11. SET data=REPLACE(data, '${embypath}', '${jellyfinpath}');
  12. SQL