Transform column names into camelCase?

troxy · #1 (**permalink**) 10-15-2007, 12:02 AM

I'm working on a project where the column names are in uppercase, with words separated by underscores.
Is there any built in option in Zend_Db to automagically have these column names transformed into camelCase when you fetch stuff?
For instance, if I'm fetching an object it would be nice to have $obj->userId instead of $obj->USER_ID.
Edit: And by the way, I'm using the Pdo_Mssql driver.

Best Regards,
Troxy

troxy · #2 (**permalink**) 11-05-2007, 11:05 PM

Okay, so you have to extend the Zend_Db_Table and Zend_Db_Table_Row.
The extended table class might look like this:

PHP Code:


			
class MyTable extends Zend_Db_Table_Abstract {

    protected $_name = 'TABLE_NAME';

    protected $_primary = 'ID';

    protected $_rowClass = 'MyTable_Row'; // Tell it to use your custom extended row class

}

And in the extended row class is where the magic occurs:

PHP Code:


			
<?php

class MyTable_Row extends Zend_Db_Table_Row_Abstract {



    protected function _transformColumn($columnName) {

        if (!is_string($columnName)) {

            require_once 'Zend/Db/Table/Row/Exception.php';

            throw new Zend_Db_Table_Row_Exception('Specified column is not a string');

        }

        return strtoupper(preg_replace('/(?<=\\w)([A-Z])/', '_\\1', $columnName)); // Transform the camelCase into UPPER_CASE

    }

}

And then you can simply use it like this

PHP Code:


			
$table = new MyTable();

$result = $table->find(10);

$row = $result->current();

$value = $row->fooBar; // The actual name in the table is FOO_BAR

mehaase · #3 (**permalink**) 10-20-2008, 11:04 PM

Quote:

Originally Posted by troxy

I'm working on a project where the column names are in uppercase, with words separated by underscores.
Is there any built in option in Zend_Db to automagically have these column names transformed into camelCase when you fetch stuff?
For instance, if I'm fetching an object it would be nice to have $obj->userId instead of $obj->USER_ID.
Edit: And by the way, I'm using the Pdo_Mssql driver.

Best Regards,
Troxy

I like this solution.. I just found this thread on google and I want to know what the general solution is for this problem?

The schema is defined using lower_case_underscore format, and the ZF standard is to use lowerCamelCase. Do we really have to resort to a hack like this? It's a nice hack, and I think we'll probably use it for my project, but I'm wondering if there's anything else out there.

jweber · #4 (**permalink**) 10-21-2008, 08:28 PM

I don't consider this solution a "hack".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode