Tool for anonymize fields in your development database.
You can generate random name, firstname, date, string, ...
It works with all databases supported by PDO.
Before :
| id | name | firstname | login | pwd | |
|---|---|---|---|---|---|
| 1 | admin | admin | admin@exemple.com | admin | $2y$10$TIbP5QZSRwG4qgIIPM2Id.xXMppaVA9NS.1l8l1tNmOXcrsPc0tw. |
| 2 | Vidal | Stanislas | stanislas.vidal@exemple2.com | svidal | $2y$10$MJqgEaabRg7E0u0ijfN89uxYCj7A8yl55jO6Ln4TXDRDY0lLhzJ.O |
| 3 | Bailly | Ernest | ernest.bailly@exemple3.com | ebailly | $2y$10$JRxko3xIdSbrSDUdX6bTgeE/l4bhPbpDtSGZ6.rEXmkJfaz4zXHty |
| 4 | Boulanger | Brunehaut | brunehaut.boulanger@exemple42.com | bboulanger | $2y$10$4NpShLrWcc3feINtfqC2F.30oJ/yT3w9S98sgDP7jGlJEBSX54u.2 |
After :
| id | name | firstname | login | pwd | |
|---|---|---|---|---|---|
| 1 | admin | admin | admin@exemple.com | admin | $2y$10$TIbP5QZSRwG4qgIIPM2Id.xXMppaVA9NS.1l8l1tNmOXcrsPc0tw. |
| 2 | Lacroix | Aurore | test+aurore.lacroix@exemple.com | alacroix | $2y$10$TIbP5QZSRwG4qgIIPM2Id.xXMppaVA9NS.1l8l1tNmOXcrsPc0tw. |
| 3 | Fleury | Mélissandre | test+mélissandre.fleury@exemple.com | mfleury | $2y$10$TIbP5QZSRwG4qgIIPM2Id.xXMppaVA9NS.1l8l1tNmOXcrsPc0tw. |
| 4 | Olivier | Estelle | test+estelle.olivier@exemple.com | eolivier | $2y$10$TIbP5QZSRwG4qgIIPM2Id.xXMppaVA9NS.1l8l1tNmOXcrsPc0tw. |
Copy config.php.dist to config.php.
Copy ./json/databases/schema.json to ./json/databases/
Copy ./json/tables/schema.json to ./json/tables/
Edit these files for your needs.
You can add php files in ./functions/ with your own functions.
See README.md
$ php anonymizedb.php helpTo anonymize the data in your database :
$ php anonymizedb.php ./json/databases/<YOUR_DB_NAME>.json ./json/tables/<YOUR_TABLE_NAME>.json