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 / 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
@hnykda
hnykda / settings.json
Created March 31, 2023 09:46
{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4},"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":"20220209-094013/v1.11.8-g8c7bb8d","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20220209-094013/v1.11.8-g8c7bb8d","build_
@hnykda
hnykda / esphome.yaml
Created March 21, 2023 22:03
substitutions:
device_name: bottommirror
esphome:
name: ${device_name}
platform: ESP8266
board: esp01_1m
logger:
api:
@hnykda
hnykda / log.txt
Created March 18, 2023 15:07
log
This file has been truncated, but you can view the full file.
@hnykda
hnykda / gist:dcf19279cd34b07a08cb25be4589c9c1
Created February 3, 2023 15:21
deco-log
Fri Aug 5 13:33:52 2022 daemon.notice netifd: Interface 'wanv6' is setting up now
Fri Aug 5 13:33:52 2022 user.debug netifd: ubus call network.interface notify_proto { "action": 1, "command": [ "\/usr\/sbin\/pppd", "nodetach", "ifname", "pppoev6-wanv6", "ipparam", "wanv6", "lcp-echo-interval", "20", "lcp-echo-failure", "5", "nodefaultroute", "noaccomp", "nopcomp", "ipv6", "maxfail", "1", "user", "wia", "password", "wia", "ip-up-script", "\/lib\/netifd\/pppv6-up", "ipv6-up-script", "\/lib\/netifd\/pppv6-up", "ip-down-script", "\/lib\/netifd\/ppp-down", "ipv6-down-script", "\/lib\/netifFri Aug 5 13:33:52 2022 daemon.info pppd[18458]: pppoe_init() success
Fri Aug 5 13:33:52 2022 daemon.notice netifd: wanv6 (18458): pppoe_init() success
Fri Aug 5 13:33:52 2022 daemon.notice pppd[18458]: PPPoE DevName Hook, the name is nic-br-wan
Fri Aug 5 13:33:52 2022 daemon.notice netifd: wanv6 (18458): PPPoE DevName Hook, the name is nic-br-wan
Fri Aug 5 13:33:52 2022 daemon.notice pppd[18458]: make the channel with pp