al-one/laravel-replace-into

为Laravel的SQL replace into

维护者

详细信息

github.com/al-one/laravel-replace-into

源代码

问题

安装次数: 4,346

依赖者: 0

建议者: 0

安全性: 0

星级: 4

关注者: 3

分支: 1

公开问题: 0

v1.9.0-beta1 2022-08-04 10:45 UTC

Requires

MIT c37058c79a00d9ef1f79f39c7076c878dcaa7359

  • Alone <hi.woop@anlo.ng>

databaselaraveleloquentreplace-into

This package is auto-updated.

Last update: 2024-09-17 08:51:25 UTC

README

安装

# composer.json

"minimum-stability": "dev",
"prefer-stable": true,

$ composer require "al-one/laravel-replace-into" -vvv

使用方法

# optional if >= 5.5
# config/app.php
<?php

return [

    'providers' => [
        Alone\LaravelReplaceInto\ServiceProvider::class,
    ],

];
use Illuminate\Support\Facades\DB;

DB::table('user_attrs')->replace(
    ['uid' => 10000,'type' => 'key','value' => 'val'],
    ['uid','type'] // uniqueKeys
);

DB::table('user_attrs')->replace([
    ['uid' => 10000,'type' => 'key1','value' => 'val1'],
    ['uid' => 10001,'type' => 'key2','value' => 'val2'],
],['uid','type']);
use Illuminate\Database\Eloquent\Model;

class UserAttr extends Model
{
    public function uniqueKeys()
    {
        return ['uid','type'];
    }
}

UserAttr::replace(
    ['uid' => 10000,'type' => 'key','value' => 'val']
);

UserAttr::replace([
    ['uid' => 10000,'type' => 'key1','value' => 'val1'],
    ['uid' => 10001,'type' => 'key2','value' => 'val2'],
]);

许可协议

MIT