Support for UPDATE & DELETE methods?

[gms8994]

Rob, have you given any thought to creating insert, update, and delete methods instead of having queries written inline?

I don't know that they'd add any specific functionality, but something like the way Zend_Db (v1, not v2) does would be nice to have.

[robmorgan]

Hi @gms8994, yes I've thought about this, but potentially in the next major release (not any time soon) as Phinx is approaching an API freeze and stability is paramount. I'll leave the issue open for now.

[joshribakoff]

Also need a last insert ID. Work around currently is:

$id = $this->fetchRow("select LAST_INSERT_ID()")[0]

[niekoost]

Or use
$this->adapter->getConnection()->lastInsertId();

For better readable source code:
$con = $this->adapter->getConnection();
and then use
$id = $con->lastInsertId();
where needed

[rjmackay]

Any update on this? particularly a method for last insert id?

[maxgalbu]

I'm interested in this too

[lorenzo]

@robmorgan for CakePHP 3.0 we started using phinx as our migrations tool and we'd like to see this feature happen. We are planing on releasing a low level database set of classes that could fit well for providing this feature with very low difficulty. Would you be interested in talking about this at some point?

[maxgalbu]

This pull request could help executing insert or update: #256

It would be as simple as this:

class SomeMigration extends AbstractMigration
{
    public function up()
    {
        $sql = 'INSERT INTO test(intCol, strCol) VALUE(:intColVal, :strColVal)';
        $this->execute($sql, array(
            'strColVal' => 'foo',
        )); 
    }
}

[Keloo]

+1 for lastInsertId()

[trinhhunganh]

+1 for lastInsertId()

[cballou]

+1 for lastInsertId()