Doctrine 2.1 – Map entity to multiple tables

I have the following database situation:

wp_users (user table generated by wordpress)
ID | user_login | ... 

wp_sp_user (extension to the wp_users table)
ID (FK) | surname | address | ... 

Now I’ve already been trying for hours to “fuse” those two tables into one single User entity, e.g:

Read More
class User {
  var ID;
  var user_login;
  var surname;
  var address;
  ...
}

Is there any way to accomplish such a mapping without modifying the wp_user table (which I don’t want to do for updating reasons)?

Related posts

Leave a Reply

2 comments

  1. This is not possible. It also doesn’t make sense to do so.

    You will need to physically merge the tables together in MySQL and create a Doctrine entity for that table. This is the only way you can ensure your data is clean and fully normalized.

    Another possible solution is to create one entity for each table and use a business object to combine results from each. This is not a very nice solution at all, as you will have to handle constraints on the application layer, and you will double the amount of queries you launch.