NAME

SQL::Loader::MySQL

SYNOPSIS

In Perl script

 use SQL::Loader::MySQL;
 SQL::Loader::MySQL->new(
   url => $schema_url,
   dbname       => $dbname,
   dbuser       => $dbuser,
   dbpass       => $dbpass,
   print_http_headers => <boolean>,
   quiet        => <boolean>
 )->run;

The database specified by $dbname must exist.

In URL specified

 <h2>$table_name</h2>

 ...

 <h3>Purpose</h3>

 ...

 <table>
   <tr>
     <td>$order</td>
     <td>$column_name</td>
     <td>$column_type</td>
     <td>$additional_info</td>
   </tr>
 </table>

For further details see README file.

DESCRIPTION

Screen scrape a database schema from a twiki ( or compatible ) web page and create it in a MySQL database.

INPUT PARAMETERS

 $schema_url - the url to scrape db schema from - required
 $dbname - name of database to use - required 
 $dbuser - database username - required
 $dbpass - database password - required 
 $print_http_headers ( boolean ) - Test $url server response only by requesting headers ( does not rebuild db )
 $quiet ( boolean ) - do not print any informational messages

SEE ALSO

SQL::Loader

INHERITANCE

SQL::Loader

METHODS

create

create a mysql table

connect_string

return dbh connect string.

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.