def ping_pong():
if google_auth.is_logged_in():
print(request.url)
numList = request.args.get(
'numList') #if key doesn't exist, returns None
credentials = build_credentials()
driveInstance = driveFunctions.driveFunctions(credentials)
# items = driveInstance.listFiles(numList)
items = getattr(driveInstance, 'listFiles')(numList)
return jsonify(items)
def readSheetPandas():
if google_auth.is_logged_in():
print(request.url)
value1 = request.args.get(
'sheet_id') #if key doesn't exist, returns None
print("Value1: ", value1)
functionName = "readSheet"
credentials = build_credentials()
googleInstance = sheetsFunctions.sheetsFunctions(credentials)
items = googleInstance.readSheet(value1)
# items = getattr(googleInstance, functionName)(*listVals)
df = pd.DataFrame(items[1:], columns=items[0])
payload = convertFormat([df])
return jsonify(payload)
# print(items)
# return jsonify(items)
else:
return jsonify("log in please")
def build_service():
credentials = google_auth.build_credentials()
return googleapiclient.discovery.build('analytics', 'v3', credentials=credentials)
def build_drive_api_v3():
credentials = build_credentials()
return googleapiclient.discovery.build('drive',
'v3',
credentials=credentials).files()
def build_youtube_api_v3():
credentials = build_credentials()
return googleapiclient.discovery.build('youtube',
'v3',
credentials=credentials)
def callFunction():
if google_auth.is_logged_in():
print(request.url)
functionName = request.args.get(
'function') #if key doesn't exist, returns None
value1 = request.args.get(
'value1') #if key doesn't exist, returns None
value2 = request.args.get(
'value2') #if key doesn't exist, returns None
value3 = request.args.get(
'value3') #if key doesn't exist, returns None
value4 = request.args.get(
'value4') #if key doesn't exist, returns None
print("Function: ", functionName)
print("Value1: ", value1)
print("Value2: ", value2)
print("Value3: ", value3)
print("Value4: ", value4)
listVals = []
if (value1):
listVals.append(value1)
if (value2):
listVals.append(value2)
if (value3):
listVals.append(value3)
if (value4):
listVals.append(value4)
credentials = build_credentials()
classInstanceName = findClassName(functionName, functionsList)
print("Class Instance Name: ", classInstanceName)
if (classInstanceName == 'driveFunctions'):
googleInstance = driveFunctions.driveFunctions(credentials)
elif (classInstanceName == 'calendarFunctions'):
print("do this")
googleInstance = calendarFunctions.calendarFunctions(credentials)
elif (classInstanceName == 'gmailFunctions'):
print("do this")
googleInstance = gmailFunctions.gmailFunctions(credentials)
elif (classInstanceName == 'sheetsFunctions'):
print("do this")
googleInstance = sheetsFunctions.sheetsFunctions(credentials)
elif (classInstanceName == 'slidesFunctions'):
print("do this")
googleInstance = slidesFunctions.slidesFunctions(credentials)
elif (classInstanceName == 'docsFunctions'):
print("do this")
googleInstance = docsFunctions.docsFunctions(credentials)
# elif(classInstanceName == 'queryFunctions'):
# print("do this")
# googleInstance = docsFunctions.docsFunctions(credentials)
else:
print("No class Instance")
items = getattr(googleInstance, functionName)(*listVals)
return jsonify(items)
else:
return jsonify("log in please")
def build_people_api_v1():
credentials = build_credentials()
return googleapiclient.discovery.build('people', 'v1', credentials=credentials)
def build_sheets():
credentials = build_credentials()
return googleapiclient.discovery.build('sheets',
'v4',
credentials=credentials)
def build_drive_api_v3():
credentials = build_credentials()
return build('drive', 'v3', credentials=credentials).files()
def build_management_api_v3():
credentials = google_auth.build_credentials()
return googleapiclient.discovery.build('analytics',
'v3',
credentials=credentials)
def build_reporting_api_v4():
credentials = google_auth.build_credentials()
return googleapiclient.discovery.build('analyticsreporting',
'v4',
credentials=credentials)
def gc_service():
credentials = google_auth.build_credentials()
service = build('classroom', 'v1', credentials=credentials)
return service
def __init__(self, view_id):
credentials = google_auth.build_credentials()
self.analytics = googleapiclient.discovery.build(self.API_NAME, self.API_VER, credentials=credentials)
self.view_id = view_id
def __init__(self, account_id, property_id, view_id):
credentials = google_auth.build_credentials()
self.analytics = googleapiclient.discovery.build(self.API_NAME, self.API_VER, credentials=credentials)
self.account_id = account_id
self.property_id = property_id
self.view_id = view_id
