Skip to content

Instantly share code, notes, and snippets.

@jasonho-lynx
jasonho-lynx / test.ipynb
Created March 26, 2021 03:13
test nbviewer
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jasonho-lynx
jasonho-lynx / org_chart.csv
Created June 22, 2021 03:15
org_chart.csv
source relation target
COO reports to CEO
CFO reports to CEO
CTO reports to CEO
Head of Accounting reports to CFO
Head of Legal reports to COO
Director of Marketing reports to COO
Director of Sales reports to COO
Director of Engineering reports to CTO
Marketeer 1 reports to Director of Marketing
@jasonho-lynx
jasonho-lynx / state.py
Last active June 22, 2021 04:17
state.py
'data': [
{
'nodes': [
{'id': 'COO', 'value': 'COO', 'name': 'COO'},
{'id': 'CEO', 'value': 'CEO', 'name': 'CEO'},
{'id': 'CFO', 'value': 'CFO', 'name': 'CFO'},
{'id': 'CTO', 'value': 'CTO', 'name': 'CTO'},
...
],
'edges': [
-- users table
CREATE TABLE public.users (
id UUID PRIMARY KEY,
email TEXT,
created_at TIMESTAMP WITH TIME ZONE
);
-- table to store files that users create
CREATE TABLE public.files (
id UUID DEFAULT uuid_generate_v4() PRIMARY KEY,
-- trigger function is created here (not the actual trigger).
CREATE OR REPLACE FUNCTION insert_into_public_users()
RETURNS TRIGGER AS $$
BEGIN
INSERT INTO public.users (id, email, created_at)
VALUES(NEW.id, NEW.email, NOW());
RETURN NEW;
END;
$$
import { createClient } from '@supabase/supabase-js';
const SUPABASE_URL = YOUR_SUPABASE_URL;
const SUPABASE_PUBLIC = YOUR_SUPABASE_ANON_KEY;
const supabase = createClient(SUPABASE_URL, SUPABASE_PUBLIC);
const doSignUps = async () => {
const signUps = [
supabase.auth.signUp({ email: 'owner@email.com', password: '123456' }),
# refer to https://github.com/cylynx/verifyml/blob/main/verifyml/model_tests/ModelTest.py for latest version
@dataclass
class ModelTest(ABC):
"""Base class for all FEAT tests"""
result: any = field(init=False, default=None)
passed: bool = field(init=False, default=None)
@abstractmethod
@jasonho-lynx
jasonho-lynx / format_sql.py
Created February 22, 2023 07:44
Formats SQL files in a repo using the clickhouse-format package.
"""Formats SQL files in this repo using the clickhouse-format package. Prints a list of files that
require manual formatting e.g. those with %()s params or queries that use backticks for column
names.
"""
import subprocess
from glob import glob
sql_files = glob("**/*.sql", recursive=True)