streamlined

Though I have come up with a couple of working solutions to what I am looking for, I am wondering if there is a more streamlined way of determining which of 3 columns from a single row contains the smallest/min value. Below is an example of the data I am working with:

AccountNumber Job DaysSinceLastSale DaysSinceLastCharge DaysSinceEstablished YO502 NULL NULL 5283 NULL YO525 NULL 2303 2303 5917 ZE100 1 190 449 707 ZE100 2 160 279 615 ZI402 NULL 2109 2109 NULL

And what the outcome would be, which is just the new column of DaysInactive containing the lesser of the 3 non-null DaysSincexxx values:

AccountNumber Job DaysSinceLastSale DaysSinceLastCharge DaysSinceEstablished DaysInactive YO502 NULL NULL 5283 NULL 5283 YO525 NULL 2303 2303 5917 2303 ZE100 1 190 449 707 190 ZE100 2 160 279 615 160 ZI402 NULL 2109 2109 NULL 2109

This is what I have to this point that simply uses a series of CASE expressions to compare them with. The objective is to find the lowest value of days of inactivity for a client job based on any of 3 different date values tied to the job. And to be clear, 2 of the columns (DaysSinceLastSale and DaysSinceLastCharge) are the primary target, with the 3rd (DaysSinceEstablished) being a last resort in the event the first 2 are NULL (All 3 of them can actually be NULL, in which case we default to 99999). I am ultimately using this in a PowerBI report so a >= slicer can be setup for the end-users to manually enter the minimum number of inactive days a record should have in order to be returned on the report visual:

...

I have a data frame that looks like something this:

...

I have multiple ETL kind of tasks, that I plan to perform serverless. The execution time for the tasks vary from 5 to 30 minutes (depending on the amount of data coming at an instance). Since functions have a timeout of 10 minutes, these tasks cannot be performed together in one single function. I recently came across Durable Functions in Azure for orchestration of different functions. I wanted to know if Durable functions altogether also have a timeout of 10 minutes, or I can have multiple functions in it (which run from 3-5mins each).

For example, task 1 takes 3mins, task 2 takes 5 mins, task 3 takes 7 minutes, task 4 takes 3minutes and task 5 takes 2mins. Can I have all these tasks orchestrated in a single durable function?

My current approach is to have a queue trigger function for each of the tasks separately, but this kind of workflow is quiet a mess. I feel durable functions will be best for making a streamlined workflow.

...

I created a new notebook in Google Cloud Vertex-AI that has the following properties:

When I open the notebook, I am prompted by the following message:

After some time, I get the following error message:

...

I have my github repo connected to my vercel build for my next.js project, and it auto builds whenever I push to the repo. However, I get this error whenever the Github-deployment builds:

ModuleNotFoundError: Module not found: Error: Can't resolve '../components_nt/tracking/formContent' in '/vercel/path0/pages' Build error occurred Error: > Build failed because of webpack errors at /vercel/path0/node_modules/next/dist/build/index.js:390:19 at async Span.traceAsyncFn (/vercel/path0/node_modules/next/dist/telemetry/trace/trace.js:60:20) error Command failed with exit code 1. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command. Error: Command "yarn run build" exited with 1

I have tried redeploying, reinstalling my next and node_modules, and clearing the build cache. None of these work for the GitHub way.

However, for some odd reason, if I run vercel --prod then it builds properly and works, but I don't know why. I would appreciate doing the Github way as it is less hassle and more streamlined.

Has anyone else ever experienced this issue? Would really appreciate any help!

...

I'm processing some very big files, and my simple Go program to do this is taking 2 minutes to run instead of the 15 seconds it takes for the equivalent C program (https://gist.github.com/g2boojum/5729bf75a41f537b8251af25a816c2fc). Clearly I'm missing something important. (It's also my first Go program, so I'm sure the code is idiomatically poor, too.)

The files I'm processing are csv files, which look like the following, and the only issue is that they're GB in size.

...

I am creating an express app using mongoose with the intention of connecting this to React for the frontend.

I have listed some CRUD operations for a customer controller below but there are a few things I do not like about this approach.

1. When using Customer.findById with a valid ObjectID that is not found, it returns null with a 200 response code. I want this to return 404 if no customer was found. I realise I could change the catch response to a 404, but I want to have some generic error handling incase the server goes down during the request or an invalid ObjectId was provided, which brings me to my next item.
2. If I provide an invalid ObjectId I want to provide some meaningful message, is 500 the right response code?
3. Error handling: Am I returning errors the correct way? currently errors return a string with the error message. Should I return JSON instead? e.g. res.status(500).json({error: error.message). I am planning on connecting this to react (which I am still learning) and I assume the UI will need to display these messages to the user?
4. findById is repeated in getCustomerById, updateCustomer, and deleteCustomer. I feel this is bad practice and there must be a more streamlined approach?
5. I want to have one function that validates if the ObjectId is valid. I am aware that I can do this is the routes using router.params but I'm not sure if checking for a valid id should be in the routes file as it seems like something the controller should be handling? See routes example below from another project I did.

What are the best practices and suggested ways to improve my code, based on the above? I have read the documentation from mongoose, mozilla, and stackoverflow Q&A but they don't seem to address these issues (at least I could not find it).

I am really after some guidance or validation that what I am doing is correct or wrong.

customer.controller.js

...

Initially I wrote this tkinter app functionally, but now that I'm converting it into OOP due to how bloated its become, the major issue I'm having is understanding a streamlined way to pass variables between a large number of classes.

Below is a minimum test version of the start of my code, with two variables defined in Mainframe that I want to first pass to FileSelect to update them and then on to LoadFiles. The big area of confusion for me is why file_list is seemingly updating correctly when running print_files, but the import_state variable I want to use to enable a button in LoadFiles does not.

...

All code for entire project is available here

The database is PostgreSQL 12.7
The backend is Java 11.0.12
I am building my TDD tests with JUnit 5.8.1

Here is CommentDaoTest.java None of it is working, but I am specifically working on getAllNotNull

Line one of the method gets an exception response that leads to a NullPointerException on line 90 of CommentPostgres.java

...