vijinho / kohana2-legacy

     * @param   array   where clause

     * @return  string

     */

    public function update($table, $values, $where)

    {

        foreach ($values as $key => $val) {

            $valstr[] = $this->escape_column($key).' = '.$val;

        }

        return 'UPDATE '.$this->escape_table($table).' SET '.implode(', ', $valstr).' WHERE '.implode(' ', $where);

    }

    /**

     * Set the charset using 'SET NAMES <charset>'.

     * @param   array   values

     * @return  string

     */

    public function insert($table, $keys, $values)

    {

        // Escape the column names

        foreach ($keys as $key => $value) {

            $keys[$key] = $this->escape_column($value);

        }

        return 'INSERT INTO '.$this->escape_table($table).' ('.implode(', ', $keys).') VALUES ('.implode(', ', $values).')';

    }

    /**

     * Builds a MERGE portion of a query.

        return $prefix.' '.$this->escape_column($field).' NOT REGEXP \''.$this->escape_str($match) . '\'';

    }

    public function merge($table, $keys, $values)

    {

        // Escape the column names

        foreach ($keys as $key => $value) {

            $keys[$key] = $this->escape_column($value);

        }

        return 'REPLACE INTO '.$this->escape_table($table).' ('.implode(', ', $keys).') VALUES ('.implode(', ', $values).')';

    }

    public function limit($limit, $offset = 0)

    {