Spaces:
Runtime error
Runtime error
| #!/usr/bin/env python3 | |
| # -*- coding: utf-8 -*- | |
| """ | |
| Created on Mon May 8 20:35:33 2023 | |
| @author: potato | |
| """ | |
| import pandas as pd | |
| from datetime import date,datetime | |
| import pymysql | |
| import requests | |
| import os | |
| def df_to_dict_univ_region(df)->dict: | |
| result_dict = {} | |
| sz1,sz2 = df.shape | |
| for i in range(sz1): | |
| if(df.iloc[i,0] in result_dict): | |
| result_dict[df.iloc[i,0]].add(df.iloc[i,1]) | |
| else: | |
| temp_set = set() | |
| result_dict[df.iloc[i,0]] = temp_set | |
| result_dict[df.iloc[i,0]].add(df.iloc[i,1]) | |
| return result_dict | |
| def df_to_dict_topic_qlist(df)->dict: | |
| result_dict = {} | |
| df_header = list(df.columns) | |
| sz1,sz2 = df.shape | |
| for i in range(sz2-1): | |
| temp_dict = {} | |
| #temp_name = df_header[i+1] | |
| for j in range(sz1): | |
| temp_set = parse_to_set(df.iloc[j,i+1]) | |
| temp_dict[df.iloc[j,0]] = temp_set | |
| result_dict[df_header[i+1]]=temp_dict | |
| return result_dict | |
| def df_to_dict_qlist(df)->dict: | |
| result_dict = {} | |
| sz1,_ = df.shape | |
| for i in range(sz1): | |
| result_dict[df.iloc[i,0]] = df.iloc[i,1] | |
| return result_dict | |
| def parse_to_set(ostr:str)->set: | |
| result_list = ostr.split(",") | |
| result_set = set(result_list) | |
| return result_set | |
| def display_dict(dict1:dict)->dict: | |
| result_dict = {} | |
| for k,_ in dict1.items(): | |
| result_dict[k] = k | |
| return result_dict | |
| def list_display(list1)->dict: | |
| result_dict = {} | |
| for i in range(len(list1)): | |
| result_dict[list1[i]] = list1[i] | |
| return result_dict | |
| def get_qlist_by_cate(qlist:list,qlist_qcontent_dict): | |
| result_dict = {} | |
| for i in range(len(qlist)): | |
| result_dict[qlist_qcontent_dict[qlist[i]]]= qlist_qcontent_dict[qlist[i]] | |
| return result_dict | |
| def get_v_count(df): | |
| return | |
| def get_univreg_by_school_dict(df): | |
| sz1,_ = df.shape | |
| lea_dict = {} | |
| for i in range(sz1): | |
| if df.iloc[i,1] not in lea_dict: | |
| lea_dict[df.iloc[i,1]]= df.iloc[i,0] | |
| return lea_dict | |
| def record_login(role): | |
| url = "https://worldtimeapi.org/api/timezone/America/Denver" | |
| response = requests.get(url) | |
| result = response.json() | |
| date_in = result["datetime"] | |
| date = date_in[0:10] | |
| time = date_in[11:19] | |
| connection = pymysql.connect(host='database-2.czikup7sd3q9.us-east-2.rds.amazonaws.com', | |
| user='admin', | |
| password='admintest', | |
| database='login_db', | |
| charset='utf8mb4', | |
| cursorclass=pymysql.cursors.DictCursor) | |
| cursor = connection.cursor() | |
| #cursor.execute("use login_db;") | |
| curr_query = "insert into login_n values ( '"+str(date) +"','"+ str(time) +"','"+role+ "')" | |
| try: | |
| cursor.execute(curr_query) | |
| connection.commit() | |
| print("Query run succeed") | |
| """ | |
| cursor.execute("select * from login_n;") | |
| result1 = cursor.fetchall() | |
| for row in result1: | |
| print(row) | |
| # | |
| """ | |
| except Exception as error: | |
| print("There is exception happened:", type(error).__name__,"-",error) | |
| cursor.close() | |
| return | |