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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
delete_data_in_the_database_directly_via_ssh [2018/05/07 21:57] – [Delete all endusers] lucydelete_data_in_the_database_directly_via_ssh [2019/07/25 12:50] – external edit 127.0.0.1
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: 2021/05/19 08:10 by lucy