Marlom Girardi marlomgirardi

I hereby claim:

To claim this, I am signing this object:

	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:

	# 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` \| \

	-- ------------------
	-- 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>';