Skip to content

Instantly share code, notes, and snippets.

View nrodriguez's full-sized avatar
🏠
Working from home

Nephtali Rodriguez nrodriguez

🏠
Working from home
View GitHub Profile
@nrodriguez
nrodriguez / query.sql
Last active July 26, 2021 18:47
LucidChart query
SELECT 'mysql' dbms,t.TABLE_SCHEMA,t.TABLE_NAME,c.COLUMN_NAME,c.ORDINAL_POSITION,c.DATA_TYPE,c.CHARACTER_MAXIMUM_LENGTH,n.CONSTRAINT_TYPE,k.REFERENCED_TABLE_SCHEMA,k.REFERENCED_TABLE_NAME,k.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLES t
LEFT JOIN INFORMATION_SCHEMA.COLUMNS c ON t.TABLE_SCHEMA=c.TABLE_SCHEMA AND t.TABLE_NAME=c.TABLE_NAME
LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE k ON c.TABLE_SCHEMA=k.TABLE_SCHEMA AND c.TABLE_NAME=k.TABLE_NAME AND c.COLUMN_NAME=k.COLUMN_NAME
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS n ON k.CONSTRAINT_SCHEMA=n.CONSTRAINT_SCHEMA AND k.CONSTRAINT_NAME=n.CONSTRAINT_NAME AND k.TABLE_SCHEMA=n.TABLE_SCHEMA AND k.TABLE_NAME=n.TABLE_NAME
WHERE t.TABLE_TYPE='BASE TABLE' AND t.TABLE_SCHEMA NOT IN('INFORMATION_SCHEMA','mysql','performance_schema') AND t.TABLE_NAME IN(
'actor_action_reasons',
'actor_action_rules',
'actor_roles',
'adjustment_actions',
@nrodriguez
nrodriguez / card_problem.js
Last active October 13, 2020 18:37
Card Problem
/* Construct the basics for a given card game.
Build out the functionality to:
Build a card deck
Retrieve a random card from the deck
Retrieve a random suited card from the deck
Shuffle the deck
Deal a card from a given deck
Deal a hand of X cards from a given deck
Deal a number of hands to a given set of players
@nrodriguez
nrodriguez / addons.json
Created August 24, 2016 05:42
Addons List for Curse/WoWInterface
[
{
"path": "SpellGainz",
"repo": "SpellGainz",
"curse": "spellgainz",
"wowi": "24154",
"changelog": true,
"changelogPath": "CHANGELOG.md"
}
]
SqsFacade.new
-> <SqsFacade:0x007fcea2944260 @full_message={"Type"=>"Notification", "MessageId"=>"be3b6b8b-ce76-4e6e-a800-bba8377a37a7", "TopicArn"=>"arn:aws:sns:us-east-1:31cf754f-bbd7-4c14-9c78-e81f7d115958:some-sns-topic", "Subject"=>"entityupsert", "Message"=>"{\"something\":\"hey\",\"really\":\"there\",\"cool\":\"lonely girl\"}", "Timestamp"=>"2016-05-19T19:53:01.936Z", "SignatureVersion"=>"1", "Signature"=>"c+9MIvg7+87QVQzm3xAxog==", "SigningCertURL"=>"https://sns.us-east-1.amazonaws.com/eb74a61a20c15ac1c53db21a4af05993.pem", "UnsubscribeURL"=>"https://sns.us-east-1.amazonaws.com/?Action=Unsubscribe&SubscriptionArn=arn:aws:sns:us-east-1:31cf754f-bbd7-4c14-9c78-e81f7d115958:some-sns-topic:1234"}>
Worker
Nephtalis-MacBook-Pro.local:56187 on MAILER at just now Retry or Remove
Class
UserMailer
Arguments
"tutor_advertisement"
{"about_me"=>"<p>Nulla doloribus et fuga culpa. Molestias repudiandae commodi incidunt quo nulla voluptas ad. Soluta provident dolorem et @\#$% qui voluptatem. Consequatur aliquam voluptas.</p><p>Autem qui suscipit recusandae ex. Qui amet et maxime modi sint debitis quae. Enim similique velit sunt fugit animi. Magnam ratione qui provident veniam dolores quo unde.</p><p>Commodi provident enim dolor sed modi nihil reprehenderit. Eum quae odio temporibus quis totam et. Autem qui ut sit. Ut cumque sint. Velit et dolorum fugiat.</p><p>Est minus aliquam iste eligendi voluptas dicta adipisci. Sit quis quos est. Ipsum inventore quae.</p>", "activation_datetime"=>nil, "activation_token"=>"uRKDkhMJKJzNPUvi", "authorize_net_profile_id"=>nil, "availability_bitmask"=>"00000000000000000000000000000000000000000000000000000000", "badges"=>{}, "birthdate"=>nil, "cancellation_period"=>nil, "contractor
@nrodriguez
nrodriguez / .bashrc
Last active October 12, 2015 21:28
BashRC
PATH=$PATH:$HOME/.rvm/bin # Add RVM to PATH for scripting
[[ -s "$HOME/.rvm/scripts/rvm" ]] && . "$HOME/.rvm/scripts/rvm"
alias ..='cd ..'
alias ...='cd ../..'
alias slt='open -a "Sublime Text"'
alias sourcerc="source ~/.bashrc"
alias clearOrig='echo "Removing .orig files..."; find . -name *.orig | while read -d $'\''\n'\'' file; do rm -v "$file"; done;'