lovasoa
2b6b981dfe
and specify that this is a SQLite example in the README https://github.com/lovasoa/SQLpage/issues/152
25 lines
1.0 KiB
SQL
25 lines
1.0 KiB
SQL
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 $id IS NOT NULL; |