Question

我试图在历史遗留的MySql数据库上执行理论。如今,这名女巫非常好。但......

页: 1

CREATE TABLE `events` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  -- skipped ---
  `title` varchar(255) NOT NULL DEFAULT   ,
  `category` text,
)...

表格Categories, whitch有类别。结构类似......

CREATE TABLE `tx_tendsical_category` (
  ...
 `title` varchar(255) NOT NULL DEFAULT   ,
  ...
)

Now... Category IDS are stored as comma (,) separated values in events.category field. How can i setup relations without much hassle... I need hasMany etc...

Answer 1

如果你在数据库图象上存在问题,请写自己的水力器。如果你掌握所有数据,进行分类,并交还适当的物体收集。

Answer 2

I did it this way... Perhapse there is better way?

public function getCategories(){
    return Doctrine_Query::create()
        ->from("Category c")
        ->where("c.uid IN ?",array(explode(",",$this->category)))
        ->execute(array(),Doctrine_Core::HYDRATE_ON_DEMAND);
}

友情链接