chadbaldwin

alias: Garage Door Open Notification
description: Send out repeating notifications or announcements that the garage door is left open
mode: restart
trigger:
  - platform: state
    entity_id:
      - group.garage_motion
      - binary_sensor.contact_7_contact
condition:
  - condition: state

chadbaldwin

# Start SQL Server docker instance
function Start-SQLServer {
    param (
        [Parameter()][string]$Tag = 'latest'
    )

    $containerName = 'sqlserver'
    $sa_password = 'yourStrong(!)Password'
    $container = docker inspect $containerName | ConvertFrom-Json

chadbaldwin

.

chadbaldwin

tts:
  - platform: google_translate

template:
  - binary_sensor:
      - name: garage_open_no_motion
        state: >
          {{
            (is_state('binary_sensor.contact_7_contact', 'on'))
            and

chadbaldwin

​If you try to add a space to the name in GitHub, it gets trimmed.

If you try to add a space to the name in Windows, it gets trimmed.

The best option seems to be to add the file via command line with the space in the name, then commit and push.

chadbaldwin

$string = 'Tables'
$result = '','/','*/','**/' | ? {$true} -PV left |
    % { '','/','/*','/**' } -PV right |
    % {
        $glob = "${left}${string}${right}"
        $stat = Measure-Command { $list = rg --files -g $glob }
        [pscustomobject]@{
            Glob = $glob
            Count = $list.Count
            Stat = $stat.Milliseconds

chadbaldwin

# configuration.yaml
template:
  - sensor:
      - name: new_entity_id
        device_class: power
        unit_of_measurement: W # watts
        state: "{{ states('sensor.target_entity_id') | default(0, true) | round(2, default=0) }}"

# customize.yaml
sensor.new_entity_id:

chadbaldwin

chadbaldwin

IF OBJECT_ID('tempdb..#gaps','U') IS NOT NULL DROP TABLE #gaps; --SELECT * FROM #gaps
CREATE TABLE #gaps (
    ID int NOT NULL IDENTITY,
    Val int NOT NULL,
);

DECLARE @repeat int, @randval int, @sql nvarchar(MAX);
DECLARE @c int = 1000; -- How many islands to create
WHILE (@c > 0)
BEGIN;

chadbaldwin

------------------------------------------------------------------------------

------------------------------------------------------------------------------
--	DECLARE @VIN VARCHAR(17) = '3FA6PQHR5DR24649O' --VIN with invalid characters test
--	DECLARE @VIN VARCHAR(17) = '3FA6P0HR5DR246490' --VIN with invalid check digit test
	DECLARE @VIN VARCHAR(17) = '1FTFX1E58LKF43489'; --Valid VIN test

DECLARE @VINCheck TABLE (Letter CHAR(1) NOT NULL, [Value] TINYINT NOT NULL);
INSERT INTO @VINCheck
	VALUES	('A',1),('B',2),('C',3),('D',4),('E',5),('F',6),('G',7),('H',8),