[Bio] / Sprout / SingleTableLoad.pl Repository:
ViewVC logotype

View of /Sprout/SingleTableLoad.pl

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.2 - (download) (as text) (annotate)
Wed Jul 5 21:48:11 2006 UTC (14 years ago) by parrello
Branch: MAIN
Changes since 1.1: +52 -8 lines
Added the "phone" option.

#!/usr/bin/perl -w

=head1 Single Table Load

This script loads one or more Sprout table from an existing DTX file.

It takes as positional parameters the table names. The command-line
options are as follows.

=over 4

=item trace

Desired tracing level. The default is 3.

=item user

Suffix to use for trace, output, and error files created.

=item background

Redirect the standard and error output to files in the FIG temporary directory.

=item sql

Trace SQL statements.

=item phone

Phone number to message when the load finishes.



use strict;
use Tracer;
use DocUtils;
use TestUtils;
use Cwd;
use Sprout;
use SFXlate;
use File::Copy;
use File::Path;

# Get the command-line options.
my ($options, @parameters) = StandardSetup(['ERDB', 'Sprout', 'DBKernel'],
                                           phone => ["", "phone number (international format) to call when load finishes"],
                                            '<table1> <table2> ...',
# Set a variable to contain return type information.
my $rtype;
# Insure we catch errors.
eval {
    # Get a Sprout object.
    my $sprout = SFXlate->new_sprout_only();
    # Attempt the load. Note that we have the truncate flag on to force the table
    # to be rebuilt.
    $sprout->LoadUpdate(1, \@parameters);
if ($@) {
    Trace("Load failed with error: $@") if T(0);
    $rtype = "error";
} else {
    Trace("Load complete.") if T(2);
    $rtype = "no error";
if ($options->{phone}) {
    my $msgID = Tracer::SendSMS($options->{phone}, "Sprout table load terminated with $rtype.");
    if ($msgID) {
        Trace("Phone message sent with ID $msgID.") if T(2);
    } else {
        Trace("Phone message not sent.") if T(2);


MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3