William Liu WilliamQLiu

## 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

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

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

## run_scp.sh
# scp from a server to your local
scp username@serverhost.com:/file/you/want/log.txt .

## inspect.py
#%%
print "Importing libraries"
import pandas as pd
import sqlalchemy as sa
from sqlalchemy.engine import reflection

#%%
# DB Connection Info
print "Getting MySQL Connection on DB"
USER = 'someusername'

## 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';
	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
	from ipdb import slaunch_ipdb_on_exception
	with slaunch_ipdb_on_exception():
	# scp from a server to your local
	scp username@serverhost.com:/file/you/want/log.txt .
	#%%
	print "Importing libraries"
	import pandas as pd
	import sqlalchemy as sa
	from sqlalchemy.engine import reflection

	#%%
	# DB Connection Info
	print "Getting MySQL Connection on DB"
	USER = 'someusername'
	# 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';