Mat MatMoore

Rails	Django	Description
preload	prefetch_related	one query per table
eager_load	select_related	one query with joins
includes	N/A	same as preload if associated table not references, otherwise eager_load

axe

https://pypi.org/project/axe-playwright-python/

How Slack use axe in playright:

Playwright test lands on a page/view
Axe analyzes the page
Pre-defined exclusions are filtered out
Violations and artifacts are saved to a file

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/

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.

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

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

Language fluency

Interactive courses

Projects

Exercism
- Dominoes
Bank Account

	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') \|\|

	TopicalFacet
	#sentence_fragment
	multiple values
	is expected to eql "end_date"
	disallowed values
	is expected to be nil
	single value
	is expected to eql "end_date"

	Registries::TopicTaxonomyRegistry

	"""
	Can't capture exactly:

	- condionally required fields
	- validation rules
	- format
	"""
	import csv
	from os import environ