I want to select some data in my database but i can't
First insert and update is success
but select func response err
Below is the error history.
/Users/Project/gitlab.co.kr/dev/api-server/node/node_modules/express/lib/response.js:1150
: JSON.stringify(value);
^
TypeError: Converting circular structure to JSON
--> starting at object with constructor 'Query'
| property '_timer' -> object with constructor 'Timer'
--- property '_object' closes the circle
at JSON.stringify (<anonymous>)
at stringify (/Users/Project/gitlab.co.kr/dev/api-server/node/node_modules/express/lib/response.js:1150:12)
at ServerResponse.json (/Users/Project/gitlab.co.kr/api-server/node/node_modules/express/lib/response.js:271:14)
at ServerResponse.send (/Users/Project/gitlab.co.kr/api-server/node/node_modules/express/lib/response.js:162:21)
at /Users/Project/gitlab.co.kr/dev/api-server/node/dist/controller/video/VideoController.js:111:26
at step (/Users/Project/gitlab.co.kr/dev/api-server/node/dist/controller/video/VideoController.js:33:23)
at Object.next (/Users/Project/gitlab.co.kr/dev/api-server/node/dist/controller/video/VideoController.js:14:53)
at fulfilled (/Users/Project/gitlab.co.kr/dev/api-server/node/dist/controller/video/VideoController.js:5:58)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Node.js v18.3.0
And Below is the My code.
public Select = async (videoDTO?: VideoDTO): Promise<SearchResponseType> => {
const Id: string = videoDTO.getId();
const Time: string = videoDTO.getTime();
const resultData = await this.Connection.query(SelectQuery, [Id, Time], (err: any, result: any) => {
if (err) {
Logger.error(`Select : ${err}`);
return;
}
return result;
});
// console.log("@")
const ResponseSelect: SearchResponseType = {
status: 200,
message: 'SELECT VIDEO SUCCESS',
data: {
result: resultData,
},
};
return ResponseSelect;
};
plz somebody help me