NAME

Chess::ELO::FEDA - Download FEDA ELO (http://www.feda.org) into differents backends (SQLite)

VERSION

version 0.04

SYNOPSIS

my $elo = Chess::ELO::FEDA->new(
   -url      => 'http://feda.org/feda2k16/wp-content/uploads/2017_11.zip'
   -folder   => './elo/feda',
   -target   => '2017_11.sqlite',
   -callback => sub { my $player = shift; },
   -verbose  => 1
);

DESCRIPTION

The main idea of this module consists on build a SQL format from the XLS downloaded from the URL provided. All players information are loaded into "elo_feda" table, according this script:

CREATE TABLE elo_feda(
   feda_id integer primary key, 
   surname varchar(32) not null,
   name    varchar(32), 
   fed     varchar(8), 
   rating  integer, 
   games   integer, 
   birth   integer, 
   title   varchar(16), 
   flag    varchar(8)
);

METHODS

new (%OPTS)

Constructor. It accepts a hash with these options:

-callback

This callback sub will be called on each record found. It receives a hash reference with the player data: feda_id, surname, name, fed, rating, games, birth, title, flag

-folder

Working folder of the overall process. It is not created if it doesn't exists.

-target

Target file where the parser stores the ELO information. According the file extension, it selects the proper backend: .sqlite for SQLite dabase or .csv for a CSV file format. An empty value means that no backend is built.

-url

The URL direction (http://) used by the downloader to search the ZIP file. The main file expected into the package is the XLS

-verbose

0 by default. If set, shows useful debug messages

cleanup

Unlink the files dowloaded for this downloader (the XLS file)

download

Download the ZIP file from the -url parameter. Extract the XLS file to the target_folder (which must exists).

parse

Parse and transform the XLS input file to the proper backend, according the -target parameter. It relies on DBD::* in order to build the file.

run

Integrates download, parse and cleanup in a single call.

AUTHOR

Miguel Prz <niceperl@gmail.com>

COPYRIGHT AND LICENSE

This software is copyright (c) 2017 by Miguel Prz.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.