[Bio] View of /Sprout/SproutStats.pl

Revision 1.2 - (download) (as text) (annotate)
Thu Jun 8 15:37:32 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
CVS Tags: mgrast_dev_08112011, mgrast_dev_08022011, rast_rel_2014_0912, rast_rel_2008_06_18, rast_rel_2008_06_16, rast_rel_2008_12_18, mgrast_dev_04082011, rast_rel_2008_07_21, rast_rel_2010_0928, rast_2008_0924, mgrast_version_3_2, mgrast_dev_12152011, rast_rel_2008_04_23, mgrast_dev_06072011, rast_rel_2008_09_30, rast_rel_2009_0925, rast_rel_2010_0526, rast_rel_2014_0729, rast_rel_2009_05_18, rast_rel_2010_1206, mgrast_release_3_0, mgrast_dev_03252011, rast_rel_2010_0118, mgrast_rel_2008_0924, mgrast_rel_2008_1110_v2, rast_rel_2009_02_05, rast_rel_2011_0119, mgrast_rel_2008_0625, mgrast_release_3_0_4, mgrast_release_3_0_2, mgrast_release_3_0_3, mgrast_release_3_0_1, mgrast_dev_03312011, mgrast_release_3_1_2, mgrast_release_3_1_1, mgrast_release_3_1_0, mgrast_dev_04132011, rast_rel_2008_10_09, mgrast_dev_04012011, rast_release_2008_09_29, mgrast_rel_2008_0806, mgrast_rel_2008_0923, mgrast_rel_2008_0919, rast_rel_2009_07_09, rast_rel_2010_0827, mgrast_rel_2008_1110, myrast_33, rast_rel_2011_0928, rast_rel_2008_09_29, mgrast_rel_2008_0917, rast_rel_2008_10_29, mgrast_dev_04052011, rast_rel_2009_03_26, mgrast_dev_10262011, rast_rel_2008_11_24, rast_rel_2008_08_07, HEAD
Changes since 1.1: +1 -1 lines

Fxied obsolete references to the {_erdb} member.

#!/usr/bin/perl -w

=head1 Sprout Stats

Display the number of records in each Sprout table.

The currently-supported command-line options are as follows.

=over 4

=item trace

Numeric trace level. A higher trace level causes more messages to appear. The
default trace level is 2.

=back

=cut

use strict;
use Tracer;
use Sprout;
use ERDB;
use SFXlate;

# Get the command-line options.
my ($options, @parameters) = Tracer::ParseCommand({ trace => 2 }, @ARGV);
# Set up tracing.
my $traceLevel = $options->{trace};
TSetup("$traceLevel errors Tracer", "TEXT");
# Get the ERDB object.
my $sprout = SFXlate->new_sprout_only();
my $erdb = $sprout;
# Get its database handle.
my $dbh = $erdb->{_dbh};
# Get the list of table names.
my @tables = $erdb->GetTableNames();
# Loop through the tables.
for my $table (@tables) {
    # Insure this table exists.
    if (! $dbh->table_exists($table)) {
        Trace("Table $table not found in database.") if T(0);
    } else {
        # Get the number of records.
        my $rv = $dbh->SQL("SELECT COUNT(*) FROM $table");
        Trace($rv->[0]->[0] . " records in table $table.") if T(2);
    }
}

1;