Построй бэкенд для доступа к базе данных авиаперелеты с использование nodejs фреймворка nestjs и prisma, создай схему данных и подключи APi к таблицам базы данных

# Создаем новый проект NestJS
nest new flight-api

# Переходим в папку проекта
cd flight-api

# Устанавливаем Prisma и клиент базы данных (например, PostgreSQL)
npm install prisma @prisma/client

# Устанавливаем NestJS модуль для работы с Prisma
npm install @nestjs/prisma

# Инициализируем Prisma
npx prisma init

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

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL") // Убедитесь, что переменная окружения DATABASE_URL настроена
}

model Flight {
  id          Int      @id @default(autoincrement())
  flightNumber String   @unique
  departure    String
  destination  String
  departureTime DateTime
  arrivalTime   DateTime
  price        Float
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

npx prisma migrate dev --name init

import { Global, Module } from '@nestjs/common';
import { PrismaService } from './prisma.service';

@Global()
@Module({
  providers: [PrismaService],
  exports: [PrismaService],
})
export class PrismaModule {}

import { Injectable, OnModuleDestroy, OnModuleInit } from '@nestjs/common';
import { PrismaClient } from '@prisma/client';

@Injectable()
export class PrismaService extends PrismaClient implements OnModuleInit, OnModuleDestroy {
  async onModuleInit() {
    await this.$connect();
  }

  async onModuleDestroy() {
    await this.$disconnect();
  }
}

nest generate module flight
nest generate service flight
nest generate controller flight

import { Injectable } from '@nestjs/common';
import { PrismaService } from '../prisma/prisma.service';
import { Flight } from '@prisma/client';

@Injectable()
export class FlightService {
  constructor(private prisma: PrismaService) {}

  async getAllFlights(): Promise<Flight[]> {
    return this.prisma.flight.findMany();
  }

  async getFlightById(id: number): Promise<Flight | null> {
    return this.prisma.flight.findUnique({ where: { id } });
  }

  async createFlight(data: Omit<Flight, 'id' | 'createdAt' | 'updatedAt'>): Promise<Flight> {
    return this.prisma.flight.create({ data });
  }

  async updateFlight(id: number, data: Partial<Flight>): Promise<Flight> {
    return this.prisma.flight.update({ where: { id }, data });
  }

  async deleteFlight(id: number): Promise<Flight> {
    return this.prisma.flight.delete({ where: { id } });
  }
}

import { Controller, Get, Post, Put, Delete, Param, Body } from '@nestjs/common';
import { FlightService } from './flight.service';
import { Flight } from '@prisma/client';

@Controller('flights')
export class FlightController {
  constructor(private flightService: FlightService) {}

  @Get()
  async getAllFlights(): Promise<Flight[]> {
    return this.flightService.getAllFlights();
  }

  @Get(':id')
  async getFlightById(@Param('id') id: string): Promise<Flight | null> {
    return this.flightService.getFlightById(Number(id));
  }

  @Post()
  async createFlight(@Body() data: Omit<Flight, 'id' | 'createdAt' | 'updatedAt'>): Promise<Flight> {
    return this.flightService.createFlight(data);
  }

  @Put(':id')
  async updateFlight(@Param('id') id: string, @Body() data: Partial<Flight>): Promise<Flight> {
    return this.flightService.updateFlight(Number(id), data);
  }

  @Delete(':id')
  async deleteFlight(@Param('id') id: string): Promise<Flight> {
    return this.flightService.deleteFlight(Number(id));
  }
}

import { Module } from '@nestjs/common';
import { PrismaModule } from './prisma/prisma.module';
import { FlightModule } from './flight/flight.module';

@Module({
  imports: [PrismaModule, FlightModule],
})
export class AppModule {}

npm run start:dev