For those of you who are willing to test/play with creepy Firebird PDO support scheme for Yii.
Scheme tested on Firebird 2.1.3 for Windows, using php 5.2.11, Yii 1.0.9.
All the stuff connected with named parameters binding in data changing queries (insert/update) is broken due to the Firebird PDO known bug. Nevertheless data reading features seems to work properly (just as far as I tested it) including AR.
Installation:
1. Unpack yiifb.0.01.zip into %YII%/framework/db/schema/
2. Register schema classes in %YII%/framework/YiiBase.php
After
'CMssqlTableSchema' => '/db/schema/mssql/CMssqlTableSchema.php',
add
'CFirebirdColumnSchema' => '/db/schema/firebird/CFirebirdColumnSchema.php',
'CFirebirdCommandBuilder' => '/db/schema/firebird/CFirebirdCommandBuilder.php',
'CFirebirdPdoAdapter' => '/db/schema/firebird/CFirebirdPdoAdapter.php',
'CFirebirdSchema' => '/db/schema/firebird/CFirebirdSchema.php',
'CFirebirdTableSchema' => '/db/schema/firebird/CFirebirdTableSchema.php',
3. Add the following lines into %YII%/framework/db/CDbConnection.php
After
$pdoClass='CMssqlPdoAdapter';
add
else if($driver==='firebird')
$pdoClass='CFirebirdPdoAdapter';
And after
return $this->_schema=new COciSchema($this);
add
case 'firebird': // Firebird/Interbase driver
return $this->_schema=new CFirebirdSchema($this);
4. DSN in your main.php should look somewhat similar to
'connectionString'=>'firebird:dbname=localhost:C:\Program Files\NetSchool\DB\MAIN30.GDB',
Good luck.