多态一对多关联

比如我们有一张文章表，一张书籍表，一张评论表。文章和书籍的评论记录都在同一张评论表中。

  1. mysql> desc tb_article;
  2. +---------+------------------+------+-----+---------+----------------+
  3. | Field   | Type             | Null | Key | Default | Extra          |
  4. +---------+------------------+------+-----+---------+----------------+
  5. | id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  6. | title   | varchar(32)      | NO   |     | NULL    |                |
  7. | content | text             | NO   |     | NULL    |                |
  8. +---------+------------------+------+-----+---------+----------------+
  10. mysql> desc tb_book;
  11. +-------+------------------+------+-----+---------+----------------+
  12. | Field | Type             | Null | Key | Default | Extra          |
  13. +-------+------------------+------+-----+---------+----------------+
  14. | id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  15. | title | varchar(32)      | NO   |     | NULL    |                |
  16. +-------+------------------+------+-----+---------+----------------+
  18. mysql> desc tb_comment;
  19. +-------------+------------------+------+-----+---------+----------------+
  20. | Field       | Type             | Null | Key | Default | Extra          |
  21. +-------------+------------------+------+-----+---------+----------------+
  22. | id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  23. | content     | text             | NO   |     | NULL    |                |
  24. | type        | tinyint(4)       | NO   |     | NULL    |                |
  25. | relation_id | int(10) unsigned | NO   |     | NULL    |                |
  26. +-------------+------------------+------+-----+---------+----------------+

定义

一对多关联会用到的注解：

@PolymorphicOneToMany、@PolymorphicToOne、@JoinFrom、@JoinTo、@AutoSelect、@AutoInsert、@AutoUpdate、@AutoSave、@AutoDelete

如 imi-demo 中代码所示，Article定义了一个$comments属性，这个属性关联Comment模型。

Article中id与Comment中relation_id关联，并且type为1的才关联。

Article 模型

  1. /**
  2.  * Article
  3.  * @Entity
  4.  * @Table(name="tb_article", id={"id"})
  5.  * @property int $id
  6.  * @property string $title
  7.  * @property string $content
  8.  * @property \Imi\Util\ArrayList $comments
  9.  * @property \Imi\Util\ArrayList $taggables
  10.  * @property \Imi\Util\ArrayList $tags
  11.  */
  12. class Article extends Model
  13. {
  14.     /**
  15.      * id
  16.      * @Column(name="id", type="int", length=10, accuracy=0, nullable=false, default="", isPrimaryKey=true, primaryKeyIndex=0, isAutoIncrement=true)
  17.      * @var int
  18.      */
  19.     protected $id;
  21.     /**
  22.      * 获取 id
  23.      *
  24.      * @return int
  25.      */ 
  26.     public function getId()
  27.     {
  28.         return $this->id;
  29.     }
  31.     /**
  32.      * 赋值 id
  33.      * @param int $id id
  34.      * @return static
  35.      */ 
  36.     public function setId($id)
  37.     {
  38.         $this->id = $id;
  39.         return $this;
  40.     }
  42.     /**
  43.      * title
  44.      * @Column(name="title", type="varchar", length=32, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  45.      * @var string
  46.      */
  47.     protected $title;
  49.     /**
  50.      * 获取 title
  51.      *
  52.      * @return string
  53.      */ 
  54.     public function getTitle()
  55.     {
  56.         return $this->title;
  57.     }
  59.     /**
  60.      * 赋值 title
  61.      * @param string $title title
  62.      * @return static
  63.      */ 
  64.     public function setTitle($title)
  65.     {
  66.         $this->title = $title;
  67.         return $this;
  68.     }
  70.     /**
  71.      * content
  72.      * @Column(name="content", type="text", length=0, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  73.      * @var string
  74.      */
  75.     protected $content;
  77.     /**
  78.      * 获取 content
  79.      *
  80.      * @return string
  81.      */ 
  82.     public function getContent()
  83.     {
  84.         return $this->content;
  85.     }
  87.     /**
  88.      * 赋值 content
  89.      * @param string $content content
  90.      * @return static
  91.      */ 
  92.     public function setContent($content)
  93.     {
  94.         $this->content = $content;
  95.         return $this;
  96.     }
  98.     /**
  99.      * 评论
  100.      * 
  101.      * @PolymorphicOneToMany(model=ImiDemo\HttpDemo\MainServer\Model\Comment::class, type="type", typeValue=1)
  102.      * @JoinTo("relation_id")
  103.      * @AutoSave(orphanRemoval=true)
  104.      * @AutoDelete
  105.      *
  106.      * @var \Imi\Util\ArrayList
  107.      */
  108.     protected $comments;
  110.     /**
  111.      * Get 评论
  112.      *
  113.      * @return  \ImiDemo\HttpDemo\MainServer\Model\Comment[]
  114.      */ 
  115.     public function getComments()
  116.     {
  117.         return $this->comments;
  118.     }
  120.     /**
  121.      * Set 评论
  122.      *
  123.      * @param  \ImiDemo\HttpDemo\MainServer\Model\Comment[]  $comments  评论
  124.      *
  125.      * @return  self
  126.      */ 
  127.     public function setComments($comments)
  128.     {
  129.         $this->comments = $comments;
  131.         return $this;
  132.     }
  134. }

主要参考$comments上的注解，与多态一对多一样。

Comment 模型

  1. /**
  2.  * Comment
  3.  * @Entity
  4.  * @Table(name="tb_comment", id={"id"})
  5.  * @property int $id
  6.  * @property string $content
  7.  * @property int $type
  8.  * @property int $relationId
  9.  */
  10. class Comment extends Model
  11. {
  12.     /**
  13.      * id
  14.      * @Column(name="id", type="int", length=10, accuracy=0, nullable=false, default="", isPrimaryKey=true, primaryKeyIndex=0, isAutoIncrement=true)
  15.      * @var int
  16.      */
  17.     protected $id;
  19.     /**
  20.      * 获取 id
  21.      *
  22.      * @return int
  23.      */ 
  24.     public function getId()
  25.     {
  26.         return $this->id;
  27.     }
  29.     /**
  30.      * 赋值 id
  31.      * @param int $id id
  32.      * @return static
  33.      */ 
  34.     public function setId($id)
  35.     {
  36.         $this->id = $id;
  37.         return $this;
  38.     }
  40.     /**
  41.      * content
  42.      * @Column(name="content", type="text", length=0, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  43.      * @var string
  44.      */
  45.     protected $content;
  47.     /**
  48.      * 获取 content
  49.      *
  50.      * @return string
  51.      */ 
  52.     public function getContent()
  53.     {
  54.         return $this->content;
  55.     }
  57.     /**
  58.      * 赋值 content
  59.      * @param string $content content
  60.      * @return static
  61.      */ 
  62.     public function setContent($content)
  63.     {
  64.         $this->content = $content;
  65.         return $this;
  66.     }
  68.     /**
  69.      * type
  70.      * @Column(name="type", type="tinyint", length=4, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  71.      * @var int
  72.      */
  73.     protected $type;
  75.     /**
  76.      * 获取 type
  77.      *
  78.      * @return int
  79.      */ 
  80.     public function getType()
  81.     {
  82.         return $this->type;
  83.     }
  85.     /**
  86.      * 赋值 type
  87.      * @param int $type type
  88.      * @return static
  89.      */ 
  90.     public function setType($type)
  91.     {
  92.         $this->type = $type;
  93.         return $this;
  94.     }
  96.     /**
  97.      * relation_id
  98.      * @Column(name="relation_id", type="int", length=10, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  99.      * @var int
  100.      */
  101.     protected $relationId;
  103.     /**
  104.      * 获取 relationId
  105.      *
  106.      * @return int
  107.      */ 
  108.     public function getRelationId()
  109.     {
  110.         return $this->relationId;
  111.     }
  113.     /**
  114.      * 赋值 relationId
  115.      * @param int $relationId relation_id
  116.      * @return static
  117.      */ 
  118.     public function setRelationId($relationId)
  119.     {
  120.         $this->relationId = $relationId;
  121.         return $this;
  122.     }
  124. }

查询

常见的增删改查就不写了，和一对多关联一样用法

评论模型反查文章模型

注解及用法与一对一相同