教义自定义数据类型

2022-01-16 00:00:00 orm mysql symfony doctrine dbal

我正在使用 Symfony2 开发应用程序.Symfony2 将 Doctrine 2 用于 DBAL 和 ORM.据我所知，Doctrine2 不支持 BLOB 数据类型.但是我想通过自定义数据类型映射来实现 BLOB 支持:

I'm developing application with Symfony2. Symfony2 is using Doctrine 2 for DBAL and ORM. As far as I know Doctrine2 doesn't have suport for BLOB data type. However I want to implement BLOB support through the custom data type mapping:

http://www.doctrine-project.org/docs/dbal/2.0/en/reference/types.html

但是我很难理解这部分应该去哪里.

However I'm struggling to understand where should this part go.

<?php
Type::addType('money', 'MyProjectTypesMoneyType');
$conn->getDatabasePlatform()->registerDoctrineTypeMapping('MyMoney', 'money');

有人经历过吗?

我需要 BLOB 类型的原因是我想从现有的 MySQL 数据库中导入映射.

The reason I need a BLOB type is that I want to import mapping from existing MySQL database.

推荐答案

另一种解决方案是在配置文件中注册您的自定义类型

Another solution would be to register your Custom Type in the config file

您只需将其添加到您的配置文件中:

You just need to add that in your config file:

# app/config/config.yml
doctrine:
    dbal:
        types:
            money:  MyProjectTypesMoneyType

您可以在此 Symfony 中找到有关如何注册自定义映射类型的更多信息食谱条目

相关文章