update-db.sh 397 B

123456789101112
  1. #!/bin/sh
  2. embypath=${2:-/var/lib/emby-server}
  3. jellyfinpath=${3:-/var/lib/jellyfin}
  4. db=${1:-${jellyfinpath}/data/library.db}
  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