William Liu WilliamQLiu

## index.html
<!DOCTYPE html>
<!-- How to create Mouse Events for D3 -->
<html>

  <head>
    <!-- Load D3 from site -->
    <script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>

    <!-- CSS (Styling) -->
    <style type="text/css">

## sidekiq_monitoring
stats = Sidekiq::Stats.new

stats.queues

stats.enqueued

stats.processed

stats.failed

## small-sample-companies.csv

          
            Strosin-Osinski
            1987
            2015

            
              Ratke, Ankunding and Wilkinson
              1915
              1943

            
              Effertz-Swaniawski
              1915
              1937

            
              Schimmel-Wuckert
              1920
              1980

            
              Mayer-Schinner
              2015
              2015

            
              Zulauf, Reichert and Bogisich
              1912
              1916

            
              Weber-Skiles
              2011
              2011

            
              Powlowski-Kutch
              1960
              1963

            
              Lubowitz-Schmitt
              1989
              1995

            
              Padberg, Johns and Gottlieb
              1976
              1992

## get_table_size.sql
SELECT
    table_name AS "Table",
    round(((data_length + index_length) / 1024 / 1024), 2) as size
FROM information_schema.TABLES
WHERE table_schema = "my_database"
ORDER BY size DESC;

## Dockerfile
ENTRYPOINT ["tail", "-f", "/dev/null"]


## secrets.py
""" Create Quick Keys """
import secrets
print(secrets.token_urlsafe(64))
#'uT_aNtkVomcrkgZc5XFxKVlM3DnrBjcl_3P1yavGm2nqof74IZ5CR2Z1-0ga2jTK4i30I6RGsXodwXPq3repHQ'
# ^ don't use this one

## supervisord.conf
[program:something]
user=vagrant
directory=/app/someapp/
command=uwsgi --ini /app/someapp/something/uwsgi.ini -H /home/vagrant/.virtualenvs/venv/
autorestart=true
start=true

## remove .pyc files
find . -name \*.pyc -delete

## launch_ipdb_on_exception.py
from ipdb import slaunch_ipdb_on_exception
with slaunch_ipdb_on_exception():

## save_query_to_csv
# Run below to save to csv - run each line by line
\T csv
\o ~/my_file.csv
select * from users where created_at > '2017-01-01';
	<!DOCTYPE html>
	<!-- How to create Mouse Events for D3 -->
	<html>

	<head>
	<!-- Load D3 from site -->
	<script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>

	<!-- CSS (Styling) -->
	<style type="text/css">
	stats = Sidekiq::Stats.new

	stats.queues

	stats.enqueued

	stats.processed

	stats.failed
Strosin-Osinski	1987	2015
Ratke, Ankunding and Wilkinson	1915	1943
Effertz-Swaniawski	1915	1937
Schimmel-Wuckert	1920	1980
Mayer-Schinner	2015	2015
Zulauf, Reichert and Bogisich	1912	1916
Weber-Skiles	2011	2011
Powlowski-Kutch	1960	1963
Lubowitz-Schmitt	1989	1995
Padberg, Johns and Gottlieb	1976	1992
	SELECT
	table_name AS "Table",
	round(((data_length + index_length) / 1024 / 1024), 2) as size
	FROM information_schema.TABLES
	WHERE table_schema = "my_database"
	ORDER BY size DESC;
	""" Create Quick Keys """
	import secrets
	print(secrets.token_urlsafe(64))
	#'uT_aNtkVomcrkgZc5XFxKVlM3DnrBjcl_3P1yavGm2nqof74IZ5CR2Z1-0ga2jTK4i30I6RGsXodwXPq3repHQ'
	# ^ don't use this one
	[program:something]
	user=vagrant
	directory=/app/someapp/
	command=uwsgi --ini /app/someapp/something/uwsgi.ini -H /home/vagrant/.virtualenvs/venv/
	autorestart=true
	start=true
	from ipdb import slaunch_ipdb_on_exception
	with slaunch_ipdb_on_exception():
	# Run below to save to csv - run each line by line
	\T csv
	\o ~/my_file.csv
	select * from users where created_at > '2017-01-01';