我正在嘗試刪除具有 6 個關系的產品，如下所示：品牌->屬于（品牌::類）；標簽->belongsToMany(Tag::class, 'tags_product');字段->belongsToMany(Field::class, 'product_field');尺寸->belongsToMany(Size::class, 'product_size');國家->belongsToMany(Country::class, 'country_product');countryProducts->hasMany(CountryProduct::class);productFields->hasMany(ProductField::class);exportationFactors->hasMany(ExportationFactor::class);我是否必須首先擺脫這些關系？目前我有這個刪除功能的代碼ini_set('max_execution_time', 300);$products = $request->all();try { DB::beginTransaction(); foreach ($products as $product) { $dbProduct = $this->getProduct($product['SKU']); $dbProduct->brand()->delete(); $dbProduct->tags()->delete(); $dbProduct->fields()->delete(); $dbProduct->sizes()->delete(); $dbProduct->countries()->delete(); $dbProduct->exportationFactors()->delete(); Log::error($dbProduct); $dbProduct->delete(); } DB::commit();} catch (Exception $e) { DB::rollBack(); throw new HttpException(500, 'Sucedio un error eliminando la información favor intentar de nuevo');}我得到這個錯誤SQLSTATE[23000]: 完整性約束違規：1451 無法刪除或更新父行：外鍵約束失敗 ( sondel. products, CONSTRAINT products_brand_id_foreignFOREIGN KEY ( brand_id) REFERENCES brands( id)) (SQL: delete from brandswhere brands. id= 2)
2 回答
LEATH
TA貢獻1936條經驗 獲得超7個贊
試試這個：
$dbProduct->delete();
Brand::where('product_id', $dbProduct->id)->delete();
Tags::where('product_id', $dbProduct->id)->delete();
并添加所有表
吃雞游戲
TA貢獻1829條經驗 獲得超7個贊
這是我到達的解決方案：
ini_set('max_execution_time', 300);
$products = $request->all();
try {
DB::beginTransaction();
foreach ($products as $product) {
$product = $this->getProduct($product['SKU']);
$product->sizes()->detach();
$product->tags()->detach();
$product->fields()->detach();
$product->countries()->detach();
$product->exportationFactors()->delete();
$product->delete();
DB::commit();
}
DB::commit();
} catch (Exception $e) {
DB::rollBack();
throw new HttpException(500, 'Sucedio un error eliminando la información favor intentar de nuevo');
}
在 vue.js 中
sendData(data, index) {
this.loading = true;
this.error = {};
this.$http.post(this.baseUrl, data, this.params)
.then(
() => {
this.successAction();
this.statuses[index] = 1;
this.errorDis = false;
},
(res) => {
this.showErrors(res);
this.statuses[index] = 2;
this.errorDis = true;
}
);
},
- 2 回答
- 0 關注
- 181 瀏覽
添加回答
舉報
0/150
提交
取消