22일차. ui-server 를 다시 구축하기

 

 

 

 

이제 이거는 localhost:3000

---

page.tsx 이 화면을 챗 gpt처럼 보이게 해줘

 

 

 

---

 

쿼리 화면 다시 띄우기

 

 

 

docker exec -it esgseed psql -U esgseed -d esgseeddb

 

\d schedules

 

 

컬럼명 넣어줌 java에서는 

INSERT INTO teams(team_uk, region_name, team_name, e_team_name, orig_yyyy, stadium_uk, zip_code1, zip_code2, address, ddd, tel, fax, homepage, owner) VALUES
('K05','전북','현대모터스','CHUNBUK  HYUNDAI MOTORS  FC','1995','D03','560','190',
'전북 전주시 덕진구 반월동 763-1  전주월드컵경기장  내','063','273-1763','273-1762','http://www.hyundai-motorsfc.com', NULL),
('K08','성남','일화천마','SEONGNAM  ILHWA CHUNMA FC','1988','B02','462','130',
'경기도 성남시 분당구 야탑동  486번지 성남 제2종합운동장  내','031','753-3956','753-4443','http://www.esifc.com', NULL),
('K03','포항','스틸러스','FC POHANG  STEELERS','1973','C06','790','050',
'경북 포항시 죽도동 614-8 동양빌딩  7층','054','282-2002','282-5955','http://www.steelers.co.kr', NULL),
('K07','전남','드래곤즈','CHUNNAM  DRAGONS FC','1994','D01','544','010',
'전남 광양시 중동 1318-5 신한은행빌딩  2층','061','792-5600','792-5605','http://www.dragons.co.kr', NULL),
('K09','서울','FC서울','FOOTBALL CLUB  SEOUL','1983','B05','138','221',
'서울 마포구 성산동 515 월드컵 경기장  내','02','2005-5746','2005-5802','http://www.fcseoul.com', NULL),
('K04','인천','유나이티드','INCHEON  UNITED FC','2004','B01','110','728',
'인천광역시 남구 문학동 482  인천월드컵경기장  내','032','2121-5271','2121-5276','http://www.incheonutd.com', NULL),
('K11','경남','경남FC','GYEONGNAM  FC','2006','C05','111','222',
'경남 창원시 두대동 145  창원종합운동장','055','6644-8468','6644-8488','http://www.gsndfc.co.kr', NULL),
('K01','울산','울산현대','ULSAN HYUNDAI  FC','1986','C04','682','060',
'울산광역시 동구 서부동 산137-1  현대스포츠클럽하우스','052','230-6141','230-6145','http://www.uhfc.tv', NULL),
('K10','대전','시티즌','DAEJEON CITIZEN  FC','1996','D02','301','030',
'대전광역시 유성구 노은동 270  대전월드컵경기장 서관  3층','042','252-2002','221-0669','http://www.dcfc.co.kr', NULL),
('K02','수원','삼성블루윙즈','SUWON  SAMSUNG BLUEWINGS  FC','1995','B04','440','220',
'수원시 팔달구 우만1동 228  수원월드컵경기장  4층','031','247-2002','257-0766','http://www.bluewings.kr', NULL),
('K12','광주','광주상무','GWANGJU  SANGMU FC','1984','A02','450','419',
'광주광역시 서구 풍암동 423-2  광주월드컵경기장  내','062','777-5180','777-5181','http://www.gwangjusmfc.co.kr', NULL),
('K06','부산','아이파크','BUSAN IPARK  FC','1983','C02','570','050',
'부산광역시 강서구 대저1동 2155번지  강서체육공원  내','051','555-7101','555-7103','http://www.busanipark.co.kr', NULL),
('K13','강원','강원FC','GANGWON  FC','2008','A03','333','444',
'강원 춘천시 중앙로 7 강원도 개발공사  빌딩  내','033','459-3631','459-3630','http://www.gangwon-fc.com', NULL),
('K14','제주','제주유나이티드FC','JEJU  UNITED FC','1982','A04','555','666',
'제주 서귀포시 강정동  3355-5','064','3631-2460','3631-2468','http://www.jeju-utd.com', NULL),
('K15','대구','대구FC','DAEGU  FC','2002','A05','777','888',
'대구광역시 수성구 대흥동 504  대구스타디움  내','053','5566-3967','5566-3970','http://www.daegufc.co.kr', NULL);

 

 

 

 

컬럼명 바꾸고 싶을때 쓰는 코드

 

ALTER TABLE schedules RENAME COLUMN hometeam_id TO hometeam_uk;

 

 

 

sangbepa  4:51 PM

ALTER TABLE teams DROP COLUMN IF EXISTS team_id;

 

EUNJIN SEO  4:52 PM

ALTER TABLE schedules RENAME COLUMN hometeam_id TO hometeam_uk;

4:54

생성 jpa 업데이트 방법- 엔티티 구조를 바꾸면 컬럼이 생김, 기존에 있던 컬럼은 안없어짐, 있으면 리소스를 많이 차지함, 잘못된 컬럼을 없애줘야함. jpa =yaml 테이블구조가 안깨지니까 컬럼만 지워주면 됨

 

 

---

 

다시 ui로 돌아와서 

layout.tsx

page.tsx

 

리턴은 하나밖에 없음! 

 

f12

 

 

이버튼을 클릭하면 인풋박스에 있는 테스트를 알러트로 띄어줘@page.tsx