Prisma

docker-compose_yml.txt

I was using above file to do prisma deploy . I am getting below mentioned error running that command .

-.txt

It looks like your prisma instance could not connect to a postgres server. Did you forget to add the "postgres" service in docker-compose.yml ?

If the postgres is running on your host machine, use `host.docker.internal` as the postgres host instead of localhost if you have docker &gt;= `18.03`. JS logs are rarely helpful here, consider looking into the docker logs of the Prisma container to find relevant info to post.

Hello, I would be very grateful, if someone could answer my question about Prisma at stackoverflow. <https://stackoverflow.com/questions/52591611/specifying-prismas-database-name-in-postgresql>

Error: Variable '$where' cannot be non input type

Did add detailed  description of the issue in the conversation

I did deploy a prisma server on a localhost postgres from the datamodel generated using prisma introspect .
Now that the server is running I  was trying to run the query below .

-.php

And I created a client by generating using prisma and I am using a filter . Following snippet has index.js of client

-.js

I was wondering why it isn't working in playground and client ?

If I am trying to load schema it isn't working

Is there a good way to get similar types generated for an Angular app as Prisma Bindings generates? Apollo’s codegen doesn’t seem to do what I want (or work, really).

<@U8QT4GH1S> you can try out GraphQL Code Generator. It's here <https://github.com/dotansimha/graphql-code-generator>

Hoping this is the right place for this. When I try to deploy via cli in my terminal, it just asks me to authenticate over and over

I'm not able to deploy my changes
`graphcool deploy` just results in the cli opening a new browser tab to auth every time I click the "Auth" button

Hi

How can I handle a Middleware with the library next-routes?

For example, in the server.js file I use:

const server = express()

server.get("/", myAwesomeMiddleware, (req, res) =&gt; handle(req, res));

Thanks :grin:.

I am getting above errors for prisma deploy .

Alert_offer , Checkout_order_offer are associate entities created to capture manyToMany relation.

Is "id" a mandatory field for all tables ?

<@UD3MGP8TA> let's continue the conversation in this thread :slightly_smiling_face:

no, `id` is not mandatory for all tables. But _if_ you want to use `id`, you have to conform to certain possibilities. Can you share your datamodel?

I don't want to use 'id' for all tables .

I was generating prisma model from existing postgres model

create table alert_offer
(
  sale_alert_id bigint not null
    constraint fkkalfe7keier2t8lv4mpr8dtjr
    references sale_alert
    on update restrict on delete restrict,
  offer_id      bigint not null
    constraint fkeg0evpjnarifhv4cbs339lqn9
    references checkoutoffer
    on update restrict on delete restrict,
  constraint idx_404828_primary
  primary key (sale_alert_id, offer_id)
);

create index idx_404828_fkeg0evpjnarifhv4cbs339lqn9
  on alert_offer (offer_id);

I suggest you share a reproducible bug report here, so we can figure out what the problem is: <https://github.com/prisma/prisma/issues/new?template=bug_report.md>

Above model defines the model which is giving the error

"Alert_offer
    :heavy_multiplication_x: The required field `id` is missing and has to have the format: id: ID! @unique or id: UUID! @unique or id: Int! @unique."

datamodel-old.prisma

This the schema created by prisma introspect

<@U0RQY0KK5> will add to github . But do have a look at schema created by prisma.

<https://github.com/prisma/prisma/issues/3236>

If I am not wrong I see the reason for failing my model is


  "fail if a model does not specify an id field at all for a passive connector" in {
    val schema =
      """
        |type Todo {
        |  title: String
        |}
      """.stripMargin
    val result = SchemaSyntaxValidator(schema, isActive = false).validate
    val error1 = result.head
    error1.`type` should equal("Todo")
    error1.field should equal(Some("id"))
    error1.description should include(
      s"The required field `id` is missing and has to have the format: id: ID! @unique or id: UUID! @unique or id: Int! @unique.")
  }

Hi <@U6WCWHPPV>, could you please create an issue for this here: <https://github.com/prisma/prisma-cloud-feedback>?

<https://github.com/prisma/prisma-cloud-feedback/issues/214>

<@U0RQY0KK5> Can we restrict prisma to generate only Query API's and not mutation API's for existing db's ?

No, you can't :slightly_smiling_face: But you can build a layer on top of the Prisma API to restrict operations

I built a data pipeline which gets data from various sources and put it in data warehouse(postgres) . We are planning to build analytics dashboard and I thought prisma could be fit to avoid me writing lot of rest API's for GET calls . It as wells removes dependency of frontend guy waiting for API's :slightly_smiling_face: . I will build a layer on top but I think what I have is a valid generic use case and it would be great if you could support it in future.

Has anyone done any comparison between Prisma and other stuff is starting to appear out there? Like Postgraphile, Strapi, Loopback 4… etc.

<@U7VF7DGT1> if I am not wrong prisma uses Postgraphile for postgres database.

Not correct, we have an own adapter implementation.