Paul English paul-english

## build_interpro_db.py
import os
import sqlite3
from xml.etree.ElementTree import iterparse
from tqdm import tqdm
import json


def create_database(dbname: str):
    # Create a connection to the SQLite database
    conn = sqlite3.connect(dbname)

## gist:94bce97cbbebf5e9e73d634021ad2eb1
### version information

```
pre-commit version: 2.18.1
git --version: git version 2.32.0 (Apple Git-132)
sys.version:
    3.9.7 (default, Sep 16 2021, 08:50:36)
    [Clang 10.0.0 ]
sys.executable: /Users//opt/anaconda3/bin/python
os.name: posix

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                paul-english
                / keybase.md
            
            
              Created
              March 17, 2022 17:48
            
              
                keybase.md
              
          
    Keybase proof

I hereby claim:

I am paul-english on github.
I am log0ymxm (https://keybase.io/log0ymxm) on keybase.
I have a public key whose fingerprint is 09EA 4D46 DD08 D8E3 CEC3  AA7C A967 2C1A 03D1 840A

To claim this, I am signing this object:

  
## little_library_tour.html
<!DOCTYPE html>
<head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8" />

        <script>
            L_NO_TOUCH = false;
            L_DISABLE_3D = false;
        </script>

    <style>html, body {width: 100%;height: 100%;margin: 0;padding: 0;}</style>

## unisplat.py
from tqdm import tqdm
import csv

order = [
    "",
    "ID",
    "AC",
    "DT",
    "DE",
    "GN",

## redis_disjoint_set.py
import random

class RedisDisjointSet(object):
    """
    https://en.wikipedia.org/wiki/Disjoint-set_data_structure

    UTF-8 based persistent disjoint set structure that just assumes there's a local redis
    """

    def __init__(self, seed=None):

## gist:f1f9527fdeed923ce11c70e4713d3c62
echo "echo 'sleep 1' >> ~/.profile" >> ~/.profile

## naics_lookup_table.sql
create table penglish_scratch.naics_desc_lookup (
code varchar(6) sortkey distkey,
description varchar(255)
);


insert into penglish_scratch.naics_desc_lookup values
('11', 'Agriculture, Forestry, Fishing and Hunting'),
('111', 'Crop Production'),
('1111', 'Oilseed and Grain Farming'),

## parse_elixir_dump_column.py
from lark import Lark

l = Lark('''
?start: elixir_item | json_value | xml | node

///////////////////////
// JSON

?json_value: json_object
          | json_array

## gist:0228d2263982afc41e8e582d270e8493
import requests

from slackclient import SlackClient

DAYS = 1
FTL_URL = "https://backend.thefoodtruckleague.com/events/?days=%s&name=" % DAYS
SLACK_TOKEN = ""

def post_food_trucks_for_the_day():
    sc = SlackClient(SLACK_TOKEN)
	import os
	import sqlite3
	from xml.etree.ElementTree import iterparse
	from tqdm import tqdm
	import json


	def create_database(dbname: str):
	# Create a connection to the SQLite database
	conn = sqlite3.connect(dbname)
	### version information

	```
	pre-commit version: 2.18.1
	git --version: git version 2.32.0 (Apple Git-132)
	sys.version:
	3.9.7 (default, Sep 16 2021, 08:50:36)
	[Clang 10.0.0 ]
	sys.executable: /Users//opt/anaconda3/bin/python
	os.name: posix
	<!DOCTYPE html>
	<head>
	<meta http-equiv="content-type" content="text/html; charset=UTF-8" />

	<script>
	L_NO_TOUCH = false;
	L_DISABLE_3D = false;
	</script>

	<style>html, body {width: 100%;height: 100%;margin: 0;padding: 0;}</style>
	from tqdm import tqdm
	import csv

	order = [
	"",
	"ID",
	"AC",
	"DT",
	"DE",
	"GN",
	import random

	class RedisDisjointSet(object):
	"""
	https://en.wikipedia.org/wiki/Disjoint-set_data_structure

	UTF-8 based persistent disjoint set structure that just assumes there's a local redis
	"""

	def __init__(self, seed=None):
	create table penglish_scratch.naics_desc_lookup (
	code varchar(6) sortkey distkey,
	description varchar(255)
	);


	insert into penglish_scratch.naics_desc_lookup values
	('11', 'Agriculture, Forestry, Fishing and Hunting'),
	('111', 'Crop Production'),
	('1111', 'Oilseed and Grain Farming'),
	from lark import Lark

	l = Lark('''
	?start: elixir_item \| json_value \| xml \| node

	///////////////////////
	// JSON

	?json_value: json_object
	\| json_array
	import requests

	from slackclient import SlackClient

	DAYS = 1
	FTL_URL = "https://backend.thefoodtruckleague.com/events/?days=%s&name=" % DAYS
	SLACK_TOKEN = ""

	def post_food_trucks_for_the_day():
	sc = SlackClient(SLACK_TOKEN)