CRUD 저장 프로시저 (Stored Procedure) 에 관한 질문입니다.

Question

//mysql DB (저장 프로시저) # get ( 단일 행을 반환 ) delimiter // create procedure usp_get_board() begin select * from board; end // delimiter ; # get ( 여러 행을 반환) delimiter // create procedure usp_get_list_board(IN pi_bNum INT) begin select * from board where bNum &#61; pi_bNum; end // delimiter ; # put delimiter // create procedure usp_update_board(IN pi_bNum INT, IN pi_bTitle varchar(20), IN pi_bContent varchar(1500), IN pi_bId varchar(20)) begin UPDATE board set bTitle &#61; pi_bTitle, bContent&#61; pi_bContent, bId &#61; pi_bId WHERE bNum &#61; pi_bNum; end // delimiter ; # delete delimiter // create procedure usp_delete_board(IN pi_bNum INT) begin delete from board where bNum&#61;pi_bNum; end // delimiter ; // typescript //get export async function getPosts(req: Request, res: Response): Promise<Response | void> { try { const conn &#61; await connect(); // const Board &#61; await conn.query(&#96;SELECT &#64;RNUM :&#61; &#64;RNUM &#43; 1 AS NO, a.* FROM (SELECT * FROM board ORDER BY bNum ASC ) a, ( SELECT &#64;RNUM :&#61; 0 ) b;&#96;); const sql &#61; 'CALL usp_get_board;'; // const sql &#61; &#96;SELECT &#64;RNUM :&#61; &#64;RNUM &#43; 1 AS NO, a.* FROM (SELECT * FROM board ORDER BY bNum ASC ) a, ( SELECT &#64;RNUM :&#61; 0 ) b&#96;; const Board &#61; await conn.query(sql); console.log(sql); return res.json(Board[0]); } catch (e) { console.log(e) } } 프로시저는 crud로 총 5개 만들었구여 현재 typescript 로 만든 api에 적용시키려고 하는데 const sql &#61; 'CALL usp_get_board;'; 이런식으로 불러오는거 아닌가요?? 적용이 안되네요 ㅠ 도와주세요

CRUD 저장 프로시저 (Stored Procedure) 에 관한 질문입니다.

0개의 답변

Q&A 목록