Create SQL Scripts for Encrypt and Decrypt Personal Information
by Guilherme Marcondes https://github.com/guimarc/odoo-apps
Odoo
Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 97 |
Technical Name |
encrypt_pi_data |
License | LGPL-3 |
Website | https://github.com/guimarc/odoo-apps |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 97 |
Technical Name |
encrypt_pi_data |
License | LGPL-3 |
Website | https://github.com/guimarc/odoo-apps |
Create SQL Scripts for Encrypt and Decrypt Personal Information
Table of contents
Usage
- Access Encrypt PI Model
- Click in New and select the Model/field to be encrypted
- Check all entries created
- Go Actions >> Run Create SQL encrypt and decrypt scripts option
- In your temp path will be created two files : .encrypt.sql and decrypt.sql
- Copy the content from encrypt.sql and Run under your database using psql/pgadmin/dbeaver.
- New columns will be created with encrypt data and the real data will be deleted.
- To restore the data do the same action but using the instructions from decrypt.sql
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Authors
- Guilherme Marcondes<guilhermemarcondes4@msn.com>
Contributors
- Guilherme Marcondes<guilhermemarcondes4@msn.com>
Please log in to comment on this module