Skip to content

Instantly share code, notes, and snippets.

💭
I may be slow to respond.

Webysther Nunes Webysther

💭
I may be slow to respond.
Block or report user

Report or block Webysther

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View tricks.sql
date_parse('2019-05-01 23:05:04','%Y-%m-%d %H:%i:%s');
date_format(col,'%Y-%m-%d %H:%i:%s');
# athena snapshot
date_parse('20190501T23:00:00','%Y%m%dT%H:%i:%s');
# converte data em milisegundos para segundos
from_unixtime(to_unixtime(created_at)/1000)
@Webysther
Webysther / folder_bucket_clean.py
Created Sep 27, 2018
Bucket 'folder' cleanup
View folder_bucket_clean.py
def bucket_cleanup(name, path):
s3 = boto3.resource('s3')
bucket = s3.Bucket(name)
objects_to_delete = []
for obj in bucket.objects.filter(Prefix=path):
objects_to_delete.append({'Key': obj.key})
bucket.delete_objects(
Delete={
@Webysther
Webysther / vpn.sh
Created Jan 13, 2018
OpenVPN Install Ubuntu 16.04
View vpn.sh
sudo apt install openvpn
sudo apt install network-manager-openvpn
sudo apt-get install network-manager-openvpn-gnome
# Using GUI or cli command:
sudo openvpn --config /path/to/openvpn.ovpn
@Webysther
Webysther / console.js
Created Nov 6, 2017
Remove message more fast on Linkedin
View console.js
/**
* 1 - Execute this code on console inside message linkedin
* 2 - Click em message you want to delete to direct deletion
*/
async function remove(){
$('.msg-thread__topcard-overflow-icon').click();
await new Promise(resolve => setTimeout(resolve, 1000));
$('.delete').each(function(){
this.click();
var found = "";
You can’t perform that action at this time.