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
29 lines
1.1 KiB
SQL
29 lines
1.1 KiB
SQL
SELECT 'dynamic' AS component,
|
|
sqlpage.run_sql('shell.sql')
|
|
AS properties;
|
|
|
|
SELECT 'title' AS component,
|
|
'Toggle Light / Dark Mode' AS contents,
|
|
TRUE AS center;
|
|
|
|
SELECT 'text' AS component;
|
|
SELECT 'This is a demo of a light/dark background toggle mecanism for websites built with [SQLpage](https://sql-page.com/), Ophir Lojkine''s fantastic tool
|
|
|
|
## Installation
|
|
|
|
The SQL backend to this is SQLite, so the installation is easy:
|
|
|
|
1. [Install SQLpage](https://sql-page.com/your-first-sql-website/)
|
|
|
|
1. Clone SQLpage''s repository: `git clone https://github.com/sqlpage/SQLPage.git`
|
|
|
|
1. cd to `SQLpage/examples/light-dark-toggle` and run `sqlpage` in the cloned directory
|
|
|
|
1. Open a browser window to `http://localhost:5005`
|
|
|
|
## Usage
|
|
|
|
The initial background theme is light. To switch to dark mode, click on the '' ☀ '' symbol on the right of the top menu bar. Click on the same symbol to switch back to light mode.
|
|
|
|
I have included some dummy pages under a mock ''Categories'' menu to show that the ''light'' or ''dark'' setting is kept between pages. This is done by setting and reading a cookie called ''lightdarkstatus''.' AS contents_md;
|