Insert IGNORE

Ulten · January 3, 2011, 9:53pm

is it possible to add INSERT IGNORE into ActiveRecord?

$model->save(true,‘ignore’);

or

$model->insert()

$model->update?

mdomba · January 4, 2011, 7:07am

INSERT IGNORE is a MySql command… it does not exist in all databases…

Ulten · January 4, 2011, 7:34pm

maybe some simulation? if not sported then

try catch exception and suppress error?

mdomba · January 4, 2011, 8:54pm

If that command is supported only by one database… I don’t see why would that be useful in the core… especialy if we just simulate it or suppresing the error…

Ulten · January 5, 2011, 7:14am

if its supports in data base then send IGNORE, if not support then send catch error, and don’t show it like ignore should work.

when working with AR,

$ar = new model;

$ar->value=‘incompactible dublicate value’;

$ar->save()->ignore;

or $ar->ignore->save();

without dirting code with try catch if it not needed.