在 Yii2 中使用 Gii 从数据库视图创建 CRUD

Create a CRUD from a database view using Gii in Yii2(在 Yii2 中使用 Gii 从数据库视图创建 CRUD)

问题描述

我使用 mariadb 视图的 gii 生成了一个模型，该模型有效.

I have generated a Model using gii of a mariadb view, which worked.

然后尝试对模型使用 gii CRUD 生成器，我收到错误

Then trying use the gii CRUD generator for the model, I get the error

The table associated with appmodelsFuture must have primary key(s).

这是完全可以理解的，因为视图没有 PK.我发现了一些建议，说要向模型添加一个主键函数，所以我尝试了

Which is perfectly understandable as the the view does not have a PK. I found some advice that says to add a primaryKey function to the model so I tried

public function primaryKey()
{
    return 'id';
}

id 是列名，它实际上是基础表中的 PK，它是视图的一部分.但这失败了，但有一个例外

With id being the column name which is actually the PK in the underlying table, which is part of the view. But this fails with an exception

Cannot make static method yiidbActiveRecord::primaryKey() non static in class appmodelsFuture

所以我尝试将方法设为静态，但它会引发新的异常

So I tried making the method static but it then throws new exception

Undefined index: i
1. in /home/adrian/projects/mtview/mtview/vendor/yiisoft/yii2-gii/generators/crud/Generator.php at line 509

有没有办法解决这个问题，或者现在无法使用 gii 为数据库视图生成代码?

Is there a way around this, or is it now impossible to use gii to generate code for Database views?

推荐答案

简单地添加到您的模型类

Simple add to your Model class

 public static function primaryKey()
{
    return ['id'];
}

这篇关于在 Yii2 中使用 Gii 从数据库视图创建 CRUD的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！