Modify all queries in Zend\Db (add where)

Question

I need to modify all queries that are executed through Zend\Db before sending them to DB.

Basically it needs to add additional WHERE statement to all selects, updates and deletes and additional column and value in inserts.

I was thinking about writing my own TableGateway feature for that, the problem is that I would like to avoid being restricted to TableGateway alone and have this functionality while using Zend\Db\Adapter and TableGateway at the same time.

Thomas Dutrion · Accepted Answer · 2016-02-26 17:30:53Z

1

You can have a look at some of the events dispatched from the table gateway if that make sense in your context: http://framework.zend.com/apidoc/2.4/namespaces/Zend.Db.TableGateway.Feature.EventFeature.html

There is a preSelect event that is triggered and which you can probably listen to.

answered Feb 26, 2016 at 17:30

Thomas Dutrion

1,8931 gold badge11 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adam Over a year ago

thanks Thomas, the problem is that all Features are for TableGateway only, I need to have such flexibility of altering queries on an adapter level.

Adam · Accepted Answer · 2016-02-29 16:49:33Z

1

I have ended up writing custom db adapter that handles all the logic. I'll probably share it as an open source if I'll have a time to clean up the code.

answered Feb 29, 2016 at 16:49

Adam

8738 silver badges33 bronze badges

Collectives™ on Stack Overflow

Modify all queries in Zend\Db (add where)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related