Skip to content

Instantly share code, notes, and snippets.

View revolunet's full-sized avatar
🐫
Killing bugz

Julien Bouquillon revolunet

🐫
Killing bugz
View GitHub Profile
@revolunet
revolunet / albert.mjs
Last active December 11, 2024 00:18
Albert API With RAG and JavaScript
// @ts-check
// see also: https://albert.api.etalab.gouv.fr/documentation
import { readFile, readdir } from "fs/promises";
import pAll from "p-all";
const API_KEY = process.env.ALBERT_API_KEY;
const API_URL = "https://albert.api.etalab.gouv.fr";
@revolunet
revolunet / test.md
Created November 29, 2024 23:14
test mermaid charts

test mermaid charts

see all on https://mermaid.live

Pie

pie title Pets adopted by volunteers
    "Dogs" : 386
    "Cats" : 85
@revolunet
revolunet / chorus.md
Last active January 30, 2025 15:16
Process commande chorus
@revolunet
revolunet / README.md
Created November 14, 2024 17:55
oauth2-proxy diagram
sequenceDiagram
    participant User
    participant Proxy
    participant GitHub
    participant App
    
    User->>Proxy: Visits protected URL
    Proxy->>User: 302 Redirect to GitHub login
    User->>GitHub: GET /login
@revolunet
revolunet / test.md
Created November 12, 2024 23:22
some links
@revolunet
revolunet / index.md
Last active November 12, 2024 10:51
extract vaultwarden non-2FA users

extract vaultwarden non-2FA users

in the /users/overview browser console:

const table = document.querySelector("table#users-table");
const unsecureUsers = Array.from(table.querySelectorAll("tbody tr")).filter(r=>!r.innerHTML.includes("2FA is enabled")).map(r => r.querySelector("td.sorting_1:first-of-type span.d-block").textContent);
copy(unsecureUsers.join("\n")); // clipboard copy
@revolunet
revolunet / giveaway.md
Last active October 1, 2024 07:08
Dons 28/9/24

Dons 28/9/24

  • Tenues capoiera 8 ans et 12 ans
  • Cocote minute SEB "Clipso"
  • Robot Silvercrest Monsieur cuisine SKMH 1100 A1 avec accessoires vapeur
  • Jouet poussette enfant avec deux poupées
  • Jouet lave vaisselle
  • Radio reveil bluetooth MUSE M172-BT
  • BB: ciel lumineux Pabobo SP02B
  • Livre Jeux adulte FibreTigre "Out there l'exil"
@revolunet
revolunet / gen-diffusionkit.sh
Last active August 17, 2024 14:41
DiffusionKIT example script (OSX)
#!/bin/sh
# pip install diffusionkit-cli
# example: ./gen-diffusionkit.sh group-of-people-having-an-eureka-moment
PROMPT="$@"
if [ ${#PROMPT} -le 5 ]; then
echo "Please provide an explicit prompt"
exit 1
@revolunet
revolunet / createCharge.js
Created July 22, 2024 13:13
sellsy webhook code extract
import { when } from "q";
import Sellsy from "node-sellsy";
import { getBookeoProductId } from "./bookeo";
export const TVA = 20;
/**
* create sellsy invoice and paymanet
* return existing customer if any
@revolunet
revolunet / kysely-cte.ts
Created July 18, 2024 00:00
Some kysely query with PostgreSQL CTE
await db
.with("expiration_date", (db) =>
db
.selectFrom("missions")
.select(({ fn }) => ["user_id", fn.max("end").as("expiration")])
.groupBy("user_id")
)
.selectFrom(["users", "expiration_date"])
.select([
"users.username",