Skip to content

iGLOO-be/clean-table

Repository files navigation

Clean table Mysql

Usage

$ clean-table --help
Options:
  --help               Show help                                       [boolean]
  --version            Show version number                             [boolean]
  --dsn                                                               [required]
  --table, -t          Table name                                     [required]
  --time-field         Column name
  --time-value         Number of days                                   [number]
  --time-type          Type of time-field
                             [choices: "date", "datetime"] [default: "datetime"]
  --filter             [COLUMN] [VALUE]                                  [array]
  --limit              Max record deleted              [number] [default: 50000]
  --debug                                                              [boolean]
  --dry-run, --dryrun  See the number of rows affected                 [boolean]
  --yes, -y            Bypass the confirm prompt                       [boolean]