Benjamin Hare > SQL-Loader-0.02 > SQL::Loader

Download:
SQL-Loader-0.02.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.02   Source  

NAME ^

SQL::Loader

SYNOPSIS ^

use base qw( SQL::Loader );

DESCRIPTION ^

Base class for SQL::Loader::MySQL

SEE ALSO ^

SQL::Loader::MySQL

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.

syntax highlighting: