I hereby claim:
- I am millerjp on github.
- I am johnnydigitalis (https://keybase.io/johnnydigitalis) on keybase.
- I have a public key ASBvGSDtstLV_SGs4k2qZbDjzzH2zmgjgDc_knZj_fy29wo
To claim this, I am signing this object:
Johnny Miller millerjp
millerjp
/ keybase.md
Created
January 15, 2019 15:34
millerjp
/ sstable_load.sh
Created
March 14, 2016 19:23
wrapper for sstableloader to load one file at a time, rename and moved completed to directory
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
| #!/bin/bash | |
| #This is the directory that teh sstables will be palce into load - the table name is also going to be changed from v2 to v4 | |
| WORKING_DIR=/somecompany/cassandra/data/sstable_loading_dir/someks/sometable_v4 | |
| COMPLETED_DIR=/somecompany/cassandra/data/sstable_completed_dir | |
| mkdir -p $COMPLETED_DIR | |
| mkdir -p $WORKING_DIR | |
| rm -rf $WORKING_DIR/* |
millerjp
/ nativeReport.sh
Last active
March 11, 2016 09:47
Workout and count which hosts are connecting on the cassandra native port
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
| #!/bin/bash | |
| # Scipt to count connected hosts on port, preform nslookup of hosts and output details | |
| # | |
| HOSTNAME=`hostname` | |
| PORT=$1 | |
| IP_HOSTS_COUNT=`netstat -tn | 'next unless(/^tcp\s+\d+\s+\d+\s+\S+?:${PORT}\s+(\S+)?:/); print "$1\n";' | sort | uniq -c | awk '{print "tohost\t",$1,"\t"$2,"\tfromhost\n"}'` | |
| while read -r line; do |
millerjp
/ extra 1 SELECT bookmark_index
Created
December 27, 2013 21:28
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
| SELECT vid_id, created, time_in_video FROM bookmark_index WHERE user_id = '' AND tvshow_id = 'Baywatch' AND season = '' AND continue_watching = '' AND video_id = ''; | |
| vid_id | created | time_in_video | |
| --------+--------------------------+--------------- | |
| 666QAZ | 2013-12-25 15:12:51+0100 | 20 |
millerjp
/ extra 2 SELECT bookmark_index
Created
December 27, 2013 21:29
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
| SELECT vid_id, created, time_in_video FROM bookmark_index WHERE user_id = '' AND tvshow_id = '' AND season = '' AND continue_watching = '' AND video_id IN ('666QAZ', '666WSX', '666EDC'); | |
| vid_id | created | time_in_video | |
| --------+--------------------------+--------------- | |
| 666QAZ | 2013-12-25 15:12:51+0100 | 20 | |
| 666WSX | 2013-12-26 15:12:51+0100 | 40 | |
| 666EDC | 2013-12-27 15:12:51+0100 | 40 |
millerjp
/ req 3 SELECT bookmark_index
Created
December 27, 2013 21:28
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
| SELECT vid_id, created, time_in_video FROM bookmark_index WHERE user_id = 'johnny' AND tvshow_id = 'Baywatch' AND season = '1' AND continue_watching = '' AND video_id = ''; | |
| vid_id | created | time_in_video | |
| --------+--------------------------+--------------- | |
| 666QAZ | 2013-12-25 15:12:51+0100 | 20 |
millerjp
/ SELECT * FROM bookmark_by_user_tvshow_and_season
Created
December 27, 2013 21:21
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
| SELECT * FROM bookmark_by_user_tvshow_and_season ; | |
| user_id | tvshow_id | season | video_id | continue_watching | created | time_in_video | |
| ---------+--------------+--------+----------+-------------------+--------------------------+--------------- | |
| patrick | A-Team | 5 | 666EDC | True | 2013-12-27 15:12:51+0100 | 40 | |
| hayato | Thundercats | 1 | 666RFV | False | 2013-12-28 15:12:51+0100 | 50 | |
| johnny | Knight Rider | 3 | 666WSX | False | 2013-12-26 15:12:51+0100 | 30 | |
| johnny | Baywatch | 1 | 666QAZ | True | 2013-12-25 15:12:51+0100 | 20 |
millerjp
/ SELECT * FROM bookmark_by_user_continue_watching
Created
December 27, 2013 21:17
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
| SELECT * FROM bookmark_by_user_continue_watching ; | |
| user_id | continue_watching | video_id | created | season | time_in_video | tvshow_id | |
| ---------+-------------------+----------+--------------------------+--------+---------------+-------------- | |
| johnny | True | 666QAZ | 2013-12-25 15:12:51+0100 | 1 | 20 | Baywatch | |
| johnny | False | 666WSX | 2013-12-26 15:12:51+0100 | 3 | 30 | Knight Rider | |
| patrick | True | 666EDC | 2013-12-27 15:12:51+0100 | 5 | 40 | A-Team | |
| hayato | False | 666RFV | 2013-12-28 15:12:51+0100 | 1 | 50 | Thundercats |
millerjp
/ req 2 SELECT bookmark_index
Created
December 27, 2013 21:27
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
| SELECT vid_id, created, time_in_video FROM bookmark_index WHERE user_id = 'johnny' AND tvshow_id = '' AND season = '' AND continue_watching = 'true' AND video_id = ''; | |
| vid_id | created | time_in_video | |
| --------+--------------------------+--------------- | |
| 666QAZ | 2013-12-25 15:12:51+0100 | 20 |
millerjp
/ req 1 SELECT bookmark_index
Created
December 27, 2013 21:26
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
| SELECT vid_id, created, time_in_video FROM bookmark_index WHERE user_id = 'johnny' AND tvshow_id = '' AND season = '' AND continue_watching = '' AND video_id = '666QAZ'; | |
| vid_id | created | time_in_video | |
| --------+--------------------------+--------------- | |
| 666QAZ | 2013-12-25 15:12:51+0100 | 20 |
NewerOlder