QueryBuilder.php

Go to the documentation of this file.

<?php
namespace Xoops\Core\Database;

use Xoops\Core\Database\Connection;

class QueryBuilder extends \Doctrine\DBAL\Query\QueryBuilder
{

    public function deletePrefix($delete = null, $alias = null)
    {
        $delete = Connection::prefix($delete);
        return $this->delete($delete, $alias);
    }

    public function updatePrefix($update = null, $alias = null)
    {
        $update = Connection::prefix($update);
        return $this->update($update, $alias);
    }

    public function insertPrefix($insert = null)
    {
        $insert = Connection::prefix($insert);
        return $this->insert($insert);
    }

    public function fromPrefix($from, $alias = null)
    {
        $from = Connection::prefix($from);
        return $this->from($from, $alias);
    }

    public function joinPrefix($fromAlias, $join, $alias, $condition = null)
    {
        $join = Connection::prefix($join);
        return $this->join($fromAlias, $join, $alias, $condition);
    }


    public function innerJoinPrefix($fromAlias, $join, $alias, $condition = null)
    {
        $join = Connection::prefix($join);
        return $this->innerJoin($fromAlias, $join, $alias, $condition);
    }

    public function leftJoinPrefix($fromAlias, $join, $alias, $condition = null)
    {
        $join = Connection::prefix($join);
        return $this->leftJoin($fromAlias, $join, $alias, $condition);
    }

    public function rightJoinPrefix($fromAlias, $join, $alias, $condition = null)
    {
        $join = Connection::prefix($join);
        return $this->rightJoin($fromAlias, $join, $alias, $condition);
    }
}