Recently Updated Pages
Input
required (positional) parameteres optional parameters (?foo=bar) read user cookies Post request w...
OOB Swap
With OOB Swap I mean swapping multiple elements at once, which may come from multiple template fi...
Svelte Concepts
Basics Variables https://svelte.dev/docs/svelte/$state https://svelte.dev/docs/svelte/$derived le...
Typescript
Types Usually when defining types, you would want to create your own types file types.ts <prefix>...
Testing (playwright)
How to test Click X, then Y, then Z. Finally, assert that XYZ is visible on the page. Finding ele...
Testing (pytest)
Intro Additional info https://docs.pytest.org/en/stable/explanation/anatomy.html Initial setup In...
Basics
Snippets Check if database exists Postgres SELECT EXISTS ( SELECT 1 FROM pg_database ...
HTML and JS
You can use // @ts-check at the top of a <script> tag to get typescript support in VScode. Use ...
Test strategy
What to test? In the other chapters it is described how to test (pytest, playwright for frontend,...
Testing (svelte)
TODO
HTML
HTML linting can be done with djlint
HTML
Auto format with djlint To auto-format HTML files, you can run uv run djlint . --reformat Ignore...
Jinja - useful commands
https://jinja.palletsprojects.com/en/stable/templates/ TODO if elif else for loop if defined
Tips and Tricks
Data types Window functions Window functions are functions that grab additional data per row, e.g...
Postgres - Piccolo (Python) hints
Piccolo column types Postgres column types Postgres type Python type Piccolo type Python examp...