Here is my take on a coronavirus dashboard that uses daily updated json data from countries. To view the covid19.py dashboard click here: covid19-normal.html To view the log scale covid19.py dashboard clickRead More…
Below is examples of passing arguments to python via regular argument assignment, and tuples and *tuples, and dictionaries and **dictionaries. Here is my gist link for it: https://gist.github.com/anonymous/271d6160cdd90a482b40 (older) Not covering all methods (forRead More…
Rule of thumb: when implementing a function or program, you should implement it at the end points. Quote: End-to-end connectivity is a property of the Internet that allows all nodes of the network toRead More…
So you changed a file and now you want the original back (the original from the last commit). You want to undo the changes. I do it like this: git checkout HEADRead More…
Articles to check out: * https://www.digitalocean.com/community/tutorials/how-to-install-and-use-ack-a-grep-replacement-for-developers-on-ubuntu-14-04 * http://beyondgrep.com/why-ack/ * http://readwrite.com/2010/11/10/how-to-search-your-source-with GREP (rinIE) or EGREP (rinI) the all round search utility
|
1 2 3 |
grep -rinIE "match word" /folder grep -rinIE "match word" /folder egrep -rinI "match word" /folder |
NOTE: the grep article recommend -inIEr, but thats hard to remember,Read More…
This article is probably worth reading twice due to my style of writing (sorry). Read the comments as they have alot of informational text. I tried to make them understandable to aRead More…
If you want to convert a program to hexdecimal or binary out, here is two programs to do so. First get your pre-reqs:
|
1 2 3 4 |
apt-get update apt-get install python apt-get install pip pip install bitstring |
Note: these programs would work outside of linux,Read More…
VIM PRINT WHITESPACE CHARACTERS SET LIST and NO LIST #################################################### Info from: http://stackoverflow.com/questions/1675688/make-vim-show-all-white-spaces-as-a-character When programming in python via vi or vim its important to know where you have those pesky tabs so thatRead More…
Here is a copy paste of my answer on stackexchange forums LESSON ON REMOVING NEWLINES and EMPTY LINES WITH SPACES “t” is the variable with the text. You will see an “s”Read More…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 |
##################################### # SQLITE3 INPUT COMMANDS CHEATSHEET # ##################################### ######### dot commands ############ # dump all of the database sqlite3 file1.db .dump # see tables sqlite3 file1.db .table ######### sql commands ############ # run one command (to select all from a table called $table1) # Note needed to escape the $ if you do " ' ' " sqlite3 file1.db "select * from '\$table1';" # No need to escape the $ if you do ' " " ' (because bash doesnt expand $ within '') sqlite3 file1.db 'select * from "$table1";' # regular tables name sqlite3 file1.db 'select * from table2;' sqlite3 file1.db "select * from table2;" # You can essentially stack these sql commands: sqlite3 file1.db "select * from table2; select * from table3;" sqlite3 file1.db "select * from '\$table1'; select * from table3;" ######### echo ############ # you can also echo in commands - echo dot commands echo ".dump" | sqlite3 file1.db echo ".table" | sqlite3 file1.db # echo sql commands echo "select * from '\$table1';" | sqlite3 file1.db echo 'select * from "$table1";' | sqlite3 file1.db echo 'select * from table2;' | sqlite3 file1.db echo "select * from table2;" | sqlite3 file1.db ######### echo -e ############ # What about sqlite . commands with sql commands - then you need to echo them in with -e. dot commands need to be on a new line, so we need to emulate a new line with echo -e (using \n in the string). -e with echo allows echo to take in special characters such as \n for newline (or \t for tab, but we dont use the tab) # Lets say you want to do the following 2 commands: # .header on (which shows column names) # select * from table2 (which shows the output of tables2) # Since dot command need to end with a newline, our echo needs to be able to do that. Thats why we use a "echo -e" which we can specify special commands thru. # rule1: after every dot command put a \n # rule2: if not the first command, then put \n before every dot command # rule3: dont forget to end sql commands with ; # tip: just run the echo by itself to make sure each dot command is on its own line. # syntax is: echo -e "<.dotcommand>\n<sqlcommand1>;<sqlcommand2>;\n<.dotcommand>\n<sqlcommand3>;" | sqlite3 file.db # simple example: echo -e ".header on\nselect * from table2;" | sqlite3 file1.db # if we were to just run the echo command, you would see this (which helps understand it): echo -e ".header on\nselect * from table2;" # OUTPUT: # .header on # select * from table2; # more chained complex command: echo -e ".header on\nselect * from table2;select * from '\$table1';\n.header off\nselect * from '\$table4';" | sqlite3 file1.db # running the echo by itself: echo -e ".header on\nselect * from table2;select * from '\$table1';\n.header off\nselect * from '\$table4';" # OUTPUT: # .header on # select * from table2;select * from '$table1'; # .header off # select * from '$table4'; |