This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"""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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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' }), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; | |
$$ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'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': [ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.