I have been developing an application using Phalcon models and it works great.
However there are a few situations where I need to use the save() function without overwriting certain fields on update operations. For example if I have a table with the columns:
> id, name, age
> 1, bob, 20
> 2, anna, 28,
> 3, tracey, 37
Now if I perform an update, without specifing the name anna:
> 2, , 29
It overwrites anna with nothing and I've destroyed the record...
Obviously this is an extremely simple example. I have real tables with >25 fields which I need to update maybe only half of them in certain controllers.
Making an initial database call to retrieve the record is too expensive in my opinion and therefore not an option.
I hope I'm missing something obvious.