#5800: dbo_oracle driver : insertion statement missing
---------------------------------------+------------------------------------
Reporter: pluriels | Owner: phishy
Type: Bug | Status: new
Priority: Low | Milestone: 1.2.x.x
Component: Oracle | Version: RC2
Severity: Normal | Resolution:
Keywords: oracle, driver, insert | Php_version: PHP 5
Cake_version: |
---------------------------------------+------------------------------------
Comment (by jaydipdave):
Hi Pluriels,
As per new nightmare release on 25th November, 2008.
I don't think we require "renderStatement" function in dbo_oracle.php.
We are already having the same function in dbo_source.php.
{{{
function renderStatement($type, $data) {
extract($data);
$aliases = null;
switch (strtolower($type)) {
case 'select':
return "SELECT {$fields} FROM {$table}
{$alias} {$joins} {$conditions} {$group} {$order} {$limit}";
break;
case 'create':
return "INSERT INTO {$table} ({$fields})
VALUES ({$values})";
break;
case 'update':
if (!empty($alias)) {
$aliases = "{$this->alias}{$alias}
{$joins} ";
}
return "UPDATE {$table} {$aliases}SET
{$fields} {$conditions}";
break;
case 'delete':
if (!empty($alias)) {
$aliases = "{$this->alias}{$alias}
{$joins} ";
}
return "DELETE {$alias} FROM {$table}
{$aliases}{$conditions}";
break;
case 'schema':
foreach (array('columns', 'indexes') as
$var) {
if (is_array(${$var})) {
${$var} = "\t" .
join(",\n\t", array_filter(${$var}));
}
}
if (trim($indexes) != '') {
$columns .= ',';
}
return "CREATE TABLE {$table}
(\n{$columns}{$indexes});";
break;
case 'alter':
break;
}
}
}}}
I was facing the same problem, I commented out the dbo_oracle.php's
renderStatement and the application started working.
CackePHP with oracle is bit buggy, but we all will solve it out.
Thank You,
Jaydeep Dave
--
Ticket URL: <https://trac.cakephp.org/ticket/5800#comment:1>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
