ORM Plugin cache relationships when query

[Hanmo123]

ORMs like eloquent allow api return a resource with defined relations(hasOne, hasMany, belongsToOne, belongsToMany, hasOneThrough). For example, when query a post, a user data might be return at the same time:

GET /api/v1/posts/1

{
  "data": {
    "id": 1,
    "title": "xxx",
    "user": {
      "id": 1
    }
  }
}

In this situation, pinia-colada can provide an option to define relationships, and then when successfully responded, colada can put the user into cache, so that we can query the user directly from cache instead of query again.

[posva]

Having an ORM plugin would be cool. I think most of the time you don't need an ORM but can get the benefits with auto generated queries and mutations with openapi-ts or similar. The benefit of an approach like Pinia Colada is that it lets you handle your service layer however makes more sense for your app. That way you don't have to write code you don't use.

In order for something like this to go forward, it would need a lot more details and use cases 😄

[Hanmo123]

Sorry, I'm not quite sure what openapi does here. I learned that openapi is an api specification, then how does it allow pinia-colada to cache related models?

BTW, If you don't have plans to support this feature, is there a way to manually set cache for the query above useUserQuery without using queryCache.ensureDefinedQuery(this method will send the request immediately)?

[posva]

You can setQueryState.

[Hanmo123]

You mean setEntryState? Currently i am using this.

[posva]

Both work 🙂
BTW I'm available for paid help

[Hanmo123]

Sorry for my mistake that the query was triggered incorrectly, the statement mentioned above queryCache.ensureDefinedQuery will send query immediately is false.

Thanks again for your work.