[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@Conerck

DMZ already uses LAST_INSERT_ID, but I don't know that any database guarantees that multiple inserts are atomic. On a high-traffic website, the resulting IDs may not actually be serial.

(Also, even if one or more DB does do atomic inserts, many users use different databases. I, for example, use PostgreSQL almost exclusively, except when testing DMZ.)

Generating the insert should really be pretty simple :

Code:

$success = TRUE;
foreach($obj->all as $o) {
    $o->validate();
    if(!$o->valid) {
        $success = FALSE;
    }
}
if(!$success) {
    $obj->error_message('query', 'Unable to validate.');
    return FALSE;
}

// alternatively, you could accept the fields_to_set as a parameter.
$fields_to_set = array();
$fields_to_check = $obj->fields;
foreach($obj->all as $o) {
    foreach($fields_to_check as $index => $f) {
        // keep track of which fields have been added
        $remaining_fields = array();
        if( ! empty($o->{$f})) {
             $fields_to_set[] = $f;
        } else {
             $remaining_fields[] = $f;
        }
    }
    $fields_to_check = $remaining_fields;
}

$sql = 'INSERT INTO ';
$table_name = $obj->prefix . $obj->tablename;
$sql .= $obj->db->protect_identifiers($table_name);
$sql .= ' (';
foreach($fields_to_set as $index => $field) {
    if($index > 0) {
        $sql .= ',';
    }
    $sql .= $obj->db->protect_identifiers($field);
}
$sql .= ")\n VALUES";

$first = TRUE;
foreach($obj->all as $o) {
    $sql.= $first ? '' : ",\n       ";
    $first = FALSE;
    $sql .= ' (';
    foreach($fields_to_set as $index => $field) {
        $sql .= $obj->db->escape($o->{$field});
    }
    $sql .= ')';
}

$success = $obj->db->simple_query($sql);

if(!$success) {
    $obj->error_message('query', 'Unable to run the query.');
}

return $success;

Barring any typos, that should work.