Please support INSERT ~ SELECT query!

[o0h]

Can you support INSERT ~ SELECT val1, val2 FROM tmp WHERE NOT EXISTS(*) statement?

You have already support ON DUPLICATE KEY syntax, but it only helps me UNIQUE/PRIMARY keys' duplication.
I think the feature like bellow make this plugin more useful! 😄

---

api design

// Behavior's api
public function insertOnce(array $values, array $search = null)

usage 1

Specify search conditions.

$data = ['field1' => $val1, 'field2' => $val2];
$search = ['key' = $key];
$this->Table->insertOnce($data, $search);

generates sql statement bellow

INSERT INTO `table` (`field1`, `field2`)
SELECT "{$val1}", "{$val2}" FROM tmp WHERE NOT EXISTS(    
    SELECT * FROM table WHERE `key` = '{$key}'
)

usage 2

Auto set search conditions with inserting data.

$data = ['field1' => $val1, 'field2' => $val2];
$search = ['key' = $key];
$this->Table->insertOnce($data,);

generates sql statement bellow

INSERT INTO `table` (`field1`, `field2`)
SELECT "{$val1}", "{$val2}" FROM tmp WHERE NOT EXISTS(    
    SELECT * FROM table WHERE `field1` = '{$val1}' AND `field2` = '{$val2}'
)

[itosho]

thx!