php - 在 Symfony2 中创建数据库

Question

我继承了一个使用 MySQL 数据库的 Symfony 项目。我需要创建第二个数据库。我已经更改了.../htdocs/projectFolder/app/config/parameters.yml 以获得新的 dbName。

parameters:
    database_driver: pdo_mysql
    database_host: 127.0.0.1
    database_port: 8889
    database_name: inherited_db_name
    database_user: root
    database_password: root
    mailer_transport: smtp
    mailer_host: localhost
    mailer_user: null
    mailer_password: null
    locale: en
    secret: nosecret
    database_path: null

更改为:

parameters:
    database_driver: pdo_mysql
    database_host: 127.0.0.1 #can't use "localhost"
    database_port: 8889
    database_name: new_db_to_create
    database_user: root
    database_password: root
    mailer_transport: smtp
    mailer_host: localhost
    mailer_user: null
    mailer_password: null
    locale: en
    secret: nosecret
    database_path: null

除了命令，我已经尝试了所有我能想到的技巧:doctrine:database:create 一直在尝试创建“inherited_db_name”

如果我删除“inherited_db_name”数据库，然后使用新的 parameters.yml 再次运行命令，则会重新创建“inherited_db_name”。我搜索并搜索了“inherited_db_name”，但找不到它的来源。欢迎提出任何建议。

Answer 1

您应该配置您的 Symfony2 应用程序来管理这两个数据库。

因此您的parameters.yml 文件将如下所示:

parameters:
    database_driver: pdo_mysql
    database_host: 127.0.0.1
    database_port: 8889
    database_name: inherited_db_name
    database_user: root
    database_password: root
    database_driver2: pdo_mysql
    database_host2: 127.0.0.1 #can't use "localhost"
    database_port2: 8889
    database_name2: new_db_to_create
    database_user2: root
    database_password2: root
    mailer_transport: smtp
    mailer_host: localhost
    mailer_user: null
    mailer_password: null
    locale: en
    secret: nosecret
    database_path: null

现在你只需要正确配置 Doctrine:

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                driver:   "%database_driver%"
                host:     "%database_host%"
                port:     "%database_port%"
                dbname:   "%database_name%"
                user:     "%database_user%"
                password: "%database_password%"
                charset:  UTF8
            customer:
                driver:   "%database_driver2%"
                host:     "%database_host2%"
                port:     "%database_port2%"
                dbname:   "%database_name2%"
                user:     "%database_user2%"
                password: "%database_password2%"
                charset:  UTF8

    orm:
        default_entity_manager: default
        entity_managers:
            default:
                connection: default
                mappings:
                    AcmeDemoBundle:  ~
                    AcmeStoreBundle: ~
            customer:
                connection: customer
                mappings:
                    AcmeCustomerBundle: ~

请查看 Symfony2 食谱:http://symfony.com/doc/current/cookbook/doctrine/multiple_entity_managers.html