Tatham Oddie tathamoddie
tathamoddie
/ Swap unique values.sql
Created
August 5, 2010 01:36
Swap two values in SQL that have a unique constraint
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET NOCOUNT ON | |
| CREATE TABLE Foo | |
| ( | |
| Id int primary key, | |
| SortIndex int unique | |
| ) | |
| GO |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| substitutions: | |
| device_name: demo2 | |
| friendly_name: Demo 2 | |
| ## Boilerplate | |
| esphome: | |
| name: ${device_name} | |
| platform: ESP32 | |
| board: m5stack-core-esp32 |
tathamoddie
/ energy.yaml
Last active
January 3, 2024 08:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rest: | |
| - scan_interval: 15 | |
| resource: https://192.168.180.199/ivp/meters/readings | |
| verify_ssl: false | |
| headers: | |
| Authorization: !secret enphase_api_token | |
| sensor: | |
| - unique_id: enphase_rest_production_meter | |
| name: "Enphase Production Meter" | |
| json_attributes_path: "$.0.channels[0]" |
tathamoddie
/ automation-router-watchdog.yaml
Created
August 7, 2023 04:25
HA automation for a router/modem watchdog
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alias: "[Tech] Router Watchdog" | |
| mode: single | |
| trigger: | |
| - platform: state | |
| entity_id: | |
| - binary_sensor.ping_udm_ipv4 | |
| to: "off" | |
| for: | |
| minutes: 15 | |
| condition: |
tathamoddie
/ washing.yaml
Created
January 5, 2023 09:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alias: "[Washing] Done" | |
| description: "" | |
| trigger: | |
| - platform: numeric_state | |
| entity_id: sensor.washing_machine_power | |
| for: | |
| hours: 0 | |
| minutes: 0 | |
| seconds: 0 | |
| above: "500" |
tathamoddie
/ 0-home.yaml
Created
August 5, 2022 03:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## ui-views/0-home.yaml | |
| title: Home | |
| path: home | |
| icon: mdi:home | |
| badges: | |
| - sun.sun | |
| - sensor.moon | |
| - person.matt | |
| - person.tats |
tathamoddie
/ Post Notification.yaml
Last active
January 12, 2023 23:38
— forked from andrew-codechimp/Post Notification.yaml
Home Assistant Post Notification Example
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alias: Post Notification | |
| description: "" | |
| mode: restart | |
| trigger: | |
| - platform: state | |
| entity_id: | |
| - binary_sensor.z2maqarareed01_contact | |
| from: "on" | |
| to: "off" | |
| for: |
tathamoddie
/ roller-door.yaml
Created
November 20, 2022 09:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| substitutions: | |
| device_name: roller-door | |
| friendly_name: Roller Door | |
| ## Board config | |
| esphome: | |
| name: ${device_name} | |
| platform: ESP32 | |
| board: m5stack-core-esp32 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <style type="text/css">html { font-size: 200%; }</style> | |
| <script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js"></script> | |
| <script type="text/javascript"> | |
| $(function () { | |
| $("#find-link").click(function (e) { |
tathamoddie
/ automations.yaml
Last active
October 10, 2022 16:57
https://twitter.com/TathamOddie/status/1289018046384766976
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - alias: Notify when gate buzzing | |
| trigger: | |
| - entity_id: binary_sensor.gate_buzzer | |
| from: 'off' | |
| platform: state | |
| to: 'on' | |
| condition: [] | |
| action: | |
| - service: notify.everyone | |
| data: |
NewerOlder