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.