PHPackages edisonlabs/database\_sanitize - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Validation & Sanitization](/categories/validation) 4. / 5. edisonlabs/database\_sanitize ActiveDrupal-module[Validation & Sanitization](/categories/validation) edisonlabs/database\_sanitize ============================= Provides drush commands for yaml sanitization files checks and generation. 3060557.x-dev(7y ago)51.7M↑42.2%6[4 issues](https://github.com/EdisonLabs/database_sanitize/issues)[4 PRs](https://github.com/EdisonLabs/database_sanitize/pulls)GPL-2.0+PHP Since Jun 10Pushed 3mo ago6 watchersCompare [ Source](https://github.com/EdisonLabs/database_sanitize)[ Packagist](https://packagist.org/packages/edisonlabs/database_sanitize)[ RSS](/packages/edisonlabs-database-sanitize/feed)WikiDiscussions 8.x-1.x Synced 1w ago READMEChangelogDependencies (2)Versions (13)Used By (0) [![Build Status](https://camo.githubusercontent.com/a96f6c02bb9d553221c8d2783825a25881e202bbe9b66d9bc688d497042fa714/68747470733a2f2f7472617669732d63692e636f6d2f456469736f6e4c6162732f64617461626173655f73616e6974697a652e7376673f6272616e63683d382e782d312e78)](https://travis-ci.com/EdisonLabs/database_sanitize) Database Sanitize ================= [](#database-sanitize) Overview -------- [](#overview) Provides a set of drush commands to assist in generating a `database.sanitize.yml` file containing all the queries for database sanitization. ### Commands included [](#commands-included) - `db-sanitize-analyze (dbsa)` Compares existing `database.sanitize.yml` files on the site installation against existing database tables and list tables that needs to be verified and possibly sanitized. - `db-sanitize-generate (dbsg)` generates a `database.sanitize.yml` file for all tables not specified in `database.sanitize.yml` files. Use the option `--file` to specify a YML file and skip the scan. This is meant to be used alongside [merge-yaml](https://github.com/EdisonLabs/merge-yaml) composer plugin, so that when you build your local environment for a drupal site, an `database.sanitize.merge.yml` file will be generated. This file's path is what you're expected to pass in. Usage instructions ------------------ [](#usage-instructions) You can provide a `database.sanitize.yml` file containing queries for database sanitization for your module or profile. **File format** ``` sanitize: MACHINE_NAME: DBTABLENAME1: description: 'query description' query: 'DB QUERY 1' DBTABLENAME2: description: 'query description' query: 'DB QUERY 2' MACHINE_NAME2: DBTABLENAME3: description: 'query description' query: 'DB QUERY 3' DBTABLENAME4: false DBTABLENAMEPREFIX*: false ``` Using a wildcard `*` for table names is supported. For example, setting `node_revision*` will apply to all tables names starting with `node_revision`. ### Commands usage [](#commands-usage) To find out how many tables needs to be defined in `database.sanitize.yml` files: ``` drush dbsa ``` ``` # Specifying a file. drush dbsa --file=/var/www/SITE/NON-PUBLIC-FOLDER/database.sanitize.merge.yml ``` To get the YAML file content for the missing tables to be sanitized: ``` drush dbsg --machine-name="my_module" ``` To save the missing tables to a `database.sanitize.yml` file: ``` drush dbsg --machine-name="MY_profile" > docroot/profiles/MY_profile/database.sanitize.yml ``` The generated queries for each missing table default to `TRUNCATE TABLE $table`. Developers are expected to assess what content should be sanitized for each table and edit the file accordingly. Automated Tests and Code Sniffer -------------------------------- [](#automated-tests-and-code-sniffer) This repository is integrated with [Travis CI](https://travis-ci.com/EdisonLabs/database_sanitize) to perform tests and detect Drupal coding standards violations. Running tests locally for development ------------------------------------- [](#running-tests-locally-for-development) You will need to: 1. Run composer install. 2. Run composer install inside the `vendor/drush/drush` directory. 3. Within the root of the package, run this command adjusting `UNISH_DB_URL` with your database configuration. ``` UNISH_DB_URL="mysql://USERNAME:PASSWORD@127.0.0.1" UNISH_NO_TIMEOUTS=y vendor/drush/drush/vendor/bin/phpunit --configuration "vendor/drush/drush/tests" drush/tests/ ``` ### Health Score 42 — FairBetter than 88% of packages Maintenance39 Infrequent updates — may be unmaintained Popularity46 Moderate usage in the ecosystem Community17 Small or concentrated contributor base Maturity52 Maturing project, gaining track record Bus Factor1 Top contributor holds 52.6% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~620 days Total 4 Last Release 694d ago Major Versions 3.x-dev → 4.x-dev2024-07-15 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/1932061?v=4)[Jean Ribeiro](/maintainers/jkribeiro)[@jkribeiro](https://github.com/jkribeiro) --- Top Contributors [![manuee](https://avatars.githubusercontent.com/u/105582?v=4)](https://github.com/manuee "manuee (10 commits)")[![jkribeiro](https://avatars.githubusercontent.com/u/1932061?v=4)](https://github.com/jkribeiro "jkribeiro (7 commits)")[![kmoll](https://avatars.githubusercontent.com/u/4575507?v=4)](https://github.com/kmoll "kmoll (1 commits)")[![manuel-work](https://avatars.githubusercontent.com/u/9803336?v=4)](https://github.com/manuel-work "manuel-work (1 commits)") ### Embed Badge ![Health badge](/badges/edisonlabs-database-sanitize/health.svg) ``` [![Health](https://phpackages.com/badges/edisonlabs-database-sanitize/health.svg)](https://phpackages.com/packages/edisonlabs-database-sanitize) ``` ### Alternatives [ziming/laravel-zxcvbn Zxcvbn Password validation rule for Laravel 3064.3k](/packages/ziming-laravel-zxcvbn) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)