Skip to content

Instantly share code, notes, and snippets.

@RREAMANBD
RREAMANBD / probe_logwol.py
Created June 26, 2026 17:01
LOGWOL discovery probe — columns, samples, distinct values, numeric profile
#!/usr/bin/env python3
"""LOGWOL probe — discover columns, sample rows, and characterize what an 'adjustment' looks like.
Outputs JSON to OneDrive so Ric/I can review before designing the actual report query.
"""
from __future__ import annotations
import os, json, datetime, decimal
import pyodbc
DSN = os.environ.get("INTELLIDEALER_DSN", "IntelliDealerWeb")
@JordanLang22
JordanLang22 / gw-cad-oracle-discovery.sql
Created June 26, 2026 17:01
GovWorx CAD Oracle database discovery script
/*
GovWorx CAD connector discovery script - Oracle
Purpose:
- Run once in the CAD database and send the full output back to GovWorx.
- The output gives us enough schema, relationship, lookup, and sample-row context
to map the CAD source columns into the GovWorx CAD incident model, including
structured location sub-fields and extension fields used by tenant location masks.
What this script does:
@tatsuyax25
tatsuyax25 / countMajoritySubarrays.js
Created June 26, 2026 17:01
You are given an integer array nums and an integer target. Return the number of subarrays of nums in which target is the majority element. The majority element of a subarray is the element that appears strictly more than half of the times in that s
/**
* @param {number[]} nums
* @param {number} target
* @return {number}
*/
var countMajoritySubarrays = function(nums, target) {
const n = nums.length;
// Step 1: Convert to +1 / -1
const arr = nums.map(x => x === target ? 1 : -1);
@orzz5
orzz5 / transcript-general-support-35-1782493277428.html
Created June 26, 2026 17:01
Olympus Ticket Transcript — transcript-general-support-35-1782493277428.html
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><meta name="viewport" content="width=device-width,initial-scale=1">
<title>Transcript — General Support #35</title>
<style>
*{margin:0;padding:0;box-sizing:border-box}
body{background:#313338;color:#dbdee1;font-family:'gg sans','Noto Sans',Whitney,'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:15px;line-height:1.375}
a{color:#00a8fc;text-decoration:none}a:hover{text-decoration:underline}
code{background:#2b2d31;padding:0 4px;border-radius:3px;font-family:Consolas,monospace;font-size:85%}
.hdr{background:#1e1f22;border-radius:8px;padding:20px 28px;margin:20px 20px 0}
@RREAMANBD
RREAMANBD / fix_extract.ps1
Created June 26, 2026 17:01
WIP triage extract fix - delete stale + re-download + run
# Force-replace wip_extract.py with the fixed version from the gist
$ErrorActionPreference = "Stop"
Set-Location "$env:USERPROFILE\OneDrive - Bulldog Fire Apparatus\intellidealer_dashboard\wip_triage"
# Delete the stale local file first so there's no chance of running an old copy
if (Test-Path wip_extract.py) {
Remove-Item wip_extract.py -Force
Write-Host "Deleted stale wip_extract.py" -ForegroundColor Yellow
}
id station stationid value unit obstime date
0 流浮山 RF001 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
1 湿地公园 RF002 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
2 水边围 N12 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
3 石岗 RF003 M mm 2026-06-27T00:45:00+08:00 2026-06-27
4 大美督 RF004 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
5 大埔墟 RF005 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
6 北潭涌 RF006 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
7 滘西洲 RF007 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
8 西贡 N15 0 mm 2026-06-27T00:45:00+08:00 2026-06-27
@HugsLibRecordKeeper
HugsLibRecordKeeper / output_log.txt
Created June 26, 2026 17:00
Rimworld output log published using HugsLib Standalone Log Publisher
This file has been truncated, but you can view the full file.
Log uploaded on Friday, June 26, 2026, 12:59:46 PM
Loaded mods:
Harmony(brrainz.harmony)[v:2.4.2.0][mv:2.4.2.0]: 0Harmony(2.4.1), HarmonyMod(2.4.2)
Loading Progress(ilyvion.LoadingProgress)[v:0.11.0]: ilyvion.LoadingProgress(0.11.0)
Core(Ludeon.RimWorld): (no assemblies)
Royalty(Ludeon.RimWorld.Royalty): (no assemblies)
Ideology(Ludeon.RimWorld.Ideology): (no assemblies)
Biotech(Ludeon.RimWorld.Biotech): (no assemblies)
Odyssey(Ludeon.RimWorld.Odyssey): (no assemblies)
@choco-bot
choco-bot / FilesSnapshot.xml
Created June 26, 2026 17:00
infracost v2.6.0 - Passed - Package Tests Results
<?xml version="1.0" encoding="utf-8"?>
<fileSnapshot xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<files>
<file path="C:\ProgramData\chocolatey\lib\infracost\infracost-windows-amd64.zip.txt" checksum="F883930CAF4E5B8694145EDC320B7E44" />
<file path="C:\ProgramData\chocolatey\lib\infracost\infracost.nupkg" checksum="22D4BADD89350E537AEEC2A96909F3B6" />
<file path="C:\ProgramData\chocolatey\lib\infracost\infracost.nuspec" checksum="D51422141EDCF15A60EF62D6272A02BB" />
<file path="C:\ProgramData\chocolatey\lib\infracost\tools\chocolateyinstall.ps1" checksum="F1FA021DA20CA4D04026DF48B9FA6C0D" />
<file path="C:\ProgramData\chocolatey\lib\infracost\tools\infracost.exe" checksum="1791C4A5E0F25956B6798199DAA005E2" />
</files>
</fileSnapshot>
/* ===== BACKGROUND FIX (WOLVDEN SAFE) ===== */
body {
margin: 0;
padding: 0;
}
/* Remove default site backgrounds */
body, #main, #header, #footer, .container, .content {
background-color: transparent !important;
@choco-bot
choco-bot / FilesSnapshot.xml
Created June 26, 2026 17:00
letsencrypt-win-simple v2.0.10 - Passed - Package Tests Results
<?xml version="1.0" encoding="utf-8"?>
<fileSnapshot xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<files>
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\letsencrypt-win-simple.nupkg" checksum="975563AFED8B57BF571949EDB86AE4BC" />
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\letsencrypt-win-simple.nuspec" checksum="C1188E443613097FADE54C9337F8B098" />
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\win-acme.v2.0.10.444.zip.txt" checksum="F464CA9C274AA5E9CACD5CB4CE76CFE6" />
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\tools\chocolateyinstall.ps1" checksum="0CBB090FE5644324423FCB03E9958E37" />
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\tools\settings_default.config" checksum="F1A174A511A72E6BE68570EE2C7C6EEF" />
<file path="C:\ProgramData\chocolatey\lib\letsencrypt-win-simple\tools\version.txt" checksum="3941B173D27E658307C51BED