Hello Everybody!

I'm really happy of seing Zend_Framework 1.5 up!
I'm developing a (not so) little project for a little publishing house, and I choose Zend_Framework 1.5 when it was yet RC1... (being a bit afraid for it's stability).
Now it's stable, I'm far more happy of my choose!

Going to my request, I'm developing on a DBMS which doesn't support schema definition (aka MySQL).
But, for many reasons, I need a system which could work in PostgreSQL too, by simply changing the adapter.
Moreover I NEED to use the schema abstraction (mainly for keep clean namespaces).

Now to simulate the schema in MySQL I thought to patch the Zend_Db_Adapter_Abstract by adding a protected attribute called Zend_Db_Adapter_Abstract::$schemaSeparator (default to ‘.’) and a public method Zend_Db_Adapter_Abstract::getSchemaSeparator()

Then to modify the methods

to use $this->_db->getSchemaSeparator() instead of ‘.’

This way, you could extend the adapter you want, and by setting the $schemaSeparator attribute (say with '__') all the rest will work with tables named as schema__table1 schema__table2 and so on...

I know I could simply extends all those objects, but since this is a patch which could be useful to others (and seem to not have backward compatibility issue), I prefer to contribute the framework.
(also becouse I'm lazy, and don't want to monitor the Zend_Db module for such a patch submitted for someone else).

Btw, I don’t know how to submit this patch (as you can see, quite easy to write).

Obviously it’s not the same of having a real schema DBMS, but some time this could help.


Can you help me?
Have you some suggestions?


Thank you all!


Shamar

Here I write a patch for this: http://dev.tesio.it/patch.Zend_Db

Some one could tell me how to contribute?
Some one could send the patch for me? I don't need the glory... ;-)


Shamar

You can learn how to contribute this back on this page: Zend Framework: Community

__________________
- xentek

Thanks xentek!

I created this issue attaching the patch: [#ZF-2921] Allow defining of the schema separator in Zend_Db_Adapter - Zend Framework Issue Tracker

I've also sent the Individual CLA signed.

Do you know what I've to do now?


Shamar

I think you wait . I believe you can email cla@zend.com to find out if your CLA was accepted, etc.

Keep checking back on the issue you filed to see if a conversation picks up around it. You may need to convince people of why you think the patch should go into core.

__________________
- xentek