-
Notifications
You must be signed in to change notification settings - Fork 1
/
CloudScrap.py
197 lines (168 loc) · 7.81 KB
/
CloudScrap.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
import os
import gspread
import requests
import logging
import json
import re
from oauth2client.service_account import ServiceAccountCredentials
from requests.adapters import HTTPAdapter
from requests.packages.urllib3.util.retry import Retry
from bs4 import BeautifulSoup # Importing BeautifulSoup for HTML parsing
# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
# Configure Google Sheets API
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
with open('credentials.json') as creds_file:
creds_json = json.load(creds_file)
creds = ServiceAccountCredentials.from_json_keyfile_dict(creds_json, scope)
client = gspread.authorize(creds)
# Define the retry session function
def requests_retry_session(retries=3, backoff_factor=0.3, status_forcelist=(500, 502, 504), session=None):
session = session or requests.Session()
retry = Retry(
total=retries,
read=retries,
connect=retries,
backoff_factor=backoff_factor,
status_forcelist=status_forcelist,
)
adapter = HTTPAdapter(max_retries=retry)
session.mount('http://', adapter)
session.mount('https://', adapter)
return session
# Define the email extraction function
def extract_email(text):
pattern = r'\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b'
matches = re.findall(pattern, text)
if matches:
return matches[0].strip('\"<>[]()')
return None
# Define the GitHub API handler class
class GitHubApiHandler:
def __init__(self, api_keys):
self.api_keys = api_keys
self.current_key_index = 0
self.request_count = 0
self.max_requests_per_key = 3650
def get_headers(self):
return {'Authorization': f'token {self.api_keys[self.current_key_index]}'}
def check_and_switch_key(self):
remaining_requests = self.get_remaining_requests()
logger.info(f"Remaining requests for current key: {remaining_requests}")
if remaining_requests < 10:
self.current_key_index = (self.current_key_index + 1) % len(self.api_keys)
self.request_count = 0
logger.info(f"Switched to new API key: {self.current_key_index + 1}")
def get_remaining_requests(self):
headers = self.get_headers()
url = 'https://api.github.com/rate_limit'
response = requests_retry_session().get(url, headers=headers)
if response.status_code == 200:
rate_limit_data = response.json()
remaining = rate_limit_data['rate']['remaining']
return remaining
return 0
def get_user_info_from_github_api(self, profile_url):
self.check_and_switch_key()
headers = self.get_headers()
username = profile_url.split('/')[-1]
url = f'https://api.github.com/users/{username}'
response = requests_retry_session().get(url, headers=headers)
if response.status_code != 200:
logger.info(f"Failed to fetch user info for {profile_url}, status code: {response.status_code}")
return None
user_data = response.json()
email = user_data.get('email', '') or self.get_email_from_readme(username, headers)
if not email:
email = self.get_email_from_bio(profile_url, headers)
return email
def get_email_from_readme(self, username, headers):
url = f'https://raw.githubusercontent.com/{username}/{username}/main/README.md'
response = requests.get(url, headers=headers)
if response.status_code == 200:
return extract_email(response.text)
return None
def get_email_from_bio(self, profile_url, headers):
response = requests.get(profile_url, headers=headers)
if response.status_code == 200:
soup = BeautifulSoup(response.text, 'html.parser')
# Find the div containing the bio
bio_div = soup.find('div', class_='p-note user-profile-bio')
if bio_div:
# First, try to extract the email from the visible text in the div
bio_text = bio_div.get_text()
email = extract_email(bio_text)
if not email:
bio_data_text = bio_div.get('data-bio-text', '')
email = extract_email(bio_data_text)
return email
return None
# Define Google Sheets interaction functions
def get_records_with_empty_done(worksheet):
records = worksheet.get_all_records()
# Filter records where 'Done?' is empty (column 'Done?' is assumed to be at index 4, corresponding to column E)
filtered_records = [record for record in records if not record['Done?']]
return filtered_records
def batch_update_sheet1(worksheet, batch_done_updates):
# Update 'Done?' field for all records in the batch
logger.info(f"Marking {len(batch_done_updates)} records as Done in Sheet1.")
worksheet.batch_update(batch_done_updates)
def batch_append_to_sheet2(worksheet, batch_email_data):
# Append data to Sheet2 in a single request
logger.info(f"Appending {len(batch_email_data)} records to Sheet2.")
worksheet.append_rows(batch_email_data)
# Process batches of records from Google Sheets
def process_batch(worksheet1, worksheet2, github_api_handler):
records = get_records_with_empty_done(worksheet1)
batch_size = 100
batch_done_updates = []
batch_email_data = []
for i in range(0, len(records), batch_size):
batch = records[i:i + batch_size]
for record in batch:
profile_url = record['Profile URL']
row_index = records.index(record) + 2 # Adding 2 for 1-based indexing and skipping the header
if profile_url:
logger.info(f"Processing record: {record['Username']} with GitHub URL: {profile_url}")
try:
email = github_api_handler.get_user_info_from_github_api(profile_url)
# Add 'Done?' update to batch
batch_done_updates.append({'range': f'E{row_index}', 'values': [['Yes']]})
if email:
# Add email data to batch for Sheet2
batch_email_data.append([
record['Username'],
record['User ID'],
profile_url,
email,
record['Repo']
])
except Exception as e:
logger.error(f"An error occurred while processing {profile_url}: {e}")
# After processing a batch of 100, update Sheet1 and append to Sheet2
if batch_done_updates:
batch_update_sheet1(worksheet1, batch_done_updates)
batch_done_updates.clear() # Clear the batch after updating
if batch_email_data:
batch_append_to_sheet2(worksheet2, batch_email_data)
batch_email_data.clear() # Clear the batch after appending
# Main function
def main():
try:
# Load GitHub API keys
github_api_keys = os.environ['MY_GITHUB_API_KEYS'].split(',')
# Initialize GitHub API handler
github_api_handler = GitHubApiHandler(github_api_keys)
# Open the Google Sheet
sheet = client.open_by_url("https://docs.google.com/spreadsheets/d/1rKdG00VihG3zHRQLgQ6NteUHhdQxAqP2reLU8LCFotk/edit#gid=0")
# Select the worksheets (Sheet1 and Sheet2)
worksheet1 = sheet.worksheet("Sheet1")
worksheet2 = sheet.worksheet("Sheet2")
# Process records in batches of 100
logger.info("Processing records in batches...")
process_batch(worksheet1, worksheet2, github_api_handler)
except Exception as e:
logger.error(f"An error occurred in the main function: {e}")
if __name__ == "__main__":
main()