home-launcher/home-sqlpage/index.sql

SELECT 'shell' AS component
, 'dark' AS theme
, 'Portal' AS title
;
SELECT 'text' AS component
, '<style>
.card-img-top:has(+ .bg-rss) {
    width: 40%;
    margin: 10% 50% 10% 10%;
}
.card-img-top {
    width: 40%;
    margin: 10% 30% 10% 30%;
}
</style>' AS html
;
SELECT 'card' AS component
, 4 AS columns
;
SELECT 'https://shandan.one/feed'||link AS link
, title
, 'https://upload.wikimedia.org/wikipedia/en/thumb/4/43/Feed-icon.svg/128px-Feed-icon.svg.png' AS top_image
, description_md
, 'rss' AS color
FROM sqlpage_cards
WHERE grouping = 1
;
SELECT 'divider' AS component;
SELECT 'card' AS component
, 4 AS columns
;
SELECT 'https://shandan.one'||link AS link
, title
, top_image
, description_md
, color
FROM sqlpage_cards
WHERE grouping = 2
;
SELECT 'divider' AS component;
SELECT 'card' AS component
, 4 AS columns
;
SELECT * FROM sqlpage_cards
WHERE grouping = 3
;