Bug: CreateMany Returns Error Complaining "Argument skipDuplicates Does Not Exist On Enclosing Type"

[Congyuwang]

Calling create_many() returns this error:

Error executing query: P2009 - Failed to validate the query: `Argument does not exist on enclosing type.` at `Mutation.createManyLocation.skipDuplicates`

function called: client.location().create_many(many_data).exec().await?

prisma-client-rust = { git = "https://github.com/Brendonovich/prisma-client-rust", tag = "0.6.1" }

Here is a minimal example Repo to reproduce the problem: https://github.com/Congyuwang/rust-prisma-create-many-debug

The model in the example looks like this:

generator client {
  provider = "cargo prisma"
  output   = "../src/prisma.rs"
}

datasource db {
  provider = "mongodb"
  url      = env("DB_URL")
}

model Location {
  id          String @id @default(auto()) @map("_id") @db.ObjectId
  description String
}

The main function looks like this:

pub mod prisma;

#[tokio::main]
async fn main() {
    dotenv::dotenv().unwrap();
    let client = prisma::new_client().await.unwrap();
    client.location().create_many(vec![
        ("a".to_string(), vec![]),
        ("b".to_string(), vec![]),
        ("c".to_string(), vec![]),
    ]).exec().await.unwrap();
}

To reproduce, clone the repo https://github.com/Congyuwang/rust-prisma-create-many-debug, add a mongodb DB_URL and cargo run --release.

[Brendonovich]

Hmm, forgot that skipDuplicates isn't available everywhere. Will need to make that a database-specific feature.

[Congyuwang]

Right. According to https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#createmany: skipDuplicates is only supported by databases that support ON CONFLICT DO NOTHING. Perhaps this means it's supported only by Postgres?

[Congyuwang]

skipDuplicates availability:

• Postgres: YES (https://www.postgresql.org/docs/9.5/sql-insert.html#SQL-ON-CONFLICT)
• mysql: YES (https://www.mysqltutorial.org/mysql-insert-ignore/)
• mssql: NO (https://stackoverflow.com/questions/53611915/alternatives-for-insert-ignore-into-for-sql-server)
• sqlite: YES (https://www.sqlite.org/lang_insert.html)
• mongoDB: DOUBTFUL / NO (https://stackoverflow.com/questions/34153058/mongodb-multi-document-insert-ignore-custom-duplicate-field-error)

[Brendonovich]

The availability of skip_duplicates is defined by the CreateSkipDuplicates capability, which is hardcoded on each connector. The generator and runtime will need to check whether the capability is available on the current connector.
EDIT: Though, skip_duplicates is something only in the library, so checking the capabilities may not be possible and we may have to do it based on features.

[Congyuwang]

attempted fix using feature: Fix #174