Ahmet Yiğit Budak yibudak

Odoo & Python Developer

yibudak / match_instagram_followers.py

Created January 10, 2024 11:21

Match Followers and Followings from Instagram Dump

	import json

	with open("following.json") as f:
	following = json.load(f)

	with open("followers_1.json") as f:
	followers = json.load(f)

	following = [x['string_list_data'][0]['value'] for x in following['relationships_following']]
	followers = [x['string_list_data'][0]['value'] for x in followers]

yibudak / query.sql

Created April 6, 2022 17:27

Get Last 30 Days Records Count Grouped in MySQL

	SELECT DATE_FORMAT(DATE, '%m.%d.%Y') AS date, count(*) AS count
	FROM table
	WHERE DATE BETWEEN NOW() - INTERVAL 30 DAY AND NOW()
	GROUP BY date
	ORDER BY date ASC;

yibudak / turkey_cities.py

Last active March 15, 2022 10:08

Python Türkiye İlleri Dictionary

	turkey_cities = {1: 'Adana', 2: 'Adıyaman', 3: 'Afyonkarahisar', 4: 'Ağrı', 5: 'Amasya',
	6: 'Ankara', 7: 'Antalya', 8: 'Artvin', 9: 'Aydın', 10: 'Balıkesir',
	11: 'Bilecik', 12: 'Bingöl', 13: 'Bitlis', 14: 'Bolu', 15: 'Burdur',
	16: 'Bursa', 17: 'Çanakkale', 18: 'Çankırı', 19: 'Çorum', 20: 'Denizli',
	21: 'Diyarbakır', 22: 'Edirne', 23: 'Elazığ', 24: 'Erzincan', 25: 'Erzurum',
	26: 'Eskişehir', 27: 'Gaziantep', 28: 'Giresun', 29: 'Gümüşhane', 30: 'Hakkari',
	31: 'Hatay', 32: 'Isparta', 33: 'Mersin', 34: 'İstanbul', 35: 'İzmir',
	36: 'Kars', 37: 'Kastamonu', 38: 'Kayseri', 39: 'Kırklareli', 40: 'Kırşehir',
	41: 'Kocaeli', 42: 'Konya', 43: 'Kütahya', 44: 'Malatya', 45: 'Manisa', 46: 'Kahramanmaraş',
	47: 'Mardin', 48: 'Muğla', 49: 'Muş', 50: 'Nevşehir', 51: 'Niğde', 52: 'Ordu',