def get_export(code_com, num_ordre, nro): num_ordre = "%05d" % int(num_ordre) code = code_com + '/' + nro + '/PB/' + num_ordre print('Création de la fiche export pour: ' + code) objectid_obj = sql("select objectid from ftth_zone_eligibilite where code_com='" + code_com + "' and type_pf='PB' and id_metier_pf='" + code + "'") objectid_obj = sql_response_as_list(objectid_obj)[0] if objectid_obj and 'objectid' in objectid_obj: objectid = objectid_obj['objectid'] else: objectid_obj = sql("select objectid from ftth_pf where code_com='" + code_com + "' and type_pf='PB' and id_metier_pf='" + code + "'") objectid_obj = sql_response_as_list(objectid_obj)[0] if objectid_obj and 'objectid' in objectid_obj: objectid = objectid_obj['objectid'] else: return None filename_exportImbSoe =\ loads( b64decode( get("http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/keepalive?url=" + quote("http://localhost/RestFmkSrvDeploy/orion/applications/clientorion/arcgis/rest/services/geofibre/short_soe/MapServer/exts/ExportImb/ExportImbZone?objectId=" + objectid + "&layerImbId=5&layerZoneId=20&token=unknow&auteur=djhc1710&nomChampIdMetierZone=id_metier_ze&zone_geo=METROPOLE") ).replace(b'|FT|', b'') ).decode() )['filename'] export =\ b64decode( loads( get("http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/exportImb?token=unknow&auteur=djhc1710&filename=" + quote(filename_exportImbSoe) ).decode('utf-8') )['detail'].replace('\n', '')) with open(__JOB_PATH__ + sep + code.replace('/', '_') + '.csv', 'wb') as file_: file_.write(codecs.BOM_UTF8) file_.write(export)
def sql(sql_cmd, return_cmd=False): geofibre_bdd_url = "http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/requeteBDD?date=Thu%20Jul%209%2015%3A23%3A38%20GMT%2B0200%202015&token=unknow&REQUETE=" response = loads( b64decode( get( geofibre_bdd_url + sql_cmd ).replace(b'\r\n', b'') ).decode() )['reponse'] if return_cmd: return (sql_cmd, response) else: return response