MatMoore

Background

For the fundamentals of using forms in HTML, see the MDN forms tutorial

In particular, Sending and retrieving form data

Key things to keep in mind

• Each form control needs to be associated with a label for accessibility
• All named form elements send a value back to the server
• In the case of GET requests, values go into the URL as a query parameter

MatMoore

expression = """
WITH T2 AS ( SELECT (
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 
coalesce('foo', 'bar') || 

MatMoore

2024-07-03T11:39:41.2461669Z [2024-07-03 11:39:41,181] ERROR    {datahub.ingestion.run.pipeline:491} - Caught error
2024-07-03T11:39:41.2463027Z Traceback (most recent call last):
2024-07-03T11:39:41.2465452Z   File "/home/runner/work/data-catalogue/data-catalogue/.venv/lib/python3.11/site-packages/datahub/sql_parsing/sqlglot_utils.py", line 239, in try_format_query
2024-07-03T11:39:41.2467355Z     return expression.sql(dialect=dialect, pretty=True)
2024-07-03T11:39:41.2468362Z            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-03T11:39:41.2470085Z   File "/home/runner/work/data-catalogue/data-catalogue/.venv/lib/python3.11/site-packages/sqlglot/expressions.py", line 601, in sql
2024-07-03T11:39:41.2471674Z     return Dialect.get_or_raise(dialect).generate(self, **opts)
2024-07-03T11:39:41.2472492Z            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-07-03T11:39:41.2475987Z   File "/home/runner/work/data-catalogue/data-catalogue/.venv/lib/python3.11/site-packages/sqlglot/diale

MatMoore

Nunjucks / Jinja compatibility spike

Purpose of spike

Nunjucks templates are almost (but not quite) compatible with Jinja.

We wanted to find out if we could adapt existing templates written for Nunjucks so that they would render in Jinja.

Specifically, we wanted to understand what would be involved in making nhs-frontend Nunjucks templates cross-compatible with Jinja.

MatMoore

Cost/licensing

• Gitleaks is MIT licensed. However gitleaks-action has a non-standard license which requires registering (for free)
• Github offers secret scanning on all public repos
• For private repos, there is Github secret protection, which requires a GitHub Team or GitHub Enterprise Cloud account.

What's detected

• Github secret scanning - note that "non-provider" patterns are enabled separately, and there is a separate AI tool under the Copilot brand.
• [Gitleaks](https://github.com/gitleaks/gitleaks/blob/