dailybuilds

SQL - Vertica: How to generate daily rows with most previous date data

I have a base table like below: score_upd (Upd_dt,Url,Score) AS ( SELECT DATE '2019-07-26','A','x' UNION ALL SELECT DATE '2019-07-26','B','alpha' UNION ALL SELECT DATE '2019-08-01','A','y' UNION ALL SELECT DATE '2019-08-01','B','beta' UNION ALL SELECT DATE '2019-08-03','A','z' UNION ALL SELECT DATE...

How to use mock object mimicing a daily routine program?

My program has a daily routine, similar to an alarm clock event. Say, when it's 2pm(The time is the system time in my pc), do something for me. What I want to do is to speed up the testing period(I don't really want to wait 4 days looking at the daily routine and check errors.) I read on wiki of...

Tools to help a small shop score higher on the “Joel Test”

Questions #1 through #4 on the Joel Test in my opinion are all about the development tools being used and the support system in place for developers: Do you use source control? Can you make a build in one step? Do you make daily builds? Do you have a bug database? I'm just curious what free/cheap...