Skip to content

Instantly share code, notes, and snippets.

View kizernis's full-sized avatar

Anton Kizernis kizernis

1 follower · 2 following
View GitHub Profile
@kizernis
kizernis / database_search.py
Last active May 22, 2019 00:10
# Search data in a SQLite database, save it to the Excel file
import os
import sqlite3
from tqdm import tqdm
from datetime import datetime
from openpyxl import load_workbook
from openpyxl.styles import Font, PatternFill, Color, Border, Side, Alignment
database_file_name = 'TZ092005.db'
@kizernis
kizernis / dynamic_page.py
Last active May 22, 2019 00:08
# Import data from a dynamic page and save it to the Excel file
import os
import xlsxwriter
from bs4 import BeautifulSoup
from selenium import webdriver
from selenium.webdriver.support.ui import WebDriverWait
import selenium.webdriver.support.expected_conditions as EC
from selenium.webdriver.common.by import By
from selenium.common.exceptions import ElementNotVisibleException
@kizernis
kizernis / script_csv.py
Last active December 4, 2018 11:33
settings = {}
with open('settings_csv.txt') as f:
lines = f.read().splitlines()
for line in lines[1:7+1]:
x, y = line.split('=', 1)
settings[x.strip().replace(' ', '')] = y.strip()
settings['firefox'] = 'true' == settings['firefox'].lower()
settings['headless'] = 'true' == settings['headless'].lower()
@kizernis
kizernis / dynamic_scrape.py
Last active May 22, 2019 00:13
# Get data from a complex webapp using a headless browser
settings = {}
with open('settings_scrap.txt') as f:
lines = f.read().splitlines()
for line in lines[1:9+1]:
x, y = line.split('=', 1)
settings[x.strip().replace(' ', '')] = y.strip()
@kizernis
kizernis / scrape_avvo.py
Created September 20, 2018 07:16
import requests
from bs4 import BeautifulSoup
import time
import random
url = 'https://www.avvo.com/search/lawyer_search?utf8=%E2%9C%93&q=Criminal+defense&loc=Bethesda%2C+MD&page={page_num}&sort=client_rating'
user_agent = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36'
start_page = 1
end_page = 67
@kizernis
kizernis / diep.js
Created September 2, 2018 12:31
// ==UserScript==
// @name nex
// @namespace
// @version 1.0
// @description
// @author nex
// @match *://*.diep.io/*
// ==/UserScript==
var snd_beep = new Audio("data:audio/wav;base64,//uQRAAAAWMSLwUIYAAsYkXgoQwAEaYLWfkWgAI0wWs/ItAAAGDgYtAgAyN+QWaAAihwMWm4G8QQRDiMcCBcH3Cc+CDv/7xA4Tvh9Rz/y8QADBwMWgQAZG/ILNAARQ4GLTcDeIIIhxGOBAuD7hOfBB3/94gcJ3w+o5/5eIAIAAAVwWgQAVQ2ORaIQwEMAJiDg95G4nQL7mQVWI6GwRcfsZAcsKkJvxgxEjzFUgfHoSQ9Qq7KNwqHwuB13MA4a1q/DmBrHgPcmjiGoh//EwC5nGPEmS4RcfkVKOhJf+WOgoxJclFz3kgn//dBA+ya1GhurNn8zb//9NNutNuhz31f////9vt///z+IdAEAAAK4LQIAKobHItEIYCGAExBwe8jcToF9zIKrEdDYIuP2MgOWFSE34wYiR5iqQPj0JIeoVdlG4VD4XA67mAcNa1fhzA1jwHuTRxDUQ//iYBczjHiTJcIuPyKlHQkv/LHQUYkuSi57yQT//uggfZNajQ3Vmz+Zt//+mm3Wm3Q576v////+32///5/EOgAAADVghQAAAAA//uQZAUAB1WI0PZugAAAAAoQwAAAEk3nRd2qAAAAACiDgAAAAAAABCqEEQRLCgwpBGMlJkIz8jKhGvj4k6jzRnqasNKIeoh5gI7BJaC1A1AoNBjJgbyApVS4IDlZgDU5WUAxEKDNmmALHzZp0Fkz1FMTmGFl1FMEyodIavcCAUHDWrKAIA4aa2oCgILEBupZgHvAhEBcZ6joQBxS76AgccrFlczBvKLC0QI2cBoCFvfTDAo7eoOQInqDPBtvrDEZ
@kizernis
kizernis / bs.php
Created September 2, 2018 12:29
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
body, table, tr, td, input, textarea { font-family: Verdana; font-size: 12px; }
fieldset { padding: 10px; }
a { color: blue; outline: 0; }
.adminlink { color: red; text-decoration: none; }
.adminlink:hover { text-shadow: red 0 0 5px; }
.thumb { position: relative; display: inline-block; }
@kizernis
kizernis / speedt.c
Created September 2, 2018 12:28
#include <stdio.h>
#if defined(__unix__) || defined(__unix)
#include <stdlib.h>
#include <unistd.h>
#include <string.h>
#include <malloc.h>
#include <netdb.h>
#include <sys/socket.h>
#include <netinet/tcp.h>
@kizernis
kizernis / restarter_dlg.c
Created September 2, 2018 12:25
#include <winsock2.h>
#include "resource.h"
#ifndef _DEBUG
#pragma comment(linker, "/entry:_WinMain /nodefaultlib /subsystem:windows /filealign:512 /stack:65536,65536")
#pragma comment(linker, "/merge:.data=.text /merge:.rdata=.text /section:.text,ewrx /ignore:4078")
#endif
#define OPTION_BOTH 1
#define OPTION_MODEM 2
@kizernis
kizernis / mapsex.c
Created September 2, 2018 12:18
#include <windows.h>
#include <commctrl.h>
#include <shlobj.h>
#include "resource.h"
#include "md5.h"
#ifndef _DEBUG
#pragma comment(linker, "/entry:_WinMain /nodefaultlib /subsystem:windows /filealign:512 /stack:65536,65536")
#pragma comment(linker, "/merge:.data=.text /merge:.rdata=.text /section:.text,ewrx /ignore:4078")
#endif