User Tools

Site Tools


delete_data_in_the_database_directly_via_ssh

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
delete_data_in_the_database_directly_via_ssh [2018/05/07 21:57]
lucy [Delete all endusers]
delete_data_in_the_database_directly_via_ssh [2019/07/25 12:50] (current)
Line 6: Line 6:
  
 ===== Delete all scenario templates ===== ===== Delete all scenario templates =====
-sudo -u postgres psql phishing -c "DELETE FROM scenario_templates WHERE NOT is_deleted"+sudo -u postgres psql phishing -c 'DELETE FROM scenario_templates WHERE NOT is_deleted'
  
 ===== Delete all Awareness template ===== ===== Delete all Awareness template =====
-sudo -u postgres psql phishing -c "DELETE FROM awareness_templates WHERE NOT is_deleted"+sudo -u postgres psql phishing -c 'DELETE FROM awareness_templates WHERE NOT is_deleted'
  
 ===== Delete all file templates ===== ===== Delete all file templates =====
Line 22: Line 22:
  
 ===== Delete all LUCY users (not admin) ===== ===== Delete all LUCY users (not admin) =====
-sudo -u postgres psql phishing -c "UPDATE users SET is_deleted=TRUE where role_id=3"+sudo -u postgres psql phishing -c 'UPDATE users SET is_deleted=TRUE where role_id=3'
  
  
delete_data_in_the_database_directly_via_ssh.txt ยท Last modified: 2019/07/25 12:50 (external edit)