tk/deichman.no: allow variable extended opening hours

euler2 SQL migration:

-- rename regularMannedOpeningHours to regularOpeningHours

UPDATE library SET data=json_set(data,'$.regularOpeningHours', json_extract(data,'$.regularMannedOpeningHours'));

-- populate regularOpeningHours with extendedFrom and extendedTo from branch-level values

WITH res AS (
    SELECT
        library.id,
        days.key,
        json_set(days.value,
            '$.extendedFrom', json_extract(data, '$.extendedStart'),
            '$.extendedTo', json_extract(data, '$.extendedClose')) AS val
    FROM library, json_each(json_extract(data, '$.regularOpeningHours')) AS days
    WHERE json_extract(library.data, '$.extendedOpeningHours')
)
UPDATE library
    SET data=json_set(data, '$.regularOpeningHours', json(t.val))
FROM (SELECT id, '[' || GROUP_CONCAT(val ,',') || ']' AS val FROM res GROUP BY id) AS t
WHERE library.id=t.id;

-- remove obsolete keys

UPDATE library SET data=json_remove(data,
    '$.regularMannedOpeningHours',
    '$.extendedStart',
    '$.extendedClose');

deichman.no: info screen: style opening hour as a table