Programmiererforum

Posted: **02 Apr 2025, 06:15**

Ich habe folgende Tabellenstruktur. />...
< /tr>
< /thead>

1 < /td>
uUid-m01 < /td>
Movie 1 < /td> < /; />

Table: categories

id
uuid
Titel < /th>
...
< /tr>
< /thead>

1 < /td>
< /td> uuid-c01 < /td>
category 1 < /td> < /< /td> < /> category 1 < /td> < /< /< /> category 1 < /td> < /< /td> < /> category 1 < /td> />...
< /tr>

2 < /td>
uUid-c02 < /td>
Kategorie 2 < /td>
< /> < />
< /> < /tre />
Table: movie_categories

id
movie_id
category_id
uUid < /th>
...
< /tr>
< /thead>

..
..../ted>< />..........
...

Post: .../api/movies/create

hasMany(MovieCategory::class);
}

...
}
[/code]
Models/APIS/V1/MovieCategory.php

Code: Select all

class MovieCategory extends Model {
...

public function movie() {
return $this->belongsTo(Movie::class);
}
public function category() {
return $this->hasOne(Category::class);
}
}

models/APIS/V1/Category.php

Code: Select all

class Category extends Model {
public function movieCategory() {
return $this->belongsTo(MovieCategory::class);
}
}

controller/apis/v1/moviecontroller.php

Code: Select all

public function store(MovieRequest $request) {
try {
$Post = $request->validated();

$Movie = Movie::create([
'uuid'  => Str::uuid(),
'title' => $Post['title'],
]);

$Movie->movieCategories()->create($Post['category_ids']);

...
} catch (\Throwable $th) {
...
}
}

Jetzt ist die Frage, dass in der Category_ids ich die uUids der Kategorien übertrage, aber in der Movie_Categories Tabelle akzeptiert die Spalte die Spalte. class = "Lang-json PrettyPrint-Override">{
...
"error": {
"code": "22003",
"message": "SQLSTATE[22003]: Numeric value out of range: 1264 Out of
range value for column 'category_id' at row 1 (SQL:
insert into `movie_categories`
(`movie_id`, `category_id`, `uuid`, `updated_at`, `created_at`)
values
(3, uuid-c01, uuid-string, 2025-04-01 07:36:18, 2025-04-01 07:36:18))"
}
}
< /code>
Während die Ausgabe sein sollte: < /p>
Tabelle: Movie_categories < /code> < /p>

Programmiererforum

LaRavel 9, Elternmund -Bulk -Einsatz, während Sie UUID durch ID ersetzen

LaRavel 9, Elternmund -Bulk -Einsatz, während Sie UUID durch ID ersetzen