[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]Conerck[/eluser]
[quote author="OverZealous" date="1264975386"]@Conerck

That seems like an easy thing to make into an extension. I would recommend looping through all objects and checking validate, to ensure that the pre-processing rules are run. If one or more objects returns FALSE, return that and exit.

Then manually build an insert query. DMZ uses the CodeIgniter ActiveRecord methods, so you might be able to use those to build the query.

One thing that would be a real problem (and why I wouldn't include this as a core function) is that there is no way to retrieve the IDs of the newly inserted rows. This makes it difficult to support, since you cannot modify or reference new items.[/quote]
Thanks for the input. I'll look into the extension option.

But... I don't think the IDs are a problem. You could use the MySQL function LAST_INSERT_ID (see: http://dev.mysql.com/doc/refman/5.0/en/e...ement.html and http://dev.mysql.com/doc/refman/5.0/en/i...-insert-id). Since the value is connection specific and you don't have multi-threading in PHP you can pretty much garuantee that the return value belongs to your last INSERT and can extrapolate the IDs of the other entries from that (unless the DB is setup with an autoincrement offset other than 1, but even that could be coded around if necessary).

I think the problem of making sure that all new objects have the same fields set is much more difficult or at least expensive, since you'd have to compare every object with each other, giving you at least an n² complexity (I think).
If some objects have some fields left blank you can't use a multiple-row insert.


Edit: After looking into it a bit more it seems that CI's ActiveRecord doesn't support bulk inserts either, so I'd have to built the SQL Query from scratch, which isn't very pretty, even when done in an DMZ extension...