๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

TIL

(21)
๋žœ๋ค ๋ฌธ์ž์—ด ์ƒ์„ฑํ•˜๊ธฐ 32 ๋ฐ”์ดํŠธ ๋žœ๋ค๊ฐ’ ์ƒ์„ฑํ•˜๊ธฐ
npx prisma format Prisma schema ํฌ๋งท ๊ณต์‹ Docs: https://www.prisma.io/docs/reference/api-reference/command-reference#format ๊ณต์‹ ๋ฌธ์„œ์˜ format ๋ช…๋ น์–ด์— ๋Œ€ํ•œ ์„ค๋ช… Formats the Prisma schema file, which includes validating, formatting, and persisting the schema. ์ƒˆ๋กœ์šด ์‚ฌ์ด๋“œ ํ”„๋กœ์ ํŠธ๋ฅผ ์ง„ํ–‰ํ•˜๋ฉด์„œ Prisma๋ฅผ ์ฒ˜์Œ ์‚ฌ์šฉํ•ด๋ณด๋‹ค๋ณด๋‹ˆ schema ์ƒ์„ฑ๋ถ€ํ„ฐ ๊ณ„์† ์—๋Ÿฌ๊ฐ€ ๋–ด๋‹ค. @relation์„ ์‚ฌ์šฉํ•˜๋ฉด์„œ ํ…Œ์ด๋ธ” ํ•œ ์ชฝ์—๋งŒ @relation์„ ๋ช…์‹œํ•ด์ฃผ๊ณ  ๋‹ค๋ฅธ ํ•œ ์ชฝ์—์„  ํ•„๋“œ๋ฅผ ์ ์–ด์ฃผ์ง€ ์•Š์•˜๋”๋‹ˆ ์—๋Ÿฌ๊ฐ€ ๋‚œ ๊ฒƒ์ด์—ˆ๋Š”๋ฐ ์—๋Ÿฌ ๋ฉ”์‹œ์ง€์— ์นœ์ ˆํ•˜๊ฒŒ๋„ ์ง์ ‘ ์ถ”๊ฐ€ํ•ด์ฃผ๋“ ์ง€ prisma f..
CSS Modules ํด๋ž˜์Šค๋ช… ๋„ฃ๋Š” ๋ฒ• Today I learned ์นดํ…Œ๊ณ ๋ฆฌ์— ์žˆ๊ธด ํ•˜์ง€๋งŒ Today์— ๋ฐฐ์šด๊ฑด ์•„๋‹ˆ๊ณ ... Next.js ๊ด€๋ จ ํŠœํ† ๋ฆฌ์–ผ๋ณด๋‹ค๊ฐ€ ์˜ˆ์ „์— ๊ณ ๋ฏผํ•˜๊ณ  ์ฐพ์•„๋ดค๋˜ ๋ถ€๋ถ„์ด ์ƒ๊ฐ๋‚˜์„œ ์–ผ๋ฅธ ๊ธ€๋กœ ๋‚จ๊ฒจ๋ณธ๋‹ค. ์ง€๋‚œ ์‚ฌ์ด๋“œ ํ”„๋กœ์ ํŠธ ๋•Œ CSS Modules๋ฅผ ์‚ฌ์šฉํ–ˆ๋Š”๋ฐ ํด๋ž˜์Šค ๋ช…์„ ์—ฌ๋Ÿฌ ๊ฐœ ๋„ฃ๋Š” ๊ฒƒ๊ณผ ๊ด€๋ จํ•˜์—ฌ ์ฐพ์•„๋ณธ ์ ์ด ์žˆ์—ˆ๋‹ค. (๊ธฐ์กด์— ์ž‘์„ฑํ–ˆ๋˜ ์ฝ”๋“œ์—์„œ ๋ณด๊ณ  ์˜ฌ๋ฆฌ๋Š” ๊ฒƒ์ด๊ธฐ ๋•Œ๋ฌธ์— ๋” ์ •ํ™•ํ•œ ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด์„œ๋Š” ๋ฌธ์„œ๋ฅผ ์ฐพ์•„๋ณด๊ฑฐ๋‚˜ ์ถ”๊ฐ€์ ์œผ๋กœ ๊ฒ€์ƒ‰ํ•ด๋ณด๋Š” ๊ฒƒ์„ ๊ถŒํ•ด๋“œ๋ฆฝ๋‹ˆ๋‹ค. ) 1. ํด๋ž˜์Šค ๋ช…์ด ํ•˜๋‚˜ ์ผ ๋•Œ - style.className ๋ฐฉ์‹ - style['class-name'] ๋ฐฉ์‹ 2. ํด๋ž˜์Šค ๋ช…์ด ๋‘๊ฐœ ์ด์ƒ์ผ ๋•Œ - {`${style.className1} ${style.className2}`} / {`${style['class-n..
MySQL ๋คํ”„ ๋œจ๊ธฐ ๋ฏธ๋ž˜์— ๋คํ”„ ๋œฐ ๋‚˜๋ฅผ ์œ„ํ•ด mysqldump -u root -p [๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ช…] > [ํŒŒ์ผ๋ช…].sql ์ฐธ์กฐ https://blog.dalso.org/article/mysql-mariadb-dump
MySQL ์ปฌ๋Ÿผ ์ถ”๊ฐ€ํ•˜๊ธฐ ์ž์ฃผํ•˜๋Š” ์ž‘์„ฑ(?)ํ•˜๋Š” ๊ฒŒ ์•„๋‹ˆ๋ผ ๊ทธ๋Ÿฐ์ง€ DDL ์ž‘์„ฑํ•  ๋•Œ๋Š” ๋งค๋ฒˆ ์ฐพ์•„๋ณด๋Š” ๊ฒƒ ๊ฐ™์€ ๋А๋‚Œ -_-;; ALTER TABLE `ํ…Œ์ด๋ธ”๋ช…` ADD COLUMN `์ปฌ๋Ÿผ๋ช…` ๋ฐ์ดํ„ฐ ํƒ€์ž… NULL๊ฐ’์„ค์ • COMMENT '์ปค๋งจํŠธ๋ช…' AFTER `์ถ”๊ฐ€๋˜๊ธธ ์›ํ•˜๋Š” ์œ„์น˜ ์•ž ์ปฌ๋Ÿผ๋ช…`; ALTER TABLE `member` ADD COLUMN `firstname` VARCHAR(20) NOT NULL COMMENT '์ด๋ฆ„' AFTER `surname`; ALTER TABLE `member` ADD COLUMN `nickname` VARCHAR(20) NULL DEFAULT NULL COMMENT '์ด๋ฆ„' AFTER `firstname`; ๋งจ ์•ž์— ์ถ”๊ฐ€๋˜๊ธฐ๋ฅผ ์›ํ•œ๋‹ค๋ฉด AFTER `์ปฌ๋Ÿผ๋ช…`์ด ์•„๋‹Œ FIRST๋ฅผ ์ ์–ด์ฃผ๋ฉด๋˜๊ณ  ๋งจ ๋’ค..