[NFR] Query\Builder support INSERT/UPDATE/DELETE

[iwai]

I tried to think of a new method, but how about you??

# INSERT INTO Cars (price, type) VALUES (:price:, :type:)
$result = $this->modelsManager->createBuilder()
   ->insert('Cars', array('price' => 15000.00, 'type' => 'Sedan'))
   ->getQuery()
   ->execute();

# UDPATE Cars SET price = :price, type = :type: WHERE id = :id:
$result = $this->modelsManager->createBuilder()
   ->update('Cars', array('price' => 15000.00, 'type' => 'Sedan'))
   ->where('id = :id:', array('id' => 100))
   ->getQuery()
   ->execute();

# DELETE FROM Cars WHERE id = :id:
$result = $this->modelsManager->createBuilder()
   ->delete('Cars')
   ->where('id = :id:', array('id' => 100))
   ->getQuery()
   ->execute();

## Or alternate concept

# INSERT INTO Cars (price, type) VALUES (:price:, :type:)
$result = $this->modelsManager->createBuilder()
   ->insert('Cars', array('price', 'type'), array(15000.00, 'Sedan'))
   ->getQuery()
   ->execute();

# UDPATE Cars SET price = :price, type = :type: WHERE id = :id:
$result = $this->modelsManager->createBuilder()
   ->update('Cars', array('price', 'type'), array(15000.00, 'Sedan'))
   ->where('id = :id:', array('id' => 100))
   ->getQuery()
   ->execute();

Method return is Phalcon\Mvc\Model\Query\Status.

I'm afraid my expressions may be rude or hard to read, because I'm not so good at English.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[boast]

+1 Looks really nice.

[braska]

+1

[pgasiorowski]

👍

[atnartur]

+1

[kbtz]

😍

[mrenigma]

+1 Would be amazingly useful for batch processing!

[posthy]

+1

[brainiac84]

+1

[nejtr0n]

+1

[collinswang]

how to collect this issue?

[vitalypanait]

+1

[icedeng]

+1

[armageddon-cat]

+1

[salyakhov-art]

+1

[sergeyklay]

+1

[ryomo]

delete() and update() are already implemented, right?

$this->modelsManager->createBuilder()
    ->from('Cars')
    ->where('type = :type:', array('type' => 'Sedan'))
    ->getQuery()
    ->execute()  // This returns Phalcon\Mvc\Model\Resultset
    ->delete();

The above is equivalent to the following PHQL.

$phql = 'DELETE FROM Car WHERE type = :type:';
$query = new Query($phql, Di::getDefault());
$query->execute(['type' => 'Sedan']);

Both of 2 got same SQL statements. (PHQL also calls DELETE FROM ~ many times.)

SELECT `car`.`id`, `car`.`type` FROM `car` WHERE `car`.`type` = :0
SAVEPOINT PHALCON_SAVEPOINT_2
DELETE FROM `car` WHERE `id` = ?
DELETE FROM `car` WHERE `id` = ?
DELETE FROM `car` WHERE `id` = ?
...
RELEASE SAVEPOINT PHALCON_SAVEPOINT_2

refer

• Abstract class Phalcon\Mvc\Model\Resultset

[JigneshPansuriaDeveloper]

this above delete and update not working for non primary key.

[Firzenizer]

Damn I was just looking for this feature. Seems it doesn't exist. I was looking to update using inWhere()

[Jurigag]

@ryomo

It's not implemented, is just selecting first and then deleting. I think there shouldn't be selecting.

[dictbox]

+1

[dictbox]

Laravel support similar function。

[stale]

Thank you for contributing to this issue. As it has been 90 days since the last activity, we are automatically closing the issue. This is often because the request was already solved in some way and it just wasn't updated or it's no longer applicable. If that's not the case, please feel free to either reopen this issue or open a new one. We will be more than happy to look at it again! You can read more here: https://blog.phalconphp.com/post/github-closing-old-issues