如何解决APIATO项目中违反完整性约束的错误？

Question

我在里面开发了一个APIATO项目，我想要执行CRUD操作，我创建了一个名为upload的函数，该函数负责发布详细信息，并通过将凭据传递到.env文件与我的数据库集成，当我尝试在postman中发送请求时，我得到了以下错误

Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null (SQL: insert into `blogs_table` (`name`, `price`, `image`, `rating`, `country`, `description`, `user_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, 2021-08-08 17:06:53, 2021-08-08 17:06:53)) in file /home/vagrant/code/apiato/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 692

我不知道如何解决这个错误，请帮我解决这个问题...

BlogContoller.php

<?php

namespace App\Containers\UserRegistration\UserContainer\UI\API\Controllers;

use App\Containers\UserRegistration\UserContainer\UI\API\Requests\CreateUserContainerRequest;
use App\Containers\UserRegistration\UserContainer\UI\API\Requests\DeleteUserContainerRequest;
use App\Containers\UserRegistration\UserContainer\UI\API\Requests\GetAllUserContainersRequest;
use App\Containers\UserRegistration\UserContainer\UI\API\Requests\FindUserContainerByIdRequest;
use App\Containers\UserRegistration\UserContainer\UI\API\Requests\UpdateUserContainerRequest;
use App\Containers\UserRegistration\UserContainer\UI\API\Transformers\UserContainerTransformer;
use App\Containers\UserRegistration\UserContainer\Actions\CreateUserContainerAction;
use App\Containers\UserRegistration\UserContainer\Actions\FindUserContainerByIdAction;
use App\Containers\UserRegistration\UserContainer\Actions\GetAllUserContainersAction;
use App\Containers\UserRegistration\UserContainer\Actions\UpdateUserContainerAction;
use App\Containers\UserRegistration\UserContainer\Actions\DeleteUserContainerAction;
use App\Ship\Parents\Controllers\ApiController;
use Illuminate\Http\JsonResponse;
// use Illuminate\Support\Facades\Request;
use Illuminate\Http\Request;
use App\Containers\UserRegistration\UserContainer\Models\BlogModel;

class BlogController extends ApiController
{
    public function upload(Request $request ){
        //dd($request->all());
        $blog = new BlogModel();
        $blog->name=$request->input('name');
        $blog->price=$request->input('price');
        $blog->image=$request->input('image');
        $blog->rating=$request->input('rating');
        $blog->country=$request->input('country');
        $blog->description=$request->input('description');
        $blog->user_id = auth()->id();     
        $blog->save();
        return response()->json(['blogs'=>$blog]);
    }
}

BlogModel.php

<?php

namespace App\Containers\UserRegistration\UserContainer\Models;

use App\Ship\Parents\Models\Model;

class BlogModel extends Model
{
    protected $table='blogs_table';
    protected $fillable = [
        'name','price','image','country','rating','description'
    ];

    protected $attributes = [

    ];

    protected $hidden = [

    ];

    protected $casts = [

    ];

    protected $dates = [
        'created_at',
        'updated_at',
    ];

    /**
     * A resource key to be used in the serialized responses.
     */
    protected string $resourceKey = 'BlogModel';
    public function user(){
        return $this->belongsTo(UserContainer::class);
    }
}

Migration table

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateBlogsTable extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('blogs_table', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('price');
            $table->string('country');
            $table->string('description');
            $table->integer('rating');
            $table->string('image');
            $table->unsignedInteger('user_id');
            $table->foreign('user_id')->references('id')->on('user_containers');
            $table->timestamps();
            //$table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('blogs_table');
    }
}

Answer 1

您在BlogContoller.php中的$request->input('name')为空。您可以在name列的迁移中添加nullable()方法，如下所示。

$table->string('name')->nullable();