view release on metacpan or  search on metacpan

lib/App/FTNDB/ToDo.pod  view on Meta::CPAN

=head1 App::FTNDB To Do

=head2 General

Create App::FTNDB::Examples for example configuration files and scripts?

Move code repository information and the distribution archive information from
the README file to elsewhere, like I already did with FTN::Database v0.41; the
POD in lib/FTN/Database.pm is where I put it there, so need to decide there to
put for for this.  Main script and module?

Add an option, like -r, for specifying a region number; to be used like the
zone (-z) or net (-n) options, and available to all commands as needed.

Add script option for referencing an sql string for things like defining a
table or other definitions.  Is "-s" already being used?

Use Test::Database in test scripts?


=head2 ftndbadm

Develop a new version of the ftndb-admin script, basing it on App::Cmd and at
least initially having the name ftndbadm.  Move the functionality currently
in the ftndb-admin script to the new ftndbadm script.


=head2 App::FTNDB::Command::drop.pm

As part of the transition to using App::Cmd; move the functionality for the
I<drop> command from bin/ftndb-admin to the new module for the drop command.

Besides functionality for dropping databases and tables by their names, add
being able to drop an index by name.


=head2 App::FTNDB::Command::create.pm

As part of the transition to using App::Cmd; move the functionality for the
I<create> command from bin/ftndb-admin to the new module for the create command.

Add a command line option to reference a file containing the definition of a
nodelist table ("-s" as noted above?); perhaps also add a configuration option
for the same thing?


=head2 App::FTNDB::Nodelist

After create_ftn_table is available: rewrite create_nodelist_table to use that
and the new define_nodelist_table function.

Add a function to enable getting the nodelist header information; when given a
full path to a nodelist file, it will return a hash with at least the ftnyear
and yearday information. (Should really be a function of or an extension to
FTN::Nodelist.)

Add a function that checks if an ftnyear:yearday combination is already in the
database. Check for the ftnyear first; if that is present, then check yearday?
Or should such a function be in FTN::Database::Nodelist, as that is a database
function?

Derive and move function to insert or update an entry from ftndb-nodelist.
Separate functions for insert & update, or different options in same function?

Move get_nodelist_filename subroutine from the ftndb-nodelist script?

Derive and move a function for executing queries on the nodelist table from
the code used in the list_ftn_nodelist subroutine.