NAME
SQL::Loader
SYNOPSIS
use base qw( SQL::Loader );
DESCRIPTION
Base class for SQL::Loader::MySQL
SEE ALSO
METHODS
new
constructor
run
main app loop
create_table
create the sql tables. must be overridden in subclass.
_work_out_table_cols
define the columns of the given table
_set_purpose_and_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.
_set_table_title
helper sub to extract the name that should be used for the table currently being created.
_clean
helper sub to clean leading, tailing and excessive whitespace from a string.
_print_http_headers
print headers option, invoked if the --print-http-headers switch is used. Use to test server response for example. Does not rebuild database.
_init
initialize class
initialized
get/set initialized param
print_http_headers
get/set print_http_headers param
url
get/set url to be scraped
dbname
get/set dbname
dbuser
get/set dbuser
dbpass
get/set dbpass
dbh
get/set database handle
quiet
get/set quiet param
connect_string
return dbh connect string. must be overridden in subclass.
AUTHOR
Ben Hare for www.strategicdata.com.au
benhare@gmail.com
COPYRIGHT
(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.