DBAL-182: Insert and Merge Query Objects

[doctrinebot]

Jira issue originally created by user @beberlei:

We are missing Insert and Merge Query Objects.

See Drupal DBTNG:

Merge: http://drupal.org/node/310085
Insert: http://drupal.org/node/310079

[doctrinebot]

• relates to DBAL-320: allow SQL QueryBuilder to do INSERTS
• is referenced by DBAL-599: Add support of insert and insert select statements in DBAL QueryBuilder
• is referenced by DBAL-636: QueryBuilder insert

[doctrinebot]

Comment created by @beberlei:

From the first glance: Drupal API has some problems in that it assumes literal values are the default, which makes working with them simple if no expression is necessary. But inconsistent otherwise.

Implementation Details:

• Difference compared to QueryBuilder is that these objects are no builders, but actually executors.
• Don't assume Literals
• Creation is delegated to Platform (Runtime API of a Vendor)

{conn}
$conn->createInsertQuery();
$conn->createMergeQuery();
{conn}

Sample API:

$conn->createInsertQuery($tbl)->fields(array('foo', 'bar'))->values(array('?', '?'))->(array(1, 2))->execute();
$conn->createInsertQuery($tbl)->fields(array('foo', 'bar'))->params(array(1, 2))->execute(); // values(?, ?) is implicit.
$conn->createInsertQuery($tbl)->fields(array('foo', 'bar'))->params(array('NOW()', '1'))->execute(); // if no "params" set assume execute once.
$conn->createInsertQuery($tbl)->fields(array('foo', 'bar'))->value('foo', 'NOW())->params(array(1))->params(array(2))->execute();
$conn->createInsertQuery($tbl)->fields(array('foo', 'bar'))->select($queryBuilder)->execute();

Merge: I dont know yet:

problem i see here is that people mistake values() for a "safe" method and pass values in there that should be quoted instead.

[Ocramius]

This won't happen - the proposed API doesn't really make sense to me, and we should instead have UPSERT as in #1320

Closing.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.