zeta components db handler with ini settings

Wednesday 30 March 2011 7:58:56 am

Hi,

I'm willing to use to use the db schema zeta component which seems far more powerful than the Exponential one but Exponential db interface is not compatible.

I'm wondering if Exponential API makes it possible to instantiate a ezcDBHandler using DatabaseSettings defined in site.ini. Has anyone tried that before ?

Thursday 31 March 2011 12:24:00 am

Hi Nicolas, thanks for your reply.

The thing is I'm developing an upgrade script which is totally unrelated to eZ's execution so I wouldn't mind using a totally different API. My need is more of a ezcDbFactory wrapper loading site.ini's DatabaseSettings block and calling the component's factory but I gather nothing exists at the time.

I guess I'll have to make one. Any pit traps I should beware when it comes to db instantiation ?

Thursday 31 March 2011 2:32:33 am

Hi Benjamin, Gaetano,

Here is an initialization stub, easily embeddable in a dedicated method :

public static function initializeEzcPersistentSession()
    {
        if ( !self::$initialized )
        {
            // @FIXME : make this code DBMS-agnostic
            $dbURI = "mysql://";
            $dbURI .= eZINI::instance()->variable( 'DatabaseSettings', 'User' );
            $dbURI .= ':' . eZINI::instance()->variable( 'DatabaseSettings', 'Password' );
            $dbURI .= '@' . eZINI::instance()->variable( 'DatabaseSettings', 'Server' );
            $dbURI .= '/' . eZINI::instance()->variable( 'DatabaseSettings', 'Database' );

            ezcDbInstance::set( ezcDbFactory::create( $dbURI ) );
            $session = new ezcPersistentSession( ezcDbInstance::get(),
                                                 new ezcPersistentCacheManager( new ezcPersistentCodeManager( "extension/ezforumtools/classes/po/" ) ) );
            ezcPersistentSessionInstance::set( $session ); // set default session
            self::$initialized = true;
        }
        return ezcPersistentSessionInstance::get();
    }

and here is a usage stub :

$session = eZForumTools::initializeEzcPersistentSession();
$q = $session->createFindQuery( 'eZForumModeratedEntry' );
$q->where( $q->expr->eq( 'contentObjectId', $q->bindValue( $objectId ) ) );
return $session->find( $q, 'eZForumModeratedEntry' );

These are stubs, to be wrapped in lazy initialization ideally,
Hope it helps,
Cheers,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye