4.Our Approach to Delete of the Database Record

① Physics delete : Deleted Database Record can’t be undone.
② logical delete : Deleted Database Record can be undone.

■Reasons for ensuring that logical deletion is used
Logical deletion allows the data to be treated as deleted, so it can be undone.
In practice, an integer column called “delete_flg” is created and managed as 0 or 1.

Physics delete

①Delete one case

●MySQL
delete from test where id = 3;

●idiorm
$test= ORM::for_table(‘test’)->where(‘id’,3)->delete();

②Multiple deletions

●MySQL
delete from test where name = tarou;

●idiorm
$test= ORM::for_table(‘test’)->where(‘name’,’tarou’)->delete_many();

logic delete

①Delete one case

●MySQL
UPDATE from test SET delete_flg = 1 where id = 3;

●idiorm
$test= ORM::for_table(‘test’)->where('id',3)->find_one();
$test->delete_flg = 1;
$test->save();

②Multiple deletions

●MySQL
UPDATE from test SET delete_flg = 1;

●idiorm
$test= ORM::for_table(‘test’)->find_result_set();
$test->set('delete_flg',1);
$test->save();