import requests import json import re import sys import os import db_functions as db from APIRequest import get_request_pcr, print_components, set_http_pcr conn = db.get_connection() print("Currently in db:") db.doQuery(conn, "select count(*) from Professor;") http_str = set_http_pcr("instructors") json_obj = get_request_pcr(http_str) instr_list = json_obj["result"]["values"] for item in instr_list: # need to use tripple quotes because some names have ' in them # instructors have -1 as default avg rating pid = "{0}".format(item["id"]) just_the_num = pid.split("-")[0] query_str = """insert into Professor (pid,name,avg_rating) VALUES("{0}","{1}",-1);""".format( just_the_num, item["name"]) db.doQuery(conn, query_str) db.close(conn)
print('{0} cells updated.'.format(result.get('updatedCells'))) #exit() else: print("row changed during update") else: print("animalid not found", animalid) count += 1 prev_animalid = animalid now = datetime.datetime.now() print(now) range_name = tab + 'A1' print(range_name) values = [ ["Last full update " + str(now)], # Additional rows ... ] body = {'values': values} result = service.spreadsheets().values().update( spreadsheetId=config.spreadsheet_id, range=range_name, valueInputOption=value_input_option, body=body).execute() print('{0} cells updated.'.format(result.get('updatedCells'))) #Close the DB connection db_functions.close(cnxn, cursor) now = datetime.datetime.now() current_timestamp = (now.strftime('%Y-%m-%d %H:%M:%S')) print("success: " + current_timestamp)