| import json | |
| from typing import AbstractSet, Any, Generator, Mapping, Sequence, ValuesView | |
| import dagster as dg | |
| from dagster import ( | |
| AssetCheckResult, | |
| AssetExecutionContext, | |
| AssetKey, | |
| AssetMaterialization, | |
| AssetObservation, |
| CREATE SECRET http ( | |
| TYPE HTTP, | |
| EXTRA_HTTP_HEADERS MAP { | |
| 'Authorization': 'Bearer sk_test_VePHdqKTYQjKNInc7u56JBrQ' | |
| } | |
| ); | |
| select unnest(data) as customers | |
| from read_json('https://api.stripe.com/v1/customers'); |
| find . -type f -print0 | xargs -0 stat -f "%z" | awk '{b+=$1} END { | |
| if (b > 1073741824) { | |
| printf "%.2f GB\n", b/1073741824 | |
| } else if (b > 1048576) { | |
| printf "%.2f MB\n", b/1048576 | |
| } else if (b > 1024) { | |
| printf "%.2f KB\n", b/1024 | |
| } else { | |
| printf "%d bytes\n", b | |
| } |
All of these diagrams are dynamically rendered during html display by Github, the images generated from text inside the Github-Flavored Markdown. None are static images. Mermaid support was released for Github on 2022-02-14
Pros & Cons:
Notes:
B-->C[fa:fa-ban forbidden], hyperlink and tooltips) are supported by Github.
| with "columns" as ( | |
| select ' - name: ' || column_name || '\n description: '|| lower(column_name) || ' (data type '|| lower(DATA_TYPE) || ')' | |
| as column_statement, | |
| table_name | |
| from information_schema.columns | |
| where table_schema = 'TABLE_NAME' | |
| order by 1 | |
| ), | |
| tables as ( |
| #!/bin/bash | |
| # RSS feed header | |
| echo '<?xml version="1.0" encoding="UTF-8" ?>' > blog.xml | |
| echo '<rss version="2.0">' >> blog.xml | |
| echo ' <channel>' >> blog.xml | |
| echo ' <title>RSS feed title</title>' >> blog.xml | |
| echo ' <link>https://example.com</link>' >> blog.xml | |
| echo ' <description>Example RSS feed </description>' >> blog.xml |
| -- Two dashes start a one-line comment. | |
| --[[ | |
| Adding two ['s and ]'s makes it a | |
| multi-line comment. | |
| --]] | |
| ---------------------------------------------------- | |
| -- 1. Variables and flow control. | |
| ---------------------------------------------------- |
| Filter | Description | Example |
|---|---|---|
| allintext | Searches for occurrences of all the keywords given. | allintext:"keyword" |
| intext | Searches for the occurrences of keywords all at once or one at a time. | intext:"keyword" |
| inurl | Searches for a URL matching one of the keywords. | inurl:"keyword" |
| allinurl | Searches for a URL matching all the keywords in the query. | allinurl:"keyword" |
| intitle | Searches for occurrences of keywords in title all or one. | intitle:"keyword" |
| import heapq | |
| class MedianCalculator: | |
| def __init__(self): | |
| self.heaps = [], [] | |
| def add_num(self, num): | |
| small, large = self.heaps | |
| heapq.heappush(small, -heapq.heappushpop(large, num)) | |
| if len(large) < len(small): |