self.__observation = self.json_data['OBSERVATII']
except KeyError:
self.__observation = ''
return self.__observation
if __name__ == "__main__":
filename = sys.argv[1]
start = int(sys.argv[3])
API_KEY = sys.argv[2]
db = DatabaseConnection(SETTINGS.DATABASE_NAME, SETTINGS.DATABASE_USERNAME, SETTINGS.DATABASE_PASSWORD)
con = db.connection
#db.reset_tables(con, "faw_create_address_pharmacy_company.sql")
address_counter = db.count_all(con, "SELECT * FROM address;")
json_file = open(SETTINGS.JSON_PATH + filename, 'r')
json_data = json.load(json_file)
addresses = [json_data[x]['ADRESA'] for x in range(0, len(json_data))]
localities = [json_data[x]['LOCALITATE'] for x in range(0, len(json_data))]
cities = [SETTINGS.COUNTY[json_data[x]['JUD/SECT']] for x in range(0, len(json_data))]
end = len(json_data)
for i in range(start, end):
print('-------------------------------------------------------------')
if json_data[i]['URBAN/RURAL'] == 'URBAN':
URL = 'https://maps.googleapis.com/maps/api/geocode/json?address='+addresses[i].split(',')[0]+','+ \
addresses[i].split(',')[1]+','+localities[i].strip(' ')+','+cities[i]+'&key='+API_KEY
db = DatabaseConnection(SETTINGS.DATABASE_NAME, SETTINGS.DATABASE_USERNAME, SETTINGS.DATABASE_PASSWORD)
con = db.connection
db.reset_tables(con, "faw_create_medicine_composition.sql")
json_file = open(SETTINGS.JSON_PATH + '_medicine_list.json', 'r')
json_data = json.load(json_file)
for i in range(0, len(json_data)):
data = json_data[i]
# medicine
medicine = Medicine(data)
query = "INSERT INTO medicine (name, concentrate, package, form, producer, producer_country, price) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', %.2f);" %(
medicine.name, medicine.concentrate, medicine.package, medicine.form,
medicine.producer, medicine.producer_country, medicine.price)
print("INSERT IN MEDICINE:", query)
db.execute_query(con, query)
# composition
dci = data['dci']
mc = MedicineComposition()
medicine_id = db.count_all(con, "SELECT * FROM medicine;")
if dci.find(' + ') != -1:
dci_list = dci.split(' + ')
for d in dci_list:
mc.add_new(db, con, d, medicine_id)
else:
mc.add_new(db, con, dci, medicine_id)
@property
def start_time(self):
d = {1:"06:00", 2:"06:30", 3:"07:00", 4:"07:30", 5:"08:00", 6:"08:30", 7:"09:00", 8:"09:30", 9:"10:00"}
self.__start_time = d[int(random.uniform(1,10))]
return self.__start_time
@property
def end_time(self):
d = {1:"17:00", 2:"17:30", 3:"18:00", 4:"18:30", 5:"19:00", 6:"19:30", 7:"20:00", 8:"20:30", 9:"21:00",
10:"21:30", 11:"22:00", 12:"22:30", 13:"23:00", 13:"23:30", 14:"00:00"}
self.__end_time = d[int(random.uniform(1,15))]
return self.__end_time
if __name__ == "__main__":
db = DatabaseConnection(SETTINGS.DATABASE_NAME, SETTINGS.DATABASE_USERNAME, SETTINGS.DATABASE_PASSWORD)
con = db.connection
db.reset_tables(con, "faw_create_timetable.sql")
not_id = [575, 1961, 4902, 5629, 7435] + list(range(6410, 6466)) + list(range(8531, 8543))
pharmacies_id = db.count_all(con, "SELECT * FROM pharmacy;")
for p_id in range(1, pharmacies_id):
if p_id in not_id:
continue
timetable = Timetable()
query = "INSERT INTO timetable (monday, tuesday, wednesday, thursday, friday, saturday, sunday, start_time, end_time, pharmacy_id) VALUES (%s, %s, %s, %s, %s, %s, %s, '%s', '%s', %d)" % (
timetable.monday, timetable.tuesday, timetable.wednesday, timetable.thursday, timetable.friday,
timetable.saturday, timetable.sunday, timetable.start_time, timetable.end_time, p_id)
print("INSERT IN TIMETABLE:", query)
db.execute_query(con, query)
def pharmacy_id(self):
self.__pharmacy_id = random.randint(1, self.pharmacy_len)
return self.__pharmacy_id
@property
def medicine_id(self):
self.__medicine_id = random.randint(1, self.medicine_len)
return self.__medicine_id
if __name__ == "__main__":
db = DatabaseConnection(SETTINGS.DATABASE_NAME, SETTINGS.DATABASE_USERNAME, SETTINGS.DATABASE_PASSWORD)
con = db.connection
db.reset_tables(con, "faw_create_pharmacy_medicine.sql")
pharmacy_len = db.count_all(con, "SELECT * FROM pharmacy;")
medicine_len = db.count_all(con, "SELECT * FROM medicine;")
pharmacy_medicine = PharmacyMedicine(pharmacy_len, medicine_len)
for i in range(1, 10000):
while True:
pharm_id = pharmacy_medicine.pharmacy_id
med_id = pharmacy_medicine.medicine_id
query_search = "SELECT * FROM pharmacy_medicine WHERE pharmacy_id=%d and medicine_id=%d;" % (pharm_id, med_id)
try:
query_count_results = db.count_all(con, query_search)
query_pharmacy_id = db.count_all(con, "SELECT id FROM pharmacy WHERE id=%d" % pharm_id)
query_medicine_id = db.count_all(con, "SELECT id FROM medicine WHERE id=%d" % med_id)
except Exception as e:
con.rollback()