Advertisement
Guest User

Untitled

a guest
Aug 18th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. sqlite3 .svn/wc.db "pragma integrity_check"
  2.  
  3. sqlite3 .svn/wc.db "reindex nodes"
  4. sqlite3 .svn/wc.db "reindex pristine"
  5.  
  6. sqlite3 .svn/wc.db "pragma integrity_check"
  7.  
  8. sqlite3 .svn/wc.db "reindex nodes"
  9. sqlite3 .svn/wc.db "reindex pristine"
  10.  
  11. sqlite3 .svn/wc.db
  12.  
  13. sqlite> .mode insert
  14. sqlite> .output dump_all.sql
  15. sqlite> .dump
  16. sqlite> .exit
  17.  
  18. mv .svn/wc.db .svn/wc-corrupt.db
  19. sqlite3 .svn/wc.db
  20.  
  21. sqlite> .read dump_all.sql
  22. sqlite> .exit
  23.  
  24. sqlite3 rep-cache.db
  25.  
  26. .clone rep-cache-new.db
  27.  
  28. ren rep-cache.db rep-cache-old.db
  29.  
  30. ren re-cache-new.db rep-cache.db
  31.  
  32. del rep-cache.db
  33.  
  34. >sudo apt-get install sqlite3
  35.  
  36. >sqlite3 .svn/wc.db
  37.  
  38. sqlite> select * from wc_lock;
  39. 1|-1
  40. sqlite> delete from wc_lock;
  41. sqlite> select * from wc_lock;
  42. sqlite> .q
  43.  
  44. var updateStatementString : String! = ""
  45.  
  46. for item in cardids {
  47.  
  48. let newstring = "UPDATE "+TABLE_NAME+" SET pendingImages = '(pendingImage)' WHERE cardId = '(item)';"
  49. updateStatementString.append(newstring)
  50.  
  51. }
  52.  
  53.  
  54. print(updateStatementString)
  55. let results = dbManager.sharedInstance.update(updateStatementString: updateStatementString)
  56.  
  57. return Int64(results)
  58.  
  59. rm -rf .svn
  60. svn co http://mon.svn/mondepot/ . --force
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement