The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

WWW::Scraper::Wikipedia::ISO3166::Database::Create - Create/drop tables in www.scraper.wikipedia.iso3166.sqlite

Synopsis

See "Synopsis" in WWW::Scraper::Wikipedia::ISO3166.

Description

Documents the methods end-users need to create/drop tables in the SQLite database, www.scraper.wikipedia.iso3166.sqlite, which ships with this distro.

See scripts/create.tables.pl and scripts/drop.tables.pl.

Distributions

This module is available as a Unix-style distro (*.tgz).

See http://savage.net.au/Perl-modules.html for details.

See http://savage.net.au/Perl-modules/html/installing-a-module.html for help on unpacking and installing.

Constructor and initialization

new(...) returns an object of type WWW::Scraper::Wikipedia::ISO3166::Database::Create.

This is the class's contructor.

Usage: WWW::Scraper::Wikipedia::ISO3166::Database::Create -> new().

This method takes a hash of options.

Call new() as new(option_1 => value_1, option_2 => value_2, ...).

Available options: None.

Methods

This module is a sub-class of WWW::Scraper::Wikipedia::ISO3166::Database and consequently inherits its methods.

create_all_tables()

Create these tables:

o countries
o subcountries
o subcountry_categories
o subcountry_info

create_countries_table()

Create the countries table.

create_subcountries_table()

Create the subcountries table.

create_subcountry_categories_table()

Create the subcountry_categories table.

create_subcountry_info_table()

Create the subcountry_info table.

drop_all_tables()

Create these tables:

o countries
o subcountries
o subcountry_categories
o subcountry_info

drop_table($table_name)

Drop the table called $table_name,

new()

See "Constructor and initialization".

report($table_name, $message, $result)

For $table_name, if the result of the create or drop is an error, die with $message.

If there was no error, log a create/drop message at level debug.

FAQ

For the database schema, etc, see "FAQ" in WWW::Scraper::Wikipedia::ISO3166.

References

See "References" in WWW::Scraper::Wikipedia::ISO3166.

Support

Email the author, or log a bug on RT:

https://rt.cpan.org/Public/Dist/Display.html?Name=WWW::Scraper::Wikipedia::ISO3166.

Author

WWW::Scraper::Wikipedia::ISO3166 was written by Ron Savage <ron@savage.net.au> in 2012.

Home page: http://savage.net.au/index.html.

Copyright

Australian copyright (c) 2012 Ron Savage.

        All Programs of mine are 'OSI Certified Open Source Software';
        you can redistribute them and/or modify them under the terms of
        The Artistic License, a copy of which is available at:
        http://www.opensource.org/licenses/index.html