Example #1
0
 static function pretify($sql)
 {
     $position = 0;
     $completed = 0;
     $start = 0;
     $end = 0;
     $skips = null;
     $c = null;
     $literals = new _hx_array(array());
     while ($position <= strlen($sql)) {
         $c = _hx_char_at($sql, $position++);
         switch ($c) {
             case "\\":
                 $position += 1;
                 break;
             case "'":
                 $start = $position;
                 $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$QUOTE, $sql, $position);
                 $end = $skips->position;
                 $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, null);
                 $sql = $skips->string;
                 $completed = $skips->position;
                 $position = $completed + 1;
                 break;
             case "\"":
                 $start = $position;
                 $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$QUOTES, $sql, $position);
                 $end = $skips->position;
                 $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, null);
                 $sql = $skips->string;
                 $completed = $skips->position;
                 $position = $completed + 1;
                 break;
             case "`":
                 $start = $position;
                 $skips = system_base_Sql_colour::skippy(system_base_Sql_colour::$REV_TICK, $sql, $position);
                 $end = $skips->position;
                 $skips = system_base_Sql_colour::now_in_colour($sql, $completed, $start, $end, system_base_Sql_colour::$REV_TICK);
                 $sql = $skips->string;
                 $completed = $skips->position;
                 $position = $completed + 1;
                 break;
         }
     }
     $sql = system_base_Sql_colour::now_in_colour($sql, $completed, $position, $position, null)->string;
     $sql = system_base_Sql_colour::$NEWLINE->replace($sql, "<br>");
     $sql = system_base_Sql_colour::$TAB->replace($sql, "&nbsp;&nbsp;&nbsp;&nbsp;");
     return $sql;
 }