URL Logger hangs

prashant
Topic Author
Offline
Platinum Member

More

2 years 2 months ago #23916 by prashant

Replied by prashant on topic URL Logger hangs

Thank you so much for putting together this script , I will try it out & update my result.It's really appreciated.

You are right , with web hooks the battle is for milliseconds, I will also try to shave off few milliseconds by putting together a python script where I will pass the logid , so that it can access the sql directory and not writing the json file.

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

2 years 2 months ago #23941 by prashant

Replied by prashant on topic URL Logger hangs

Update, we've simplified the script even further now by reading directly the logID from sql table instead of writing and then reading the json file

Code:

const { spawn } = require('child_process');
try {
    const WORKING_DIRECTORY = 'C:\\Users\\Superadmin\\Documents\\KBIAutomation\\brain\\';
    const pythonExecutablePath = `python`;  // Use 'python' from PATH
    const parameters = ["mywork.py",logId,"whip.yaml"];
    // Execute the Python script without waiting for completion within specified working directory
    spawn(pythonExecutablePath, parameters, { cwd: WORKING_DIRECTORY,detached: true })
    return 200;
} catch (err) {
logger.error(`Caught an error: ${err.message ? err.message : err}`);
return 500; // Any error caught here results in a 500 status
}

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 years 2 months ago #23942 by admin

Replied by admin on topic URL Logger hangs

Looks good

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

ETL Forum