爱哪无忧又

1125 经验值

说明

由于客户要求项目必须使用PostgreSQL数据库,所以项目没有使用mysql数据库,使用laravel5.2开发由于项目是和第三方数据对接的,所以数据库表的id字段无法使用int自增,因此字段类型使用的是varchar(32)类型

问题

主键不是int类型,使用Eloquent ORM 查询数据一对多数据查询为空

表设计情况

一个学校拥有多个教师的情况:学校表


Schema::create('schools', function (Blueprint $table) {
    $table->string('id',32)->comment('学校id');
    $table->string('school_name')->comment('学校名称');
    $table->timestamps();
});

Model关系定义


<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class School extends Model
{
    protected $fillable = ['id','school_name'];
    public function teachers()
    {
        return $this->hasMany('App\Models\Teacher');
    }
}

教师表

Schema::create('teachers', function (Blueprint $table) {
    $table->string('id',32)->comment('教师id');
    $table->string('teacher_name')->comment('教师名称');
    $table->string('school_id',64)->nullable()->comment('学校id');
    $table->timestamps();
});

Model关系定义

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Teacher extends Model
{
    protected $fillable = ['id','teacher_name','school_id'];

    public function school()
    {
        return $this->belongsTo('App\Models\School');
    }
}

现有数据

pingjia=# select * from schools;

+---------------------+--------------+---------------------+---------------------+

| id                | school_name     | created_at    | updated_at          |

+---------------------+--------------+---------------------+---------------------+

| CNCSYS1600000000001 | 广州演示学校 | 2017-08-03 15:59:16 | 2017-08-09 18:16:38 |

| CNCSYS1600000000000 | 演示学校一   | 2017-08-03 11:22:17 | 2017-08-09 18:51:31 |

+---------------------+--------------+---------------------+---------------------+

2 rows in set

pingjia=# 

    
pingjia=# select * from teachers;
+---------------------+--------------+---------------------+---------------------+---------------------+
| id                  | teacher_name | school_id           | created_at          | updated_at          |
+---------------------+--------------+---------------------+---------------------+---------------------+
| CNCSYS1600000000000 | admin        | CNCSYS1600000000000 | 2017-08-03 11:24:12 | 2017-08-03 11:24:17 |
| CNCSYS1600000000001 | wk           | CNCSYS1600000000000 | 2017-08-03 11:50:27 | 2017-08-03 11:50:27 |
| CNCSYS1600000000003 | 教师01       | CNCSYS1600000000001 | 2017-08-03 16:13:21 | 2017-08-08 17:53:43 |
| CNCSYS1600000000020 | 张三         | CNCSYS1600000000000 | 2017-08-07 14:49:28 | 2017-08-07 14:49:28 |
| CNCSYS1600000000026 | 演示教师     | CNCSYS1600000000001 | 2017-08-08 17:57:35 | 2017-08-08 17:57:35 |
| CNCSYS1600000000002 | qingdao XXX  | CNCSYS1600000000000 | 2017-08-03 11:57:37 | 2017-08-08 12:05:34 |
| CNCSYS1600000000136 | 教师02       | CNCSYS1600000000000 | 2017-08-09 16:06:11 | 2017-08-09 16:06:11 |
| CNCSYS1600000000138 | 教师04       | CNCSYS1600000000000 | 2017-08-09 16:06:11 | 2017-08-09 16:06:11 |
| CNCSYS1600000000137 | 教师03       | CNCSYS1600000000000 | 2017-08-09 16:06:11 | 2017-08-09 16:06:11 |
| CNCSYS1600000000139 | 教师05       | CNCSYS1600000000000 | 2017-08-09 16:06:11 | 2017-08-09 16:06:11 |
| CNCSYS1600000000135 | 教师01       | CNCSYS1600000000000 | 2017-08-09 16:06:11 | 2017-08-09 16:06:11 |
+---------------------+--------------+---------------------+---------------------+---------------------+
11 rows in set

pingjia=# 


 进入tinker查询查看学校下所有教师数据查询不到

    >>> namespace App\Models;
    => null
    >>> School::find('CNCSYS1600000000001')->teachers()->get()
    => Illuminate\Database\Eloquent\Collection {#718
         all: [],
       }
    >>>

反之可以查到学校信息

    >>> Teacher::find('CNCSYS1600000000003')->school
    => App\Models\School {#725
         id: "CNCSYS1600000000001",
         school_name: "广州演示学校",
         created_at: "2017-08-03 15:59:16",
         updated_at: "2017-08-09 18:16:38",
       }
    >>>

请问大神们如何解决

学习了 为什么文章没有收藏功能

有视频源代码么?是否可以提供一下咯