Function parseSQLFile

tools/sql2graph.php:97–160

($filename, &$tables, &$edges)

}

function parseSQLFile($filename, &$tables, &$edges) {
  //init
  $tables = array();
  $edges = array();
  
  //parse file
  $file = file($filename);
  for($i = 0;$i < count($file);++$i)
  {
    $line = trim($file[$i]);
    //node
    if(beginsWith($line, "CREATE TABLE"))
    {
      $parts                  = explode(" ", $line);
      $current_table          = $parts[2];
      $tables[$current_table] = array();
      $j                      = $i+1;
      $line                   = trim($file[$j]);
      //table
      while(!beginsWith($line, "CREATE TABLE") && !beginsWith($line, "ALTER TABLE") && $line != "")
      {
        //primary key
        if(beginsWith($line, "PRIMARY KEY"))
        {
          $parts = explode(" ", $line);
          $tables[$current_table][rp($parts[3])][] = "P";
        }
        // index
        elseif(beginsWith($line, "KEY"))
        {
          $parts = explode(" ", $line);
          $tables[$current_table][rp($parts[2])][] = "I";
        }
        // normal field
        else
        {
          $parts = explode(" ", $line);
          if($parts[0] != ")") 
            $tables[$current_table][$parts[0]] = array();
        }
        ++$j;
        $line = trim($file[$j]);
      }
    }
    //edges
    elseif(beginsWith($line, "ALTER TABLE"))
    {
      $parts = explode("`", $line);
      $from  = $parts[1];
      $j     = $i+1;
      while(beginsWith(trim($file[$j]), "ADD CONSTRAINT"))
      {
        $parts                          = explode(" ", $file[$j]);
        $to                             = $parts[9];
        $tables[$from][rp($parts[7])][] = "F";
        $edges[] = array(
          $from,
          $to,