Skip to content

Instantly share code, notes, and snippets.

View theholy7's full-sized avatar
:octocat:
Focusing

José Antunes theholy7

:octocat:
Focusing
View GitHub Profile
@theholy7
theholy7 / sql_to_df.py
Last active September 8, 2018 13:00
psycopg2, pandas and python
import os
import pandas.io.sql as sqlio
import psycopg2
from dotenv import load_dotenv, find_dotenv
load_dotenv(find_dotenv())
SQL_USER = os.environ.get('SQL_USER')
SQL_PASS = os.environ.get('SQL_PASS')
@theholy7
theholy7 / firefox_update.md
Created April 10, 2019 09:24
Update Firefox in Ubuntu (download and command line instructions)

First, download firefox. Then:

$ # Untar the download
$ tar xjf firefox-<version-num>.tar.bz2
$ # Remove current firefox
$ sudo rm -r /opt/firefox
$ # Move new firefox to old firefox location
$ sudo mv ~/Downloads/firefox /opt/firefox
class AuthorizedResource(Resource):
"""
We created this AuthorizedResource from Resource
because the user authorization was being made after payload
validation. This way a non-auth'ed user was able to sniff the
payload that was required by the endpoint.
By wrapping dispatch_request with the requires_auth function,
we check for user authentication first.
"""
@requires_auth
@theholy7
theholy7 / mysql_loadtest.py
Created June 19, 2020 12:51
Load testing script for MySQL database
import time
import logging
from locust import TaskSet, User, between, task, events
import mysql.connector
TEST_QUERY = '''
SELECT COUNT(*) FROM YOUR_TABLE_HERE;
'''