Skip to content

Instantly share code, notes, and snippets.

View Kyu's full-sized avatar
😜
I like doing shit

Precious Kyu

😜
I like doing shit
View GitHub Profile
@Kyu
Kyu / sqlite-to-mysql.py
Created January 2, 2018 15:19
converts sqlite to mysql
#Incomplete
from sqlalchemy import (
create_engine,
MetaData,
Table
)
from sqlalchemy.orm import sessionmaker
sqlite_engine = create_engine('sqlite:///main.db', echo=True)
@Kyu
Kyu / file-names.py
Created January 2, 2018 10:26
Outputs all file names in dir to file
import os
path = os.getcwd()
for root, dirs, files in os.walk(path):
with open('names.txt', 'w') as f:
f.writelines([i +'\n' for i in files])
#from: https://stackoverflow.com/a/26494912
$colItems = Get-ChildItem $startFolder | Where-Object {$_.PSIsContainer -eq $true} | Sort-Object
foreach ($i in $colItems)
{
$subFolderItems = Get-ChildItem $i.FullName -recurse -force | Where-Object {$_.PSIsContainer -eq $false} | Measure-Object -property Length -sum | Select-Object Sum
$i.FullName + " -- " + "{0:N2}" -f ($subFolderItems.sum / 1MB) + " MB"
}
@Kyu
Kyu / file-search.py
Created December 16, 2017 18:12
searches files
import os
def search(path, query):
results = []
q = query.lower()
for root, dirs, files in os.walk(path):
for file in files:
if q in file.lower():
results.append(os.path.join(root, name))
for ls in dirs:
@Kyu
Kyu / Bloc-Alliance-Crawler.py
Last active May 15, 2017 20:00
Crawls Bloc Alliances for Economy and Military info.
from bs4 import BeautifulSoup
import aiohttp
import asyncio
from datetime import datetime
import csv
loop = asyncio.get_event_loop()
client = aiohttp.ClientSession(loop=loop)
HEADERS = {'User-Agent': 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0'}
BLOC = 'http://blocgame.com'
import requests
from bs4 import BeautifulSoup
s = requests.session()
headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36'}
url = 'http://blocgame.com'
data = {'username': 'USERNAME', 'password': 'PASSWORD', 'login': ''}
s.headers['User-Agent'] = headers['User-Agent']
@Kyu
Kyu / index.js
Last active November 22, 2016 13:19
// from https://github.com/izy521/discord.io/blob/master/lib/index.js
@Kyu
Kyu / BlocCr.py
Last active June 6, 2022 16:51
Async friendly version of BlocCrawl.py
from bs4 import BeautifulSoup
import aiohttp
import asyncio
import datetime
import csv
class Complete(KeyboardInterrupt):
pass
@Kyu
Kyu / BlocCrawl.py
Last active June 6, 2022 16:51
Crawls nations from http://www.blocgame.com
from bs4 import BeautifulSoup
from urllib.request import Request, urlopen
import datetime
import csv
start = datetime.datetime.now()
def get_countries(url):
try: