LUCY

User Tools

Site Tools

Trace:
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 revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
delete_data_in_the_database_directly_via_ssh [2018/03/28 19:51] – lucydelete_data_in_the_database_directly_via_ssh [2018/05/07 21:58] – lucy
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 16: Line 16:
  
 ===== Delete all endusers ===== ===== Delete all endusers =====
-sudo -u postgres psql phishing -c "DELETE FROM users WHERE NOT is_deleted AND role_id=5"+sudo -u postgres psql phishing 
 +UPDATE users SET is_deleted=true WHERE NOT is_deleted AND role_id=5; 
 +\q 
  
 ===== 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: 2021/05/19 08:10 by lucy