SQL::Loader
use base qw( SQL::Loader );
Base class for SQL::Loader::MySQL
SQL::Loader::MySQL
constructor
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.
initialize class
get/set initialized param
get/set print_http_headers param
get/set url to be scraped
get/set dbname
get/set dbuser
get/set dbpass
get/set database handle
get/set quiet param
return dbh connect string. must be overridden in subclass.
Ben Hare for www.strategicdata.com.au
benhare@gmail.com
(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.
To install SQL::Loader, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Loader
CPAN shell
perl -MCPAN -e shell install SQL::Loader
For more information on module installation, please visit the detailed CPAN module installation guide.