datasource db {
  provider = "sqlite"
  url      = "file:./../config/rss_bot_database.db"
}

model rss {
  id   Int    @id @unique(map: "sqlite_autoindex_rss_1") @default(autoincrement())
  link String @unique(map: "sqlite_autoindex_rss_2")
  last String
  name String @unique(map: "sqlite_autoindex_rss_3")
}

datasource db {
  provider = "sqlite"
  url      = "file:./../config/rss_bot_database.db"
}

model rss {
  id      Int    @id @unique(map: "sqlite_autoindex_rss_1") @default(autoincrement())
  link    String
  last    String
  name    String
  chat_id Int    @default(0)
}

model setting {
  id             Int     @id @unique @default(autoincrement())
  show_changelog Boolean @default(true)
  last_version   String
  chat_id        Int     @unique
  delay          Int
}

npx prisma migrate dev --name multichat

Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "rss_bot_database.db" at "file:./../config/rss_bot_database.db"

- The migration `20220503190343_multichat` failed.
- Drift detected: Your database schema is not in sync with your migration history.

The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database.

It should be understood as the set of changes to get from the expected schema to the actual schema.

[+] Added tables
  - rss

[*] Changed the `rss` table
  [+] Added unique index on columns (name)
  [+] Added unique index on columns (link)
  [+] Added unique index on columns (id)
- The migrations recorded in the database diverge from the local migrations directory.

✔ We need to reset the SQLite database "rss_bot_database.db" at "file:./../config/rss_bot_database.db".
Do you want to continue? All data will be lost.

const getActiveUsers = await prisma.user.findMany({
  take: 10,
  orderBy: {
    posts: {
      _count: 'desc',
    },
  },
})

where

SELECT "Resource".*
    FROM "Resource"
    LEFT JOIN "Appointment" ON "Appointment"."resourceId" = "Resource"."id"
    WHERE "Appointment"."id" IS NULL
    OR NOT (
        "Appointment"."startAt" < ${range.endDate}
        AND ("Appointment"."startAt" + INTERVAL '1 Minute' * "Appointment"."duration") > ${range.startDate}
    );

prisma.resource.findMany({
    where: {
      appointments: {
        none: {
          startAt: { lt: range.endDate },
          // How do I query:
          // ("Appointment"."startAt" + INTERVAL '1 Minute' * "Appointment"."duration") > ${range.startDate}
        },
      },
    },
  });

model User {
  id                         Int                          @id @default(autoincrement())
  username                   String?                      @unique 
  Post                       Post[]   
  PostLike                   Post[]                       @relation("likeTable")
}

model Post {
  id          Int           @id @default(autoincrement())
  content     String?
  userId      Int
  user        User          @relation("posts", fields: [userId], references: [id])
  Likes       User[]        @relation("likeTable")
}

imageID   String  @id @default(auto()) @map("_id") @db.ObjectId
    messageID String?
    userID    String?
    guild     String?
    channelID String?
    logID     String?

    url String

    type            String
    interactionType String?

    isVideo Boolean?

    tags       String[]
    likedBy    Users[]  @relation(fields: [likedByIds], references: [id])
    likedByIds String[]
}

model Users {
    id             String   @id @map("_id")
    premium        Boolean  @default(false)
    tagsSuggested  Int      @default(0)
    baraRequested  Int      @default(0)
    isContribuitor Boolean  @default(false)
    liked          Images[]
}

await prisma.userAgent.aggregateRaw({
    pipeline: [
      {
        $search: {
          compound: {
            must: [
              {
                text: {
                  query: "opera",
                  path: {
                    wildcard: "*",
                  },
                },
              },
              {
                equals: {
                  path: "application_id",
                  value: 'ObjectId("6284913de2e5beb0e6336033")',
                },
              },
            ],
          },
        },
      },
    ],
  });

yarn

npx prisma init

Prisma

yarn add

Need to install the following packages:
  prisma
Ok to proceed? (y) 
> Downloading Prisma engines for Node-API for debian-openssl-1.1.x

(new PrismaClient()).album

.findMany()

The table 'public.Album' does not exist in the current database.

(new PrismaClient()).album

{}

type User {

id: String

stats: Stats

}

type Stats {

id: String

}

User {
 stats: (parent, args, context) => {
  return context.newPrisma.user.findUnique({
    where: { id: parent.id },
  }).stats();
 }
}

// prisma.client.ts
export type Post {
  decimal: Prisma.Decimal
}

// post.entity.ts
class Post {
  decimal: string
}

// post.controller.ts
async function findOnePost(): Promise<Post> {
  return prisma.post.findOne() 
}

npx prisma db pull

npx prisma generate

The column new does not exist

new

prisma migrate

That's the error I get: :sob:{
    "errors": [
        {
            "message": "\nInvalid `prisma.queryRaw()` invocation:\n\n\n  Raw query failed. Code: `42601`. Message: `db error: ERROR: syntax error at or near \"$1\"`",
            "locations": [
                {
                    "line": 2,
                    "column": 3
                }
            ],
            "path": [
                "getCars"
            ],
            "extensions": {
                "code": "INTERNAL_SERVER_ERROR",
                "exception": {
                    "code": "P2010",
                    "clientVersion": "3.13.0",
                    "meta": {
                        "code": "42601",
                        "message": "db error: ERROR: syntax error at or near \"$1\""
                    },
                    "stacktrace": [
                        "Error: ",
                        "Invalid `prisma.queryRaw()` invocation:",
                        "",
                        "",
                        "  Raw query failed. Code: `42601`. Message: `db error: ERROR: syntax error at or near \"$1\"`",
                        "    at Object.request (C:\\Users\\Giorgia.Mazzini\\Documents\\learninggraphql\\smarter01\\BE\\node_modules\\@prisma\\client\\runtime\\index.js:45629:15)",
                        "    at async Proxy._request (C:\\Users\\Giorgia.Mazzini\\Documents\\learninggraphql\\smarter01\\BE\\node_modules\\@prisma\\client\\runtime\\index.js:46456:18)"
                    ]
                }
            }
        }
    ],
    "data": {
        "getCars": null
    }
}

getCars: (_parent, { input }, { prisma }) => {
    if(input){

        console.log(input) // --> SELECT * FROM car WHERE car."plate" ILIKE '%123%'  //type String
        const differentInput = '%123%'

        // const result =  prisma.$queryRaw`SELECT * FROM car WHERE car."plate" ILIKE '%123%'` // works
        // const result =  prisma.$queryRaw`SELECT * FROM car WHERE car."plate" ILIKE ${differentInput}` // works
        // const result =  prisma.$queryRawUnsafe(input) // Works

        const result =  prisma.$queryRaw`${input}` // Doesn`t work!!!!
        return result

    }
    // ... Other code
  }

The column (not available) does not exist in the current database

prisma.cities.findFirst({

where: {

name: {

equals: name,

mode: "insensitive",

},

},

});

» npx prisma migrate dev --name add_config --create-only
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "xxx", schema "public" at "<http://xxx.b.db.ondigitalocean.com:25060|xxx.b.db.ondigitalocean.com:25060>"

Error: P3006

Migration `20220222031047_init` failed to apply cleanly to the shadow database. 
Error code: P1014
Error:
The underlying table for model `migrations` does not exist.