Express 내가 원하는 결과 외에 추가적인 데이터가 나온다? - [{"_buf":{"type":"Buffer","data": [...], ... }
나의 에러 기록 🤬
이 글의 목적?
최근에 프론트 개발을 하는 친구와 토이 프로젝트를 시작했다. 스프링으로 진행하려했지만 최근에 공부한 내용을 실습해보고자 하는 생각으로 express를 이용했다. 이번에는 간단한 내용이니 문제와 해결을 분리하지 않고 한번에 정리해보자. 😀
문제 & 해결
사실 에러라기보다 내가 원하는 결과 외에 추가적인 데이터가 나오는 문제다.
이 문제에 대한 해결책으로 하단의 코드처럼 간단하게 처리할 수 있지만 마음에 들지 않았다. 제 3자가 봤을 때 이해가 안되는 코드라고 생각했기 때문이다.
const result = await dataSource.query(
`SELECT id, content FROM TEST`
);
return result[0];다른 해결방법이 없을까 고민하면서 열심히 구글링하다가 다행히 나와 같은 문제를 겪은 사람을 발견할 수 있었다.
알고보니 추가적으로 나오는 데이터는 ColumnDefinition이라는 것을 알 수 있었다. 즉, mysql2를 이용하면 query() 함수는 rows, fields를 반환한다는 것이다. (문서도 확인해보니 rows, fields에 대한 설명이 나와있었다. 데헷 😛)
따라서 코드에 더 직관적으로 표현하기 위해서 다음과 같은 코드를 이용하여 프로젝트에 적용했다.
const [rows, fields] = await dataSource.query(
`SELECT id, content FROM TEST`
);
return rows;이 글의 레퍼런스
34개의 댓글
天元娛樂online為您帶來高規格的多元娛樂體驗！專注於體育、真人、電競、彩票、棋牌、電子等領域，匯聚最新最全的娛樂項目，所有不同喜好的玩家都能在此盡情享受。立即加天元娛樂城開啟您的歡樂新旅程天元online
Good artcile, but it would be better if in future you can share more about this subject. Keep posting.성남가라오케
Discover a world where creativity and innovation are boundless. We strive to create experiences that empower, inspire, and connect. From cutting-edge technology to compelling narratives, our dedication to excellence shines through. Join our collaborative community, where your ideas are valued and together, we'll push the boundaries of what's possible, shaping a future full of promise and innovation.Stimulus Checks
Explora las exposiciones más destacadas de Madrid con Dondego.es, tu guía completa de eventos culturales. Nuestra plataforma agrega y destaca las exhibiciones más interesantes de la ciudad, desde arte contemporáneo hasta historia y ciencia. Ya seas un entusiasta del arte o simplemente curioso por descubrir nuevas expresiones culturales, encontrarás en Dondego.es una selección cuidadosamente curada de exposiciones imperdibles. Mantente al tanto de fechas, ubicaciones y detalles clave para planificar tu visita y sumergirte en la riqueza cultural de Madrid exposiciones madrid
A very excellent blog post. I am thankful for your blog post. I have found a lot of approaches after visiting your post. slot
Maintain the nice perform, My partner and i examine handful of content with this internet site and also I do believe your net website will be genuine intriguing and contains received sectors regarding great details. 김해호빠
Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. Vintage furniture
Psilocybe Caerulipes for Sale: Also known as Blue-Foot mushrooms, Psilocybe Caerulipes are perfect for a unique psychedelic experience. Order online for high-quality shrooms delivered to your door.Buy MDMA online USA
An interesting dialogue is price comment. I feel that it is best to write more on this matter, it may not be a taboo topic however usually individuals are not enough to talk on such topics. To the next. Cheers. https://elysios.com.br/blog/codigo_promocional-1xbet_bono.html
Wow! This could be one of the most useful blogs we have ever come across on thesubject. Actually excellent info! I’m also an expert in this topic so I can understand your effort. 총판구인
Fine place, a an exceptionally amazing webpage that there is at this point, stick to beneficial financial job, shall be to come back. situs slot gacor hari ini
Hey, this day is too much good for me, since this time I am reading this enormous informative article here at my home. Thanks a lot for massive hard work.xoslotz
Experience the best in slot gaming with BANG188, the official slot dealer known for easy wins. Our platform offers a diverse range of games and a secure, user-friendly environment. BANG188 is dedicated to providing fair play and maximum winning potential for all players. bang188
Experience human-like content with AI Humanizer, the world’s leading AI humanizer. This award-winning tool transforms AI-generated text, maintaining quality and meaning. Perfect for product descriptions, blogs, and social media, AI Humanizer supports multiple languages, making it ideal for global use. humanize
Hey what a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and will look for more postings from you. calcio inter
I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. medico estetico torino
This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. mastoplastica additiva torino
Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks 메이저사이트
Thanks for this great post, i find it very interesting and very well thought out and put together. I look forward to reading your work in the future. 보증업체
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. sultan188
That i originated onto your webpage despite the fact that highlighting basically just a bit submits. Fine strategy for after that, I am bookmarking at any one time take an individual's finished increases. 발산호스트바
Find the best online hold'em sites with our 2024 Hold'em Casino Usage Guide. Compare features, security, and customer service. Choose a site that ensures a safe, enjoyable hold'em experience. Texas Hold'em offers excitement and strategic thinking for all players. 홀덤사이트
Terrific short article. All the content has an affect on a large amount of emergency worries of our population. Everyone can not be uninvolved to make sure you all of these worries. This approach content gives you plans and additionally techniques. Particularly revealing and additionally effective. Tapety
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! maplay789
BT 娛樂城遊戲網的目標是讓玩家了解娛樂城，讓他們在考慮註冊及遊玩時能夠做出明智的決定！專注於體育、真人、電競、彩票、棋牌、電子等遊戲評價與評分，為了確保玩家們遊戲安全，讓玩家能夠享受到公平、安全的遊戲環境。加入BT 娛樂城遊戲網開啟您的歡樂新旅程! 娛樂城
Your articles are inventive. I am looking forward to reading the plethora of articles that you have linked here. Thumbs up! buy a small business
Trusted Toto Site Reviews: Our experts verify major Toto sites for safety and reliability. Enjoy a secure gaming environment with our comprehensive reviews and guidelines. 메이저 토토사이트
As i followed on your web log even while aligning really just a little submits. Attractive technique for then, We are book-marking at one time seize ones own whole goes up. bar알바
You're permitted to publish titles, although not hyperlinks, unless of course they're authorized as well as upon subject. 출장마사지
Book all your travel essentials with Trip.com, from hotels and flights to tours, train tickets, and car rentals. This all-in-one platform simplifies travel planning and management. Trust Trip.com for convenience and comprehensive service, ensuring a smooth travel experience. 런던 숙소 추천
Cheers to the article along with wonderful guidelines.. perhaps My spouse and i in addition feel that efforts can be the key element of receiving good results. 야놀자 쿠폰
Keep up to date the nice deliver the results, I actually learn very few discussions during this webpage plus There's no doubt that that your chosen website site is definitely serious helpful and has now became encircles with brilliant information and facts. dabwoods vape
Mukkban, the reliable eat and run verification company, offers thorough fraud checks. 먹튀검증사이트