Using Laravel 5.1, how can I access a JSON key/value pair via Query Builder in a migration? There is JSON data stored in json_data_column that I need to validate in a where() Query Builder expression. Logic is such :
DB::transaction(function () { echo 'Deleting rows where user_id is empty...' . PHP_EOL; DB::table('payment_methods')->where('json_data_column->user_id', '""')->delete(); });
However, chaining does not seem to work here. Indeed, output is:
[Illuminate\Database\QueryException] SQLSTATE[42703]: Undefined column: 7 ERROR: column "user_id" does not exist LINE 1: ... "payment_methods" where "json_data_column"->user_id... ^ (SQL: delete from "payment_me thods" where "payment_platform_data"->user_id = "")
Is it possible to use chaining using the logic up there in this case? If not, how can I access the JSON fields?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire