NAME

hd_delete_all.pl - delete all records which table names and IDs are written in a file.

VERSION

This documentation refers to hd_delete_all.pl version 0.0.5

USAGE

$ hd_delete_all.pl --infile inserted.yml -d mydb -u myuser -p mypasswd

ARGUMENTS

• -i | --in | --infile

  (Required) a file name of YAML in which tables and IDs to be deleted are written like the followings:

  ---
  customer:
    - 50
    - 51
  item:
    - 101
    - 102
  purchase:
    - 501
    - 502
    - 503

• -d | --dbname

  (Required) A name of database

• -h | --host

  (Optional) Hostname of database

• --port

  (Optional) Port no.

• -u | --user

  (Required) User name to connect mysql

• -p | --password

  (Required) Password to connect mysql

• -v | --verbose

  (Optional) Display verbose messages.

DESCRIPTION

This scripts deletes all records specified by YAML file, which is generated by hd_insert_bulk.pl (included in this package). Of course manually created YAML file can also be used.

BUGS AND LIMITATIONS

There are no known bugs in this module. Please report problems to Takashi Egawa (egawa.takashi at gmail com) Patches are welcome.

SEE ALSO

Data::HandyGen::mysql hd_insert_bulk.pl

AUTHOR

Takashi Egawa (egawa.takashi at gmail com)

LICENCE AND COPYRIGHT

Copyright (c)2013 Takashi Egawa (egawa.takashi at gmail com). All rights reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.