Yii2+ElasticSearch增删改查实现

最新推荐文章于 2024-04-19 09:54:47 发布
最新推荐文章于 2024-04-19 09:54:47 发布
阅读量647 收藏
点赞数
分类专栏： Elasticsearch Yii Mysql 文章标签： elasticsearch yii mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiadiganhuo/article/details/116204295
版权
Yii 同时被 3 个专栏收录
5 篇文章 0 订阅
订阅专栏
Elasticsearch
2 篇文章 0 订阅
订阅专栏
Mysql
2 篇文章 0 订阅
订阅专栏

构建该model之前需要自行配置yii2-elasticsearch组件安装
我是通过composer安装的
在composer.json中
在这里插入图片描述
安装完成之后
在这里插入图片描述
然后需要在yii的配置文件中加入小组件相关配置
在这里插入图片描述

接下来就是构建业务模型
集成的ActiveRecord类应该为组件目录下的AR类

use yii\elasticsearch\ActiveRecord

这个AR了重写了yii2的AR类部分方法，有些查询需要原生es语句才可以。
Model:

class HospitalEsModel extends ActiveRecord
{
    /**
     * 数据库
     */
    public static function getDb()
    {
        return \Yii::$app->get('elasticsearch');
    }

    /**
     * 索引
     */
    public static function index()
    {
        return 'hospital';
    }

    /**
     * 设置索引别名
     */
    public static function alias()
    {
        return 'hospital_new';
    }

    /**
     * 类型
     */
    public static function type()
    {
        return '_doc';
    }

    /**
     * 返回字段
     */
    public function attributes()
    {
        $mapConfig = self::mapConfig();
        return array_keys($mapConfig['properties']);
    }

    /**
     * 映射配置
     */
    public static function mapConfig()
    {
        return [
            'properties' => [
                'id'                     => ['type' => 'integer'],  //医院id
                'province_id'            => ['type' => 'integer'], //省份ID
                'province_name'          => ['type' => 'keyword'], //省份名称
                'city_id'                => ['type' => 'integer'], //城市ID
                'city_name'              => ['type' => 'keyword'], //城市名称
                'district_id'            => ['type' => 'integer'], //区县ID
                'district_name'          => ['type' => 'keyword'],//区县名称
                'name'                   => ['type' => 'text', 'analyzer' => "ik_max_word"], //医院名称
                'nick_name'              => ['type' => 'text', 'analyzer' => "ik_max_word"], //医院别名
                'phone'                  => ['type' => 'keyword'], //医院电话
                'address'                => ['type' => 'text', 'analyzer' => "ik_max_word"], //医院地址
                'site'                   => ['type' => 'keyword'], //医院网址
                'mail_num'               => ['type' => 'keyword'], //邮编
                'fax_num'                => ['type' => 'keyword'], //传真
                'email'                  => ['type' => 'keyword'], //邮箱
                'routes'                 => ['type' => 'text', 'analyzer' => "ik_max_word"], //路线
                'level'                  => ['type' => 'keyword'], //医院等级文本
                'insurance'              => ['type' => 'keyword'], //是否保险
                'type'                   => ['type' => 'keyword'], //类型：综合、专科
                'kind'                   => ['type' => 'keyword'], //性质：公立、私立
                'tsks'                   => ['type' => 'text', 'analyzer' => "ik_max_word"],  //特色
                'photo'                  => ['type' => 'keyword'], //头图
                'photo_list'             => ['type' => 'text'], //图片列表
                'description'            => ['type' => 'text', 'analyzer' => "ik_max_word"], //简介
                'city_uri'               => ['type' => 'keyword'],//城市URI
                'page_uri'               => ['type' => 'keyword'], //页面URI
                'url'                    => ['type' => 'keyword'], //医院网址
                'is_shequ'               => ['type' => 'integer'], //是否是社区服务站
                'insurance_num'          => ['type' => 'keyword'], //医保编码
                'display_order'          => ['type' => 'integer'], //显示顺序
                'status'                 => ['type' => 'byte'],   //状态, 0正常, 1未审核
                'level_num'              => ['type' => 'integer'], //医院等级对应数字
                'store_id'               => ['type' => 'integer'], //药店ID
                'score'                  => ['type' => 'integer'], //综合评分
                'source'                 => ['type' => 'keyword'], //来源
                'fudan_score'            => ['type' => 'integer'], //复旦大学医院综合评分
            ]
        ];
    }

    /**
     * 设置映射
     */
    public static function mapping()
    {
        return self::mapConfig();
    }

    /**
     * 获取映射
     */
    public static function getMapping()
    {
        $db = self::getDb();
        $command = $db->createCommand();
        return $command->getMapping(static::index());
    }

    /**
     * 更新映射
     */
    public static function updateMapping()
    {
        $db = self::getDb();
        $command = $db->createCommand();
        if (!$command->indexExists(self::index() . '_' . date('d'))) {
            return $command->createIndex(self::index() . '_' . date('d'), [
                'mappings' => static::mapping(),
            ]);
        }else{
            return $command->setMapping(self::index() . '_' . date('d'), '', self::mapping());
        }
    }

    /**
     * 更新别名指向
     */
    public static function updateAlias()
    {
        $db = self::getDb();
        $command = $db->createCommand();
        $alias = $command->getAliasInfo();
        $currentIndex = key($alias);

        $result = $command->addAlias(self::index() . '_' . date('d'), self::alias());
        if ($currentIndex) {
            $result = $command->removeAlias($currentIndex, self::alias());
        }
        return $result;
    }

    /**
     * 创建索引
     */
    public static function createIndex()
    {
        $db = static::getDb();
        $command = $db->createCommand();
        $result = $command->createIndex(static::index(), [
            'mappings' => static::mapping(),
        ]);

        return $result;
    }

    /**
     * 删除索引
     */
    public static function deleteIndex()
    {
        $db = static::getDb();
        $command = $db->createCommand();
        $result = $command->deleteIndex(static::index());
        return $result;
    }

    /**
     * 获取医院详情
     */
    public function getDetail($hospital_id, $fields = [])
    {
        if (!empty($fields)) {
            return self::find()->select($fields)->where(['id' => $hospital_id])->asArray()->one();
        }
        return self::find()->where(['id' => $hospital_id])->asArray()->one();
    }


    /**
     * 获取医院等级数据
     */
    private function getHospitalLevel($level_id)
    {
        $level_base = json_decode(\Yii::$app->redis->get('yuanxin:base:data:sundry'), true);
        if (empty($level_base) || !is_array($level_base)) {
            return '';
        }
        return isset($level_base[1][$level_id]) ? $level_base[1][$level_id] : '';
    }

    /**
     * 根据医生ID将医生数据插入ES中
     */
    public function insertToEs($hospital_id)
    {
        $hospitalInfo = DoctorHospitals::find()->where(['id' => $hospital_id])->asArray()->one();


        if (!empty($hospitalInfo)) {
            //医院等级文本
            $hospital_level_text = $this->getHospitalLevel($hospitalInfo['level_num']);

            try {
                $hospitalEsModel = new self();
                $hospitalEsModel->setPrimaryKey($hospitalInfo['id']);
                $hospitalEsModel->setAttribute('id', $hospital_id);
                $hospitalEsModel->setAttribute('province_id', trim($hospitalInfo['province_id']));
                $hospitalEsModel->setAttribute('province_name', $this->filterText($hospitalInfo['province_name']));
                $hospitalEsModel->setAttribute('city_id', trim($hospitalInfo['city_id']));
                $hospitalEsModel->setAttribute('city_name', $this->filterText($hospitalInfo['city_name']));
                $hospitalEsModel->setAttribute('district_id', $hospitalInfo['district_id']);
                $hospitalEsModel->setAttribute('district_name', $this->filterText($hospitalInfo['district_name']));
                $hospitalEsModel->setAttribute('name', $this->filterText($hospitalInfo['name']));
                $hospitalEsModel->setAttribute('nick_name', $this->filterText($hospitalInfo['nick_name']));
                $hospitalEsModel->setAttribute('phone', $this->filterText($hospitalInfo['phone']));
                $hospitalEsModel->setAttribute('address', $this->filterText($hospitalInfo['address']));
                $hospitalEsModel->setAttribute('site', $this->filterText($hospitalInfo['site']));
                $hospitalEsModel->setAttribute('mail_num', $this->filterText($hospitalInfo['mail_num']));
                $hospitalEsModel->setAttribute('fax_num', $this->filterText($hospitalInfo['fax_num']));
                $hospitalEsModel->setAttribute('email', $this->filterText($hospitalInfo['email']));
                $hospitalEsModel->setAttribute('routes', $this->filterText($hospitalInfo['routes']));
                $hospitalEsModel->setAttribute('level', $this->filterText($hospital_level_text));
                $hospitalEsModel->setAttribute('insurance', $this->filterText($hospitalInfo['insurance']));
                $hospitalEsModel->setAttribute('type', $this->filterText($hospitalInfo['type']));
                $hospitalEsModel->setAttribute('kind', $this->filterText($hospitalInfo['kind']));
                $hospitalEsModel->setAttribute('tsks', $this->filterText($hospitalInfo['tsks']));
                $hospitalEsModel->setAttribute('photo', $this->filterText($hospitalInfo['photo']));
                $hospitalEsModel->setAttribute('photo_list', $this->filterText($hospitalInfo['photo_list']));
                $hospitalEsModel->setAttribute('description', $this->filterText($hospitalInfo['description']));
                $hospitalEsModel->setAttribute('city_uri', $this->filterText($hospitalInfo['city_uri']));
                $hospitalEsModel->setAttribute('page_uri', $this->filterText($hospitalInfo['page_uri']));
                $hospitalEsModel->setAttribute('url', $this->filterText($hospitalInfo['url']));
                $hospitalEsModel->setAttribute('is_shequ', $this->filterText($hospitalInfo['is_shequ']));
                $hospitalEsModel->setAttribute('insurance_num', $this->filterText($hospitalInfo['insurance_num']));
                $hospitalEsModel->setAttribute('display_order', intval($hospitalInfo['display_order']));
                $hospitalEsModel->setAttribute('status', intval($hospitalInfo['status']));
                $hospitalEsModel->setAttribute('level_num', intval($hospitalInfo['level_num']));
                $hospitalEsModel->setAttribute('store_id', intval($hospitalInfo['store_id']));
                $hospitalEsModel->setAttribute('score', intval($hospitalInfo['score']));
                $hospitalEsModel->setAttribute('source', strval($hospitalInfo['source']));
                $hospitalEsModel->setAttribute('fudan_score', intval($hospitalInfo['fudan_score']));

                $hospitalEsModel->save();
            } catch (\Exception $e) {
                return ['code' => 0, 'msg' => $e->getMessage()];
            }
        } else {
            return ['code' => 0, 'msg' => '医院不存在，插入ES失败！'];
        }
        return ['code' => 1, 'msg' => '医院信息插入ES成功!'];
    }


    /**
     * 更新ES中医生数据
     */
    public function updateToEs($hospital_id)
    {
        $hospitalEsModel = self::get($hospital_id);
        //如果不存在就插入ES
        if (is_null($hospitalEsModel)) {
            return $this->insertToEs($hospital_id);
        } else {
            $hospitalInfo = DoctorHospitals::find()->where(['id' => $hospital_id])->asArray()->one();
            //医院等级文本
            $hospital_level_text = $this->getHospitalLevel($hospitalInfo['level_num']);
            try {
                $hospitalEsModel->setAttribute('province_id', trim($hospitalInfo['province_id']));
                $hospitalEsModel->setAttribute('province_name', $this->filterText($hospitalInfo['province_name']));
                $hospitalEsModel->setAttribute('city_id', trim($hospitalInfo['city_id']));
                $hospitalEsModel->setAttribute('city_name', $this->filterText($hospitalInfo['city_name']));
                $hospitalEsModel->setAttribute('district_id', $hospitalInfo['district_id']);
                $hospitalEsModel->setAttribute('district_name', $this->filterText($hospitalInfo['district_name']));
                $hospitalEsModel->setAttribute('name', $this->filterText($hospitalInfo['name']));
                $hospitalEsModel->setAttribute('nick_name', $this->filterText($hospitalInfo['nick_name']));
                $hospitalEsModel->setAttribute('phone', $this->filterText($hospitalInfo['phone']));
                $hospitalEsModel->setAttribute('address', $this->filterText($hospitalInfo['address']));
                $hospitalEsModel->setAttribute('site', $this->filterText($hospitalInfo['site']));
                $hospitalEsModel->setAttribute('mail_num', $this->filterText($hospitalInfo['mail_num']));
                $hospitalEsModel->setAttribute('fax_num', $this->filterText($hospitalInfo['fax_num']));
                $hospitalEsModel->setAttribute('email', $this->filterText($hospitalInfo['email']));
                $hospitalEsModel->setAttribute('routes', $this->filterText($hospitalInfo['routes']));
                $hospitalEsModel->setAttribute('level', $this->filterText($hospital_level_text));
                $hospitalEsModel->setAttribute('insurance', $this->filterText($hospitalInfo['insurance']));
                $hospitalEsModel->setAttribute('type', $this->filterText($hospitalInfo['type']));
                $hospitalEsModel->setAttribute('kind', $this->filterText($hospitalInfo['kind']));
                $hospitalEsModel->setAttribute('tsks', $this->filterText($hospitalInfo['tsks']));
                $hospitalEsModel->setAttribute('photo', $this->filterText($hospitalInfo['photo']));
                $hospitalEsModel->setAttribute('photo_list', $this->filterText($hospitalInfo['photo_list']));
                $hospitalEsModel->setAttribute('description', $this->filterText($hospitalInfo['description']));
                $hospitalEsModel->setAttribute('city_uri', $this->filterText($hospitalInfo['city_uri']));
                $hospitalEsModel->setAttribute('page_uri', $this->filterText($hospitalInfo['page_uri']));
                $hospitalEsModel->setAttribute('url', $this->filterText($hospitalInfo['url']));
                $hospitalEsModel->setAttribute('is_shequ', $this->filterText($hospitalInfo['is_shequ']));
                $hospitalEsModel->setAttribute('insurance_num', trim($hospitalInfo['insurance_num']));
                $hospitalEsModel->setAttribute('display_order', intval($hospitalInfo['display_order']));
                $hospitalEsModel->setAttribute('status', intval($hospitalInfo['status']));
                $hospitalEsModel->setAttribute('level_num', intval($hospitalInfo['level_num']));
                $hospitalEsModel->setAttribute('store_id', intval($hospitalInfo['store_id']));
                $hospitalEsModel->setAttribute('score', intval($hospitalInfo['score']));
                $hospitalEsModel->setAttribute('source', strval($hospitalInfo['source']));
                $hospitalEsModel->setAttribute('fudan_score', intval($hospitalInfo['fudan_score']));

                $hospitalEsModel->save();
            } catch (\Exception $e) {
                return ['code' => 0, 'msg' => $e->getMessage()];
            }

            return ['code' => 1, 'msg' => '医院更新ES成功！'];
        }
    }


    /**
     * 从ES中删除数据
     */
    public function deleteFromEs($hospital_id)
    {
        return self::find()->where(['id' => $hospital_id])->delete();
    }


    /**
     * 初始化时跑数据
     */
    public function initEsData($hospital_id){
        $hospitalInfo = DoctorHospitals::find()->where(['id' => $hospital_id])->asArray()->one();

        //医院等级文本
        $hospital_level_text = $this->getHospitalLevel($hospitalInfo['level_num']);

        //组合数据
        $data = [];
        $data['id'] = $hospital_id;
        $data['province_id'] = intval($hospitalInfo['province_id']);
        $data['province_name'] = $this->filterText($hospitalInfo['province_name']);
        $data['city_id'] = intval($hospitalInfo['city_id']);
        $data['city_name'] = $this->filterText($hospitalInfo['city_name']);
        $data['district_id'] = intval($hospitalInfo['district_id']);
        $data['district_name'] = $this->filterText($hospitalInfo['district_name']);
        $data['name'] = $this->filterText($hospitalInfo['name']);
        $data['nick_name'] = $this->filterText($hospitalInfo['nick_name']);
        $data['phone'] = $this->filterText($hospitalInfo['phone']);
        $data['address'] = $this->filterText($hospitalInfo['address']);
        $data['site'] = $this->filterText($hospitalInfo['site']);
        $data['mail_num'] = $this->filterText($hospitalInfo['mail_num']);
        $data['fax_num'] = $this->filterText($hospitalInfo['fax_num']);
        $data['email'] = $this->filterText($hospitalInfo['email']);
        $data['routes'] = $this->filterText($hospitalInfo['routes']);
        $data['level'] = $this->filterText($hospital_level_text);
        $data['insurance'] = $this->filterText($hospitalInfo['insurance']);
        $data['type'] = $this->filterText($hospitalInfo['type']);
        $data['kind'] = $this->filterText($hospitalInfo['kind']);
        $data['tsks'] = $this->filterText($hospitalInfo['tsks']);
        $data['photo'] = $this->filterText($hospitalInfo['photo']);
        $data['photo_list'] = $this->filterText($hospitalInfo['photo_list']);
        $data['description'] = $this->filterText($hospitalInfo['description']);
        $data['city_uri'] = $this->filterText($hospitalInfo['city_uri']);
        $data['page_uri'] = $this->filterText($hospitalInfo['page_uri']);
        $data['url'] = $this->filterText($hospitalInfo['url']);
        $data['is_shequ'] = $this->filterText($hospitalInfo['is_shequ']);
        $data['insurance_num'] = $this->filterText($hospitalInfo['insurance_num']);
        $data['display_order'] = intval($hospitalInfo['display_order']);
        $data['status'] = intval($hospitalInfo['status']);
        $data['level_num'] = intval($hospitalInfo['level_num']);
        $data['store_id'] = intval($hospitalInfo['store_id']);
        $data['score'] = intval($hospitalInfo['score']);
        $data['source'] = intval($hospitalInfo['source']);
        $data['fudan_score'] = intval($hospitalInfo['fudan_score']);

        $db = self::getDb();
        $command = $db->createCommand();
        $res = $command->insert(self::index().'_'.date('d'),  '_doc', $data, $hospital_id);
        return $res;
    }

    /**
     * 过滤文本
     */
    private function filterText($content)
    {
        //过滤标签空格
        $contentStr = preg_replace("/(\s|\&nbsp\;|　|\xc2\xa0)/", "", strip_tags($content));
        //过滤字符串中的\r\n 以及转义字符
        $contentStr = stripslashes(str_replace(array("\r\n", "\r", "\n"), "", $contentStr));

        return strval(trim($contentStr));
    }
}

具体实现效果：
https://wenzheng.blog.csdn.net/article/details/116135276

PHP开光程序员
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 4
    评论
专栏目录
yii2-elasticsearch, Yii 2 Elasticsearch扩展.zip
09-18
yii2-elasticsearch, Yii 2 Elasticsearch扩展 Elasticsearch查询和 Yii 2的ActiveRecord这个扩展为 Yii框架 2.0提供了的集成。 它包括基本查询/搜索支持，还实现了 ActiveRecord Pattern，允许你在elasticsearch
yii2 elasticsearch
liangpz521的技术资料库
09-18 3524
1、yii2中向es添加数据 $name = "郑州房价最新动态"; $keyword = ["房价",'地价']; //多个字段可以使用数组 $desc = "关注郑州房价最新动态，了解楼盘最新行情。主安家做前期准备"; $id = 4; $customer = new EsStore(); $cus
探索 Yii2-Elasticsearch：高效数据检索的利器
最新发布
gitblog_00084的博客
04-19 268
探索 Yii2-Elasticsearch：高效数据检索的利器 项目地址:https://gitcode.com/yiisoft/yii2-elasticsearch Yii2-Elasticsearch 是一个由 Yiisoft 开发的 PHP 框架，用于与 Elasticsearch 数据库进行无缝集成。Elasticsearch 是一种流行的、高性能的全文搜索引擎，广泛应用于日志分析、实时数...
yii2 elasticsearch 多条件查询，单条件查询
qq_34228881的博客
12-27 3087
配置部分如下： 'elasticsearch' => [ 'class' => 'yii\elasticsearch\Connection', 'nodes' => [ ['http_address' => '192.168.0.199:9200'], ['http_address' =&g...
Yii2 ElasticSearch
freedom_fd的博客
06-11 608
Yii2 ElasticSearch yii2 安装 ElasticSearch composer require --prefer-dist yiisoft/yii2-elasticsearch:"~2.0.0" 在main.php 中配置 'elasticsearch' => [ 'class' => 'yii\elasticsearch\Connection', ...
Yii2增删改查之查询 where参数详细介绍
10-21
主要介绍了Yii2增删改查之查询 where参数详细介绍的相关资料,非常不错，具有参考借鉴价值，需要的朋友可以参考下
Yii针对添加行的增删改查操作示例
10-21
主要介绍了Yii针对添加行的增删改查操作,涉及Yii结合jQuery针对页面元素的动态操作及数据库增删改查等操作相关实现技巧,需要的朋友可以参考下
Yii2框架数据库简单的增删改查语法小结
10-21
主要介绍了Yii2框架数据库简单的增删改查语法小结,非常不错，具有参考借鉴价值，需要的朋友可以参考下
Yii2实现增删改查后留在当前页的方法详解
10-20
yii2.0框架是PHP开发的一个比较高效率的框架，集合了作者的大量心血，下面这篇文章主要介绍了Yii2如何实现增删改查后仍留在当前页的方法,需要的朋友可以参考借鉴，下面来一起看看吧。
Yii2.0高级框架数据库增删改查的一些操作
10-23
yii2.0框架是PHP开发的一个比较高效率的框架，集合了作者的大量心血，下面通过用户为例给大家详解yii2.0高级框架数据库增删改查的一些操作
yii2-elasticsearch:Yii 2 Elasticsearch 扩展
08-04
Yii 2 的 Elasticsearch 查询和 ActiveRecord 这个扩展为提供了集成。 它包括基本的查询/搜索支持，还实现了ActiveRecord模式，允许您在 Elasticsearch 中存储活动记录。 有关许可证信息，请检查文件。 文档位于 。 要求 根据您使用的 Elasticsearch 版本，您需要此扩展的不同版本。 对于 Elasticsearch 1.6.0 到 1.7.6 使用扩展版本 2.0.x 对于 Elasticsearch 5.x 或更高版本，请使用扩展版本 2.1.x 安装 安装此扩展的首选方法是通过 ： composer require --prefer-dist yiisoft/yii2-elasticsearch:"~2.1.0" 配置 要使用此扩展，您必须在应用程序配置中配置 Connection 类： return [
Yii2.0实现的批量更新及批量插入功能示例
10-17
主要介绍了Yii2.0实现的批量更新及批量插入功能,结合实例形式总结分析了Yii2.0数据库实现数据的批量更新与批量插入功能相关操作技巧,需要的朋友可以参考下
Yii2从Elasticsearch中获取列表含搜索
xiadiganhuo的博客
06-10 218
// 分页条件查询 public function actionList() { $reallyParams = $this->reallyParams;
Yii2集成Elasticsearch（一）
wx145的博客
10-24 3419
背景知识： 全文搜索可以简单地分为两类，一种是顺序扫描，即我们常见的使用 like %keyword% 方式，扫描整张数据表，在每一条记录中查找；另一种就是索引扫描。elasticsearch就是后者。 索引扫描分为两部分：创建索引和搜索索引。创建索引的主要步骤是：对原数据进行分词处理（去掉标点和一些无意义的词等等），将得到的词元交给语言处理组件（例如将复数变为单数，将过去式变为一般式等等），...
Yii2-elasticsearch的简单使用
weixin_45000482的博客
12-30 1674
Yii2-elasticsearch的简单使用
Yii2集成Elasticsearch（二）
wx145的博客
11-04 3171
背景知识： 全文搜索可以简单地分为两类，一种是顺序扫描，即我们常见的使用 like %keyword% 方式，扫描整张数据表，在每一条记录中查找；另一种就是索引扫描。elasticsearch就是后者。 索引扫描分为两部分：创建索引和搜索索引。创建索引的主要步骤是：对原数据进行分词处理（去掉标点和一些无意义的词等等），将得到的词元交给语言处理组件（例如将复数变为单数，将过去式变为一般式等等），...
Yii2操作elasticsearch封装model
PHP开光程序员的博客
07-26 731
<?php /** * 问答ES模型 * Created by PhpStorm. * DateTime: 2019/7/18 11:48 */ namespace backend\models; use yii\elasticsearch\ActiveRecord; use yii\data\Pagination; use yii\helpers\ArrayHelper; u...
yii2 ElasticSearch delete 稍微有点托比的es删除数据
Terry - 专注外贸B2C
02-10 981
# 删除ES数据。 public function actionClear(){ echo "clear"; EsMidData7::initDb(1); //EsMidData7::deleteAll(['service_date_str' => '2017-02-09']); $ids = [1,10,13,14,15,16,17,19]; foreach($ids
gii2框架实现增删高差
05-22
gii2是Yii2框架自带的代码生成器，可以快速生成常用的增删改查代码。以下是基本的使用方法： 1. 首先，确保已经安装了Yii2框架，并且在控制台中进入到项目的根目录。 2. 执行以下命令生成模型文件： ``` ./yii gii/model --tableName=<table_name> --modelClass=<model_name> ``` 其中，`<table_name>`为数据库表名，`<model_name>`为生成的模型类名。 3. 接着，执行以下命令生成 CRUD （增删改查）代码： ``` ./yii gii/crud --modelClass=<model_name> --controllerClass=<controller_name> ``` 其中，`<model_name>`为之前生成的模型类名，`<controller_name>`为生成的控制器类名。 4. 执行以上命令后，会在项目中自动生成相应的模型、控制器、视图等文件，实现了基本的增删改查功能。 需要注意的是，以上命令生成的代码只是基础代码，需要根据具体业务需求进行修改和完善。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

PHP开光程序员

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值