多态一对一关联

比如我们有一个用户表，一个团队表，他们和头像表相关联。

  1. mysql> desc tb_user;
  2. +----------+------------------+------+-----+---------+----------------+
  3. | Field    | Type             | Null | Key | Default | Extra          |
  4. +----------+------------------+------+-----+---------+----------------+
  5. | id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  6. | username | varchar(32)      | NO   |     | NULL    |                |
  7. | age      | tinyint(3)       | NO   |     | NULL    |                |
  8. +----------+------------------+------+-----+---------+----------------+
  10. mysql> desc tb_team;
  11. +-------+------------------+------+-----+---------+----------------+
  12. | Field | Type             | Null | Key | Default | Extra          |
  13. +-------+------------------+------+-----+---------+----------------+
  14. | id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  15. | name  | varchar(32)      | NO   |     | NULL    |                |
  16. +-------+------------------+------+-----+---------+----------------+
  18. mysql> desc tb_avatar;
  19. +-------------+------------------+------+-----+---------+----------------+
  20. | Field       | Type             | Null | Key | Default | Extra          |
  21. +-------------+------------------+------+-----+---------+----------------+
  22. | id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  23. | type        | tinyint(4)       | NO   | MUL | NULL    |                |
  24. | relation_id | int(10) unsigned | NO   |     | NULL    |                |
  25. | url         | varchar(255)     | NO   |     | NULL    |                |
  26. +-------------+------------------+------+-----+---------+----------------+

具体示例代码可以看imi-demo项目，下面仅为简单展示。

具体示例代码可以看imi-demo项目，下面仅为简单展示。

具体示例代码可以看imi-demo项目，下面仅为简单展示。

定义

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

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

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

User中id与Avatar中relation_id关联，并且type为1的才关联。

User 模型

  1. /**
  2.  * User
  3.  * @Entity
  4.  * @Table(name="tb_user", id={"id"})
  5.  * @property int $id
  6.  * @property string $username
  7.  * @property \ImiDemo\HttpDemo\MainServer\Model\UserEx $ex
  8.  * @property \Imi\Util\ArrayList $userRole
  9.  * @property \Imi\Util\ArrayList $role
  10.  * @property \ImiDemo\HttpDemo\MainServer\Model\Avatar $avatar
  11.  */
  12. class User extends Model
  13. {
  14.     /**
  15.      * 头像
  16.      * 
  17.      * @PolymorphicOneToOne(model=ImiDemo\HttpDemo\MainServer\Model\Avatar::class, type="type", typeValue=1)
  18.      * @JoinTo("relation_id")
  19.      * @AutoSave
  20.      * @AutoDelete
  21.      *
  22.      * @var \ImiDemo\HttpDemo\MainServer\Model\Avatar
  23.      */
  24.     protected $avatar;
  26.     /**
  27.      * Get 头像
  28.      *
  29.      * @return  \ImiDemo\HttpDemo\MainServer\Model\Avatar
  30.      */ 
  31.     public function getAvatar()
  32.     {
  33.         return $this->avatar;
  34.     }
  36.     /**
  37.      * Set 头像
  38.      *
  39.      * @param  \ImiDemo\HttpDemo\MainServer\Model\Avatar  $avatar  头像
  40.      *
  41.      * @return  self
  42.      */ 
  43.     public function setAvatar(\ImiDemo\HttpDemo\MainServer\Model\Avatar $avatar)
  44.     {
  45.         $this->avatar = $avatar;
  47.         return $this;
  48.     }
  50. }

@PolymorphicOneToOne注解中，type代表在Avatar模型中的字段名，typeValue代表匹配的值。

Avatar 模型

  1. /**
  2.  * Avatar
  3.  * @Entity
  4.  * @Table(name="tb_avatar", id={"id"})
  5.  * @property int $id
  6.  * @property int $type
  7.  * @property int $relationId
  8.  * @property string $url
  9.  */
  10. class Avatar 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.      * type
  42.      * @Column(name="type", type="tinyint", length=4, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  43.      * @var int
  44.      */
  45.     protected $type;
  47.     /**
  48.      * 获取 type
  49.      *
  50.      * @return int
  51.      */ 
  52.     public function getType()
  53.     {
  54.         return $this->type;
  55.     }
  57.     /**
  58.      * 赋值 type
  59.      * @param int $type type
  60.      * @return static
  61.      */ 
  62.     public function setType($type)
  63.     {
  64.         $this->type = $type;
  65.         return $this;
  66.     }
  68.     /**
  69.      * relation_id
  70.      * @Column(name="relation_id", type="int", length=10, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  71.      * @var int
  72.      */
  73.     protected $relationId;
  75.     /**
  76.      * 获取 relationId
  77.      *
  78.      * @return int
  79.      */ 
  80.     public function getRelationId()
  81.     {
  82.         return $this->relationId;
  83.     }
  85.     /**
  86.      * 赋值 relationId
  87.      * @param int $relationId relation_id
  88.      * @return static
  89.      */ 
  90.     public function setRelationId($relationId)
  91.     {
  92.         $this->relationId = $relationId;
  93.         return $this;
  94.     }
  96.     /**
  97.      * url
  98.      * @Column(name="url", type="varchar", length=255, accuracy=0, nullable=false, default="", isPrimaryKey=false, primaryKeyIndex=-1, isAutoIncrement=false)
  99.      * @var string
  100.      */
  101.     protected $url;
  103.     /**
  104.      * 获取 url
  105.      *
  106.      * @return string
  107.      */ 
  108.     public function getUrl()
  109.     {
  110.         return $this->url;
  111.     }
  113.     /**
  114.      * 赋值 url
  115.      * @param string $url url
  116.      * @return static
  117.      */ 
  118.     public function setUrl($url)
  119.     {
  120.         $this->url = $url;
  121.         return $this;
  122.     }
  124.     /**
  125.      * 对应用户
  126.      * 
  127.      * @PolymorphicToOne(model=ImiDemo\HttpDemo\MainServer\Model\User::class, modelField="id", type="type", typeValue=1, field="relation_id")
  128.      * @AutoSelect(false)
  129.      *
  130.      * @var \ImiDemo\HttpDemo\MainServer\Model\User
  131.      */
  132.     protected $user;
  134.     /**
  135.      * Get 对应用户
  136.      *
  137.      * @return  \ImiDemo\HttpDemo\MainServer\Model\User
  138.      */ 
  139.     public function getUser()
  140.     {
  141.         return $this->user;
  142.     }
  144.     /**
  145.      * Set 对应用户
  146.      *
  147.      * @param  \ImiDemo\HttpDemo\MainServer\Model\User  $user  对应用户
  148.      *
  149.      * @return  self
  150.      */ 
  151.     public function setUser(\ImiDemo\HttpDemo\MainServer\Model\User $user)
  152.     {
  153.         $this->user = $user;
  155.         return $this;
  156.     }
  158.     /**
  159.      * 对应用户
  160.      * 
  161.      * @PolymorphicToOne(model=ImiDemo\HttpDemo\MainServer\Model\Team::class, modelField="id", type="type", typeValue=2, field="relation_id")
  162.      * @AutoSelect(false)
  163.      *
  164.      * @var \ImiDemo\HttpDemo\MainServer\Model\Team
  165.      */
  166.     protected $team;
  168.     /**
  169.      * Get 对应用户
  170.      *
  171.      * @return  \ImiDemo\HttpDemo\MainServer\Model\Team
  172.      */ 
  173.     public function getTeam()
  174.     {
  175.         return $this->team;
  176.     }
  178.     /**
  179.      * Set 对应用户
  180.      *
  181.      * @param  \ImiDemo\HttpDemo\MainServer\Model\Team  $team  对应用户
  182.      *
  183.      * @return  self
  184.      */ 
  185.     public function setTeam(\ImiDemo\HttpDemo\MainServer\Model\Team $team)
  186.     {
  187.         $this->team = $team;
  189.         return $this;
  190.     }
  192.     /**
  193.      * 对应用户
  194.      * 
  195.      * @PolymorphicToOne(model=ImiDemo\HttpDemo\MainServer\Model\User::class, modelField="id", type="type", typeValue=1, field="relation_id")
  196.      * @PolymorphicToOne(model=ImiDemo\HttpDemo\MainServer\Model\Team::class, modelField="id", type="type", typeValue=2, field="relation_id")
  197.      * @AutoSelect(false)
  198.      *
  199.      * @var \ImiDemo\HttpDemo\MainServer\Model\User|\ImiDemo\HttpDemo\MainServer\Model\Team
  200.      */
  201.     protected $relationModel;
  203.     /**
  204.      * Get 对应用户
  205.      *
  206.      * @return  \ImiDemo\HttpDemo\MainServer\Model\User|\ImiDemo\HttpDemo\MainServer\Model\Team
  207.      */ 
  208.     public function getRelationModel()
  209.     {
  210.         return $this->relationModel;
  211.     }
  213.     /**
  214.      * Set 对应用户
  215.      *
  216.      * @param  \ImiDemo\HttpDemo\MainServer\Model\User|\ImiDemo\HttpDemo\MainServer\Model\Team  $relationModel  对应用户
  217.      *
  218.      * @return  self
  219.      */ 
  220.     public function setRelationModel($relationModel)
  221.     {
  222.         $this->relationModel = $relationModel;
  224.         return $this;
  225.     }
  226. }

Avatar 模型中，$user和$team是指定类型的关联，只能取到对应模型的数据。

$relationModel会根据当前模型的type值，查询出对应模型的数据，类型不固定。

查询

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

头像模型反查用户模型

智能类型查询

  1. $avatar = Avatar::find(1);
  2. $avatar->queryRelations('relationModel');
  3. $user = $avatar->relationModel;

指定类型查询

  1. $avatar = Avatar::find(1);
  2. $avatar->queryRelations('user');
  3. $user = $avatar->user;

同时查询多个

  1. $avatar = Avatar::find(1);
  2. $avatar->queryRelations('user', 'relationModel');
  3. $user1 = $avatar->user;
  4. $user2 = $avatar->relationModel;