Anthony Da Mota AkdM

Home Assistant Door/Window Usage and Voltage Stats

This SQL query calculates the number of times doors and windows have been opened and closed in Home Assistant, along with the average uses per day, and retrieves the current voltage for each sensor.

To be used with the SQLite Web addon, replace all binary_sensor and sensor entities with your own.

WITH state_changes AS
  (SELECT sm.entity_id,
          s.state,

JIRA Branch Name Copy

It's now here: https://github.com/AkdM/JIRA-Branch-Name-Copy

macOS sign app shortcut

To add in .zshrc :

sign_app() {
  local app_path=$1
  # Add quarantine attribute to prevent Gatekeeper warnings
  xattr -cr "$app_path"
  # Sign the app with the specified identity

The following will get the YT livestream (it should be a .m3u8 file), and will output multiple %d.mp4 files, every 20 seconds thanks to ffmpeg:

ffmpeg -i `youtube-dl --youtube-skip-dash-manifest -g "https://www.youtube.com/watch?v=f9ALdmDLPGU"` -c copy -flags +global_header -f segment -segment_time 20 -segment_format_options movflags=+faststart -reset_timestamps 1 "%d.mp4"

Context

I have a LG OLED 65C1, now rooted with RootMyTV v2. I have been hacking around exploring all the possibilities, and this gist is thus a personal cheatsheet.

Commands

🔄 "Stealth" reboot

If ever your TV goes into servicing at LG for whatever reason, it would be better to have every chances to your sides by not allowing them seeing you made some "not covered" stuff to the TV. A reboot command can be detected, so there's an alternative. But it has to be confirmed yet if it's really stealth or not.

Please however note the following from @Informatic. But we don't know if LG can do something about it:

1. Install `youtube-dl`

https://github.com/ytdl-org/youtube-dl

2. Install `ffmpeg`

https://ffmpeg.org

3. Run `rtsp-simple-server` (repo here)

docker run --rm -it -e RTSP_PROTOCOLS=tcp -p 8554:8554 -p 1935:1935 -p 8888:8888 aler9/rtsp-simple-server

4. Run `ffmpeg` with best available quality Youtube video

	…

	homekit: !include configurations/homekit.yaml
	switch: !include configurations/switches.yaml

	…

	(template Maître Claude)

	Madame, Monsieur,

	Je vous mets solennellement en demeure de vous conformer dans les plus brefs délais aux obligations découlant du Règlement Général sur la Protection des Données (RGPD).
	En effet, comme vous pourrez le constater sur le courrier de démarchage commercial joint en annexe, j'ai reçu un courrier de la part de votre agence, comportant mes nom et adresse. Or, je ne vous ai jamais donné mon consentement pour collecter et utiliser mes données personnelles à des fins de prospection, en violation des articles 5.1.a, 6 et 13 du RGPD.

	Par la présente, je vous somme :

	D'exercer mon droit d'accès prévu à l'article 15 en me communiquant toutes les données me concernant que vous détenez.

	# You can whitelist files/folders with !, those will not be ignored.
	# Everything that starts with a / are for root elements

	# ignore
	/custom_components/
	/zigbee2mqtt/log
	/zigbee2mqtt/state.json
	/home-assistant_v2.* # Exclude Home Assistant history-related database. Make sure to enable git LFS if you don't exclude that, since those files can go easily over 100MB
	/home-assistant.log*
	/.ssh/

	-- Kill System Preferences first if already open
	if application "System Preferences" is running then
	tell application "System Events"
	set theID to unix id of processes whose name is "System Preferences"
	try
	do shell script "kill -9 " & theID
	delay 0.1
	end try
	end tell
	end if