use base qw( SQL::Loader );
Base class for SQL::Loader::MySQL
main app loop
create the sql tables. must be overridden in subclass.
define the columns of the given table
helper sub to determine if a table is valid and should be created. a table is considered valid if it has a 'Purpose' defined on the twiki page.
This sub gets called repeatedly once a purpose has been found until a <table> line is found, indicating start of a db table.
helper sub to extract the name that should be used for the table currently being created.
helper sub to clean leading, tailing and excessive whitespace from a string.
print headers option, invoked if the --print-http-headers switch is used. Use to test server response for example. Does not rebuild database.
get/set initialized param
get/set print_http_headers param
get/set url to be scraped
get/set database handle
get/set quiet param
return dbh connect string. must be overridden in subclass.
Ben Hare for www.strategicdata.com.au
(c) Copyright Strategic Data Pty. Ltd.
This module is free software. You can redistribute it or modify it under the same terms as Perl itself.