Modeling help request about electrodb HOT 4 OPEN

@aisflat439 I checked out your Playground (thank you for doing that btw, it is very helpful) and it looked like the error was that the product entity referenced warehouseId as a composite attribute but warehouseId was not defined in attributes. I changed that, and removed the export keywords (the playground doesn't like those right now) and everything is now running just fine:

https://electrodb.fun/?#code/PQKgBAsg9gJgpgGzARwK5wE4Es4GcA0YuccYGeqCALgUQBYCG5YA7llXWAGbZwB2MXGBDAAUKKwBbAA5QMVMAG8wAUT5V2AT0IBlTADcsAY1IBfbhiiSwAIkRwjVSzABGNgNzijUPrgVUGFwRSAF5bTShUDAB9AKC4aL4GSTgPLx8-MAAFZ1RHNQ0qTTAwvjgWVXUtAAowUTAleoawSVhEAC5G5ub9TFwsH06bAEYbfCbu-kLNIZzYPKoxiebiDEMTIbl4DFwl7tNx7oYqJywXVCo8TsVlhpYmODpI4gBJGGvb5qLpOCG-bD4AHM9t0wAdPtJco43h9QV9ND8-qcgSC4eQ0FhyO8wE50IdQeC4UkUrC4TiEb9bP8sCj8Wi4BisZ1cXA6c1CaD4LgjNhpBpBl0yd9KTZqbTPhzupDjJSbmTyYjbHxUJIXJhUey2Q1vKh1KS4cKhsrVeqtWC2ZKwDT4AAPK6C7rAYA4uhYIQIN00MCQ+aOXCfBpOq1UADkQikPwwXAcCnOCigAGsGJoIVCaPrQdIExm4VwcAhsTYsxq4d4ZFB+pdOgBtAC6Zoalu6uGzDrJecQhZbJdBZdklcp1aLabeNnrAbBErN93IT1QxDmMAWuBzzW8CGCjgGfCGM8ezzgi+XPYa1rgNqGgP6owb3tbcvl3HzhavWGGxdv2qs-fYg5se7nV4YDHW8mxWe8JwaDsC0va9u0-MA+wrX8a2HX0qFHcd5VMKdlhwxt8UUOJgnBABKdJfAUAB1B5ALgAotBKMAygqBiilqJoHwaVp4AQVdeh2bchhvT4pi0IYaNnA8e1WdYRS2PoNUtY5Tjje0uOaACDxhNtukNKlkWBW90VQTE4GxFkzTA4lZQnfTRUMk8yAZUymRxDA8VwuEGBgGByFwFddPhRUHIBIyJxMsyLI81kvNBSQGCSQFMFXBp7LFcK4UtS0zztQKNLuWiD3yicgw4N0wA9PwhC0+c8DqeUg3YMMrRkTBo0cMA4zARNkwnddN35HdbFq4hdlvLNUuaaDCw-SDEO-ZCqzAOtQNvFspqg58-gTJyv3LAdUNGuBMNAuLumOo8-SmgaYyEkairqq6aCc3LYLfJzJqC7oZve99doQpDDpW-9HqAkCJzAhoNu+6bttsV9hng+agZQlasLJfCCQtJoOSIwISNEcjxAYXBND4IxuF1LcfEQ8hjkPNNqhszoMsILkeSwPltwAflZwywAAH2YygEHxaUTD5kWTQwIWRY3QgdXUKXjTVWXheVDdSLbcgqCiPhsjTNjNAAOh5OAGeqArvRHLsrDgABaVBTOAwgnUoLAYGqUizRss0Od5IbOgDrmhqF4WbB7CXKWj8OwAABjNJWqE6ZO4-jvDSJNwEoG90QcJJsmKapimw-NhnJP3OqreY5JWTAHy-LwIRTGuWuSSIQzCEb-zcCljK5c1sWbfQt5+4FjXRbBbWH11-WwErujjZNppy8uK3lh75vOi3gK48jtk-eWY6dNFe2HagDhMCdl2xjAIMPa9n3caznO84LoMABVXRquQEyEQE9MqAAEJRCk3JpTLg1Mw6NwgIlBgyUMDVBPtiNm7dfgZRnssOeGADaLwPMvVA0gYCW2tigi0WdiBUA3nCBKSUUroIodnXOyh-KyF8CKBgG5EjlBsNPfO4ggwvBDNYKBG5igIArAoJ4FQqBQDADAeR5UVyiCEawRKlwYA4nkebC2lxCDdWEdYBgjhUBcIQMUIhJCNBAlUc6KijAFAvHUeoK0QhcD23KkCSqWAExwBNgEuxYB5w0kBC6UgPolzQhgIQKh4SwD6C4egIJUAuDqKknVN4rB2CcAYAtXUVAwFF0gdA7cDdfLPU-lAfB1cUH8zCoQSJCwdKYJ1nAPWuDDboUIcQ0hqZR4xMzibKhNDQTkM+EGZOnQADU0yhlv3IgXbwlF0lVyAkxEMLA6AO2GPHeOIZPDLMyE06JGziEOwAKx7IOSTCpaYqk1OIMgsGJ0YkjyiRhGApF3BAA

Can you verify if this is what you'd expect?

from electrodb.

I can take a look at this more closely tonight 👍

from electrodb.

Thanks in advance! I think what I need is to create a service to manage the join.

from electrodb.

Just to chime in ... this is actually very helpful for me getting started with M2M relations, maybe this should be part of the documentation some time?

Also a question: I have almost the same situation BUT need to query on warehouseId to retrieve a single warehouse so I swapped the sk and pk as in this snippet:

const WarehouseEntity = new Entity( 
  // ...
  indexes: {
      warehouses: {
        collection: "warehouses",
        pk: {
          field: "pk",
          composite: ["warehouseId"],
        },
        sk: {
          field: "sk",
          composite: [],
        }
      },
  // ...
});

And then the very basic function:

async function getWarehouse(warehouseId: string) {
  return await WarehouseEntity.get({ warehouseId }).go();
}

Now my question: is this indeed the right approach for this access pattern or doesn't it matter at all?

from electrodb.