def main():
if RECORDER_NAME.upper() == "ALL":
print "Developed LandInfo Photo"
if (LAST_DATE is None) or (len(LAST_DATE) <> 8) or not int(LAST_DATE):
last_update_date = support_rhm_sync_data.get_last_update_date()
if (last_update_date is None) or (len(last_update_date) <> 8):
last_update_date = "20150101"
else:
last_update_date = LAST_DATE
print "\n========================================\n"
print "\n===Start Working====\n"
print last_update_date
print "\n========================================\n"
# last_update_date = "20140102"
# Request to Nasim get data
lst_records = requestPlotPhotos.getListPhotoUrls(last_update_date)
# print last_update_date
# For loop all result of Nasim to insert our database
for record in lst_records:
try:
print ("===Consider : %s \n" % (last_update_date))
print record
print ("\n")
landinfor_name = str(record[0])
landinfor_recorder_name = str(record[1])
landinfor_landscapeNorthPhotoURL = str(record[4])
landinfor_landscapeEastPhotoURL = str(record[5])
landinfor_landscapeSouthPhotoURL = str(record[6])
landinfor_landscapeWestPhotoURL = str(record[7])
landinfor_soilPitPhotoURL = str(record[2])
landinfor_soilSamplesPhotoURL = str(record[3])
result = support_rhm_sync_data.update_photos_landinfo(
landinfor_name,
landinfor_recorder_name,
landinfor_landscapeNorthPhotoURL,
landinfor_landscapeEastPhotoURL,
landinfor_landscapeSouthPhotoURL,
landinfor_landscapeWestPhotoURL,
landinfor_soilPitPhotoURL,
landinfor_soilSamplesPhotoURL,
)
if result == 1:
print "\n ===Update successfully==="
else:
print "\n ===Error ----"
except:
pass
else:
print "Does not support now !"
def main():
if (RECORDER_NAME.upper() == "ALL"):
print "Developed"
recorder_name_list = support_rhm_sync_data.get_list_recorder_name_from_landpks()
if ((LAST_DATE is None) or (len(LAST_DATE) <> 8) or not int(LAST_DATE)):
last_update_date = support_rhm_sync_data.get_last_update_date()
if ((last_update_date is None) or (len(last_update_date) <> 8)):
last_update_date = "20140102"
else:
last_update_date = LAST_DATE
print "\n========================================\n"
print "\n===Start Working====\n";
print last_update_date
print "\n"
print recorder_name_list
print "\n========================================\n"
#last_update_date = "20140102"
# Request to Nasim get data
lst_records = requestRHMdata.getListRHMdata(recorder_name_list,last_update_date)
#print last_update_date
# For loop all result of Nasim to insert our database
for record in lst_records:
try:
print ("===Consider : %s \n" %(last_update_date));
print record
print ("\n")
rhm_name = str(record[0])
rhm_recorder_name = str(record[1])
rhm_transect = str(record[2])
rhm_dominant_woody_species = str(record[3])
rhm_dominant_nonwoody_species = str(record[4])
rhm_species_of_interest_1 = str(record[5])
rhm_species_of_interest_2 = str(record[6])
rhm_segment = str(record[7])
rhm_date = str(record[8])
rhm_canopy_height = str(record[9])
rhm_canopy_gap = str(record[10])
rhm_basal_gap = str(record[11])
rhm_species_1_density = int(record[12])
rhm_species_2_density = int(record[13])
rhm_species_of_interest_1_count = int(record[14])
rhm_species_of_interest_2_count = int(record[15])
rhm_stick_segment_0 = str(record[16])
rhm_stick_segment_1 = str(record[17])
rhm_stick_segment_2 = str(record[18])
rhm_stick_segment_3 = str(record[19])
rhm_stick_segment_4 = str(record[20])
if (not support_rhm_sync_data.check_exit_rhm_record(rhm_name,rhm_recorder_name,rhm_transect,rhm_segment)):
result = support_rhm_sync_data.insert_rhm_data_to_rhm_store(rhm_name,rhm_recorder_name, rhm_transect,rhm_dominant_woody_species,rhm_dominant_nonwoody_species,rhm_species_of_interest_1,rhm_species_of_interest_2, rhm_segment, rhm_date, rhm_canopy_height, rhm_canopy_gap, rhm_basal_gap,rhm_species_1_density,rhm_species_2_density,rhm_species_of_interest_1_count,rhm_species_of_interest_2_count, "", rhm_stick_segment_0, rhm_stick_segment_1 , rhm_stick_segment_2, rhm_stick_segment_3 ,rhm_stick_segment_4)
if (result == 1):
print "\n ===Insert successfully==="
else:
print "\n ===Error ----"
else:
print "\n ===Record existed==="
except:
pass
else:
list_recorder_name = [RECORDER_NAME]
if ((LAST_DATE is None) or (len(LAST_DATE) <> 8) or not int(LAST_DATE)):
last_update_date = support_rhm_sync_data.get_last_update_date_follow_recorder_name(RECORDER_NAME)
if ((last_update_date is None) or (len(last_update_date) <> 8)):
last_update_date = "20140102"
else:
last_update_date = LAST_DATE
print "\n========================================\n"
print "\n===Start Working====\n";
print last_update_date
print "\n"
print list_recorder_name
print "\n========================================\n"
lst_results = requestRHMdata.getListRHMdata(list_recorder_name,last_update_date)
for record in lst_results:
try:
print ("===Consider : %s \n" %(last_update_date));
print record
print ("\n")
rhm_name = str(record[0])
rhm_recorder_name = str(record[1])
rhm_transect = str(record[2])
rhm_dominant_woody_species = str(record[3])
rhm_dominant_nonwoody_species = str(record[4])
rhm_species_of_interest_1 = str(record[5])
rhm_species_of_interest_2 = str(record[6])
rhm_segment = str(record[7])
rhm_date = str(record[8])
rhm_canopy_height = str(record[9])
rhm_canopy_gap = str(record[10])
rhm_basal_gap = str(record[11])
rhm_species_1_density = int(record[12])
rhm_species_2_density = int(record[13])
rhm_species_of_interest_1_count = int(record[14])
rhm_species_of_interest_2_count = int(record[15])
rhm_stick_segment_0 = str(record[16])
rhm_stick_segment_1 = str(record[17])
rhm_stick_segment_2 = str(record[18])
rhm_stick_segment_3 = str(record[19])
rhm_stick_segment_4 = str(record[20])
if (not support_rhm_sync_data.check_exit_rhm_record(rhm_name,rhm_recorder_name,rhm_transect,rhm_segment)):
result = support_rhm_sync_data.insert_rhm_data_to_rhm_store(rhm_name,rhm_recorder_name, rhm_transect,rhm_dominant_woody_species,rhm_dominant_nonwoody_species,rhm_species_of_interest_1,rhm_species_of_interest_2, rhm_segment, rhm_date, rhm_canopy_height, rhm_canopy_gap, rhm_basal_gap,rhm_species_1_density,rhm_species_2_density,rhm_species_of_interest_1_count,rhm_species_of_interest_2_count, "", rhm_stick_segment_0, rhm_stick_segment_1 , rhm_stick_segment_2, rhm_stick_segment_3 ,rhm_stick_segment_4)
if (result == 1):
print "\n ===Insert successfully==="
else:
print "\n ===Error ----"
else:
print "\n ===Record existed==="
except:
pass
