abubelinha’s gists

abubelinha / iframe-killa.js

Created March 2, 2022 23:07 — forked from rodmcnew/iframe-killa.js

This is a bookmarklet that removes all iframes from the current page. Paste its code into a bookmark URL field. Click the bookmark to remove all iframes. Once started, it also removes newly spawned iframes every 100ms.

javascript:void(function(){setInterval(function(){document.querySelectorAll('iframe').forEach(function(element){console.log('Iframe Killa - Removing Element:', element);element.parentNode.removeChild(element)})},100)}());

abubelinha / col_versions.R

Created February 12, 2022 20:02 — forked from cboettig/col_versions.R

	library(tidyverse)

	# 2017 monthly
	x <- tempfile("col")
	dir.create(x)
	download.file("https://download.catalogueoflife.org/col/monthly/2017-02-27_dwca.zip", file.path(x, "dwca.zip"))
	unzip(file.path(x, "dwca.zip"), exdir = x)
	fs::dir_ls(x)
	taxa <- readr::read_tsv(file.path(x, "taxa.txt"), guess_max=1e6, quote="", col_types = readr::cols(.default = "c"))
	taxa %>% filter(specificEpithet == "sapiens", taxonomicStatus == "accepted name", genus=="Homo")

abubelinha / reportlab_hello.py

Created January 3, 2022 18:56 — forked from cwebber314/reportlab_hello.py

Reportlab hello world with an image, bulleted list, and enumerated list.

	"""
	Reportlab sandbox.
	"""
	from reportlab.lib.enums import TA_JUSTIFY
	from reportlab.lib.pagesizes import letter, landscape

	from reportlab.lib.enums import TA_JUSTIFY
	from reportlab.lib.pagesizes import letter
	from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Image
	from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle

abubelinha / dbbackup.py

Last active February 26, 2022 19:13 — forked from trafficinc/dbbackup.py

Python script for taking mysqldump

	#!/usr/local/bin/python3

	"""
	Will backup all the databases listed, will put files in same DIR as script'
	To run: $ python dbbackup.py
	"""

	import configparser
	import os
	import time

abubelinha / df_to_markdown.py

Last active November 7, 2021 09:15 — forked from jplsightm/df_to_markdown.py

Convert a Pandas Dataframe to Markdown

	import pandas as pd
	from tabulate import tabulate

	def pandas_df_to_markdown_table(df):
	# Dependent upon ipython
	# shamelessly stolen from https://stackoverflow.com/questions/33181846/programmatically-convert-pandas-dataframe-to-markdown-table
	from IPython.display import Markdown, display
	fmt = ['---' for i in range(len(df.columns))]
	df_fmt = pd.DataFrame([fmt], columns=df.columns)
	df_formatted = pd.concat([df_fmt, df])

abubelinha / push_file_to_github_repo_branch.py

Created October 29, 2021 18:04 — forked from avullo/push_file_to_github_repo_branch.py

Push file update to GitHub repository using GitHub API in Python

	import requests
	import base64
	import json
	import datetime


	def push_to_repo_branch(gitHubFileName, fileName, repo_slug, branch, user, token):
	'''
	Push file update to GitHub repo

abubelinha / zenodo-upload.py

Created February 5, 2021 11:02 — forked from slint/zenodo-upload.py

	import requests

	params = {'access_token': '<your-access-token>'}

	# Create the deposit resource
	url = "https://sandbox.zenodo.org/api/deposit/depositions"
	headers = {"Content-Type": "application/json"}

	res = requests.post(
	url,

abubelinha / Makefile

Last active February 4, 2021 10:11 — forked from guss77/Makefile

MariaDB update table with UUID (reproduction of the issue using docker-compose)

	COMPOSE := docker-compose -p demouuid

	start:
	$(COMPOSE) up -d
	sleep 3
	while $(COMPOSE) ps \| grep -q database; do \
	$(COMPOSE) logs 2>/dev/null\| grep -q 'MySQL init process done.' && break;\
	$(COMPOSE) logs 2>/dev/null\| grep -i error && break;\
	$(COMPOSE) ps \| grep -q Exit && break;\
	done

abubelinha / bench.py

Created January 23, 2021 17:48 — forked from methane/bench.py

Benchmarking MySQL drivers (Python 3.4)

	from __future__ import print_function
	import time

	def query_10k(cur):
	t = time.time()
	for _ in range(10000):
	cur.execute("SELECT 1,2,3,4,5")
	res = cur.fetchall()
	assert len(res) == 1
	assert res[0] == (1,2,3,4,5)

abubelinha / so_read_url_write_file.py

Created January 19, 2021 22:06 — forked from hughdbrown/so_read_url_write_file.py

Read from URL, write to file

	"""
	Code to write data read from a URL to a file

	Based on an answer on SO:
	http://stackoverflow.com/questions/22676/how-do-i-download-a-file-over-http-using-python/22721
	"""

	import urllib2

	mp3file = urllib2.urlopen("http://www.example.com/songs/mp3.mp3")