Dave Morriss davmo
0 Followers · 0 Following
  • Joined on 2021-01-19
Repositories
1
 Projects Packages Public Activity Starred Repositories
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 pull request rho_n/hpr_generator#175 2023-10-20 12:45:33 +00:00
fix2_next_available_episode
davmo created branch fix2_next_available_episode in rho_n/hpr_generator 2023-10-20 12:43:29 +00:00
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 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 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 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 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 created branch fix_next_available_episode in rho_n/hpr_generator 2023-10-10 17:02:08 +00:00
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 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
davmo pushed to main at rho_n/hpr_generator 2023-10-06 14:47:21 +00:00
faac8c202e Updated README.md
davmo commented on issue rho_n/hpr_generator#172 2023-10-05 17:36:22 +00:00
Relative links aren't working on "Stuff you need to know" page

Given:

<h1 id="agreement">Stuff you need to know<a href="#agreement">.</a></h1>

I would be inclined to drop the <a> tag entirely:

<h1 id="agreement">Stuff you need to…
davmo commented on issue rho_n/hpr_generator#172 2023-10-05 17:28:52 +00:00
Relative links aren't working on "Stuff you need to know" page

I see what you mean (I think).

If I go to the main about page and click on Stuff you need to know. I am sent to [https://hackerpublicradio.org/abo…