comptes_delete_confirm.sql

SELECT 'redirect' AS component,
        'signin.sql?error' AS link
 WHERE NOT EXISTS (SELECT 1 FROM login_session WHERE id=sqlpage.cookie('session'));
SET group_id = (SELECT user_info.groupe FROM login_session join user_info on user_info.username=login_session.username WHERE id = sqlpage.cookie('session'));
SELECT 'redirect' AS component,
        'index.sql?restriction' AS link
        WHERE $group_id<'4';

SELECT 'redirect' AS component,
        'index.sql?restriction' AS link
        WHERE $group_id<>'4';

--Menu
SELECT 'dynamic' AS component, sqlpage.read_file_as_text('menu.json') AS properties;

DELETE FROM user_info
WHERE username = $id
RETURNING
   'text' AS component,
   'Le compte ' || username ||  ' a été supprimé.' as contents_md;

SELECT 
    'hero' as component,
    'comptes.sql' as link,
    'Retour à la liste' as link_text;