App::FTNDB::Nodelist - Fidonet/FTN Nodelist SQL Database operations.
Version 0.39
App::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.
The following functions are available in this module: create_nodelist_table(), drop_nodelist_table(), create_ftnnode_index(), remove_ftn_domain(), nodelist_file_info().
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.
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.
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.
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:
The four digit year from the nodelist file header line. Defaults to the year number from the nodelist file time stamp.
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.
The four digit year number from the timestamp of the nodelist file.
The year day number from the timestamp of the nodelist file.
The header line (first line) from the nodelist file as a string.
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 App::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);
Robert James Clay, <jame at rocasa.us>
<jame at rocasa.us>
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.
bug-ftndb at rt.cpan.org
You can find documentation for this module with the perldoc command.
perldoc App::FTNDB::Nodelist
You can also look for information at:
FTN Database application issue tracker
https://sourceforge.net/p/ftnpl/ftndb/tickets/
RT: CPAN's request tracker
http://rt.cpan.org/NoAuth/Bugs.html?Dist=App-FTNDB
Search CPAN
http://search.cpan.org/dist/App-FTNDB
L<FTN::Database>, L<ftndb-admin>, and L<ftndb-nodelist>
Copyright 2010-2013 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.
To install App::FTNDB, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::FTNDB
CPAN shell
perl -MCPAN -e shell install App::FTNDB
For more information on module installation, please visit the detailed CPAN module installation guide.