4.4.3 新增

4.4.3 新增

create()：直接插入

<?php
namespace App\Controller;

class IndexController extends AbstractController
{
    public function index()
    {
        // 插入数据
        return \App\Model\UserActivity::query()->create([
            'merchant_no' => '11211',
            'title' => 'test',
            'desc' => '111221',
            'status' => 1,
            'meta' => [
                "cover_pic" => "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1591770047788&di=8efc808496c85415054dae40e1a7f06a&imgtype=0&src=http%3A%2F%2Fa0.att.hudong.com%2F56%2F12%2F01300000164151121576126282411.jpg",
                "share_pic" => "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1591770047788&di=8efc808496c85415054dae40e1a7f06a&imgtype=0&src=http%3A%2F%2Fa0.att.hudong.com%2F56%2F12%2F01300000164151121576126282411.jpg",
                "rule"=> "rule"
            ],
            'cdn_addr' => ''
        ]);
    }
}

firstOrCreate()：如果无法查询到该数据再插入

<?php
namespace App\Controller;

class IndexController extends AbstractController
{
    public function index()
    {
        // 如果无法查询到就插入数据，否则直接将查询出来的结果返回
        return \App\Model\UserActivity::query()->firstOrCreate([
            'id' => 10026
        ], [
            'merchant_no' => '11211',
            'title' => 'test',
            'desc' => '111221',
            'status' => 1,
            'meta' => [
                "cover_pic" => "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1591770047788&di=8efc808496c85415054dae40e1a7f06a&imgtype=0&src=http%3A%2F%2Fa0.att.hudong.com%2F56%2F12%2F01300000164151121576126282411.jpg",
                "share_pic" => "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1591770047788&di=8efc808496c85415054dae40e1a7f06a&imgtype=0&src=http%3A%2F%2Fa0.att.hudong.com%2F56%2F12%2F01300000164151121576126282411.jpg",
                "rule"=> "rule"
            ],
            'cdn_addr' => ''
        ]);
    }
}