wehub-resource-sync
d718c5a372
CI / windows_test (push) Waiting to run
CI / compile_and_lint (push) Failing after 0s
CI / docker_build (linux/amd64, -linux-amd64-duckdb, duckdb) (push) Failing after 0s
CI / docker_build (linux/arm64, -linux-arm64, minimal) (push) Failing after 2s
CI / docker_build (linux/arm64, -linux-arm64-duckdb, duckdb) (push) Failing after 1s
CI / docker_build (linux/amd64, minimal) (push) Failing after 1s
CI / test (, sqlite, sqlite::memory:) (push) Has been skipped
CI / test (mssql, mssql, mssql://root:Password123!@127.0.0.1/sqlpage) (push) Has been skipped
CI / test (mysql, mysql, mysql://root:Password123!@127.0.0.1/sqlpage) (push) Has been skipped
CI / test (oracle, oracle, Driver=Oracle 21 ODBC driver;Dbq=//127.0.0.1:1521/FREEPDB1;Uid=root;Pwd=Password123!) (push) Has been skipped
CI / test (postgres, odbc, Driver=PostgreSQL Unicode;Server=127.0.0.1;Port=5432;Database=sqlpage;UID=root;PWD=Password123!, true) (push) Has been skipped
CI / test (postgres, postgres, postgres://root:Password123!@127.0.0.1/sqlpage) (push) Has been skipped
CI / playwright (push) Has been skipped
CI / docker_build (linux/arm/v7, -linux-arm-v7, minimal) (push) Failing after 0s
CI / hurl_examples (push) Failing after 8s
deploy website / deploy_official_site (push) Failing after 1s
CI / docker_push (duckdb) (push) Waiting to run
CI / docker_push (minimal) (push) Waiting to run
CI / hurl (${{ matrix.example }}) (push) Has been skipped
36 lines
1.6 KiB
SQL
36 lines
1.6 KiB
SQL
select 'dynamic' as component, sqlpage.read_file_as_text('website_header.json') as properties;
|
|
|
|
select 'alert' as component, 'Saved' as title, 'success' as color where $saved is not null;
|
|
select 'alert' as component, 'Deleted' as title, 'danger' as color where $deleted is not null;
|
|
select 'alert' as component, 'This option cannot be deleted' as title, 'danger' as color, 'If an option has already been chosen by at least one respondant, then it cannot be deleted' as description where $cannot_delete is not null;
|
|
|
|
select 'dynamic' as component,
|
|
json_array(
|
|
json_object(
|
|
'component', 'form',
|
|
'title', CONCAT('Option ', id),
|
|
'action', CONCAT('edit_option.sql?id=', id),
|
|
'validate', '',
|
|
'id', CONCAT('option', id)
|
|
),
|
|
json_object(
|
|
'type', 'text',
|
|
'name', 'profile_description',
|
|
'label', 'Profile description',
|
|
'value', profile_description
|
|
),
|
|
json_object(
|
|
'type', 'number',
|
|
'name', 'score',
|
|
'min', 0,
|
|
'label', 'Score',
|
|
'value', score
|
|
),
|
|
json_object('component', 'button', 'size', 'sm'),
|
|
json_object('title', 'Delete', 'outline', 'danger', 'icon', 'trash', 'link', CONCAT('delete_option.sql?id=', id)),
|
|
json_object('title', 'Save', 'outline', 'success', 'icon', 'device-floppy', 'form', CONCAT('option', id))
|
|
) as properties
|
|
from dog_lover_profiles;
|
|
|
|
select 'button' as component, 'center' as justify;
|
|
select 'Create new question' as title, 'create_question.sql' as link; |