[fw-general] Re: Zend_Config_Xml and PDO::MYSQL_ATTR_INIT_COMMAND

[Christoph Löffler]

Hi,

i found the conversation
http://n4.nabble.com/Zend-Config-Xml-and-PDO-MYSQL-ATTR-INIT-COMMAND-tp656930p656930.htmlin
this mailing list.

We have a similar problem here:

We use XML Config an want to set db options as described in the manual in
Example 15.6: *Passing the Auto-Quoting Option to the Factory*

$options = array(
    Zend_Db::AUTO_QUOTE_IDENTIFIERS => false
);

$params = array(
    'host'           => '127.0.0.1',
    'username'       => 'webuser',
    'password'       => 'xxxxxxxx',
    'dbname'         => 'test',
    'options'        => $options
);

$db = Zend_Db::factory('Pdo_Mysql', $params);

But how can this be done in Config_Xml?

First try with

    <databases>
      <default>
        <adapter>Pdo_Ibm</adapter>
        <params>
          <host>hostname</host>
          <port>12345</port>
          <dbname>dbname</dbname>
          <username>dbuser</username>
          <password>******</password>
          <options>

<Zend_Db::AUTO_QUOTE_IDENTIFIERS>false</Zend_Db::AUTO_QUOTE_IDENTIFIERS>
          </options>
        </params>
      </default>
    </databases>

does not work, as already mentioned.

I looked in the code and found, that the static constant has the value
'autoQuoteIdentifiers', so i tried

          <options>
            <autoQuoteIdentifiers>false</autoQuoteIdentifiers>
          </options>

which worked!

Is this ok or would you propose another approach?

I think of the 'adapterNamespace' key in the parameters array and specifing
Zend_Db::AUTO_QUOTE_IDENTIFIERS in my class.

Puzzling over it...
Greetings
Chris