PHP evidence_get_assoc_flat_summaryの例

コード例 #1

ファイル: update_flat_summary.php プロジェクト: jwssb90/get-evidence

    $sql = "";
    $sqlparam = array();
}
print "Updating flat_summary...\n";
$snap = "latest";
// If any are missing, just generate those
$join = "LEFT JOIN flat_summary fs ON v.variant_id=fs.variant_id WHERE fs.variant_id IS NULL";
$tot = theDb()->getOne("SELECT COUNT(*) FROM variants v {$join}");
if ($tot == 0) {
    // If none are missing, refresh all
    $join = "";
    $tot = theDb()->getOne("SELECT COUNT(*) FROM variants v");
}
$q = theDb()->query("SELECT DISTINCT v.variant_id FROM variants v {$join}");
$n = 0;
while ($row =& $q->fetchRow()) {
    ++$n;
    print "\r{$n} / {$tot} ";
    $flat = evidence_get_assoc_flat_summary($snap, $row["variant_id"]);
    $sql .= "(?, ?, ?, ?, ?),";
    $sqlparam[] = $row["variant_id"];
    $sqlparam[] = json_encode($flat);
    $sqlparam[] = $flat["autoscore"];
    $sqlparam[] = $flat["webscore"];
    $sqlparam[] = $flat["n_genomes"];
    if (count($sqlparam) > 100) {
        sqlflush(&$sql, &$sqlparam);
    }
}
sqlflush(&$sql, &$sqlparam);
print "\n";

コード例 #2

ファイル: evidence.php プロジェクト: jwssb90/get-evidence

function evidence_update_flat_summary($variant_id)
{
    $flat = evidence_get_assoc_flat_summary("latest", $variant_id);
    theDb()->query("REPLACE INTO flat_summary\n\t\t\tSET variant_id=?, flat_summary=?,\n\t\t\tautoscore=?, webscore=?, n_genomes=?", array($variant_id, json_encode($flat), $flat["autoscore"], $flat["webscore"], $flat["n_genomes"]));
}

コード例 #3

ファイル: index.php プロジェクト: jwssb90/get-evidence

            $html .= "<BR /><SPAN class=\"searchurl\">" . htmlspecialchars($url_abbrev) . "</SPAN>";
        } else {
            $html .= $content;
        }
        $html . "</LI>";
        $lasttag = $r["tag"];
    }
    if ($lasttag !== FALSE) {
        $html .= "</UL>\n";
    }
    $html .= "</DIV>\n";
}
$html .= "<H2>Other <I>in silico</I> analyses<BR />&nbsp;</H2>\n<DIV id=\"in_silico\">\n<UL>\n";
if ($aa) {
    $html .= "<LI>NBLOSUM100 score = <STRONG>" . ereg_replace("-", "&ndash;", 0 - blosum100($row0["variant_aa_from"], $row0["variant_aa_to"])) . "</STRONG></LI>\n";
}
$autoscore_html = $row0["autoscore"];
if ($autoscore_html > 0) {
    $autoscore_html = "<SPAN onmouseover=\"Tip('" . htmlspecialchars($row0["autoscore_flags"]) . "',BALLOON,true,FIX,[this,-18,0],FOLLOWMOUSE,false,ABOVE,true,WIDTH,-400);\" onmouseout=\"UnTip();\">" . $autoscore_html . "</SPAN>";
}
$html .= "<LI>GET-Evidence autoscore = <STRONG>" . $autoscore_html . "</STRONG>";
$html .= "</LI>\n";
$html .= "</UL>\n";
$html .= "</DIV>";
$html .= "<H2>Edit history<BR />&nbsp;</H2>\n<DIV id=\"edit_history\">";
$html .= evidence_render_history($variant_id);
$html .= "</DIV>";
$gOut["content"] .= $html;
// $gOut["content"] .= "<!--\n" . ereg_replace ("-->", "\\-\\-\\>", json_encode ($report)) . "-->\n";
$gOut["content"] .= "<!--\n" . ereg_replace("-->", "\\-\\-\\>", json_encode(evidence_get_assoc_flat_summary("latest", $variant_id))) . "-->\n";
go();