public function process($out) { if (!$out) { return false; } if (!empty($out['BRACKET'])) { // TODO: this field should be a global STATEMENT field within the output // we could add all other categories as sub_tree, it could also work with multipe UNIONs $processor = new BracketProcessor(); $out['BRACKET'] = $processor->process($out['BRACKET']); } if (!empty($out['CREATE'])) { $processor = new CreateProcessor(); $out['CREATE'] = $processor->process($out['CREATE']); } if (!empty($out['TABLE'])) { $processor = new TableProcessor(); $out['TABLE'] = $processor->process($out['TABLE']); $this->moveLIKE($out); } if (!empty($out['INDEX'])) { $processor = new IndexProcessor(); $out['INDEX'] = $processor->process($out['INDEX']); } if (!empty($out['EXPLAIN'])) { $processor = new ExplainProcessor(); $out['EXPLAIN'] = $processor->process($out['EXPLAIN'], array_keys($out)); } if (!empty($out['DESCRIBE'])) { $processor = new DescribeProcessor(); $out['DESCRIBE'] = $processor->process($out['DESCRIBE'], array_keys($out)); } if (!empty($out['DESC'])) { $processor = new DescProcessor(); $out['DESC'] = $processor->process($out['DESC'], array_keys($out)); } if (!empty($out['SELECT'])) { $processor = new SelectProcessor(); $out['SELECT'] = $processor->process($out['SELECT']); } if (!empty($out['FROM'])) { $processor = new FromProcessor(); $out['FROM'] = $processor->process($out['FROM']); } if (!empty($out['USING'])) { $processor = new UsingProcessor(); $out['USING'] = $processor->process($out['USING']); } if (!empty($out['UPDATE'])) { $processor = new UpdateProcessor(); $out['UPDATE'] = $processor->process($out['UPDATE']); } if (!empty($out['GROUP'])) { // set empty array if we have partial SQL statement $processor = new GroupByProcessor(); $out['GROUP'] = $processor->process($out['GROUP'], isset($out['SELECT']) ? $out['SELECT'] : array()); } if (!empty($out['ORDER'])) { // set empty array if we have partial SQL statement $processor = new OrderByProcessor(); $out['ORDER'] = $processor->process($out['ORDER'], isset($out['SELECT']) ? $out['SELECT'] : array()); } if (!empty($out['LIMIT'])) { $processor = new LimitProcessor(); $out['LIMIT'] = $processor->process($out['LIMIT']); } if (!empty($out['WHERE'])) { $processor = new WhereProcessor(); $out['WHERE'] = $processor->process($out['WHERE']); } if (!empty($out['HAVING'])) { $processor = new HavingProcessor(); $out['HAVING'] = $processor->process($out['HAVING'], isset($out['SELECT']) ? $out['SELECT'] : array()); } if (!empty($out['SET'])) { $processor = new SetProcessor(); $out['SET'] = $processor->process($out['SET'], isset($out['UPDATE'])); } if (!empty($out['DUPLICATE'])) { $processor = new DuplicateProcessor(); $out['ON DUPLICATE KEY UPDATE'] = $processor->process($out['DUPLICATE']); unset($out['DUPLICATE']); } if (!empty($out['INSERT'])) { $processor = new InsertProcessor(); $out = $processor->process($out); } if (!empty($out['REPLACE'])) { $processor = new ReplaceProcessor(); $out = $processor->process($out); } if (!empty($out['DELETE'])) { $processor = new DeleteProcessor(); $out = $processor->process($out); } if (!empty($out['VALUES'])) { $processor = new ValuesProcessor(); $out = $processor->process($out); } if (!empty($out['INTO'])) { $processor = new IntoProcessor(); $out = $processor->process($out); } if (!empty($out['DROP'])) { $processor = new DropProcessor(); $out['DROP'] = $processor->process($out['DROP']); } if (!empty($out['RENAME'])) { $processor = new RenameProcessor(); $out['RENAME'] = $processor->process($out['RENAME']); } if (!empty($out['SHOW'])) { $processor = new ShowProcessor(); $out['SHOW'] = $processor->process($out['SHOW']); } if (!empty($out['OPTIONS'])) { $processor = new OptionsProcessor(); $out['OPTIONS'] = $processor->process($out['OPTIONS']); } if (!empty($out['WITH'])) { $processor = new WithProcessor(); $out['WITH'] = $processor->process($out['WITH']); } return $out; }
public function process($out) { if (!$out) { return false; } if (!empty($out['CREATE'])) { $processor = new CreateProcessor(); $out['CREATE'] = $processor->process($out['CREATE']); } if (!empty($out['TABLE'])) { $processor = new TableProcessor(); $out['TABLE'] = $processor->process($out['TABLE']); $this->moveLIKE($out); } if (!empty($out['EXPLAIN'])) { $processor = new ExplainProcessor(); $out['EXPLAIN'] = $processor->process($out['EXPLAIN'], array_keys($out)); } if (!empty($out['DESCRIBE'])) { $processor = new DescribeProcessor(); $out['DESCRIBE'] = $processor->process($out['DESCRIBE'], array_keys($out)); } if (!empty($out['DESC'])) { $processor = new DescProcessor(); $out['DESC'] = $processor->process($out['DESC'], array_keys($out)); } if (!empty($out['SELECT'])) { $processor = new SelectProcessor(); $out['SELECT'] = $processor->process($out['SELECT']); } if (!empty($out['FROM'])) { $processor = new FromProcessor(); $out['FROM'] = $processor->process($out['FROM']); } if (!empty($out['USING'])) { $processor = new UsingProcessor(); $out['USING'] = $processor->process($out['USING']); } if (!empty($out['UPDATE'])) { $processor = new UpdateProcessor(); $out['UPDATE'] = $processor->process($out['UPDATE']); } if (!empty($out['GROUP'])) { // set empty array if we have partial SQL statement $processor = new GroupByProcessor(); $out['GROUP'] = $processor->process($out['GROUP'], isset($out['SELECT']) ? $out['SELECT'] : array()); } if (!empty($out['ORDER'])) { // set empty array if we have partial SQL statement $processor = new OrderByProcessor(); $out['ORDER'] = $processor->process($out['ORDER'], isset($out['SELECT']) ? $out['SELECT'] : array()); } if (!empty($out['LIMIT'])) { $processor = new LimitProcessor(); $out['LIMIT'] = $processor->process($out['LIMIT']); } if (!empty($out['WHERE'])) { $processor = new WhereProcessor(); $out['WHERE'] = $processor->process($out['WHERE']); } if (!empty($out['HAVING'])) { $processor = new HavingProcessor(); $out['HAVING'] = $processor->process($out['HAVING']); } if (!empty($out['SET'])) { $processor = new SetProcessor(); $out['SET'] = $processor->process($out['SET'], isset($out['UPDATE'])); } if (!empty($out['DUPLICATE'])) { $processor = new DuplicateProcessor(); $out['ON DUPLICATE KEY UPDATE'] = $processor->process($out['DUPLICATE']); unset($out['DUPLICATE']); } if (!empty($out['INSERT'])) { $processor = new InsertProcessor(); $out = $processor->process($out); } if (!empty($out['REPLACE'])) { $processor = new ReplaceProcessor(); $out = $processor->process($out); } if (!empty($out['DELETE'])) { $processor = new DeleteProcessor(); $out = $processor->process($out); } if (!empty($out['VALUES'])) { $processor = new ValuesProcessor(); $out = $processor->process($out); } if (!empty($out['INTO'])) { $processor = new IntoProcessor(); $out = $processor->process($out); } if (!empty($out['DROP'])) { $processor = new DropProcessor(); $out['DROP'] = $processor->process($out['DROP']); } if (!empty($out['RENAME'])) { $processor = new RenameProcessor(); $out['RENAME'] = $processor->process($out['RENAME']); } if (!empty($out['SHOW'])) { $processor = new ShowProcessor(); $out['SHOW'] = $processor->process($out['SHOW']); } return $out; }