avernet’s gists

avernet / curl-search-api.sh

Last active November 19, 2024 03:57

Orbeon Forms curl command calling the search API

	curl \
	-X POST \
	-H "Content-Type: application/xml" \
	-d '<?xml version="1.0" encoding="UTF-8"?>
	<search>
	<query path="details/title" summary-field="true"/>
	<query path="details/author" summary-field="true"/>
	</search>' \
	'http://localhost:8080/orbeon/fr/service/persistence/search/orbeon/bookshelf'

avernet / Dockerfile

Last active November 14, 2024 06:20

Run SQL Server with Full-Text Search, on macOS (Apple Silicon), with Docker

	# Based on https://tedspence.com/a-sql-server-docker-container-with-full-text-search-a1b7c5fc308c

	FROM mcr.microsoft.com/mssql/server:2022-latest
	USER root
	RUN apt-get update && \
	apt-get install -yq gnupg gnupg2 gnupg1 curl apt-transport-https && \
	curl https://packages.microsoft.com/keys/microsoft.asc -o /var/opt/mssql/ms-key.cer && \
	apt-key add /var/opt/mssql/ms-key.cer && \
	curl https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list -o /etc/apt/sources.list.d/mssql-server-2022.list && \
	apt-get update && \

avernet / add_header.py

Created December 1, 2023 01:35

mitmproxy: add a `My-Counter` header incremented with every request

	from mitmproxy import http

	class AddHeader:
	def __init__(self):
	self.counter = 0

	def request(self, flow: http.HTTPFlow) -> None:
	self.counter += 1
	flow.request.headers["My-Counter"] = str(self.counter)

avernet / form.xml

Created November 30, 2023 21:52

Form using `xxf:json-to-xml()`

	<xh:html xmlns:xh="http://www.w3.org/1999/xhtml" xmlns:xf="http://www.w3.org/2002/xforms"
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:ev="http://www.w3.org/2001/xml-events"
	xmlns:xi="http://www.w3.org/2001/XInclude"
	xmlns:xxi="http://orbeon.org/oxf/xml/xinclude"
	xmlns:xxf="http://orbeon.org/oxf/xml/xforms"
	xmlns:map="http://www.w3.org/2005/xpath-functions/map"
	xmlns:array="http://www.w3.org/2005/xpath-functions/array"
	xmlns:math="http://www.w3.org/2005/xpath-functions/math"

avernet / fetch-breakpoint.js

Created November 28, 2023 22:34

Breaking on calls to `fetch()`

	(function() {
	const originalFetch = window.fetch;
	window.fetch = function(...args) {
	debugger;
	return originalFetch.apply(this, args);
	};
	})();

avernet / insert.sql

Created October 30, 2023 17:25

For PostgreSQL, create 1k rows with 10k of random text each

+WITH RECURSIVE random_chars AS (
+    SELECT
+AS id,
+AS group_id,
+        substr(
+            'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',
+            floor(random() * 62)::int + 1,
+        ) AS char

avernet / login.jsp

Created January 19, 2023 05:54

Tomcat login page

	<!DOCTYPE html>
	<html>
	<head>
	<title>Login Page</title>
	</head>
	<body>

	<form action="/orbeon/j_security_check" method="post">
	<label for="username">Username:</label>
	<input type="text" name="j_username">

avernet / form.xml

Created April 13, 2022 19:37

Referring to an external barcode by URL

	<xh:html xmlns:sql="http://orbeon.org/oxf/xml/sql"
	xmlns:fr="http://orbeon.org/oxf/xml/form-runner"
	xmlns:ev="http://www.w3.org/2001/xml-events"
	xmlns:xxf="http://orbeon.org/oxf/xml/xforms"
	xmlns:map="http://www.w3.org/2005/xpath-functions/map"
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:xh="http://www.w3.org/1999/xhtml"
	xmlns:array="http://www.w3.org/2005/xpath-functions/array"
	xmlns:math="http://www.w3.org/2005/xpath-functions/math"
	xmlns:exf="http://www.exforms.org/exf/1-0"

avernet / form.xml

Created October 20, 2021 23:46

Last year's start and end dates

	<xh:html xmlns:xh="http://www.w3.org/1999/xhtml" xmlns:xf="http://www.w3.org/2002/xforms"
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:ev="http://www.w3.org/2001/xml-events"
	xmlns:xi="http://www.w3.org/2001/XInclude"
	xmlns:xxi="http://orbeon.org/oxf/xml/xinclude"
	xmlns:xxf="http://orbeon.org/oxf/xml/xforms"
	xmlns:map="http://www.w3.org/2005/xpath-functions/map"
	xmlns:array="http://www.w3.org/2005/xpath-functions/array"
	xmlns:exf="http://www.exforms.org/exf/1-0"

avernet / expression.xpath

Created August 3, 2020 17:55

XPath for checking date is in current fiscal year

	let
	$this-year-start := xs:date(concat(year-from-date(current-date()), '-07-01')),
	$fiscal-start :=
	if ($this-year-start <= current-date())
	then $this-year-start
	else $this-year-start - xs:yearMonthDuration('P1Y'),
	$fiscal-end := $fiscal-start + xs:yearMonthDuration('P1Y') - xs:dayTimeDuration('P1D'),
	$input-date := xs:date('2020-08-03')
	return
	$fiscal-start <= $input-date and

Alessandro Vernet avernet