Hello! Could someone please take a peek at this discussion! https://github.com/prisma/prisma/discussions/12293

👋 Hello, team!

glad i found your slack channel 🙂

i have a question regarding Postgres daterange, i know it's not supported yet but i have a hard time implementing it with

prisma.$queryRaw

as an example this query:

SELECT *
FROM IMPACTS
WHERE COMPANY_ID = 1
AND '[2020-01-01,2020-12-31]'::daterange @> during
GROUP BY 1
ORDER BY 1 ASC

this exact query return me this error ( using Express 😞

{
  "error": {
    "code": "P2010",
    "clientVersion": "3.10.0",
    "meta": {
      "code": "N/A",
      "message": "error deserializing column 2: cannot convert between the Rust type `core::option::Option<alloc::string::String>` and the Postgres type `daterange`"
    }
  }
}

Well, you do have quotes around the date array (not sure that is the string that is referred to though)

Hi … I am trying to query based on whether JSON is null, but keep running into

Type 'string' is not assignable to type 'JsonNullableFilter'.

This is the query on Postgres. I have added

filterJson

as a preview feature and run prisma generate. Is it supposed to be different?

my_users = await this.prisma.user.findMany({
        where: {
          metadata: Prisma.AnyNull,
        },
      })

Hi guys. Does anyone use SvelteKit with prisma? I wanted to know the recommended way to handle db connections. I currently have the

PrismaClient

instance passed in the hooks.ts file so that all endpoints can access it but I get a warning after some time about having upto 10 instances running. Would it be better to just create a client instance within every endpoint?

Can someone help me align the return types correctly works:

export const FindUsers = async (): Promise<ReturnType<typeof PrismaService.authentication.findMany> | null> => {
    try {
        const users = await PrismaService.authentication.findMany({
            where: { dtype: "checkpoint_login" },
            include: { user: true, authentication_permission: true },
        });

        return users
    } catch (err) {
        Logger.error({ method: "FindUsers", error: err, stack_trace: err.stack });
        return null;
    }
};

doesent work: ( im not sure why simplying returning a array breaks this.

export const FindUsers = async (): Promise<[ReturnType<typeof PrismaService.authentication.findMany> | null, null]> => {
    try {
        const users = await PrismaService.authentication.findMany({
            where: { dtype: "checkpoint_login" },
            include: { user: true, authentication_permission: true },
        });

        return [users, null];
    } catch (err) {
        Logger.error({ method: "FindUsers", error: err, stack_trace: err.stack });
        return [null, err];
    }
};

1. Type '(authentication & { user: user | null; authentication_permission: authentication_permission[]; })[]' is not assignable to type 'PrismaPromise<authentication[]>'.
     Type '(authentication & { user: user | null; authentication_permission: authentication_permission[]; })[]' is missing the following properties from type 'Promise<authentication[]>': then, catch, finally, [Symbol.toStringTag]

I want to be able to return an array like above, as i generally call the function using:

const [usersData, usersError] = await FindUsers();

Hi everyone 👋 I just released 2 community packages for working with Prisma schema files in Sublime Text. Related discussion https://github.com/prisma/prisma/discussions/12316 If you are using ST for working with schema files, do give these packages a try. Happy to answer any questions as always !

Hey seems to me like aws-us-east-1.prisma-data.com is down.. no DNS record available?

Hi team, I am updating my repo, its an old app and its using 2.5.1, so from today git protocol was full disabled by GitHub https://github.blog/2021-09-01-improving-git-protocol-security-github/ and I found https://github.com/prisma/prisma/blob/2.5.1/src/packages/engine-core/package.json#L47 so should be updated to remove git protocol ?

I was trying to find out what’s the branch for 2.5.1 tag? I would like to fix the issue with git protocol

tfw the prisma releases are all about mongo 😞

Adding a record to the db where the record is associated with another record. in the schema: Email - is associated with a Person (PKPersonID), which is also the EntityID

model Email {
  EmailID        Int       @id @default(autoincrement()) @db.Int
  EntityID?       Int       @db.Int
  EntityTypeID   Int       @db.TinyInt
  EmailAddress   String    @db.VarChar(50)
  EmailTypeID    Int       @db.Int
  Description    String?   @db.VarChar(100)
  Active         Boolean?   @default(false) @db.Bit
  ActiveFromDate DateTime  @db.Date
  ModifiedDate   DateTime?  @default(now()) @db.DateTime
  ModifiedBy     String    @db.VarChar(30)
  ValidFromDate  DateTime?  @db.DateTime2
  ValidToDate    DateTime?  @db.DateTime2
  EmailType      EmailType? @relation(fields: [EmailTypeID], references: [EmailTypeID])

  /// One to many relation with Person Entity through EntityID <-> PKPersonID
  Person      Person? @relation(fields: [EntityID], references: [PKPersonID])
}

Getting data isn't a problem, but when I try and Create a new email for an existing person: JSON sent to API server

const tempEmailBody = {
      'EntityID:': PKPersonID,
      'EntityTypeID': 1,
      'EmailAddress': email,
      "ActiveFromDate": this.currentDate,
      "ModifiedDate": this.currentDate,
      "ModifiedBy": "MDD Admin Tool - modified",
      'Active': true
    }

I get an error:

Unknown arg `EntityID:` in data.EntityID: for type EmailCreateInput. Did you mean `EntityTypeID`? Available args:
type EmailCreateInput {
  EntityTypeID: Int
  EmailAddress: String
  Description?: String | Null
  Active?: Boolean | Null
  ActiveFromDate: DateTime
  ModifiedDate?: DateTime | Null
  ModifiedBy: String
  ValidFromDate?: DateTime | Null
  ValidToDate?: DateTime | Null
  EmailType?: EmailTypeCreateNestedOneWithoutEmailInput
  Person?: PersonCreateNestedOneWithoutEmailInput

if I try and use Person

const tempEmailBody = {
      'Person:': PKPersonID,
      'EntityTypeID': 1,
      'EmailAddress': email,
      "ActiveFromDate": this.currentDate,
      "ModifiedDate": this.currentDate,
      "ModifiedBy": "MDD Admin Tool - modified",
      'Active': true
    }

I get the error:

Unknown arg `Person:` in data.Person: for type EmailCreateInput. Did you mean `Person`? Available args:    
type EmailCreateInput {                                                                                    
  EntityTypeID: Int                                                                                        
  EmailAddress: String                                                                                     
  Description?: String | Null                                                                              
  Active?: Boolean | Null                                                                                  
  ActiveFromDate: DateTime                                                                                 
  ModifiedDate?: DateTime | Null                                                                           
  ModifiedBy: String                                                                                       
  ValidFromDate?: DateTime | Null                                                                          
  ValidToDate?: DateTime | Null                                                                            
  EmailType?: EmailTypeCreateNestedOneWithoutEmailInput                                                    
  Person?: PersonCreateNestedOneWithoutEmailInput                                                          
}

IF I try and build something that creates a PersonWhereUniqueInput

const tempEmailBody = {
      'Person:': {'PersonWhereUniqueInput': {PKPersonID: this.onePerson.PKPersonID} },
      'EntityTypeID': 1,
      'EmailAddress': email,
      "ActiveFromDate": this.currentDate,
      "ModifiedDate": this.currentDate,
      "ModifiedBy": "MDD Admin Tool - modified",
      'Active': true
    }

I get the error:

Unknown arg `Person:` in data.Person: for type EmailCreateInput. Did you mean `Person`? Available args:
type EmailCreateInput {
  EntityTypeID: Int
  EmailAddress: String
  Description?: String | Null
  Active?: Boolean | Null
  ActiveFromDate: DateTime
  ModifiedDate?: DateTime | Null
  ModifiedBy: String
  ValidFromDate?: DateTime | Null
  ValidToDate?: DateTime | Null
  EmailType?: EmailTypeCreateNestedOneWithoutEmailInput
  Person?: PersonCreateNestedOneWithoutEmailInput
}

Should probably update the announcement post to specify that the document filters are for mongodb

Hi, how can I

connectOrCreate

where multiple fields match. Or how can I use

where: {AND: [{},{}]}

operation inside

connectOrCreate

?

can someone share an implementation of the PostgreSQL Daterange please ? I'm having a hard time getting it to works something like this

prisma.$queryRaw`
SELECT *
FROM MyTable
WHERE COMPANY_ID = 1
AND "[2020-01-01,2020-12-31]"::daterange @> during
GROUP BY 1
ORDER BY 1 ASC`

something like that where the date range is inclusive of bounds ( aka getting the whole day until 2020-12-31 000000 for say )

Is there a method on where I can save the current state (data) of my db (like postgresql SAVEDPOINT), then make some queries and mutatiosns and finally rollback to that savedpoint. This would be very handy in E2E tests so I can I always start with the same state of data between tests. Is there a way people is doing this with prisma?

Hey guys, got an existing project running prisma 2.26. Did a fresh git clone, running npm i I am getting: No matching version found for @prisma/engines-version@2.30.1-2.b8c35d44.... Any help?

Hey guys looking for some typescript help. I have a dynamic upsert function like so

ctx.prisma[`${var)Model`].upsert(....

Typescript automatically creates a union with the variable possiblities but as these models have different fields I get an error like

Each member of the union type '(<T extends  ....  ..... => CheckSelect<...>)' has signatures, but none of those signatures are compatible with each other.

Is there anyway to fix this problem?

I'm using VS Code with the Prisma extension. I'm also using Next.js with javascript and not typescript. When I'm doing a CRUD operation it would be handy if a model could be shown in VS Code, so you wouldn't have to lookup your model in the schema, while coding. Can I make it happen with some settings somewhere? Else it's a proposal/feature request from my side to add for the extension or the package. I think it would be very useful

const newOrder = await prisma.Order.create({

data: {

// Hmm... How did the Order model look like again..? Do I really have to go to my schema to view it? can't it be shown in VS code when hovering "Order" or while typing?

},

});

Would you like me to create a feature request of this on github?

Hello everyone iam madhusha

Hey, I’m wondering about how we get intellisense with Typescript … so if I have a model named say users, I can see this on the prisma object …

Hi everyone! 👋

Hi everyone! I would like to fix something in old version, specific 2.5.1 since GitHub full disabled git protocol yesterday, I checked the code and I didn’t find branch for 2.5.1 tag, so can anyone help me to find it? to remove this git ref https://github.com/prisma/prisma/blob/8e8412d6419de1f2691d00e9cc0d740de7f729b0/src/packages/engine-core/package.json#L47

Hello, we have a weird case with connection pooling and interactive transactions. We have a pool size of max 3 connections. We open an interactive transaction and also execute queries that aren’t bound to this transaction at the same time

For how long does Prisma keep idle connections around in the context of postgresql?

Hello, I'm attempting to migrate my backend from Sequelize to Prisma, and referring to this doc: https://www.prisma.io/docs/concepts/more/comparisons/prisma-and-sequelize The very first thing I'd like to do now that it's installed and is make Prisma the source for migrations. Even after running an introspection though, when I first run a migration, it seems like I MUST delete all my data in the postres DB. This is locally on dev by the way. Is there any way to do this without losing all my data?