Dave Morriss davmo
0 Followers · 0 Following
  • Joined on 2021-01-19
Repositories
1
 Projects Packages Public Activity Starred Repositories
davmo pushed to main at rho_n/hpr_generator 2023-11-01 16:00:57 +00:00
79a788bda9 Added content to the announcement section
davmo created pull request rho_n/hpr_generator#176 2023-10-29 17:37:58 +00:00
fix3_next_available_episode
davmo pushed to fix3_next_available_episode at rho_n/hpr_generator 2023-10-29 17:36:49 +00:00
097b50b30b Next free slot algorithm now in TT² form
8325b2c0d1 Unwanted items commented out
Compare 2 commits »
davmo created branch fix3_next_available_episode in rho_n/hpr_generator 2023-10-29 17:36:49 +00:00
davmo created pull request rho_n/hpr_generator#175 2023-10-20 12:45:33 +00:00
fix2_next_available_episode
davmo pushed to fix2_next_available_episode at rho_n/hpr_generator 2023-10-20 12:43:29 +00:00
c8135d811d Bug fix of query to find days to next free slot
dab80f1772 Using even more complex CTE query for testing
Compare 2 commits »
davmo created branch fix2_next_available_episode in rho_n/hpr_generator 2023-10-20 12:43:29 +00:00
davmo pushed to main at rho_n/hpr_generator 2023-10-12 18:36:11 +00:00
3ccd6101ee Removed unnecessary computations from query_next_available_episode
davmo closed issue rho_n/hpr_generator#173 2023-10-10 20:13:15 +00:00
Computation of days to next free slot is incorrect on index page
davmo commented on issue rho_n/hpr_generator#173 2023-10-10 20:13:15 +00:00
Computation of days to next free slot is incorrect on index page

Tested this and the MySQL variant, and the change seems to solve the problem.

The last_year, last_month and last_month fields are used in content-index.tpl.html to compute the number of…

davmo deleted branch fix_next_available_episode from rho_n/hpr_generator 2023-10-10 19:43:46 +00:00
davmo pushed to main at rho_n/hpr_generator 2023-10-10 19:43:46 +00:00
51d328203b Merge pull request 'Fixing days to next free slot' (#174) from fix_next_available_episode into main
366729a827 Fixing days to next free slot
Compare 2 commits »
davmo merged pull request rho_n/hpr_generator#174 2023-10-10 19:43:45 +00:00
Fixing days to next free slot
davmo created pull request rho_n/hpr_generator#174 2023-10-10 17:04:20 +00:00
Fixing days to next free slot
davmo pushed to fix_next_available_episode at rho_n/hpr_generator 2023-10-10 17:02:08 +00:00
366729a827 Fixing days to next free slot
davmo created branch fix_next_available_episode in rho_n/hpr_generator 2023-10-10 17:02:08 +00:00
davmo commented on issue rho_n/hpr_generator#173 2023-10-07 19:03:41 +00:00
Computation of days to next free slot is incorrect on index page

The first draft of a replacement query is this:

WITH next_id AS (
    SELECT id, id + 1 AS id_next, date as last_date
    FROM eps
    WHERE eps.date > date('now')
),
free_slot AS (
  …
davmo commented on issue rho_n/hpr_generator#173 2023-10-07 18:50:58 +00:00
Computation of days to next free slot is incorrect on index page

The original query was as followed (slightly edited for testing):

WITH next_id AS (
    SELECT id, id + 1 AS id_next, date as last_date
    FROM eps
    WHERE eps.date > date('now')
)
SE…
davmo commented on issue rho_n/hpr_generator#172 2023-10-07 18:23:00 +00:00
Relative links aren't working on "Stuff you need to know" page

I still don't get the full-stop link. In order to click it you have to have the header it's attached to on the page. Clicking it leaves you where you already are! OK, it might shift the page so…

davmo opened issue rho_n/hpr_generator#173 2023-10-06 17:37:18 +00:00
Computation of days to next free slot is incorrect on index page