<?php

// we need a contig id and number of tigr seq
if ($QUERY_STRING == ""){
  die("");
}

// get contigID
$contigID = $QUERY_STRING;

// validation
checkContigID($contigID);

// connect to the database
$Link = mysql_connect("localhost", "DB_NAME", "DB_PASSWORD")
        or die("Cannot connect to the database");
mysql_select_db("DB_NAME")
        or die("No such database");

// determine table names
if($contigID[1] == "G"){
  $table_assembly = "lettuce_assembly";
}
else if($contigID[1] == "H"){
  $table_assembly = "sunflower_assembly";
}
else if($contigID[0] == "L"){
  $table_assembly = "tomato_assembly";
}
else if($contigID[1] == "_"){
  $table_assembly = "tomato_assembly";
}
else{  // bad contig name
  die("");
}

printout($contigID, $table_assembly);


// ------------------------------------------------------

function printout($contigID, $table_assembly){

  list($Seq_Length, $Sequence) = getDataFromTableAssembly($contigID, $table_assembly);

  // output result
  echo "$Sequence\n";
}

// ------------------------------------------------------

function getDataFromTableAssembly($contigID, $table_assembly){

  // get data from table assembly
  $query = "SELECT Seq_Length, Sequence FROM $table_assembly WHERE Contig_ID = '$contigID'";
  $result = mysql_query( $query )
       or die("Invalid query");
  $rownum = mysql_num_rows($result);
  if($rownum==0) die("Unknown Contig ID");
  if($rownum>1) die("Multiple results detected");
  // just get the first tuple
  $myrow = mysql_fetch_array($result);
  $Seq_Length = $myrow['Seq_Length'];
  $Sequence = $myrow['Sequence'];

  return array($Seq_Length, $Sequence);
}

// ------------------------------------------------------


// ------------------------------------------------------

function checkContigID($contigID){

  // assume it is ok for now

}

// ------------------------------------------------------

function checkNumTigrSeq($numTigrSeq){

  // assume it is ok for now

}

// ------------------------------------------------------
// ------------------------------------------------------
// ------------------------------------------------------

?>