insert-on-duplicate-key

insert-on-duplicate-key copied to clipboard

I needed support for insert/updating rows while using mysql builtin functions (ie. AES_ENCRYPT()), but this was sending them to the underlying PDO instance as bindings, which would then insert the...

Arkitecht

First, it is a very useful function for laravel. Just save my life. But, when i using this function, i found that there are no handling for timestamps. For example:...

mons0630

Possible SQL injection

1

Source: https://github.com/yadakhov/insert-on-duplicate-key/blob/master/src/InsertOnDuplicateKey.php#L207 Example: `insertOnDuplicateKey(..., [ 'col' => 'value' ])` This just sticks 'value' straight into the SQL without sanitisation: `ON DUPLICATE KEY UPDATE col = value` @yadakhov

bytestream

Slow for more than a certain number of records

1

Thanks for a great library - does exactly what I need! I have an interesting issue: when I `insertIgnore`, `insertReplace `or `insertOnDuplicateKey `for more than approximately 7200 records with 9...

kjfdebruin

Use the connection that was set on the model instance

2

Copied from: https://github.com/yadakhov/insert-on-duplicate-key/pull/7 @yadakhov Thank you for creating this plugin. Too bad the non default connection is not read from the instance of the model. ``` \App\Model::on('otherconnection')->getModel()->insertOnDuplicateKey([[....]]); // will still...

reno1979

Punctuated strings

1

Hi @yadakhov! Thanks for your great work! I'm trying to store some strings to a database but, in some cases, I need a punctuated version of the same string to...

doubledot-web

SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many placeholders

4

Hey @yadakhov I guess I pushed too hard `insert-on-duplicate-key`, cause apparently I hit the limit of MySQL. 😅 I'm just posting this here mainly for maybe somebody else who could...

stebogit

Here's a test to fetch 500 rows which has 20 columns from a table, then insert them back without any changes: > $datas = App\SomeModel->limit(500)->get()->toArray(); > App\SomeModel::insertOnDuplicateKey($datas); The laravel-debugbar's timeline...

n0099

Creating wrong record

3

Hi, I noticed that in some particular cases the `insertOnDuplicateKey` method creates a wrong record in the table. [This](https://gist.github.com/stebogit/5b9f2a7cf31ad468ece4bada2c85f91a) is an example of input with the table schema, at the...

stebogit

insertOnDuplicateKey $updateColumns parameter doesn't allow strings

1

The insertOnDuplicateKey function works great, except when trying to pass strings in the $updateColumns parameter, as the resulting SQL doesn't enclose the value in quotes to treat them as strings:...

nonsapiens