INSERT IF NOT EXISTS with Zend_Db_Table_Row

I handle this at the level of the model using an exists($keys : Array)
method on a generic DataObject. A dataobject is like an active record.
That way you can check myDataObject->exists() to find out what you have
to do.

Regards,

Bart McLeod

Kevin Hallmark schreef:

I actually ended up solving my problem at the SQL level.

I was tracking statistics. I'm tracking each and every hit of 6
different types to an incredibly simple table. I also needed to track
the daily aggregate of hit types, per 'page' per day ('page' is the data
I'm tracking for). For ease of generating reports, I wanted all the
different hit types in one row. (Generating the report I needed would
have required 6 queries per row for 'page' listings sometimes totaling
hundreds of 'pages' so 6*x where x is the number of 'pages' in the list)

The reason I needed 'ignore' was so I could insert the 'page'/date keyed
row no matter what (making sure it's there). Then increment the
appropriate tally.

It turns out the best solution was an AFTER INSERT trigger. I wrote a
little stored procedure to INSERT IGNORE and then UPDATE the appropriate
hit type. Then I just call that SP from the trigger.

Kevin Hallmark
PHP Developer
Bonnier Corporation

-----Original Message-----
From: Bart McLeod [mailto:mcleod@...]
Sent: Thursday, May 15, 2008 4:01 AM
To: Kevin Hallmark
Cc: fw-general@...
Subject: Re: [fw-general] INSERT IF NOT EXISTS with Zend_Db_Table_Row

I handle this at the level of the model using an exists($keys : Array)
method on a generic DataObject. A dataobject is like an active record.
That way you can check myDataObject->exists() to find out what you have
to do.

Regards,

Bart McLeod

Kevin Hallmark schreef: ------------------------------------------------------------------------