handling field conflict about pg-simplify-inflector HOT 7 CLOSED

You’re almost there; change the ’categoria’ to ’@foreignFieldName products’ (but watch out for the smart quotes my phone added - sorry)

from pg-simplify-inflector.

I have restarted the server and works.
Thanks!

from pg-simplify-inflector.

As a shortcut for single-key relations? That seems a reasonable idea, but what would we call the forward relation part on the same column? Maybe the smart comment should be slightly different, e.g. “relationFieldName” / “relationForeignFieldName”?

from pg-simplify-inflector.

I need to add a smart comment to use "products" instead of "productsByCategoryId" in the relationship one to many. Where I should add that comment? directly in postgres?

I have two tables:
products

• name
• categoryId

categories

• name

I am trying this:
COMMENT ON CONSTRAINT "productos_categoriaId_fkey" on productos is 'categoria' .
but not works.

from pg-simplify-inflector.

Yes, I have tried that, but the response is always the same and don't works.
This is the query that I run in pg Admin.

And this is my query in Graphiql.

from pg-simplify-inflector.

In the second query you’re querying productosCategorias (not productos) so I’d expect constraint named something like productos_categorias_categoryId_fkey

from pg-simplify-inflector.

But there is not constraint on productosCategorias table, because the fk is on productos table.

from pg-simplify-inflector.