This file contains 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
#!/usr/bin/env python3 | |
# pip3 install selenium | |
from selenium import webdriver | |
from selenium.webdriver.common.by import By | |
from selenium.webdriver.support.ui import WebDriverWait | |
from selenium.webdriver.support import expected_conditions as EC | |
from selenium.webdriver.chrome.options import Options | |
import time |
This file contains 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 asyncio | |
import aioodbc | |
import pyodbc | |
from concurrent.futures import ThreadPoolExecutor | |
loop = asyncio.get_event_loop() | |
async def conn_attributes(conn): | |
conn.setdecoding(pyodbc.SQL_CHAR, encoding='utf-8') | |
conn.setdecoding(pyodbc.SQL_WCHAR, encoding='utf-8') |
This file contains 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
/* | |
Setup a recursive CTE to iterate over ascii ranges and remove | |
any characters within given ranges. Remember max recursion depth | |
is sql server is 100 by default | |
*/ | |
--Initial increment handler | |
DECLARE @controlcharacter int = 32, | |
--Second increment handler | |
@extendedcharacter int = 256; |
This file contains 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 sqlite3 | |
import pdb | |
from abc import ABCMeta, abstractmethod | |
class DatabaseConnector(metaclass=ABCMeta): | |
"""A class to help you connect to various databases""" | |
__metaclass__ = ABCMeta | |
_max_connections = 3 | |
_current_connections = 0 |
This file contains 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 sqlite3 | |
import pdb | |
class DatabaseConnector(object): | |
_max_connections = 3 | |
_current_connections = 0 | |
def __init__(self, server, database, schema): | |
self.server = server, | |
self.database = database, |
This file contains 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
from bs4 import BeautifulSoup | |
from urllib.request import urlopen | |
import requests | |
import zipfile | |
import io | |
""" | |
Fails file extraction requires a password :( | |
""" |
NewerOlder