chore: option to pass *config.Config to jobsdb

[Sidddddarth]

Description

Option(Optfunc) to have jobsdb-handle-specific config, which falls back to config.Default if not passed.
This can help avoid configuration mixups between tests, each jobsdb handle can have specific config to itself, and also to test actual runtime behaviour by changing config values instead of setting jobsdb.Handle's internal fields.

Also moved and grouped jobsdb config fields around to help with readability. eg.: it wasn't entirely clear(to me at first glance) how the number of maxOpenConnections were being set in case of a write/read/readWrite jobsdb.

Additionally:
misc.GetConnectionString now takes in *config.Config as a parameter, using it to fetch db connection details.

Linear Ticket

jobsdb handle specific config

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

Patch coverage: 84.97% and project coverage change: +0.01% 🎉

Comparison is base (901c69e) 68.69% compared to head (e5c564a) 68.70%.

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #3764      +/-   ##
==========================================
+ Coverage   68.69%   68.70%   +0.01%     
==========================================
  Files         345      345              
  Lines       51652    51649       -3     
==========================================
+ Hits        35480    35486       +6     
+ Misses      13884    13877       -7     
+ Partials     2288     2286       -2     

Files Changed	Coverage Δ
app/apphandlers/processorAppHandler.go	8.56% <0.00%> (ø)
processor/stash/stash.go	52.51% <0.00%> (ø)
runner/runner.go	69.16% <ø> (-0.13%)	⬇️
services/validators/envValidator.go	50.45% <50.00%> (ø)
warehouse/warehouse.go	55.14% <50.00%> (ø)
utils/misc/dbutils.go	33.33% <53.84%> (ø)
jobsdb/migration.go	69.85% <77.77%> (-0.64%)	⬇️
jobsdb/backup.go	69.25% <80.76%> (ø)
jobsdb/jobsdb.go	72.67% <91.85%> (+0.06%)	⬆️
app/apphandlers/embeddedAppHandler.go	76.67% <100.00%> (ø)
... and 6 more

... and 4 files with indirect coverage changes

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[atzoum]

how are we overriding jobsdb now so that it doesn't trigger the addNewDS loop?

[Sidddddarth]

It wasn't being used anywhere in the test.

[atzoum]

Could it be that the test wanted to simply disable this trigger?

[Sidddddarth]

true
didn't think of it that way😅
Fortunately this didn't affect this particular test.
But in the future with the config dependency, we could set the addDSLoop-timer to a sufficiently large duration.

[atzoum]

thank you @Sidddddarth! with respect to the description of this pull request, I believe it deserves some more attention to include all introduced changes