php: dividing a multitable select into several objects / object structure

let me at first state that we use php and postgre database. In our project we have decided not to use any ORM due to its overload of sql queries and we are taking the oposite way. Imagine you have a select from several tables, lets say joined on id columns. For instance: * tables: users(id, name), items(id, name, description), comments(user_id, item_id, text, rating) So basically you have a table of users, a table of some items and a table of comments which are related to one user and one item. You create two objects - user and item representing their table row. And then you want to create a comment object. In an ORM it would contain objects user and item and they would load themselves with their queries, but that would be two queries and you re thinking...hm but I can select that data with a single query...but how? Imagine that you have this select: * `SELECT * FROM comments JOIN users ON comments.user_id = users.id JOIN items ON comments.item_id = items.id` (you can also imagine a WHERE clause with specified item id or user id etc.) So how would you split the result of such a select into this class structure, lets say you want a list of comment objects: * user * item * comment (contains references to user and item object) So far our theoretical solution was to prefix name of the columns with fixed prefixes :) and then propagating the result into the object structure and each objects takes what it needs from the select. Any other solutions? Lets say more sophisticated? Thanks for any ideas PS: obviously I have used a very simple example, but try to imagine that the problem is far larger and the structure far more complex

以上就是php: dividing a multitable select into several objects / object structure的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » WebStorm

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏