Zend Framework 2 和 Doctrine 2 - 多个数据库的配置 [英] Zend Framework 2 and Doctrine 2 - Configuration for multiple databases

问题描述

我将配置文件中的代码粘贴到

I pasted the code from the configuration.md file to

module.config.php

module.config.php

'doctrine' => array(
        'connection' => array(
            'orm_crawler' => array(
                'driverClass' => 'DoctrineDBALDriverPDOMySqlDriver',
                'params' => array(
                    'host'     => 'localhost',
                    'port'     => '3306',
                    'user'     => 'root',
                    'password' => 'root',
                    'dbname'   => 'crawler',
                    'driverOptions' => array(
                        1002 => 'SET NAMES utf8'
                    ),
                )
            )
        ),

        'configuration' => array(
            'orm_crawler' => array(
                'metadata_cache'    => 'array',
                'query_cache'       => 'array',
                'result_cache'      => 'array',
                'driver'            => 'orm_crawler',
                'generate_proxies'  => true,
                'proxy_dir'         => 'data/DoctrineORMModule/Proxy',
                'proxy_namespace'   => 'DoctrineORMModuleProxy',
                'filters'           => array()
            )
        ),

        'driver' => array(
            'Crawler_Driver' => array(
                'class' => 'DoctrineORMMappingDriverAnnotationDriver',
                'cache' => 'array',
                'paths' => array(
                    __DIR__ . '/../src/Crawler/Entity'
                )
            ),
            'orm_crawler' => array(
                'class'   => 'DoctrineORMMappingDriverDriverChain',
                'drivers' => array(
                    'CrawlerEntity' =>  'Crawler_Driver'
                )
            ),
        ),

        'entitymanager' => array(            
            'orm_crawler' => array(
                'connection'    => 'orm_crawler',
                'configuration' => 'orm_crawler'
            )
        ),

        'eventmanager' => array(
            'orm_crawler' => array()
        ),

        'sql_logger_collector' => array(
            'orm_crawler' => array(),
        ),

        'entity_resolver' => array(
            'orm_crawler' => array()
        ),

    ),

```

模块.php

public function getServiceConfig()
{
    return array(
        'factories' => array(
'doctrine.authenticationadapter.orm_crawler'  => new DoctrineModuleServiceAuthenticationAdapterFactory('orm_crawler'),
                'doctrine.authenticationstorage.orm_crawler'  => new DoctrineModuleServiceAuthenticationStorageFactory('orm_crawler'),
                'doctrine.authenticationservice.orm_crawler'  => new DoctrineModuleServiceAuthenticationAuthenticationServiceFactory('orm_crawler'),

                'doctrine.connection.orm_crawler'             => new DoctrineORMModuleServiceDBALConnectionFactory('orm_crawler'),
                'doctrine.configuration.orm_crawler'          => new DoctrineORMModuleServiceConfigurationFactory('orm_crawler'),
                'doctrine.entitymanager.orm_crawler'          => new DoctrineORMModuleServiceEntityManagerFactory('orm_crawler'),

                'doctrine.driver.orm_crawler'                 => new DoctrineModuleServiceDriverFactory('orm_crawler'),
                'doctrine.eventmanager.orm_crawler'           => new DoctrineModuleServiceEventManagerFactory('orm_crawler'),
                'doctrine.entity_resolver.orm_crawler'        => new DoctrineORMModuleServiceEntityResolverFactory('orm_crawler'),
                'doctrine.sql_logger_collector.orm_crawler'   => new DoctrineORMModuleServiceSQLLoggerCollectorFactory('orm_crawler'),
                'doctrine.mapping_collector.orm_crawler'      => function (endServiceManagerServiceLocatorInterface $sl) {
                    $em = $sl->get('doctrine.entitymanager.orm_crawler');

                    return new DoctrineORMModuleCollectorMappingCollector($em->getMetadataFactory(), 'orm_crawler_mappings');
                },
                'DoctrineORMModuleFormAnnotationAnnotationBuilder' => function(endServiceManagerServiceLocatorInterface $sl) {
                    return new DoctrineORMModuleFormAnnotationAnnotationBuilder($sl->get('doctrine.entitymanager.orm_crawler'));
                },
        ),
    );
}

我收到以下错误:

C:xamppvhostszf2-tradevendorzendframeworkzendframeworklibraryendServiceManagerServiceManager.php:529

留言:

ZendMvcControllerPluginManager::get was unable to fetch or create an instance for getServiceManager

我做错了什么?请帮忙.

What am I doing wrong? Please help.

问候马修

推荐答案

Mac，欢迎使用 stackoverflow！您不需要为每个连接分别定义自定义工厂.DoctrineORMModule 已经为我们处理了这项工作.

Mac, welcome to stackoverflow! You don't need to define custom factories for each connection respectively. DoctrineORMModule already handles this job for us.

当您需要实体管理器时，通过在别名中使用它们的名称从服务定位器实例中获取它，如下所示:

When you need the entity managers, get it from service locator instance by using their names in the alias like this:

$this->getServiceLocator()->get('doctrine.entitymanager.orm_default');

或

$this->getServiceLocator()->get('doctrine.entitymanager.orm_alternative');

我正在分享我当前应用程序的数据库配置之一，该配置当前同时使用 PostgreSQL 和 MySQL 连接.

I'm sharing one of my current application's database configuration which currently uses both PostgreSQL and MySQL connections.

<?php
return array(
    'doctrine' => array(
        'connection' => array(
            // Default DB connection
            'orm_default' => array(
                'driverClass' => 'DoctrineDBALDriverPDOPgSqlDriver',
                'params' => array(
                    'host' => '1.2.3.4',
                    'user' => 'pdbuser',
                    'port' => '5432',
                    'password' => '****',
                    'dbname' => 'mydb',
                    'driver' => 'pdo_pgsql',
                ),
            ),

            // Alternative DB connection
            'orm_alternative' => array(
                'driverClass' => 'DoctrineDBALDriverPDOMySqlDriver',
                'params' => array(
                    'host' => '4.5.6.7',
                    'user' => 'dbuser',
                    'port' => '3306',
                    'password' => '****',
                    'dbname' => 'mydb',
                    'driver' => 'pdo_mysql',
                ),
            ),
        ),

        // Entity Manager instantiation settings
        'entitymanager' => array(
            'orm_default' => array(
                'connection'    => 'orm_default',
                'configuration' => 'orm_default',
            ),
            'orm_alternative' => array(
                'connection'    => 'orm_alternative',
                'configuration' => 'orm_alternative',
            ),
        ),

        // Use array cache locally, also auto generate proxies on development environment.
        'configuration' => array(
            'orm_default' => array(
                'metadata_cache' => 'array',
                'query_cache' => 'array',
                'result_cache' => 'array',
                'hydration_cache' => 'array',
                'generate_proxies' => true,
            ),
            'orm_alternative' => array(
                'metadata_cache' => 'array',
                'query_cache' => 'array',
                'result_cache' => 'array',
                'hydration_cache' => 'array',
                'generate_proxies' => true,
            ),
        ),
    ),
);

您可以轻松地将此配置与您的配置合并.

You can easily merge this configuration with yours.

希望有帮助.

这篇关于Zend Framework 2 和 Doctrine 2 - 多个数据库的配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！