lovasoa
5c288b0ac9
Restructure tests so files that only work on a single database engine are organized under `database-specific/<engine>/` instead of using long `_no...` suffixes. Add a dedicated test that runs these files only when the current database matches, and simplify the generic test runner by extracting shared execution logic.
1.3 KiB
The sql files in this folder are all tested automatically. They are organized in two subdirectories:
component_rendering/
Files that depend on SQLPage's HTML rendering (components, shells, redirects,
etc.). Every file that does not start with error_ must render a page that
contains the text "It works !" and no occurrence of the word "error" (case
insensitive). error_ files should return a page containing the word "error"
and the rest of the file name. Files may include nosqlite, nomssql,
nopostgres or nomysql in their name to skip incompatible backends.
data/
Files that only validate data-processing functions should live here. They must
return rows with an actual column plus either expected (exact match) or
expected_contains (substring match). Tests in this directory are fetched as
JSON and validated row by row.
data/database-specific/
Files that only work on a single database engine (because they use
engine-specific SQL syntax) live in a subdirectory named after that database
(sqlite, postgres, mysql, mssql, oracle, duckdb, snowflake,
generic). They are run by a separate test, only when the current database
matches. Unlike the other directories, their file names do not need _no...
suffixes to exclude incompatible backends.