i do the same thing but what i got at the terminal not the same as yours Subscriber connected successfully Connected to MongoDB this just what I got and don't give me anything else?
Hi Ramesh, the content you are sharing has good information. However, please see if you can increase the video quality as the letters are blurred and not visible. Also if you can share the dataset, it will be good to practice on that data. Thank you for the information, once again.
Wow. It's an informative video. I was always confused how winston works in my project. I've a question-How Can we change the level of logs being generated in our CLI? I mean the logs which are generated by backend service when server starts running. One log in my datadog account is wrongfully being logged as error but it should be logged as warning. I want to modify its log level.
Thank you for the tutorial, its on to the point! But i have a problem when ever i am calling the files get api (in my case i am trying to run mp3 and mp4) i couldn't able to forword the video or song in the player does it have anything to do with Gridfs stream method in backend? Please help🙂
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( P_JSON, "$[*]" COLUMNS(deviceno INT PATH "$.deviceno", ...' at line 19 I have this error sir
Great video for Beginners. Sir , 1) i want to catch the error code and description and want to insert in my own log kind of table? How can write the code for that? 2) If i have multiple insert, delete, update and select in my procedure , should i write DECLARE EXIT HANDLER for each statement separately or single declaration is enough? ( In oracle entire code can be covered by EXCEPTION , and we can write the code there for insert the error message ) Kindly give me the link/video/page above scenario? Thanks in advance
Question 1 : Answer : create the table for storing error messages like errormsg execute the below script CREATE TABLE `errormsg` ( `EM_ID` int NOT NULL AUTO_INCREMENT, `ErrorCode` int DEFAULT NULL, `ErrorDescription` varchar(500) DEFAULT NULL, `StoredProcedureName` varchar(100) DEFAULT NULL, `Created` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`EM_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; Use the following code for exception handling DECLARE CONTINUE HANDLER FOR NOT FOUND BEGIN SET @handler_invoked = 1; END; DECLARE EXIT HANDLER FOR SQLEXCEPTION, SQLWARNING BEGIN GET DIAGNOSTICS CONDITION 1 @p1 = RETURNED_SQLSTATE, @p2 = Message_TEXT; ROLLBACK; SELECT 500 AS StatusCode, @p2 AS Message, @p1 AS ErrorCode; INSERT INTO ErrorMsg(ErrorCode, ErrorDescription, StoredProcedureName) VALUES(@p1, @p2, 'test_exception'); END; Question 2 : Answer : single declaration is enough
