[Bio] / FigKernelScripts / export_ACH_resolution_DB.pl Repository:
ViewVC logotype

View of /FigKernelScripts/export_ACH_resolution_DB.pl

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (as text) (annotate)
Mon Mar 31 16:33:12 2008 UTC (12 years, 2 months ago) by overbeek
Branch: MAIN
updates to DB stuff for ACH resolution

use FIG;
my $fig = new FIG;

my $rdbH = $self->db_handle;

&FIG::verify_dir("$FIG_Config::data/ACHresolution");
if (open(DIFFS,">$FIG_Config::data/ACHresolution/diffs")
{
    my $relational_db_response = $rdbH->SQL("SELECT expertF,ourF,status FROM ACHres_diffs");
    foreach my $tuple (@$relational_db_response)
    {
	print DIFFS join("\t",@$tuple),"\n";
    }
    close(DIFFS);
}

if (open(COMMENTS,">$FIG_Config::data/ACHresolution/comments")
{
    my $relational_db_response = $rdbH->SQL("SELECT expertF,ourF,status FROM ACHres_comments");
    foreach my $tuple (@$relational_db_response)
    {
	print COMMENTS join("\t",@$tuple),"\n";
    }
    close(COMMENTS);
}


MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3