Dealing with ENUM with Symfony, Propel and Mysql

dbigbear

于 2008-03-17 05:58:00 发布

阅读量795

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库 Web开发文章标签： function class integer mysql table null

本文链接：https://blog.youkuaiyun.com/dbigbear/article/details/2190252

数据库同时被 2 个专栏收录

25 篇文章

订阅专栏

Web开发

13 篇文章

订阅专栏

本文介绍了一种在不使用MySQL特有枚举类型的情况下，在PHP中通过定义静态数组和方法来模拟枚举类型的方法。这种方法适用于希望保持数据一致性但又不想创建额外表存储枚举值的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Enum is mysql specific, so, you cannot have an enum in your schema.xml.

If you don't want to create another table to store the different 
possible values, you can simulate an enum very easily.

Imagine you have a status column in you article table you want to be an 
enum with values like ('open', 'closed'). Simply declare the status 
column as integer and then (not tested):

In your ArticlePeer.php class:

class ArticlePeer...
{
   static protected $STATUS_INTEGERS = array('open', 'closed');
   static protected $STATUS_VALUES = null;

   static public function getStatusFromIndex($index)
   {
     return self::$STATUS_INTEGERS[$index];
   }

   static public function getStatusFromValue($value)
   {
     if (!self::$STATUS_VALUES)
     {
       self::STATUS_VALUES = array_flip(self::$STATUS_INTEGERS);
     }

     $values = strtolower($value);

     if (!isset(self::STATUS_VALUES[$value])
     {
       throw new PropelException(sprintf('Status cannot take "%s" as a 
value', $value));
     }

     return self::STATUS_VALUES[strtolower($value)];
   }
}

In your Article.php class:

class Article
{
   public function setStatusName($value)
   {
     $this->setStatus(self::getStatusFromValue($value));
   }

   public function getStatusName()
   {
     return self::getStatusFromIndex($this->getStatus());
   }
}

Fabien