[Bio] / FigWebServices / FigSQL.cgi Repository:
ViewVC logotype

View of /FigWebServices/FigSQL.cgi

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (download) (annotate)
Sat Jul 15 03:26:53 2006 UTC (13 years, 4 months ago) by parrello
Branch: MAIN
CVS Tags: mgrast_dev_08112011, rast_rel_2009_05_18, mgrast_dev_08022011, rast_rel_2014_0912, rast_rel_2008_06_18, myrast_rel40, rast_rel_2008_06_16, mgrast_dev_05262011, 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, mgrast_dev_02212011, 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, mgrast_dev_02222011, rast_rel_2009_03_26, mgrast_dev_10262011, rast_rel_2008_11_24, rast_rel_2008_08_07, HEAD
Changes since 1.1: +3 -11 lines
Fixed botched attempt to allow multi-table FIG queries.

#!/usr/bin/perl -w
#
# Copyright (c) 2003-2006 University of Chicago and Fellowship
# for Interpretations of Genomes. All Rights Reserved.
#
# This file is part of the SEED Toolkit.
#
# The SEED Toolkit is free software. You can redistribute
# it and/or modify it under the terms of the SEED Toolkit
# Public License.
#
# You should have received a copy of the SEED Toolkit Public License
# along with this program; if not write to the University of Chicago
# at info@ci.uchicago.edu or the Fellowship for Interpretation of
# Genomes at veronika@thefig.info or download a copy from
# http://www.theseed.org/LICENSE.TXT.
#


use strict;
use CGI;
use Tracer;
use PageBuilder;
use DBrtns;

# Print the HTML header.
print "CONTENT-TYPE: text/html\n\n";
# Get access to the form parameters.
my $query = new CGI;
# Start the web page.
my $builder = PageBuilder::new("Html/SproutBase.html", {}, "Html");
# Create a DB object.
my $dbh = DBrtns->new();
# Get the target table name.
my $table = $query->param("TableName");
# Create the SELECT.
my $sql = "SELECT $table.* FROM $table";
# Tack on the filter.
my $filter = $query->param('Filter');
if ($filter) {
    $sql .= " WHERE $filter";
}
my $rowCount = $query->param('RowCount');
if ($rowCount > 0) {
    $sql .= " LIMIT $rowCount";
}
$builder->TagItem("p", "SQL command is: $sql");
# Create the statement handle.
my $sth = $dbh->prepare_command($sql);
if (! $sth) {
    $builder->TagItem("p", "ERROR: " . $dbh->errstr);
    $builder->TagItem("p", "Error occurred preparing statement $sql.");
}
# Execute the statement.
my $result = $sth->execute();
if (! $result) {
    $builder->TagItem("p", "ERROR: " . $sth->errstr);
    $builder->TagItem("p", "Error occurred executing statement $sql.");
}
# Fetch the data. The first row will be used to get the column names.
my $hash = $sth->fetchrow_hashref();
if (! defined $hash) {
    # The query returned no rows.
    $builder->TagItem("p", "No result returned from query.");
} else {
    # Get the columns sorted by name.
    my @keys = sort keys %{$hash};
    # Start the result table.
    $builder->StartTable(@keys);
    # Now we'll loop through all the result rows.
    while (defined $hash) {
        # Get the result data in the proper order. NULLs come back as
        # undefined values.
        my @results = map { defined $hash->{$_} ? $hash->{$_} : "(null)" } @keys;
        # Put the results in the table.
        $builder->TableRow(\@results);
        # Get the next row.
        $hash = $sth->fetchrow_hashref();
    }
    # Finish the table.
    $builder->FinishTable();
}
# Finish the page.
$builder->Finish();

1;

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3