# company
company = Company(json_data[i])
company_id = db.select_id(con, "SELECT id FROM company WHERE LOWER(name)=LOWER('%s');" % company.name)
if company_id == 0:
sql_company_row = "INSERT INTO company (name) VALUES ('%s');" % (company.name)
row = str(unicodedata.normalize('NFD', str(sql_company_row)).encode('ascii', 'ignore'))
print('INSERT IN COMPANY:', row[2:len(row)-1])
db.execute_query(con, row[2:len(row)-1])
company_id = db.select_id(con, "SELECT id FROM company WHERE LOWER(name)=LOWER('%s');" % company.name)
# pharmacy
pharmacy = Pharmacy(json_data[i], address)
county = str(unicodedata.normalize('NFD', str(address.address_componenets['county'])).encode('ascii', 'ignore'))
county_name = county[2:len(county)-1]
county_id = db.select_id(con, "SELECT id FROM county WHERE LOWER(name)=LOWER('%s');" % county_name)
locality_id = db.select_locality(con, json_data[i])
address_counter = db.count_all(con, "SELECT * FROM address;")
if pharmacy.created_date == 'NULL' and pharmacy.suspended:
sql_pharmacy_row = "INSERT INTO pharmacy (name, urban, created_date, suspended, unsuspended_date, pharmacist, exception, observation, address_id, county_id, locality_id, company_id) VALUES ('%s', %s, %s, %s, '%s', '%s', '%s', '%s', %d, %d, %d, %d);" % (
pharmacy.name, pharmacy.urban, pharmacy.created_date, pharmacy.suspended, pharmacy.unsuspended_date, pharmacy.pharmacist,
pharmacy.exception, pharmacy.observation, address_counter, county_id, locality_id, company_id
)
elif pharmacy.created_date == 'NULL' and not pharmacy.suspended:
sql_pharmacy_row = "INSERT INTO pharmacy (name, urban, created_date, suspended, unsuspended_date, pharmacist, exception, observation, address_id, county_id, locality_id, company_id) VALUES ('%s', %s, %s, %s, %s, '%s', '%s', '%s', %d, %d, %d, %d);" % (
pharmacy.name, pharmacy.urban, pharmacy.created_date, pharmacy.suspended, pharmacy.unsuspended_date, pharmacy.pharmacist,
pharmacy.exception, pharmacy.observation, address_counter, county_id, locality_id, company_id
)
elif pharmacy.created_date != 'NULL' and pharmacy.suspended:
sql_pharmacy_row = "INSERT INTO pharmacy (name, urban, created_date, suspended, unsuspended_date, pharmacist, exception, observation, address_id, county_id, locality_id, company_id) VALUES ('%s', %s, '%s', %s, '%s', '%s', '%s', '%s', %d, %d, %d, %d);" % (
pharmacy.name, pharmacy.urban, pharmacy.created_date, pharmacy.suspended, pharmacy.unsuspended_date, pharmacy.pharmacist,
pharmacy.exception, pharmacy.observation, address_counter, county_id, locality_id, company_id
print(filename)
json_file = open(SETTINGS.JSON_PATH + filename, 'r')
json_data = json.load(json_file)
for i in range(0, len(json_data)):
data = json_data[i]
if data['LOCALITATE'] != 'BUCURESTI':
if data['URBAN/RURAL'] == 'URBAN':
city = data['LOCALITATE']
#INSERT INTO locality (city, village, commune, urban) VALUES (1, 'Alba Iulia', '', '', True);
command = "INSERT INTO locality (city, village, commune, urban) VALUES ('%s', '%s', '%s', %s);" %(
city, '', '', True)
else:
commune = data['ADRESA'].split(',')[0]
village = data['LOCALITATE']
command = "INSERT INTO locality (city, village, commune, urban) VALUES ('%s', '%s', '%s', %s);" %(
'', village, commune, False)
else:
#INSERT INTO locality (city, village, commune, urban, sector) VALUES (10, 'Bucuresti', '', '', True, 'sector 1');
sector = SETTINGS.COUNTY[data['JUD/SECT']]
command = "INSERT INTO locality (city, village, commune, urban, sector) VALUES ('%s', '%s', '%s', %s, '%s');" %(
'Bucuresti', '', '', True, sector)
if db.select_locality(con, data) == 0:
file.write(command)
file.write('\n')
db.execute_query(con, command)
file.close()
