Search
Reco Everything you wanna value. 자세히보기

[IT|Programming]/Algorithm|Database

DATABASE setup of Panda Market by kipid

kipid 2024. 9. 25. 15:13
반응형
✖
m.logPrint() is working!

<eq> and <eqq> tags are rendered to MathJax format, being enclosed by \ ( \ ) and \ [ \ ].

docuK1 scripts started!
If this log is not closed automatically, there must be an error somewhere in your document or scripts.

Table of Contents is filled out.

Auto numberings of sections (div.sec>h2, div.subsec>h3, div.subsubsec>h4), <eqq> tags, and <figure> tags are done.

<cite> and <refer> tags are rendered to show bubble reference.

<codeprint> tags are printed to corresponding <pre> tags, only when the tags exist in the document.


Current styles (dark/bright mode, font-family, font-size, line-height) are shown.

kakao.js with id="kakao-js-sdk" is loaded.

New ShortKeys (T: Table of Contents, F: Forward Section, D: Previous Section, L: To 전체목록/[Lists]) are set.

m.delayPad=0;
m.wait=1024;
wait 584ms.
Doing delayed-load. : 2
▼ Hide
Toggle a mess
Go (FS)
TofC
DocuK Log
Backward
Forward
RRA
Lists
CmtZ
CmtX
Handle CmtZ
Log in
▲
out focus
  • Creative Commons
  • 저작자표시 - 적절한 출처와, 해당 라이센스 링크를 표시하고, 변경이 있는 경우 공지해야 합니다. 합리적인 방식으로 이렇게 하면 되지만, 이용 허락권자가 귀하에게 권리를 부여한다거나 귀하의 사용을 허가한다는 내용을 나타내서는 안 됩니다.
  • 비영리 - 이 저작물은 영리 목적으로 이용할 수 없습니다.
  • 변경금지 - 이 저작물을 리믹스, 변형하거나 2차적 저작물을 작성하였을 경우 그 결과물을 공유할 수 없습니다.
이 글이 도움이 되셨다면, 광고 클릭 한번씩만 부탁드립니다 =ㅂ=ㅋ.
(If this article was helpful, please click the ad once. Thank you. ;)
Mode: Bright; Font: Noto Sans KR; font-size: 18.0px (10.0); line-height: 1.6;
width: 1280, height: 720, version: 3.3.3
Canonical URI: https://kipid.tistory.com/entry/DATABASE-setup-of-Panda-Market-by-kipid
dg:plink (Document Global Permanent Link): https://kipid.tistory.com/378
document.referrer: Empty
This document is rendered by docuK (See also SEE (Super Easy Edit) of docuK and pure SEE).

DATABASE setup of Panda Market by kipid

판다마켓을 위한 DATABASE 를 구축해 봅시다.

TPH1.Posting History

▼ Show/Hide

Table of Contents

PH1.Posting History

1.기본: npx prisma init

2.Schema 모음.

2.1.Struct 제약조건 모음.

3.Schema 짜기.

3.1.DATA seeding

3.2.prisma superstruct

RRA1.References and Related Articles

T1.기본: npx prisma init

▼ Show/Hide
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
npx prisma init --datasource-provider postgresql
명령을 실행해서 다음과 같은 파일을 얻자.
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}
.env 파일 설정을 다음과 같이 하자.
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
DATABASE_URL="postgresql://postgres:[password]@localhost:5432/panda_market_dev?schema=public"
PORT=3000
panda_market_dev DATABASE 가 없으면 알아서 만들어 준다.
▲ Hide

T2.Schema 모음.

▼ Show/Hide
Product 관련:
Product
Product
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model Product {
  id              String           @id @default(uuid())
  name            String
  description     String
  price           Float
  tags            String[]
  images          String[]
  favoriteCount   Int
  productComments ProductComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
✖
,
ProductComment
ProductComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model ProductComment {
  id          String   @id @default(uuid())
  content     String
  productId   String
  product     Product  @relation(fields: [productId], references: [id], onDelete: Restrict)
  commenterId String
  commenter   User     @relation(fields: [commenterId], references: [id])
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}
✖
User 관련:
User
User
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model User {
  id              String           @id @default(uuid()) // * Can be used by salt in encryption.
  email           String           @unique
  nickname        String
  password        String
  pwdIter         Int              @default(10000)
  ssnIter         Int              @default(1000)
  articles        Article[]
  articleComments ArticleComment[]
  productComments ProductComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
✖
Article 관련:
Article
Article
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model Article {
  id              String           @id @default(uuid())
  title           String
  authorId        String
  author          User             @relation(fields: [authorId], references: [id], onDelete: Restrict)
  content         String
  articleComments ArticleComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
✖
,
ArticleComment
ArticleComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model ArticleComment {
  id          String   @id @default(uuid())
  content     String
  articleId   String
  article     Article  @relation(fields: [articleId], references: [id])
  commenterId String
  commenter   User     @relation(fields: [commenterId], references: [id])
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}
✖

T2.1.Struct 제약조건 모음.

Product 관련:
struct-Product
struct-Product
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
import * as s from 'superstruct';
import isUuid from 'is-uuid';

const Uuid = s.define('Uuid', (value) => isUuid.v4(value));

export const CreateProduct = s.object({
	name: s.size(s.string(), 1, 10),
	description: s.size(s.string(), 10, 100),
	price: s.min(s.number(), 0),
	tags: s.array(s.string()),
	images: s.array(s.string()),
	favoriteCount: s.min(s.integer(), 0),
});

export const PatchProduct = s.object({
	id: Uuid,
	...s.partial(CreateProduct),
});
✖
User 관련:
struct-User
struct-User
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateUser = s.object({
	email: email,
	nickname: s.size(s.string(), 1, 20),
	password: s.string()
});
export const PatchUser = s.partial(CreateUser);
	// * User id 는 따로 받아야 함.
✖
Article 관련:
struct-Article
struct-Article
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateArticle = s.object({
	title: s.size(s.string(), 1, 20),
	authorId: Uuid,
	content: s.size(s.string(), 10, 500),
});
export const PatchArticle = s.partial(CreateArticle);
	// * Article id 는 따로 받아야 함.
✖
Comments 관련:
struct-ProductComment
struct-ProductComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateProductComment = s.object({
	productId: Uuid,
	commenterId: Uuid,
	content: s.size(s.string(), 1, 255),
});
	// * Patch 는 위 데이터에 id 추가.
✖
,
struct-ArticleComment
struct-ArticleComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateArticleComment = s.object({
	articleId: Uuid,
	commenterId: Uuid,
	content: s.size(s.string(), 1, 255),
});
	// * Patch 는 위 데이터에 id 추가.
✖
▲ Hide

T3.Schema 짜기.

▼ Show/Hide
User
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model User {
  id              String           @id @default(uuid()) // * Can be used by salt in encryption.
  email           String           @unique
  nickname        String
  password        String
  pwdIter         Int              @default(10000)
  ssnIter         Int              @default(1000)
  articles        Article[]
  articleComments ArticleComment[]
  productComments ProductComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
Product
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model Product {
  id              String           @id @default(uuid())
  name            String
  description     String
  price           Float
  tags            String[]
  images          String[]
  favoriteCount   Int
  productComments ProductComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
Article
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model Article {
  id              String           @id @default(uuid())
  title           String
  authorId        String
  author          User             @relation(fields: [authorId], references: [id], onDelete: Restrict)
  content         String
  articleComments ArticleComment[]
  createdAt       DateTime         @default(now())
  updatedAt       DateTime         @updatedAt
}
ProductComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model ProductComment {
  id          String   @id @default(uuid())
  content     String
  productId   String
  product     Product  @relation(fields: [productId], references: [id], onDelete: Restrict)
  commenterId String
  commenter   User     @relation(fields: [commenterId], references: [id])
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}
ArticleComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
model ArticleComment {
  id          String   @id @default(uuid())
  content     String
  articleId   String
  article     Article  @relation(fields: [articleId], references: [id])
  commenterId String
  commenter   User     @relation(fields: [commenterId], references: [id])
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}

T3.1.DATA seeding

적당한 mock data 를 가지고 DATA 를 seeding 해주자.
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
import { PrismaClient } from "@prisma/client";
import data from "./mock.js";
import * as dotenv from 'dotenv';

dotenv.config();
const prisma = new PrismaClient();

async function main() {
	await prisma.product.deleteMany();
	await prisma.product.createMany({
		data,
		skipDuplicates: true,
	})
}

main()
	.then(async () => {
		await prisma.$disconnect();
	})
	.catch(async (e) => {
		console.error(e);
		await prisma.$disconnect();
		process.exit(1);
	});

T3.2.prisma superstruct

다음과 같은 제약 조건을 걸어주자.
struct-Product
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
import * as s from 'superstruct';
import isUuid from 'is-uuid';

const Uuid = s.define('Uuid', (value) => isUuid.v4(value));

export const CreateProduct = s.object({
	name: s.size(s.string(), 1, 10),
	description: s.size(s.string(), 10, 100),
	price: s.min(s.number(), 0),
	tags: s.array(s.string()),
	images: s.array(s.string()),
	favoriteCount: s.min(s.integer(), 0),
});

export const PatchProduct = s.object({
	id: Uuid,
	...s.partial(CreateProduct),
});
s.set(s.string()) 은 어떻게 데이터를 보내는지 모르겠어서 못썼음. 그냥 array 방식으로 묶으면 될줄 알았는데... =ㅇ=;; ["가", "나", "다"] 는 Set 가 아니라고 함.
사용하는 define 은
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
import * as s from 'superstruct';
import isEmail from 'is-email';
import isUuid from 'is-uuid';

const Uuid = s.define('Uuid', (value) => isUuid.v4(value));
const email = s.define('email', (value) => isEmail(value));
struct-User
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateUser = s.object({
	email: email,
	nickname: s.size(s.string(), 1, 20),
	password: s.string()
});
export const PatchUser = s.partial(CreateUser);
	// * User id 는 따로 받아야 함.
struct-Product
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateProduct = s.object({
	name: s.size(s.string(), 1, 10),
	description: s.size(s.string(), 10, 100),
	price: s.min(s.number(), 0),
	tags: s.size(s.array(s.string()), 0, 15),
	images: s.size(s.array(s.string()), 1, 2),
	favoriteCount: s.min(s.integer(), 0),
});
export const PatchProduct = s.partial(CreateProduct);
	// * Product id 는 따로 받아야 함.
struct-Article
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateArticle = s.object({
	title: s.size(s.string(), 1, 20),
	authorId: Uuid,
	content: s.size(s.string(), 10, 500),
});
export const PatchArticle = s.partial(CreateArticle);
	// * Article id 는 따로 받아야 함.
struct-ProductComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateProductComment = s.object({
	productId: Uuid,
	commenterId: Uuid,
	content: s.size(s.string(), 1, 255),
});
	// * Patch 는 위 데이터에 id 추가.
struct-ArticleComment
On the left side of codes is there a hiden button to toggle/switch scrollability ({max-height:some} or {max-height:none}).
export const CreateArticleComment = s.object({
	articleId: Uuid,
	commenterId: Uuid,
	content: s.size(s.string(), 1, 255),
});
	// * Patch 는 위 데이터에 id 추가.
▲ Hide

TRRA1.References and Related Articles

▼ Show/Hide
Toggle a mess
* 홍보/Promoting Recoeve.net (3S | Slow/Sexy/Sincere SNS)
유튜브 음악, K-Pop MV 들을 광고없이 목록재생 해서 보세요.
접속하셔서 가입 후 별점만 드레그 하시면 자신의 페이지에 저장 됩니다.
그리고 자신의 페이지로 이동한 뒤 추천 받기 (단축키 R) 를 누르시면 자신이 점수 메긴것들로 이웃 (이웃보기 단축키 B) 을 자동으로 찾아주고 그 이웃들로부터 추천을 받을 수 있습니다.
Cat=[Music/Break]--K-Pop of kipid's Recoeve.net
Toggle a mess
이 글이 도움이 되셨다면, 광고 클릭 한번씩만 부탁드립니다 =ㅂ=ㅋ.
(If this article was helpful, please click the ad once. Thank you. ;)
반응형
저작자표시 비영리 변경금지 (새창열림)

'[IT|Programming] > Algorithm|Database' 카테고리의 다른 글

prisma with PostgreSQL - cursor based pagination  (2) 2025.07.27
한글 초성검색 in Javascript  (5) 2025.06.24
MySQL SQLException in Ubuntu, Linux  (1) 2025.04.09
prisma with PostgreSQL 를 배워봅시다.  (11) 2024.09.25
Java Serializable Object to Byte Array (byte[] or SQL BLOB)  (0) 2024.09.22
week8 위클리 페이퍼 (데이터베이스 정규화에 대해 설명, 관계형 데이터베이스를 사용하는 이유를 설명)  (1) 2024.09.20
Regular Expression (정규 표현식), and match/replace method in JavaScript, JAVA, and Python  (4) 2024.08.29

'[IT|Programming]/Algorithm|Database'의 다른글

  • 현재글DATABASE setup of Panda Market by kipid

관련글

  댓글에 http/https 링크 및 수식 (\ [ Outline 수식 \ ], \ ( inline 수식 \ ) :: \ 이후 띄어쓰기 없이) 을 넣으실 수 있습니다. 또한 code 는 ``` 시작, ```/ 마지막으로 감싸 주시면 pretty-printed 되어서 나타납니다. ```[.lang-js.scrollable.no-linenums] 같이 언어를 선택해 주실수도 있고, 긴 수식의 경우 scroll bar 가 생기게 만드실 수도 있습니다. .no-linenums 로 line numbering 을 없앨수도 있습니다.

  댓글 입력 후 rendering 된 형태를 보시려면, Handle CmtZ (단축키: N) 버튼을 눌러주세요. 오른쪽 아래 Floating Keys 에 있습니다. 아니면 댓글 젤 아래에 버튼이 있습니다.
댓글들 rendering (단축키:N)
Handle comments.
Get page views

티스토리툴바