Start from scratch with SQL Server

1. Create a project directory and navigate into it:

   $mkdir hello-prisma
   $cd hello-prisma

2. Initialize a TypeScript project and add the Prisma CLI as a development dependency:

   $npm init -y
   $npm install prisma typescript ts-node @types/node --save-dev

This creates a package.json with an initial setup for your TypeScript app.

1. Next, create a tsconfig.json file and add the following configuration to it:

   tsconfig.json
   1{
   2  "compilerOptions": {
   3    "sourceMap": true,
   4    "outDir": "dist",
   5    "strict": true,
   6    "lib": ["esnext"],
   7    "esModuleInterop": true
   8  }
   9}

2. Invoke the Prisma CLI by prefixing it with npx - confirm that you can see the Prisma help screen:

   $npx prisma

3. Set up your Prisma project by creating your Prisma schema file with the following command:

   $npx prisma init

   This command created a new directory called prisma with the following contents:

   • schema.prisma: The Prisma schema with your database connection and the Prisma Client generator
   • .env: A dotenv file for defining environment variables (used for your database connection)

1. Create a project directory and navigate into it:

   $mkdir hello-prisma
   $cd hello-prisma

2. Initialize a Node.js project and add the Prisma CLI as a development dependency:

   $npm init -y
   $npm install prisma --save-dev

This creates a package.json with an initial setup for a Node.js app.

1. Invoke the Prisma CLI by prefixing it with npx - confirm that you can see the Prisma help screen:

   $npx prisma

2. Set up your Prisma project by creating your Prisma schema file with the following command:

   $npx prisma init

   This command created a new directory called prisma with the following contents:

   • schema.prisma: The Prisma schema with your database connection and the Prisma Client generator
   • .env: A dotenv file for defining environment variables (used for your database connection)

1. Create a file named index.ts and add the following sample code:

   import { PrismaClient } from '@prisma/client'
   
   const prisma = new PrismaClient()
   
   async function main() {
     // Create a user and two posts
     const createUser = await prisma.user.create({
       data: {
         name: 'Alice',
         email: 'alice@prisma.io',
         posts: {
           create: [
             { title: 'My first day at Prisma' },
             {
               title: 'How to create an Microsoft SQL Server database',
               content: 'A tutorial in progress!',
             },
           ],
         },
       },
     })
   
     // Return all posts
     const getPosts = await prisma.post.findMany({})
   
     console.log(getPosts)
   }
   
   main()
     .catch(e => {
       throw e
     })
     .finally(async () => {
       await prisma.$disconnect()
     })

2. Run the code with the following command:

   $npx ts-node index.ts

   You should see the following output:

   [
     {
       id: 1,
       title: 'My first day at Prisma',
       createdAt: 2020-10-26T08:24:10.966Z,
       content: null,
       published: false,
       authorId: 1
     {
       id: 2,
       title: 'How to create an Microsoft SQL Server database',
       createdAt: 2020-10-26T08:24:10.966Z,
       content: 'A tutorial in progress!',
       published: false,
       authorId: 1
     }
   ]

3. Change email: "alice@prisma.io" to another email address and run the code again to create another user and list of posts.

1. Create a file named index.js and add the following sample code:

   const { PrismaClient } = require('@prisma/client')
   
   const prisma = new PrismaClient()
   
   async function main() {
     // Create a user and two posts
     const createUser = await prisma.user.create({
       data: {
         name: 'Alice',
         email: 'alice@prisma.io',
         posts: {
           create: [
             { title: 'My first day at Prisma' },
             {
               title: 'How to create an Microsoft SQL Server database',
               content: 'A tutorial in progress!',
             },
           ],
         },
       },
     })
   
     // Return all posts
     const getPosts = await prisma.post.findMany({})
   
     console.log(getPosts)
   }
   
   main()
     .catch(e => {
       throw e
     })
     .finally(async () => {
       await prisma.$disconnect()
     })

2. Run the code with the following command:

   $node index.js

   You should see the following output:

   [
     {
       id: 1,
       title: 'My first day at Prisma',
       createdAt: 2020-10-26T08:24:10.966Z,
       content: null,
       published: false,
       authorId: 1
     {
       id: 2,
       title: 'How to create an Microsoft SQL Server database',
       createdAt: 2020-10-26T08:24:10.966Z,
       content: 'A tutorial in progress!',
       published: false,
       authorId: 1
     }
   ]

3. Change email: "alice@prisma.io" to another email address and run the code again to create another user and list of posts.