Accessing Data Across Modules

[rezabayati1]

Hey everyone,

Let's consider a scenario where we have two separate modules: the user module and the posts module. The user module contains information about users, while the posts module holds information about posts made by these users. Now, the challenge is to retrieve users along with their corresponding posts from the user module.

Could anyone share their insights or experiences on this topic? It would be helpful to see some example code or suggestions on how to achieve this efficiently

[Sairyss]

You can have a read module and create queries there that join users and posts and anything you want.

Discussed briefly here #133

[rezabayati1]

Thank you
Could you provide an example of how you would implement that read module and create queries to join users and posts? It would be helpful to see a code snippet to better understand the process

read module is a separate module like posts or users?

[Sairyss]

Modules
  - ReadModule
    - Posts
        - GetPostsQuery

class GetPostsQueryHandler {
  execute() {
       return database.query('select * from posts p inner join users u on p.user_id = u.id');
  }
}