L’actualité du logiciel libre et des sujets voisins (DIY, Open Hardware, Open Data, les Communs, etc.), sur un site francophone contributif géré par une équipe bénévole par et pour des libristes enthousiastes
SELECT 'shell' AS component, 'User Management App' AS title, 'user' AS icon, '/' AS link;
SELECT 'form' AS component,
'Edit user' AS title,
'insert_user.sql' || COALESCE('?id=' || $id, '') AS action;
SELECT 'First name' AS name,
TRUE AS required,
(SELECT first_name FROM "user" WHERE id = CAST($id AS INT)) AS value;
SELECT 'Last name' AS name,
TRUE AS required,
(SELECT last_name FROM "user" WHERE id = CAST($id AS INT)) AS value;
SELECT 'Email' AS name,
'email' AS type,
(SELECT email FROM "user" WHERE id = CAST($id AS INT)) AS value;
SELECT 'list' AS component, 'Addresses' AS title WHERE $id IS NOT NULL;
SELECT street || ', ' || city || ', ' || country AS title FROM address WHERE user_id = CAST($id AS INT);
SELECT 'form' AS component, 'Add address' AS title, 'insert_address.sql?user_id=' || $id AS action WHERE $id IS NOT NULL;
SELECT 'Street' AS name, TRUE AS required WHERE $id IS NOT NULL;
SELECT 'City' AS name, TRUE AS required WHERE $id IS NOT NULL;
SELECT 'Country' AS name, TRUE AS required WHERE $