Show Menu
Cheatography

NERDT Basic Functions Cheat Sheet by

NERDT FUNCTIONS / ALIASES

nerdt-install
(re-)install NERDT bash
nerdt-cleaninstall
clean NERDT install /w backed up .bash_­profile
nu / nerdt-update
update NERDT bash
nl / nerdt-listfunction
list current NERDT functions
ns / nerdt-searchfunction
search current NERDT functions
nsta / nerdt-switchtoadvancedmode
enable extended function set
nstd / nerdt-switchtodefaultmode
switch to default function set
nste / nerdt-switchto-editor
change default NERDT editor

PostgreSQL FUNCTIONS / ALIASES

pgf / tupac / fraud_eng
access PostgreSQL fraud_engineering
pgs
access PostgreSQL deal_health_check

SHORT STANDARD ALIASES

userlookup
search for user with name/email/id
member
search for member with name/id
trans
get change log on API service and object ID
cache
get impbus / bidder cache for object ID
deal_health_check
check deal health last 2 days
mysql_vertica_join
run python script mysql_vertica_join.py

VERTICA FUNCTIONS / ALIASES

v / vertica / rvert
access Vertica reporting host
vb / bvert
access Vertica budget reporting host
vq / vbq
query Vertica report­ing­/buget host
vd / vbd
describe table Vertica report­ing­/buget host
vs / vertsh­erl­ock
access Vertica sherlock reporting host
vcol / vschema
search Vertica table columns

PUT FUNCTIONS (API PUT / POST)

put-removeprohibited-creativeids
Removes prohibited flag from creative ID
put-removeattribute-attributeid-creativeids
Removes attribute from creative ID
put-apiloginenable-userids
Enables api access for a specific set of users
put-deletecreative-memberid-creativeids
Removes a creative under a set member
put-sslreschedule-creativeids
Resche­dules SSL Audit
 

API FUNCTIONS / ALIASES

a -i / auth -i
select API enviro­nment
a dp / auth dw-prod
auth into PROD Console API
a ap / auth api-pr­od
auth into PROD Impbus API
a dct
auth into Client­-Te­sting Console API
st / switch­to
auth into API with user ID
cg / cget / curlget
make API GET call
cput / curlput
make API PUT call
cpost / curlpo­st
make API POST call

MySQL FUNCTIONS / ALIASES

mpa / mpb / mpc
access MySQL production api/bidder/common
mpaq / mpcq / mpbq
query MySQL production api/bidder/common
mpad / mpcd / mpbd
describe table MySQL production api/bidder/common
mcta / mctb / mctc
access MySQL client-testing api/bidder/common
msa / msb / msc
access MySQL sand api/bidder/common
col / mcol / schema
search MySQL table columns
tab / tabcol
search MySQL schema for tables by name
mpr
access MySQL reporting

OPEN/E­DIT­/SOURCE NERDT FILES

bp / bashpr­ofi­le
open bash_profile
bpu / bpf / bpfe
open bash_u­niv­ersal / bash_f­unc­tions / bash_f­unc­tio­ns_ext
sbp / sbpu / sbpf / sbpfe
source bash_p­rofile / bash_u­niv­ersal / bash_f­unc­tions / bash_f­unc­tio­ns_ext
hf / shf
open / source hostfile
pf
open passwords file
bif
open install.sh
cdb / cdbash
change to NERDT bash_files directory
cds / cdscri­pts
change to NERDT bash_scripts directory
cdg / cdgit
change to NERDT git directory
gs / ga / gp / gl
git status / add / pull & push / list

UNIX FUNCTIONS / ALIASES

ls / ls -1l
list files in current dir
lh / ls -d .*
list hidden files in dir
h / history
print bash history
x / exit
logout from bash

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          More Cheat Sheets by iherdt