/ 
ftndb-0.37
River stage zero No dependents
/ FTNDB::Nodelist

NAME

FTNDB::Nodelist - Fidonet/FTN Nodelist SQL Database operations.

VERSION

Version 0.37

DESCRIPTION

FTNDB::Nodelist is a Perl module containing common nodelist related subroutines for Fidonet/FTN Nodelist related processing on a Nodelist table in an SQL Database. The SQL database engine is one for which a DBD module exists, defaulting to SQLite.

EXPORT

The following functions are available in this module: create_nodelist_table(), drop_nodelist_table(), create_ftnnode_index(), remove_ftn_domain(), nodelist_file_info().

FUNCTIONS

create_nodelist_table

Syntax: create_nodelist_table($db_handle, $table_name, $db_type);

Create an FTN Nodelist table in an SQL database being used for Fidonet/FTN processing, where $db_handle is an existing open database handle, $table_name is the name of the table to be created, and $db_type is the type of database.

create_ftnnode_index

Syntax: create_ftnnode_index($db_handle, $table_name);

Create an index named ftnnode on an FTN Nodelist table in an SQL database being used for Fidonet/FTN processing, where $db_handle is an existing open database handle and $table_name is the name of the table that is being indexed. The index is created on the following fields: zone, net, node, point, and domain.

remove_ftn_domain

Syntax: remove_ftn_domain($db_handle, $table_name, $domain);

Remove all entries for a particular FTN domain from an FTN nodelist table in an SQL database being used for FTN processing; where $db_handle is an existing open database handle and $table_name is the name of the table from which the FTN domain $domain is being removed.

nodelist_file_info

Syntax: %nodelist_info = nodelist_file_info($nodelist_file);

Returns a hash containing the header and other information for a nodelist file when given the file name and path for an FTN nodelist file. The possible keys returned in the hash are as follows:

Year

The four digit year from the nodelist file header line. Defaults to the year number from the nodelist file time stamp.

YearDay

The year day number from the nodelist file header line. Defaults to the file suffix of the nodelist, which is assumed to be a three digit number.

FileYear

The four digit year number from the timestamp of the nodelist file.

FileYDay

The year day number from the timestamp of the nodelist file.

HeaderLine

The header line (first line) from the nodelist file as a string.

EXAMPLES

An example of opening an FTN database, then creating a nodelist table, loading data to it, then creating an index on it, and the closing the database:

use FTNDB::Nodelist;

my $db_handle = open_ftn_database(\%db_option);
create_nodelist_table($db_handle, $table_name);
...   (Load data to nodelist table)
create_ftnnode_index($db_handle, $table_name);
close_ftn_database($db_handle);

AUTHOR

Robert James Clay, <jame at rocasa.us>

BUGS

Please report any bugs or feature requests via the web interface at https://sourceforge.net/p/ftnpl/ftndb/tickets/. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

Note that you can also report any bugs or feature requests to bug-ftndb at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=ftndb; however, the FTN Database application Issue tracker at the SourceForge project is preferred.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc FTNDB::Nodelist

You can also look for information at:

SEE ALSO

L<FTN::Database>, L<ftndb-admin>, and L<ftndb-nodelist>

COPYRIGHT & LICENSE

Copyright 2010-2012 Robert James Clay, all rights reserved.

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