The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
FTN-Database-0.16
River stage one • 2 direct dependents • 2 total dependents
/ listftndb

NAME

listftndb - List information from an Fidonet/FTN SQL database

VERSION

Version 0.15

DESCRIPTION

List information from a Fidonet/FTN St. Louis Format Nodelist to a text file. One such listing can be from a specific net from a specific zone of a nodelist table.

SYNOPSIS

listftndb -c config_file [-t tablename] [-z zone] [-n net] [-o outfile] [-v]

listftndb [-h | --help]

listftndb --version

OPTIONS

-c

This is the filename and path of a configuration file, with the default being ftnpldb.cfg in the current directory.

-x

Debug option.

-v

Verbose option.

-t

The nodelist table name to be used. Note that if there is a period in the name, that period will be changed to an underscore.

-z

If set; is the FTN Zone number, with 1 being the default.

-n

If set; is the FTN Net number, with 1 being the default.

-o

Output file. This needs to be at least the filename and can also include a path. The default output file is outfile.txt in the current directory.

CONFIGURATION

The Database section in the configuration file has the following keywords:

Type

Database type. This needs to be a database type for which a DBD module exists, the type being the name as used in the DBD module. The default type is SQLite.

Name

Database name. For an SQLite databse; this needs to be at least the filename and can also include a path.

User

Database user. For an SQLite database, this defaults to an empty string as it is not needed for that type of database.

Password

Database password. For an SQLite database, this defaults to an empty string as it is not needed for that type of database.

This is an example of the contents of an ftnpldb.cfg file:

    [Database]
    Type=mysql
    Name=ftndbtst
    User=sysop
    Password=ftndbtst

EXAMPLES

Given that $CFGFILE is a configuration file and that $LISTFILE is a file where the information is to be listed, the following command line can be used to list the nodes in Net 102 of Zone 1 in that file:

listftndb -c $CFGFILE -z 1 -n 102 -o $LISTFILE -v

AUTHOR

Robert James Clay, <jame at rocasa.us>

BUGS

Please report any bugs or feature requests to bug-ftn-database at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=FTN-Database. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

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

    perldoc listftndb

You can also look for information at:

SEE ALSO

 L<FTN::Database>, L<FTN::Database::Nodelist>, L<ftndbadm>,
 L<ftndbadm>, and L<nl2ftndb>

COPYRIGHT & LICENSE

Copyright 2010 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.