Skip to content

Instantly share code, notes, and snippets.

View hnykda's full-sized avatar

Daniel Hnyk hnykda

142 followers · 3 following
View GitHub Profile
@hnykda
hnykda / appscript.gs
Last active February 20, 2024 12:34
docuseal googlesheet public bulk send
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Submissions')
.addItem('Process Scholarships', 'processScholarshipsMenu')
.addToUi();
}
function processScholarshipsMenu() {
processSubmissions('scholarships');
}
@hnykda
hnykda / Comp.tsx
Last active February 8, 2024 22:38
"use client";
import React, { useState, useEffect } from "react";
const Comp = ({
existingDataPromise,
moveItemSideEffect,
}: {
existingDataPromise: Promise<string[]>;
moveItemSideEffect: () => void;
}) => {
@hnykda
hnykda / trafri.py
Created August 7, 2021 12:14
import paho.mqtt.client as mqtt
import json
client = mqtt.Client()
client.username_pw_set("z2muser", "z2pass")
client.connect("192.168.0.201", 1883)
topic = "zigbee2mqtt/tradfi_alpha/set"
from time import sleep
@hnykda
hnykda / vicare_manual_set.py
Last active October 29, 2023 12:30
Home Assistant PyScript setting temperatures via pyvicare
from PyViCare.PyViCare import PyViCare
COMFORT = "comfort"
NORMAL = "normal"
REDUCED = "reduced"
SLEEP = 5
@pyscript_executor
@hnykda
hnykda / automations.yaml
Last active July 23, 2023 13:13
Brink flair integration with homeassistant (https://community.home-assistant.io/t/integrating-brink-flair-325-hrv-with-home-assistant/333317)
- alias: "Set ventilation Mode Selector"
trigger:
platform: mqtt
topic: "ventilation/mode"
# entity_id: input_select.ventilation_mode
action:
service: input_select.select_option
target:
entity_id: input_select.ventilation_mode
data:
@hnykda
hnykda / keras.py
Last active June 15, 2023 04:11
Tada's usage (see discussion)
""" From: http://danielhnyk.cz/predicting-sequences-vectors-keras-using-rnn-lstm/ """
from keras.models import Sequential
from keras.layers.core import TimeDistributedDense, Activation, Dropout
from keras.layers.recurrent import GRU
import numpy as np
def _load_data(data, steps = 40):
docX, docY = [], []
for i in range(0, data.shape[0]/steps-1):
docX.append(data[i*steps:(i+1)*steps,:])
@hnykda
hnykda / gist:af13672d27fe75eee10c19055a51003c
Created May 3, 2023 12:55
# How to run it
```
sqlite3 Test.db ".read scripts/init.sql" # creates the dabatase structure
sqlite3 Test.db ".read scripts/seed.sql" # populates with dummy data
sqlite3 Test.db ".read scripts/query1.sql"
sqlite3 Test.db ".read scripts/query2.sql"
```
To run the rules program:
@hnykda
hnykda / main.py
Created April 25, 2023 08:09
generatingDnds
import os
import glob
import argparse
import json
from supabase import create_client, Client
url: str = os.environ.get("NEXT_PUBLIC_SUPABASE_URL")
key: str = os.environ.get("SUPABASE_SERVICE_ROLE_KEY")
supabase: Client = create_client(url, key)
@hnykda
hnykda / settings
Created April 12, 2023 20:19
{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4, "mode":"white"},"wifi_ap":{"enabled":false,"ssid":"shellyrgbw2-807745","key":""},"wifi_sta":{"enabled":true,"ssid":"artpolis","ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"wifi_sta1":{"enabled":false,"ssid":null,"ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"ap_roaming":{"enabled":false,"threshold":-70},"mqtt": {"enable":false,"server":"192.168.33.3:1883","user":"","id":"shellyrgbw2-807745","reconnect_timeout_max":60.000000,"reconnect_timeout_min":2.000000,"clean_session":true,"keep_alive":60,"max_qos":0,"retain":false,"update_period":30},"coiot": {"enabled":true,"update_period":15,"peer":""},"sntp":{"server":"time.google.com","enabled":true},"login":{"enabled":false,"unprotected":false,"username":"admin"},"pin_code":"","name":null,"fw":"20230329-162716/v1.13.0-rc2-g1b3e5af","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20230329-162716/v1.13
@hnykda
hnykda / settings
Created April 5, 2023 14:12
{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4, "mode":"white"},"wifi_ap":{"enabled":false,"ssid":"shellyrgbw2-807745","key":""},"wifi_sta":{"enabled":true,"ssid":"artpolis","ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"wifi_sta1":{"enabled":false,"ssid":null,"ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"ap_roaming":{"enabled":false,"threshold":-70},"mqtt": {"enable":false,"server":"192.168.33.3:1883","user":"","id":"shellyrgbw2-807745","reconnect_timeout_max":60.000000,"reconnect_timeout_min":2.000000,"clean_session":true,"keep_alive":60,"max_qos":0,"retain":false,"update_period":30},"coiot": {"enabled":true,"update_period":15,"peer":""},"sntp":{"server":"time.google.com","enabled":true},"login":{"enabled":false,"unprotected":false,"username":"admin"},"pin_code":"","name":null,"fw":"20221027-100516/v1.12.1-ga9117d3","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20221027-100516/v1.12.1-g