Spaces:
Runtime error
Runtime error
File size: 3,399 Bytes
06078d0 2dc740f 54e190a 06078d0 310f1c4 3e1d6f5 54e190a 3b59541 54e190a 3e1d6f5 54e190a c9bf667 54e190a c9bf667 54e190a 06078d0 | 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 | #!/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
|