vcutil icon indicating copy to clipboard operation
vcutil copied to clipboard

mysqldumpdissect: RFE: --coleq better help, and better syntax, and --[no-]human

Open wdoekes opened this issue 1 year ago • 0 comments

The --[no-]human should enable/disable space after a comma. Instead of:

INSERT INTO `pstore_property` VALUES (126727,'2019-10-28 15:03:22',7321,'ip',1,'10.10.10.10',NULL);

I want:

INSERT INTO `pstore_property` VALUES (126727, '2019-10-28 15:03:22', 7321, 'ip', 1, '10.10.10.10', NULL);

by (--human) default.

As for the --coleq, this is described at the top already:

#   * The --coleq rule match syntax is clunky and restrictive. Maybe do:
#     table_name[colidx]=value and then add and/or.

And the --help text is insufficient.

Instead of this search:

mysqldumpdissect -f pstore.sql --coleq pstore_property=2:i:7321 | grep ",10);"

I'd like to do this:

mysqldumpdissect -f pstore.sql --coleq 'pstore_property[2]=(i)7321 & pstore_property[6]=(i)10'

wdoekes avatar Jul 18 '24 12:07 wdoekes