saws | A supercharged AWS command line interface | Command Line Interface library

This can be solved by just splitting the array into multiple sawtooth sequences..which is O(n) operation. For example [1,2,1,3,4,-2] can be splitted into two sequence [1,2,1,3] and [3,4,-2] and now we just have to do C(size,2) operation for both the parts.

Here is psedo code explaining the idea ( does not have all corner cases handled )

I picked from your code and ended up with this...The find function is fine as is...just replace this section

The information I need is an integer, which is the day when it was recorded

Not really.

Either the input may contain multiple entries for a single date, in which case you need to know the entire date (even if year is irrelevant, there's month + day; you can't just look at that 'day' value, or you'd consider 1st of March and 1st of April as the same day which is clearly incorrect.

Or, there are no duplicates: For any given exact day, there can only ever be a single record. This sounds wrong (given the "or below anywhere in the UK?" part), but if so, you don't need to look at day or month whatsoever; just count the # of entries with a temperature recording below 0.

You could hack it and turn the month and day fields into a single unique integer (multiply month by 32, then add days: That guarantees you a unique 'month+day' ID value, because no month has 32 days, overlap is not possible). Or write it properly and turn that year+month+day field into a LocalDate instance: LocalDate when = LocalDate.of(2015, 1, 1) would produce a LocalDate instance representing jan 1st 2015.

ArrayList isn't a good tool for uniqueness; you're probably looking for HashMap which maps a given 'key' to a given value, or better yet, a HashSet, which stores values, but which will not store the same value more than once. You can then add any LocalDate for which you have found a record at sub-zero, and if you then find another such record, you'd not change anything - just add the date to the set a second time, as it won't have any effect. Then at the very end just check how large the set is. So:

1. Create a HashSet of LocalDate.
2. For each record: Write code that turns the year, month, and day values into a LocalDate, using LocalDate.of(year, month, day).
3. Check if the temperature value is below 0.0. If so, add the date you made to the set.
4. When done with the loops, the size of the set represents the # of days that the temperature was below 0 anywhere in the UK.

NB: line.split(",") will take a line of text and return a string array by splitting the input line at each comma. Integer.parseInt("50") returns the number 50.

This should be all the info you need to finish your homework.

I think there are 2 issues.

1. You need to install nginx separately from your postgress installation. This means that you will have some nginx pods/deployments, and a service that exist in the ingress-nginx namespace. To do this, follow the guide here. It is recommended that you follow a yaml file from the cloud section for a docker desktop deployment. This is someone who has gone through the process.

2. Once nginx is installed on your cluster, you need to go from you postgress deployment/pod -> service -> ingress. These will be in a different namespace than your ingress-nginx one (default is fine). To configure it, you can follow the guide located here. If you want to test things along the way, you can use kubernetes port-forwarding command to forward your postgress pod to your local machine. You can also test your service with the same method.

SQL Server doesn't support string agg as a window function for cumulative windows. But, you can use apply instead. So, get the full name from the second table using:

Just change:

Your url path doesn't accept any args but then you pass it a slug.

You need to allow the slug in the URL;