codacy-badger/batcher

A command line utility to perform concurrent mass updates or deletes against an SQL database

batcher

A utility to perform large updates or deletes in batches to improve performance.

Usage

$ ./batcher help
'update', 'delete', 'version' or 'help' subcommand is required
flags:
  -concurrency int
    	concurrency (default 20)
  -database string
    	database name
  -execute
    	execute the operation ('dry-run' only by default)
  -host string
    	host name or IP (default "localhost")
  -password string
    	password
  -portnum string
    	port number
  -set string
    	e.g. 'column_name=value, column_name=value ...' (ignored if provided with delete subcommand)
  -table string
    	table name
  -user string
    	user name
  -where string
    	e.g. 'column=value AND column IS NOT NULL ...'

CAUTION!

This can seriously mess up your day if you get it wrong. Please dry run first to make sure the statement that will run is the one you want!