Skip to content

Instantly share code, notes, and snippets.

View hnykda's full-sized avatar

Daniel Hnyk hnykda

145 followers · 3 following
View GitHub Profile
@hnykda
hnykda / converter.py
Last active August 18, 2024 14:51
Slack to Mattermost Simple Exporter
import json
import os
import argparse
import re
from datetime import datetime
from typing import Dict, List, Any
def load_json(file_path: str) -> Any:
with open(file_path, "r", encoding="utf-8") as f:
@hnykda
hnykda / appscript.gs
Last active August 1, 2024 13:38
docuseal googlesheet public bulk send
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Submissions')
.addItem('Process Scholarships', 'processScholarshipsMenu')
.addItem('Process Waivers', 'processWaiversMenu')
.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.