protected function buildQuery() { if (!isset($this->statements['SELECT']) || !$this->statements['SELECT']) { $this->statements['SELECT'][] = $this->fromAlias . '.*'; } return parent::buildQuery(); }
/** Execute DELETE query * @return boolean */ public function execute() { $result = parent::execute(); if ($result) { return $result->rowCount(); } return false; }
public function parse() { $this->sql = "DELETE "; $this->sql .= $this->parseFrom()->from; //WHERE $this->sql = $this->concatValues($this->sql, $this->parseWhere()->where); parent::parse(); return $this->sql; }
/** * Execute update query * * @param boolean $getResultAsPdoStatement true to return the pdo statement instead of row count * * @return int|boolean|\PDOStatement */ public function execute($getResultAsPdoStatement = false) { $result = parent::execute(); if ($getResultAsPdoStatement) { return $result; } if ($result) { return $result->rowCount(); } return false; }
function __construct(FluentPDO $fpdo, $from) { $clauses = array('SELECT' => ', ', 'FROM' => null, 'JOIN' => array($this, 'getClauseJoin'), 'WHERE' => ' AND ', 'GROUP BY' => ',', 'HAVING' => ' AND ', 'ORDER BY' => ', ', 'LIMIT' => null, 'OFFSET' => null, "\n--" => "\n--"); parent::__construct($fpdo, $clauses); # initialize statements $fromParts = explode(' ', $from); $this->fromTable = reset($fromParts); $this->fromAlias = end($fromParts); $this->statements['FROM'] = $from; $this->statements['SELECT'][] = $this->fromAlias . '.*'; $this->joins[] = $this->fromAlias; }