[eluser]OverZealous[/eluser]
[quote author="Jack Scott" date="1248835689"]Is there a simple way to detect whether a database field has changed in DMZ?[/quote]
All fields are NULL until they are set on a new object. You might be able to simply use is_null($object->{$field}).
However, if you need nulls, this won't help.
For already-saved objects, as long as the object remains in memory while both sources are read, you should be able to use the built-in $stored object. This exists for each DMZ object. (FYI: It is not documented, so I wouldn't rely on it's workings for future releases.)
Example:
Code:
$o = new Object();
$o->get_by_id($o->id);
// copy in DataSource 1 properties, but DON'T save it
foreach($datasource2 as $f => $k) {
if($o->{$f} === $o->stored->{$f}) {
$o->{$f} = $k;
}
}
$o->save();
If you need to save it between datasources, then you'll need to work out something else, because there is no way for DMZ to know what is meant by "changed".
Instead of a boolean per field (which may be unwieldy), I recommend creating a TEXT field on the table, and using something like json_encode and json_decode to convert an array of changed fields into a string, and store that on the table. It's a little bigger data-wise, but once you are done with the import, that column can be deleted, removing all of the extra content in one swoop. Alternatively, if this is needed multiple times, simply do a UPDATE <table> SET <column> AS NULL to clear the change history.
