SELECT 
    'form'                  AS component,
    'multipart/form-data'   AS enctype;
SELECT 
    'myfile'                AS name, 
    'file'                  AS type, 
    'File'                  AS label;

WITH uploaded_file AS (
    SELECT 
        sqlpage.uploaded_file_name('myfile') AS fname,
        sqlpage.read_file_as_data_url(sqlpage.uploaded_file_path('myfile')) AS content
)
INSERT INTO uploaded_files (fname, content, uploaded) 
SELECT fname, content, CURRENT_TIMESTAMP
FROM uploaded_file
WHERE fname IS NOT NULL AND content IS NOT NULL;

SELECT 'text' AS component, 'File uploaded!' AS contents
WHERE EXISTS (
    SELECT 1
    FROM uploaded_files
    WHERE fname = sqlpage.uploaded_file_name('myfile')
);

SELECT
    'table'         AS component, 
    'Download'      AS markdown,
    TRUE            AS sort,
    TRUE            AS search;
SELECT
    uploaded                                                AS Timestamp,
    fname                                                   AS File_Name,
    '[download](upload_file.sql?filename=' || fname || ')'  AS Download
FROM uploaded_files;

SELECT 'button' AS component;
SELECT 
    'Download ' || $filename   AS title, 
    content                    AS link FROM uploaded_files
WHERE $filename IS NOT NULL AND fname = $filename LIMIT 1;