marlomgirardi

blueprint:
  name: Shutter Position Fix
  description: A fix for 'TS130F by _TZ3210_dwytrmda' position
  domain: automation
  source_url: https://gist.github.com/marlomgirardi/4fca8e6097520727d6cf88056798a8de#file-cover_position_fix-yaml
  author: Marlom Girardi
  input:
    shutter_entity:
      name: Shutter to be fixed
      selector:

marlomgirardi

Keybase proof

I hereby claim:

• I am marlomgirardi on github.
• I am marlom (https://keybase.io/marlom) on keybase.
• I have a public key ASDsmSBzCGbzaKLf63cVI2lX30nJLqdKCw9Y9PAwIvu7iwo

To claim this, I am signing this object:

marlomgirardi

# 1. Get Kernels
# 2. Filter installed only
# 3. Remove current kernel from list
# 4. Purge all kernels on list
# 5. Auto-remove
# 6. Update grub list

sudo dpkg --list 'linux-image*' | \ 
    awk '{ if ($1=="ii") print $2}' | \
    grep -v `uname -r` | \

marlomgirardi

-- ------------------
-- FIND FK TO A TABLE
SELECT 
  TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = '<database>' AND
  REFERENCED_TABLE_NAME = '<table>';