FTNDB::Nodelist - Fidonet/FTN Nodelist SQL Database operations.
Version 0.35
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().
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.
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);
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 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=ftndb
Search CPAN
http://search.cpan.org/dist/ftndb
L<FTN::Database>, L<ftndb-admin>, and L<ftndb-nodelist>
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.
To install FTNDB, copy and paste the appropriate command in to your terminal.
cpanm
cpanm FTNDB
CPAN shell
perl -MCPAN -e shell install FTNDB
For more information on module installation, please visit the detailed CPAN module installation guide.