PHP ResultSet::append方法代码示例

 function parseResultSetFromFile($fd)
 {
     $start = getmicrotime();
     $rs = new ResultSet();
     // read in the whole file
     fseek($fd, 0, SEEK_END);
     $size = ftell($fd);
     fseek($fd, 0, SEEK_SET);
     $wholeFile = fread($fd, $size);
     $lines = explode("\n", $wholeFile);
     unset($wholeFile);
     $wholeFile = "";
     $rec = $this->parseRowFromLine($lines[0]);
     $rs->setColumnNames($rec);
     $rec = $this->parseRowFromLine($lines[1]);
     $rs->setColumnTypes($rec);
     $rec = $this->parseRowFromLine($lines[2]);
     $rs->setColumnDefaultValues($rec);
     $rs->reset();
     $lineCount = count($lines);
     for ($i = 3; $i < $lineCount; ++$i) {
         //$rec=$this->parseRowFromLine($lines[$i]);
         //inlining function parseRowFromLine() for better performance
         $line = $lines[$i];
         if (strlen(trim($line)) == 0) {
             continue;
         }
         // handle Windows \x0D\x0A (\r\n) newlines
         $line = rtrim($line);
         $rec = explode(COLUMN_SEPARATOR_CHAR, $line);
         $rec = str_replace($this->escapeCodeRead, $this->replaceWithRead, $rec);
         if (count($rec) == count($rs->colNames)) {
             $setDefaults = false;
         } else {
             $setDefaults = true;
         }
         if ($rec) {
             $rs->append($setDefaults);
             $rs->rows[$rs->pos]->fields = $rec;
             $rs->rows[$rs->pos]->id = -1;
         }
     }
     debug_print("<i>II: parseResultSetFromFile: " . (getmicrotime() - $start) . " seconds elapsed</i><br>");
     $rs->setColumnAliases(create_array_fill(count($rs->colNames), ""));
     $rs->setColumnTables(create_array_fill(count($rs->colNames), ""));
     $rs->setColumnTableAliases(create_array_fill(count($rs->colNames), ""));
     $rs->setColumnFunctions(create_array_fill(count($rs->colNames), ""));
     $rs->colFuncsExecuted = create_array_fill(count($rs->colNames), false);
     return $rs;
 }

 function executeSelectQuery(&$sqlQuery)
 {
     global $g_sqlGroupingFuncs;
     global $g_sqlSingleRecFuncs;
     $resultSets = array();
     // create a copy
     $aliases = $sqlQuery->colAliases;
     $funcs = $sqlQuery->colFuncs;
     // Read all Tables
     for ($i = 0; $i < count($sqlQuery->tables); ++$i) {
         debug_printb("<br>[executeSelectQuery] Reading table " . $sqlQuery->tables[$i] . "<br>");
         if (!($resultSets[$i] = $this->readTable($sqlQuery->tables[$i]))) {
             print_error_msg("Reading Table " . $sqlQuery->tables[$i] . " failed");
             return false;
         }
         $resultSets[$i]->setColumnTableForAll($sqlQuery->tables[$i]);
         $resultSets[$i]->setColumnTableAliasForAll($sqlQuery->tableAliases[$i]);
         // set all functions to the ResultSet of the current table
         // if table and column name matches
         debug_printb("[executeSelectQuery] Setting functions for the current table:<br>");
         for ($j = 0; $j < count($funcs); ++$j) {
             if (!$funcs[$j] || !$sqlQuery->colNames[$j]) {
                 continue;
             }
             if ($sqlQuery->colTables[$j] == $sqlQuery->tables[$i] || $sqlQuery->colTables[$j] == $sqlQuery->tableAliases[$i]) {
                 $colNr = $resultSets[$i]->findColNrByAttrs($sqlQuery->colNames[$j], $sqlQuery->colTables[$j], "");
                 if ($colNr == NOT_FOUND) {
                     continue;
                 }
                 // create a new column for each function
                 $resultSets[$i]->addColumn($sqlQuery->colNames[$j], $sqlQuery->colAliases[$j], $sqlQuery->colTables[$j], "", "str", "", $funcs[$j], "", true);
                 $funcs[$j] = "";
             }
         }
         // set all aliases where table, column name and function matches
         debug_printb("[executeSelectQuery] Setting aliases for the current table:<br>");
         for ($j = 0; $j < count($aliases); ++$j) {
             if (!$aliases[$j]) {
                 continue;
             }
             if ($sqlQuery->colTables[$j] == $sqlQuery->tables[$i] || $sqlQuery->colTables[$j] == $sqlQuery->tableAliases[$i]) {
                 if (($colNr = $resultSets[$i]->findColNrByAttrs($sqlQuery->colNames[$j], $sqlQuery->colTables[$j], $sqlQuery->colFuncs[$j])) != NOT_FOUND) {
                     $resultSets[$i]->setColumnAlias($colNr, $aliases[$j]);
                     $aliases[$j] = "";
                 }
             }
         }
         if (TXTDBAPI_DEBUG) {
             debug_printb("<br>[executeSelectQuery] Dump of Table {$i} (" . $sqlQuery->tables[$i] . "):<br>");
             $resultSets[$i]->dump();
         }
     }
     // set remaining functions to the ResultSet where column name matches
     debug_printb("[executeSelectQuery] Setting remaining functions where column name matches:<br>");
     for ($i = 0; $i < count($resultSets); ++$i) {
         for ($j = 0; $j < count($funcs); ++$j) {
             if (!$funcs[$j] || !$sqlQuery->colNames[$j]) {
                 continue;
             }
             $colNr = $resultSets[$i]->findColNrByAttrs($sqlQuery->colNames[$j], "", "");
             if ($colNr == NOT_FOUND) {
                 // 'text' or 123 ? => add column
                 if (!(is_numeric($sqlQuery->colNames[$j]) || has_quotes($sqlQuery->colNames[$j]))) {
                     continue;
                 }
                 debug_print("Adding function with quoted string or number paremeter!<br>");
             }
             // create a new column for each function
             $resultSets[$i]->addColumn($sqlQuery->colNames[$j], $sqlQuery->colAliases[$j], $sqlQuery->colTables[$j], "", "str", "", $funcs[$j], "", true);
             $funcs[$j] = "";
         }
     }
     // set remaining aliases where column name and function matches
     debug_printb("[executeSelectQuery] Setting remaining aliases where column name and function matches:<br>");
     for ($i = 0; $i < count($resultSets); ++$i) {
         for ($j = 0; $j < count($aliases); ++$j) {
             if (!$aliases[$j]) {
                 continue;
             }
             if (($colNr = $resultSets[$i]->findColNrByAttrs($sqlQuery->colNames[$j], "", $sqlQuery->colFuncs[$j])) != NOT_FOUND) {
                 $resultSets[$i]->setColumnAlias($colNr, $aliases[$j]);
                 $aliases[$j] = "";
             }
         }
     }
     debug_printb("[executeSelectQuery] Executing single-rec functions (on the separate ResultSet's):<br>");
     // execute single-rec functions (on the separate ResultSet's)
     for ($i = 0; $i < count($resultSets); ++$i) {
         $resultSets[$i]->executeSingleRecFuncs();
     }
     // A query without tables ? => make a dummy ResultSet
     $dummyResultSet = false;
     if (count($sqlQuery->tables) == 0) {
         $dummyResultSet = true;
         $rsMaster = new ResultSet();
         $rsMaster->addColumn("(dummy)", "(dummy)", "(dummy)", "(dummy)", "str", "(dummy)", "", "", true);
         $rsMaster->append();
         // else: real ResultSet
     } else {
         $dummyResultSet = false;
//.........这里部分代码省略.........

 for ($i = 0; $i < $rowCount; ++$i) {
     if (isset($_POST['delete' . $i])) {
         echo "Row {$i} deleted!<br>";
     } else {
         if (isset($_POST['dup' . $i])) {
             echo "Row {$i} duplicated!<br>";
             $rowsSaved++;
             $rs->appendRow(prep_val_save_arr($vals[$i]));
         }
         $rowsSaved++;
         $rs->appendRow(prep_val_save_arr($vals[$i]));
     }
 }
 echo "{$rowsSaved} Rows saved!<br>";
 if (isset($_POST['append_row'])) {
     $rs->append();
     echo "1 Row appended!<br>";
 }
 echo "colCount: {$colCount}<br>";
 for ($i = 0; $i < $colCount; ++$i) {
     if (isset($_POST['dupCol' . $i])) {
         $rs->duplicateColumn($i);
         echo "Column {$i} duplicated!<br>";
     }
 }
 for ($i = 0; $i < $colCount; ++$i) {
     if (isset($_POST['delCol' . $i])) {
         $rs->removeColumn($i);
         echo "Column {$i} deleted!<br>";
     }
 }