/** * 编译成SQL语句 */ protected function compile() { $parts = array(); $parts['start'] = 'delete from'; $parts[self::TABLE] = $this->renderTable(); $parts[self::WHERE] = $this->renderWhere(); $parts[self::LIMIT] = $this->renderLimit(); $parts[self::ENDS] = $this->ends; $this->parts =& $parts; return parent::compile(); }
/** * 编译成SQL语句 */ protected function compile() { $parts = array(); $parts['start'] = 'select'; $parts[self::COLUMNS] = $this->renderColumns(); $parts['from'] = 'from'; $parts[self::TABLE] = $this->renderTable(); $parts[self::JOINS] = $this->renderJoin(); $parts[self::INDEX] = $this->renderIndex(); $parts[self::WHERE] = $this->renderWhere(); $parts[self::UNION] = $this->renderUnion(); //一下不能在union子句中出现 $parts[self::ORDER] = $this->renderOrder(); $parts[self::GROUP] = $this->renderGroup(); $parts[self::LIMIT] = $this->renderLimit(); $parts[self::OFFSET] = $this->renderOffset(); $parts[self::FOR_UPDATE] = $this->renderForUpdate(); $parts[self::ENDS] = $this->ends; $this->parts =& $parts; return parent::compile(); }
/** * 编译成SQL语句 */ protected function compile() { if (!$this->duplicate) { $parts = array(); $parts['start'] = 'insert into'; $parts[self::TABLE] = $this->renderTable(); $parts[self::FIELDS] = $this->renderFields(); $parts['kvSep'] = 'values'; $parts[self::VALUES] = $this->renderValues(); $parts[self::ENDS] = $this->ends; $this->parts =& $parts; return parent::compile(); } else { //Duplicate key update return $this->compileDupValues(); } }
/** * 编译成SQL语句 */ protected function compile() { $parts = array(); $parts['start'] = 'update'; $parts[self::TABLE] = $this->renderTable(); $parts['setSep'] = 'set'; $parts[self::SETS] = $this->renderSets(); $parts[self::WHERE] = $this->renderWhere(); $parts[self::LIMIT] = $this->renderLimit(); $parts[self::ENDS] = $this->ends; $this->parts =& $parts; return parent::compile(); }