[Backend] : Express + Prisma + TypeScriptのセットアップ

node -v

# v18.14.1

curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.7/install.sh | bash
source ~/.zshrc # または ~/.bashrc
nvm install 20
node -v  # `v20.15.0` と表示される
npm -v  # `10.7.0` と表示される
nvm alias default 20

npm init -y

npm install express
npm install typescript --save-dev
npm i --save-dev @types/express
npm i --save-dev ts-node
npm i --save-dev @types/node

npm install typescript @types/express ts-node @types/node --save-dev

npx tsc --init

{
  "compilerOptions": {
    "target": "es6",
    "module": "commonjs",
    "moduleResolution": "node",
    "outDir": "./dist",
    "esModuleInterop": true,
    "forceConsistentCasingInFileNames": true,
    "strict": true,
    "skipLibCheck": true
  },
  "include": ["src/**/*"],
  "exclude": ["node_modules"]
}

/
|-- src/
|   |-- index.ts
|-- dist/
|-- node_modules/
|-- package-lock.json
|-- package.json
|-- tsconfig.json

import express from 'express';

const app = express();
const port = 3000;
//const port = process.env.PORT || 3000;

app.get('/', (req, res) => {
  res.send('Hello World!');
});

app.listen(port, () => {
  console.log(`Server running on port ${port}`);
});

"scripts": {
    "start": "ts-node src/index.ts",　// 追加
    "test": "echo \"Error: no test specified\" && exit 1"
  },

npm start

# Server running on port 3000

/
|-- src/
|   |-- index.ts
|-- dist/
|-- .gitignore
|-- node_modules/
|-- package-lock.json
|-- package.json
|-- tsconfig.json

# Node.js
node_modules/

# TypeScript
dist/
*.tsbuildinfo

# Environment variables
.env

# Logs
logs
*.log
npm-debug.log*
yarn-debug.log*
yarn-error.log*

# Mac OS
.DS_Store

npm install prisma --save-dev
npx prisma init --datasource-provider sqlite

# ✔ Your Prisma schema was created at prisma/schema.prisma
#  You can now open it in your favorite editor.

# warn You already have a .gitignore file. Don't forget to add `.env` in it to not commit any private information.

# Next steps:
# 1. Set the DATABASE_URL in the .env file to point to your existing database. If your database has no tables yet, read https://pris.ly/d/getting-started
# 2. Run prisma db pull to turn your database schema into a Prisma schema.
# 3. Run prisma generate to generate the Prisma Client. You can then start querying your database.

# More information in our documentation:
# https://pris.ly/d/getting-started

# Environment variables declared in this file are automatically made available to Prisma.
# See the documentation for more detail: https://pris.ly/d/prisma-schema#accessing-environment-variables-from-the-schema

# Prisma supports the native connection string format for PostgreSQL, MySQL, SQLite, SQL Server, MongoDB and CockroachDB.
# See the documentation for all the connection string options: https://pris.ly/d/connection-strings

DATABASE_URL="file:./dev.db"

# Example
# DATABASE_URL="postgresql://username:password@localhost:5432/mydatabase"

# Next steps:
# 1. Set the DATABASE_URL in the .env file to point to your existing database. If your database has no tables yet, read https://pris.ly/d/getting-started
# 2. Run prisma db pull to turn your database schema into a Prisma schema.
# 3. Run prisma generate to generate the Prisma Client. You can then start querying your database.

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

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

model User {
  id    Int    @id @default(autoincrement())
  name  String
  email String @unique
}

npx prisma migrate dev --name init

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

# SQLite database dev.db created at file:./dev.db

# Applying migration `20240703124541_init`

# The following migration(s) have been created and applied from new schema changes:

# migrations/
#   └─ 20240703124541_init/
#     └─ migration.sql

# Your database is now in sync with your schema.

# Running generate... (Use --skip-generate to skip the generators)

# added 1 package, and audited 102 packages in 3s

# 12 packages are looking for funding
#   run `npm fund` for details

# found 0 vulnerabilities

# ✔ Generated Prisma Client (v5.16.1) to ./node_modules/@prisma/client in 49ms

/
|-- src/
|   |-- index.ts
|-- dist/
|-- .gitignore
|-- node_modules/
|-- prisma/
|   |-- migrations/
|   |   |-- 20240703124541_init/
|   |   |-- migration_lock.toml
|   |-- dev.db
|   |-- dev.db-journal
|   |-- schema.prisma
|   |-- seed.ts
|-- package-lock.json
|-- package.json
|-- tsconfig.json

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
  // Example seed data
  const users = [
    {
      name: 'Alice',
      email: 'alice@example.com',
    },
    {
      name: 'Bob',
      email: 'bob@example.com',
    },
  ];

  for (const user of users) {
    await prisma.user.create({
      data: user,
    });
  }

  console.log('Seed data inserted successfully.');

  // Disconnect Prisma Client
  await prisma.$disconnect();
}

main()
  .catch((e) => {
    console.error('Error seeding data:', e);
    process.exit(1);
  })
  .finally(async () => {
    // Ensure Prisma Client is disconnected
    await prisma.$disconnect();
  });

{
  "name": "express-prisma-template",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "start": "ts-node src/index.ts",
    "build": "tsc",
    "dev": "nodemon src/index.ts",
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "prisma": {
    "seed": "ts-node prisma/seed.ts"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "dependencies": {
    "@prisma/client": "^5.16.1",
    "express": "^4.19.2"
  },
  "devDependencies": {
    "@types/express": "^4.17.21",
    "@types/node": "^20.14.8",
    "prisma": "^5.16.1",
    "ts-node": "^10.9.2",
    "typescript": "^5.5.2"
  }
}

npx prisma db seed

# Environment variables loaded from .env
# Running seed command `ts-node prisma/seed.ts` ...
# Seed data inserted successfully.

# 🌱  The seed command has been executed.

npx prisma studio

npx prisma migrate reset

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

# ? Are you sure you want to reset your database? All data will be lost. › (y/N)

# Applying migration `20240703124541_init`

# Database reset successful

# The following migration(s) have been applied:

# migrations/
#   └─ 20240703124541_init/
#     └─ migration.sql

# ✔ Generated Prisma Client (v5.16.1) to ./node_modules/@prisma/client in 48ms

# Running seed command `ts-node prisma/seed.ts` ...
# Seed data inserted successfully.

# 🌱  The seed command has been executed.