laravelBatch
laravelBatch copied to clipboard
insert batch and update batch in laravel
when using SQLServer throw this error [Illuminate\Database\QueryException] "SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '`'. (SQL: UPDATE ... so I need to remove backtick symbol from vendor\mavinoo\laravel-batch\src\Batch.php...
src/Common/Common.php protected static function safeJson($jsonData, $asArray = false) { $jsonData = json_decode($jsonData, true); $safeJsonData = []; if (!is_array($jsonData)) { return $jsonData; } foreach ($jsonData as $key => $value) { if...
I try to solve it with using 'E' befo raw 
example in model: ``` protected $connection = 'mysql'; protected $table = 'db1.table'; ```
Hi. How to?? $product_model = new Product; $index = 'id'; $value = [ ['id' => 1,'count' => 5], ['id' => 2,'count' => 3], ]; Batch::update($product_model , $value, $index); i want...
Latest release `2.2.4` has broken our build, when updating phone numbers like `+420111222333`, it treats this string as if increment is wanted. I think, there should be optional parameter to...
hello. Thanks for this library! I need a way to verify if the rows I inserted really got inserted. Currently, it only returns the following: ``` { totalRows: 2, totalBatch:...
Backticks are a non-standard used by MySQL. Postgres does not support them by default. "MySQL uses ` (accent mark or backtick) to quote system identifiers, which is decidedly non-standard." https://wiki.postgresql.org/wiki/Things_to_find_out_about_when_moving_from_MySQL_to_PostgreSQL...
Hello this is the following update method: `public function updateProfile(ProfileRequest $request, Profile $profile) { try { \DB::beginTransaction(); $profile = new Profile; $input = [ $this->profileInput(), ]; $index = 'id'; /**...
```php $userInstance = new User; $value = [ [ 'id' => 1, 'json' => '{}' ] , [ 'id' => 5, 'json' => '{"key":"values"}' ] , ]; $index = 'id';...