""" Module that control KML files """ import os import tempfile import shutil import psycopg2 # Fix gdal 2.40 and 3.3 integration problems try: import ogr except ModuleNotFoundError: from osgeo import ogr from tools import const from MG.tools.postgis_api import PostGis from .masterDriver import MasterDriver class KML(MasterDriver): """ Class that control Kml files """ format = 'kml' gdal_driver = 'KML' driver_type = const.VECTOR_KEY name = const.KML_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 """ user = layer.user url = layer.gdal_layer(with_vsi=False) kml = layer['source'].split('/')[-1][:-4] postgis = PostGis('public') server_name = "{}_KML_{}_{}".format(user, kml, layer['layer_name']).\ replace(' ', '_') foreign_table_name = "KML_{}_{}_ft".format(kml, layer['layer_name']).\ replace(' ', '_') try: postgis.wrapper_kml_limit_pg(user, server_name, url, user, kml, '{}'.format(layer['layer_name']), foreign_table_name) except psycopg2.errors.DuplicateObject: pass except Exception as err: raise Exception('KML wrapper error: {}'.format(err)) # 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': kml, 'table_view_name': foreign_table_name, '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, _): """ Translate layer from one driver to another Parameters ---------- src_layer: :obj:`Layer` Origin layer _: Returns ------- success: list Resulting files """ postgis_obj = PostGis('public') tmp_dir = tempfile.mkdtemp(dir=const.TMP_DIRECTORY) result_files = [] table_view_names = [] for table in src_layer.attached_sources: has_extension = len(table.split('.')) >= 2 if not has_extension: table_view_names.append(table) result_shp = os.path.join(tmp_dir, "{}.{}".format(table, self.format)) command = 'ogr2ogr -f "{}" {} PG:"host={} port={} dbname={} ' \ 'user={} password={} schemas={} tables={}"'.\ format(self.gdal_driver, result_shp, postgis_obj.ip, postgis_obj.port, postgis_obj.dbname, postgis_obj.user, postgis_obj.passw, src_layer.user, table) os.system(command) else: result_shp = table result_files.append(result_shp) 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 format 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 = [] for lay in data_source: layers.append([lay.GetName()]) output_list.append(head) output_list.append(layers) return output_list class ContainerKml(KML): """ Class that control Kml containers """ 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 = KML.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 KML.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 KML.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 = KML.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