bdraco

#!/bin/bash
# curl -o- -L https://gist.githubusercontent.com/bdraco/43f8043cb04b9838383fd71353e99b18/raw/core_integration_pr | bash /dev/stdin -d domain -p 12345

while getopts d:p: flag
do
    case "${flag}" in
        d) domain="${OPTARG}";;
        p) pull_request="${OPTARG}";;
    esac
done

bdraco

fan:
  - platform: template
    fans:
      template_bedroom_fan:
        friendly_name: "Master Bedroom Fan"
        # Measures the power use from a Shelly1 PM and if over 3W, marks the fan as on
        value_template: "{% if states('sensor.bedroom_fan_shelly_power') | float > 3 %}on{% else %}off{% endif %}"
        # Uses the Shelly1 PM sensor value to determine what speed the fan is going at. Only set to measure 33, 66, 100
        percentage_template: "{{ states('sensor.template_fan_percentage_master') }}"
        # Uses a fake switch from an input_boolean as the fan has no way of reporting direction back to HA

bdraco

def remove_foreign_keys(db):
    log("Dropping all foreign key constraints from archive database")

    inspector = reflection.Inspector.from_engine(db.engine)
    fake_metadata = MetaData()

    fake_tables = []
    all_fks = []

    for table_name in db.metadata.tables:

bdraco

class TempDropConstraint(object):
  
  def __init__(self, table, column):
    self.table = table
    self.table_name = table.__tablename__
    self.column = column
    self.constraint = list(self.table.__table__.columns[column.name].foreign_keys)[0]
    self.constraint_name = self.constraint.name
    self.referred_table = self.constraint.column.table.name

bdraco

Jinja compiled templates module loader

This code is part of a Jinja CMS for Google App Engine Python 2.7 and NDB datastore

A Jinja enviroment is created for every CMS site: site_key_id = 'example

The modules are created using compiler.py The resulting code objects are stored in the dadastore using Kind Runtimes and a BlobProperty

The modules can also be saved / downloaded as .pyc in a zip archive: -compiled-templates.zip

bdraco

#!/usr/bin/env python
"""
Python class to interface with local Tesla Powerwall JSON API
https://github.com/piersdd/tesla-powerwall-json-py


Example:

import powerwall_site
gateway_host = '192.168.5.6'