""" Module that control de behaviour of GJson files. """ import tempfile import os import shutil # Fix gdal 2.40 and 3.3 integration problems try: import ogr except ModuleNotFoundError: from osgeo import ogr import datetime import hashlib from tools import const from MG.tools.postgis_api import PostGis from .masterDriver import MasterDriver class GJSON(MasterDriver): """ Class that control de behaviour of GJson files. """ format = 'geojson' gdal_driver = 'GeoJSON' driver_type = const.VECTOR_KEY name = const.GJSON_KEY def to_local(self, layer, *_, **__): """ Get remote source to out local environment Parameters ---------- layer: :obj:`Layer` _: optional Arguments __: optional Arguments Returns ------- success: dict New parameters of the layer """ url = layer.gdal_layer(with_vsi=False) user = layer.user geojson_init = url.split('/')[-1] geojson_array = geojson_init.split('.') if len(geojson_array) >= 3: geojson = "" for i in range(len(geojson_array)-1): geojson += geojson_array[i]+'_' geojson = geojson[:-1] elif len(geojson_init.split('.')) == 2: geojson = geojson_init.split('.')[0] geojson = geojson.replace('.', '_') server_name = "{}_GJSON_{}_{}".format(user, geojson, layer['layer_name']).\ replace(' ', '_') foreign_table_name = "GJSON_{}_{}_ft".format(geojson, layer['layer_name']).\ replace(' ', '_') status_wrapper_geojson = PostGis('public').\ wrapper_gjson_pg(user, server_name, url, user, geojson, foreign_table_name) # Update parameters of layer with the new connection and source postgis = PostGis('public') new_parameters = {'ip': postgis.ip, 'port': postgis.port, 'protocol': const.POSTGRESQL_KEY, 'driver_type': const.POSTGRESQL_KEY, 'user': postgis.user, 'password': postgis.passw, 'database_name': postgis.dbname, 'layer_name': geojson, 'table_view_name': status_wrapper_geojson['layer'], 'schema': user} return new_parameters def download(self, layer, dst, *_, **__): """ Method to download the source from remote to local file. Parameters ---------- layer: :obj:`Layer` Layer from remote source dst: str Path to save the file _: list Arguments __: dict Arguments Returns ------- success: str Path where the fil has been saved """ dst = self.check_source(dst) src_path = layer['source'] layer.protocol.download(src_path, dst) # Removing, if exists, table in user's schema. # The method "to_local" has been executed earlier. postgis_obj = PostGis(layer.user) postgis_obj.get_foreign_server_from_ft( layer.user, layer.local_parameters['table_view_name']) return dst def upload(self, layer, orig, *_, **__): """ Method to upload file from out local system to remote Parameters ---------- layer: :obj:`Layer` Layer from remote source orig: str Path in local system _: list Arguments __: dict Arguments Returns ------- success: None """ layer.protocol.upload(orig, layer.get_source()) def remove(self, source, *_): """ Remove sources Parameters ---------- source: str Path to remove _: list Arguments Returns ------- success: None """ # Everything on this driver are going to be files or folder if os.path.isdir(source): shutil.rmtree(source) elif os.path.isfile(source): os.remove(source) def translate(self, src_layer, dst_driver): """ Translate layer from one driver to another Parameters ---------- src_layer: :obj:`Layer` Origin layer dst_driver: :obj:`Layer` Destiny layer Returns ------- success: list Resulting files """ tmp_dir = tempfile.mkdtemp(dir=const.TMP_DIRECTORY) result_files = [] for source in src_layer.attached_sources: gdal_layer_source = src_layer.gdal_url(source) file_name = source.split(os.sep)[-1].split('.')[0] file_result = os.path.join(tmp_dir, file_name) file_result = dst_driver.check_source(file_result) command = 'ogr2ogr -overwrite -f "{output_format}" ' \ '"{output_connection}" "{input_connection}"'.\ format(output_format=dst_driver.gdal_driver, output_connection=file_result, input_connection=gdal_layer_source) result_files.append(file_result) os.system(command) zipped = len(result_files) > 1 if zipped: output_result = src_layer['source'].split('/')[-1].split('.')[0] zip_output = os.path.join(tmp_dir, '{}.zip'.format(output_result)) result_names = [name.split(os.sep)[-1].split('.')[0] + "*" for name in result_files] command = "cd {} && zip -q {} {}".format(tmp_dir, zip_output. split(os.sep)[-1], ' '.join(result_names)) os.system(command) # Update layer new_cloud_parameters = { 'driver_type': const.ZIP_KEY, 'source': "{}/{}.zip".format('/'.join(src_layer['source']. split('/')[:-1]), output_result) } src_layer.cloud_parameters.update(new_cloud_parameters) result_files = [zip_output] src_layer.residual_sources.append(tmp_dir) return result_files def publish(self, *_, **__): """ Publish on Geoserver Parameters ---------- _ __ Returns ------- """ return None def check_source(self, source): """ Check that source follow the naming rules of the driver Parameters ---------- source: str Path to the source Returns ------- success: str Formatted path to the source """ # Checking dst path has_extension = len(source.split('.')) >= 2 if not has_extension: # Adding extension source = "{}.{}".format(source, self.format) return source def get_source(self, layer, *_, only_name=False, **__): """ Get source path with the formar of the driver Parameters ---------- layer: :obj: `Layer` only_name: bool Get only the name or full path _: list Arguments __: dict Arguments Returns ------- success: str Formatted source """ if only_name: return layer['source'].split('/')[-1].split('.')[0] return layer['source'] def check(self, layer): """ Check that source Parameters ---------- layer: :obj: `Layer` Returns ------- bool True if successful, False otherwise. """ data_source = ogr.Open(layer.gdal_layer(), 0) if not data_source: return False return True def create(self, *_): """ With the execution of the wrapper, the foreign table is obtained from which the attributes that the user indicates will be extracted, for subsequent preview. Parameters ---------- _: Notes ----- This method will return None for all layers except Postgres, since once the wrapper is done, all layers are foreign tables. Returns ------- success: None """ return None def list(self, layer): """ Get the list of attributes and layer name of the source Parameters ---------- layer: :obj: `Layer` Returns ------- dict dict containing layer and attributes. {"layers": [{"name": 'layer1', 'attributes': [attr1, attr2, ...]}]} """ data_source = ogr.Open(layer.gdal_layer(), 0) data = {'layers': []} for layer_ogr in data_source: layer_data = dict() layer_data['name'] = layer_ogr.GetName() layer_data['attributes'] = [] layer_definition = layer_ogr.GetLayerDefn() for meta in range(layer_definition.GetFieldCount()): field_definition = layer_definition.GetFieldDefn(meta) attribute_layer = field_definition.name layer_data['attributes'].append(attribute_layer) if layer_definition.GetGeomFieldCount() >= 1: layer_data['attributes'].append('geom') data['layers'].append(layer_data) return data def preview(self, _): """ Get the info to preview Parameters ---------- _: Returns ------- bool True if successful. """ return True def prelist(self, layer): """ List the layers of sources to preview Parameters ---------- layer: :obj: `Layer` Returns ------- list List that contain the layer name """ data_source = ogr.Open(layer.gdal_layer(), 0) head = ["layers"] layers = [] output_list = [] if data_source: for lay in data_source: layers.append([lay.GetName()]) output_list.append(head) output_list.append(layers) return output_list class GJSONVirtual(GJSON): """ Class that control de GJson as a string """ def to_local(self, layer, *_, **__): """ Get remote source to out local environment Parameters ---------- layer: :obj:`Layer` _: optional Arguments __: optional Arguments Returns ------- success: dict New parameters of the layer """ postgis = PostGis('public') # Me ralla mucho dejar servidores foráneos y no poder eliminarlos # En las siguientes líneas se eliminan aquellos que hayan estado 1 hora # En el sistema date_hour = str(int(datetime.datetime.now().strftime("%H")) * 60 + int( datetime.datetime.now().strftime("%M"))) sql = """ select foreign_server_name from information_schema.foreign_tables where foreign_server_name like '%gjsonV%'; """ for i in postgis.send_sql_command(sql): foreing_server_hour = int(i[0].split('__')[1]) if \ int(i[0].split('__')[1]) > 60 \ else int(i[0].split('__')[1]) + 24*60 if int(date_hour) - foreing_server_hour > 60: postgis.delete_server_data_Wraper(i[0]) # Fin de la rallada user = layer.user rnd = hashlib.md5(layer['source'].encode('utf-8')).hexdigest() server_name = user + '__' + date_hour + '__gjsonV_' + rnd foreign_table_name = 'gjsonV_' + rnd + '_ft' status_wrapper_gjson = PostGis('public').\ wrapper_gjson_pg(user, server_name, layer['source'], user, 'ogrgeojson', foreign_table_name) # Update parameters of layer with the new connection and source new_parameters = {'ip': postgis.ip, 'port': postgis.port, 'protocol': const.POSTGRESQL_KEY, 'driver_type': const.POSTGRESQL_KEY, 'user': postgis.user, 'password': postgis.passw, 'database_name': postgis.dbname, 'layer_name': rnd, 'table_view_name': status_wrapper_gjson['layer'], 'schema': user} return new_parameters class ContainerGJson(GJSON): """ Class that control de behaviour of GJson containers, for example a folder of gjson. """ def prelist(self, layer): head = ['layers'] layers = [] for _file in layer.list_files(): ext = _file.split('.')[-1] if ext == self.format: if '/' in _file: if '/ftp/' in _file: file = _file.replace('/ftp/{}/public/'.format( layer['user']), '').rsplit('/', 1)[1] source = '{}'.format(_file.replace( '/ftp/{}/public'.format(layer['user']), '')) else: file = _file.rsplit('/', 1)[1] source = '{}'.format(_file) else: file = _file source = '{}/{}'.format(layer['source'], _file) layer_new = layer.copy() layer_new.parameters['source'] = source layer_new.update_driver_and_protocol(layer_new.parameters) res = GJSON.prelist(self, layer_new) for layer_name in res[1]: layers.append(["{}:{}".format(file, layer_name[0])]) return [head, layers] def check(self, layer): layer_new = layer.copy() file, layer_name = layer_new.parameters['layer_name'].split(':') layer_new.parameters["source"] = "{}/{}".format( layer_new.parameters['source'], file) layer_new.parameters["layer_name"] = layer_name layer_new.update_driver_and_protocol(layer_new.parameters) return GJSON.check(self, layer_new) def to_local(self, layer, *args, **kwargs): layer_new = layer.copy() file, layer_name = layer['layer_name'].split(':') layer_new.parameters["source"] = "{}/{}".format( layer_new.parameters['source'], file) layer_new.parameters["layer_name"] = layer_name layer_new.update_driver_and_protocol(layer_new.parameters) return GJSON.to_local(self, layer_new, *args, **kwargs) def list(self, layer): layer_new = layer.copy() file, layer_name = layer['layer_name'].split(':') layer_new.parameters["source"] = "{}/{}".format( layer_new.parameters['source'], file) layer_new.parameters["layer_name"] = layer_name layer_new.update_driver_and_protocol(layer_new.parameters) data = GJSON.list(self, layer_new) for layer_data in data['layers']: if layer_data['name'] == layer_new["layer_name"]: layer_data['name'] = layer['layer_name'] break return data