App-FTNDB

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

      appropriate bin/* script.

0.09    Mon Aug 23 20:38 2010
    - Correct remove_ftn_domain call in bin/nl2ftndb.
    - Correct help message for the -f parameter in bin/nl2ftndb.
    - Redo the variables used in the Perl scripts for readability, including by
      separating the words in the variables by underscores.
    - Corrected an instance of a duped variable in bin/nl2ftndb help message.

0.08    Sat Aug 21 20:03 2010
    The default DBI user and password parameters for an SQLite database
    is an empty string;  change the default codeing for those in the bin/*
    scripts.

0.07    Sat Aug 21 18:19 2010
    - Correct script name in Makefile.PL from net2file to listftndb.
    - Correct wording regarding EOL change in previous Changes entry.
    - Derive and move the remove_ftn_domain functions from nl2ftndb
      to the FTN::Database::Nodelist module.

0.06    Sat Aug 21 16:55 2010

bin/ftndb-admin  view on Meta::CPAN

    $db_option{'User'} = q{};

} else {
    $db_option{'User'} = $ftndb_config->{Database}->{User};

    if ($opt_v) { logging($log_file, $log_id, "Database user being used is $db_option{'User'}") };

}

# Get the definition of the database password
if ($db_option{'Type'} eq 'SQLite') {

    $db_option{'Password'} = q{};

} else {

    $db_option{'Password'} = $ftndb_config->{Database}->{Password};
    if ($opt_v) { logging($log_file, $log_id, "Database password being used is $db_option{'Password'}") };

}

=item -d

Name of the database being created or dropped.

=cut

if ($opt_d) {

bin/ftndb-admin  view on Meta::CPAN

also include a path.

=item User

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

=item Password

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

=back

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

    # ftndb.cfg
    LogFile=/opt/ftndb/ftndb.log

bin/ftndb-nodelist  view on Meta::CPAN

    $db_option{'User'} = q{};

} else {
    $db_option{'User'} = $ftndb_config->{Database}->{User};

    if ($opt_v) { logging($log_file, $log_id, "Database user being used is $db_option{'User'}") };

}

# Get the definition of the database password
if ($db_option{'Type'} eq 'SQLite') {

    $db_option{'Password'} = q{};

} else {

    $db_option{'Password'} = $ftndb_config->{Database}->{Password};
    if ($opt_v) { logging($log_file, $log_id, "Database password being used is $db_option{'Password'}") };

}

=item -f

The nodelist file.
If the -e option is also set, then this is an exact file name.  If -e is
not set, then this is the basename of the nodelist files.  If -f is not
set, then when needed it defaults to "nodelist".

bin/ftndb-nodelist  view on Meta::CPAN

also include a path.

=item User

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

=item Password

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

=back

The B<Nodelist> section in the configuration file has the following
keywords:

=over 4

doc/History  view on Meta::CPAN

      and can be an issue;  changed how that is done by dropping the use
      of '&' in the subroutine calls.
    - Define which database type to use, using what is supported by the
      DBI DBD modules and defaulting to using the SQLite database engine.
      Use the parameter '-T' for the selection.
    
16 Jul 10
    - Moved the version number in the comment line of the Perl scripts to a
      $VERSION variable.
    - Add command line parameters to define the database name ($dbname),
      user ($dbuser), and password ($dbpass) for access to the database. 
    - Add code for creating an index on the nodelist table.
    - Change to using the FTN::Log subroutine directly.  
    - nl2db.pl - Add an option -z to load just a defined zone into the database.
    - nldbadm.pl - Replaced the use of the TableExists function with using the
      following SQL:  DROP TABLE IF EXISTS <tablename>.
    - Added note to README file about support via echos or mailing lists.
    - Rewrite shell script examples.
    
15 Jul 10
    - Changed name from nl2sql to nl2db

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

also include a path.

=item User

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

=item Password

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

=back

=head1 EXAMPLES

This is an example of the contents of an ftndb.cfg configuration file:

    # ftndb.cfg