Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. #!/bin/sh
  2. echo "Backup."
  3. cp com.plexapp.plugins.library.db backup-com.plexapp.plugins.library.db
  4.  
  5. echo "Runnig plexinc recommended checks."
  6. sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
  7. sqlite3 com.plexapp.plugins.library.db "DELETE from schema_migrations where version='20180501000000'"
  8. sqlite3 com.plexapp.plugins.library.db "PRAGMA integrity_check"
  9.  
  10. echo "Deleting duplicates.."
  11. #sqlite3 com.plexapp.plugins.library.db "delete from media_streams where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
  12. #sqlite3 com.plexapp.plugins.library.db "delete from media_items where id in (select media_item_id from media_parts group by file HAVING count() > 1);"
  13. #sqlite3 com.plexapp.plugins.library.db "delete from media_item_settings where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
  14. #sqlite3 com.plexapp.plugins.library.db "delete from media_parts where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
  15. sqlite3 com.plexapp.plugins.library.db "BEGIN; delete from media_streams where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_items where id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_item_settings where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_parts where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); commit;"
  16.  
  17. echo "Dumping."
  18. sqlite3 com.plexapp.plugins.library.db .dump > tmp.sql
  19.  
  20. echo "Restoring."
  21. rm com.plexapp.plugins.library.db
  22. sqlite3 com.plexapp.plugins.library.db < tmp.sql && rm tmp.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement