Deno Fresh + Prisma ORM + MSSQL

deno_fresh_prisma_orm_mssql_database.md

Deno Fresh with Prisma ORM and MSSQL

1. Add this line in deno.json

{
  "nodeModulesDir": "auto",
}

2. Create file .env

DATABASE_URL="sqlserver://YOUR_DB_URL:YOUR_DB_PORT;database=YOUR_DB_NAME;user=YOUR_DB_USERNAME;password=YOUR_DB_PASSWORD;encrypt=true;trustServerCertificate=true"

3. Create file prisma/schema.prisma

generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
  runtime  = "deno"
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

4. Install these packages

deno i -D npm:prisma npm:@prisma/client npm:dotenv-cli

5.1.1. Run this to create new schema model

deno run -A npm:prisma init --datasource-provider sqlserver --generator-provider prisma-client --with-model

5.1.2. Run this to push schemal model into your MSSQL server

deno run -A npm:prisma db push

5.2. Run this to pull existing schema model from MSSQL server

deno run -A npm:prisma db pull

6. Run this to generate prisma client.ts

deno run -A npm:prisma generate

7. Add this line to your .ts or .tsx where you want to use your ORM logic

import { FreshContext, Handlers } from "$fresh/server.ts";
import { PrismaClient } from "../generated/prisma/client.ts";

Tags:
#denofresh
#deno
#prisma
#orm
#mssql
#sqlserver

#denofresh
#deno
#prisma
#orm
#mssql
#sqlserver