# import datetime # import pymysql # import json # DBUserName = "root" # DBName = "measure_old" # password = "" # # {"service_id": 1, "service_name": # # "Instant Squares", # # "service_param": {"address": "Vcnr hospital", # # "latitude": "13.0914609", "longitude": "77.4077186", # # "Measurements": "Main Structure + Garage", # # "Delivery": "Delivery - 2 Buisness Hours", # # "Upload Logo": "", # # "Pitch Value": "This is a pich val", # # "Alternative Email": "devsandy12@gmail.com", # # "Optional Deliverables": [], # # "price": 10, "payment_mode": "personal_wallet"}} # def dbConnector(cmd,fetchtype): # # fetchtype is fetchall or fetchone # conn = pymysql.Connect(host="localhost",port=3306,user = DBUserName,password="",db = DBName,autocommit=True) # cur = conn.cursor() # cur.execute(cmd) # #print(descriptions) # if fetchtype == 'fetchall': # return cur.fetchall() # def generatingOrder(): # idList = [] # date = datetime.datetime.today().strftime("%y") + datetime.datetime.today().strftime("%m") # print(date) # cmd = "SELECT order_id FROM order_table WHERE order_id LIKE '{}'".format(date+'%') # data = dbConnector(cmd,'fetchall') # cmd2 = "SELECT id FROM cart_table WHERE id LIKE '{}'".format(date+'%') # data2 = dbConnector(cmd2,'fetchall') # print(data) # data = data +data2 # print(data) # if data : # for da in data: # if da[0].startswith(date): # idList.append(da[0]) # if idList: # max_ = max([int(x) for x in idList]) # return max_+1 # else: # return date+ '001' # #print('returned value',generatingOrder()) # # import geocoder # # import webbrowser # # from urllib.parse import quote # # BING_KEY ="AkmOZ6aBwGSt-6ugealpYZCfVhGH5WEBecfBYgKquE1RZ5Q9124nyE6IFQMqMBn5" # # searchTerm = "Mountain View, CA" # # g = geocoder.bing(searchTerm, key=BING_KEY) # # lat = g.json['lat'] # # long = g.json['lng'] # # zoomLevel = 1 # Show entire world # # url = f"https://www.bing.com/maps?cp={lat}~{long}&lvl={zoomLevel}&sp=point.{lat}_{long}_{quote(searchTerm)}" # # webbrowser.open_new(url) # # testing the output of the cart table. # {"service_id": 1, "service_name": "Instant Squares", "service_param": {"address": "Vcnr hospital", "latitude": "13.0914609", "longitude": "77.4077186", "Measurements": "Main Structure + Garage", "Delivery": "Delivery - 2 Buisness Hours", "Upload Logo": "", "Pitch Value": "This is a pich val", "Alternative Email": "devsandy12@gmail.com", "Optional Deliverables": [], "price": 10, "payment_mode": "personal_wallet"}} # {'id': '2302003', 'user_id': 'devsandy12@gmail.com', 'service_id': 2, 'service_param': '{"latitude": "42.27422615384798", "longitude": "-76.12665173038842", "Measurements": "Main Structure + Garage", "Delivery": "Delivery - 1 Business day or less", "Special Notes": "", "Pitch Value": "", "Alternative Email": "", "Optional Deliverables": [], "price": 20}', 'created_at': datetime.datetime(2023, 2, 11, 15, 29, 30), 'slno': 142} # conn = pymysql.Connect(host="localhost",port=3306,user = DBUserName,password="",db = DBName,autocommit=True) # cmd = "SELECT * FROM cart_table WHERE user_id = '{}'".format('devsandy12@gmail.com') # cur = conn.cursor() # cur.execute(cmd) # data = cur.fetchall() # desc = [i[0] for i in cur.description] # # ['service_id', 'service_name','service_param', 'created_at', 'slno'] # # ('id', '2302003') # # ('user_id', 'devsandy12@gmail.com') # # ('service_id', 2) # # ('service_param', '{"latitude": "42.27422615384798", " # # longitude": "-76.12665173038842", # # "Measurements": "Main Structure + Garage", # # "Delivery": "Delivery - 1 Business day or less", # # "Special Notes": "", # # "Pitch Value": "", # # "Alternative Email": "", # # "Optional Deliverables": [], "price": 20}') # # ('created_at', datetime.datetime(2023, 2, 11, 15, 29, 30)) # # ('slno', 142) # #keys dict_keys(['service_id', 'service_name', 'service_param']) # mandate_keys = ['address', 'latitude', 'longitude', 'Measurements', 'Delivery', 'Upload Logo', 'Pitch Value', 'Alternative Email', 'Optional Deliverables', 'price', 'payment_mode'] # for row in data: # dict__ = {} # print(desc) # for item in zip(desc,row): # if item[0] == 'service_id': # dict__[item[0]] = item[1] # print('Id am passing',item[1]) # cmd = "SELECT service_title FROM services WHERE id = '{}';".format(int(item[1])) # print(cmd) # cur.execute(cmd) # service_name = cur.fetchone()[0] # print('this is the service name ',service_name) # dict__['service_name'] = service_name # elif item[0] == "service_param": # dict__[item[0]] = {} # for key in mandate_keys: # data = json.loads(item[1]) # if key in data.keys(): # dict__[item[0]][key] = data[key] # else : # dict__[item[0]][key] = '' # print(dict__) # cur.close() # # f = {"service_id": 1, "service_name": "Instant Squares", "service_param": {"address": "Vcnr hospital", "latitude": "13.0914609", "longitude": "77.4077186", "Measurements": "Main Structure + Garage", "Delivery": "Delivery - 2 Buisness Hours", "Upload Logo": "", "Pitch Value": "This is a pich val", "Alternative Email": "devsandy12@gmail.com", "Optional Deliverables": [], "price": 10, "payment_mode": "personal_wallet"}} # # print('keys',f['service_param'].keys()) # #admin page. # #trsaction saving. # #deployment. class Person: def __init__(self, name, age): self.__name = name self.__age = age def get_age(self): return self.__age def std_dev(people): if not people: return None ages = [person.get_age() for person in people] mean = sum(ages) / len(ages) variance = sum((x - mean) ** 2 for x in ages) / len(ages) return variance ** 0.5 p1 = Person('Kyoungmin', 73) p2 = Person("Mercedes", 24) p3 = Person("Beatrice", 48) person_list = [p1, p2, p3] answer = std_dev(person_list) print(answer) person_list = [] answer = std_dev(person_list)