def test_export_data_in_gpkg(self): print("\nINFO: Validate Export Data in GPKG...") gpkg_path = get_test_copy_path( 'geopackage/test_export_data_ladm_v1_0.gpkg') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = ExportConfiguration() configuration.base_configuration = base_config configuration.ilimodels = ';'.join([ self.ladmcol_models.model( LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name() ]) configuration.dbfile = gpkg_path exporter = iliexporter.Exporter() exporter.tool = DbIliMode.ili2gpkg exporter.configuration = configuration exporter.configuration.xtffile = os.path.join(self.base_test_path, 'test_export_data.xtf') # exporter.stderr.connect(self.on_stderr) self.assertEqual(exporter.run(), iliexporter.Exporter.SUCCESS) self.check_export_xtf(exporter.configuration.xtffile)
def test_export_data_in_gpkg(self): print("\nINFO: Validate Export Data in GPKG...") gpkg_path = get_test_copy_path('geopackage/test_export_data.gpkg') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path('models/LADM_COL') base_config.custom_model_directories_enabled = True configuration = ExportConfiguration() configuration.base_configuration = base_config configuration.ilimodels = ';'.join([ LADMNames.SUPPORTED_LADM_MODEL, LADMNames.SUPPORTED_SNR_DATA_MODEL, LADMNames.SUPPORTED_SUPPLIES_MODEL, LADMNames.SUPPORTED_SUPPLIES_INTEGRATION_MODEL, LADMNames.SUPPORTED_OPERATION_MODEL, LADMNames.SUPPORTED_ANT_MODEL, LADMNames.SUPPORTED_CADASTRAL_FORM_MODEL, LADMNames.SUPPORTED_VALUATION_MODEL ]) configuration.dbfile = gpkg_path exporter = iliexporter.Exporter() exporter.tool = DbIliMode.ili2gpkg exporter.configuration = configuration exporter.configuration.xtffile = os.path.join(self.base_test_path, 'test_export_data.xtf') self.assertEqual(exporter.run(), iliexporter.Exporter.SUCCESS) self.check_export_xtf(exporter.configuration.xtffile)
def test_export_data_in_pg(self): print("\nINFO: Validate Export Data in PG...") restore_schema('test_export_data') db_pg = get_pg_conn('test_export_data') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = ExportConfiguration() configuration.base_configuration = base_config configuration.dbhost = 'postgres' configuration.dbusr = '******' configuration.dbpwd = 'clave_ladm_col' configuration.database = 'ladm_col' configuration.dbschema = 'test_export_data' configuration.delete_data = True configuration.ilimodels = ';'.join([self.ladmcol_models.model(LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name()]) exporter = iliexporter.Exporter() exporter.tool = DbIliMode.ili2pg exporter.configuration = configuration exporter.configuration.xtffile = os.path.join(tempfile.mkdtemp(), 'test_export_data.xtf') self.assertEqual(exporter.run(), iliexporter.Exporter.SUCCESS) self.check_export_xtf(exporter.configuration.xtffile) db_pg.conn.close()
def test_import_schema_in_gpkg(self): print("\nINFO: Validate Import Schema in GPKG...") base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = SchemaImportConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2gpkg configuration.dbfile = os.path.join(self.base_test_path, 'tmp_import_schema.gpkg') configuration.tomlfile = TOML_FILE_DIR configuration.srs_code = 3116 configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS configuration.ilimodels = ';'.join([self.ladmcol_models.model(LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.CADASTRAL_CARTOGRAPHY_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.VALUATION_MODEL_KEY).full_name()]) importer = iliimporter.Importer() importer.tool = DbIliMode.ili2gpkg importer.configuration = configuration self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) config_manager = GpkgCommandConfigManager(importer.configuration) generator = Generator(DbIliMode.ili2gpkg, config_manager.get_uri(), configuration.inheritance) available_layers = generator.layers() self.assertEqual(len(available_layers), 184)
def test_import_data_in_mssql(self): print("\nINFO: Validate Import Data in MS SQL Server...") schema = 'test_ladm_col' reset_db_mssql(schema) restore_schema_mssql(schema) db_conn = get_mssql_conn(schema) base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True model_list = [self.ladmcol_models.model(LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name()] configuration = ImportDataConfiguration() configuration.base_configuration = base_config configuration.dbhost = 'mssql' configuration.dbusr = '******' configuration.dbpwd = '<YourStrong!Passw0rd>' configuration.dbport = '1433' configuration.database = schema # use schema because delete schemas in mssql is difficult configuration.dbschema = schema configuration.db_odbc_driver = 'ODBC Driver 17 for SQL Server' configuration.delete_data = True configuration.ilimodels = ';'.join(model_list) configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS importer = iliimporter.Importer(dataImport=True) importer.tool = DbIliMode.ili2mssql importer.configuration = configuration importer.configuration.xtffile = testdata_path('xtf/test_ladm_col_queries_v1_0.xtf') self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator(DbIliMode.ili2mssql, 'DRIVER={{ODBC Driver 17 for SQL Server}};SERVER={host},1433;DATABASE={db};UID={user};PWD={pwd}' .format(db=configuration.database, user=configuration.dbusr, pwd=configuration.dbpwd, host=configuration.dbhost, port=configuration.dbport), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 156) res, code, msg = db_conn.test_connection() self.assertTrue(res, msg) test_layer = self.app.core.get_layer(db_conn, db_conn.names.LC_BOUNDARY_POINT_T, load=True) self.assertEqual(test_layer.featureCount(), 390) db_conn.conn.close()
def test_import_schema_in_mssql(self): schema = 'test_import_schema' reset_db_mssql(schema) print("\nINFO: Validate Import Schema in MS SQL Server") base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path( 'xtf') + ';' + testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = SchemaImportConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2mssql configuration.dbhost = 'mssql' configuration.dbusr = '******' configuration.dbpwd = '<YourStrong!Passw0rd>' configuration.dbport = '1433' configuration.database = schema configuration.dbschema = schema configuration.db_odbc_driver = 'ODBC Driver 17 for SQL Server' configuration.tomlfile = TOML_FILE_DIR configuration.epsg = 9377 configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS configuration.ilimodels = ';'.join([ self.ladmcol_models.model( LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name() ]) importer = iliimporter.Importer() importer.tool = DbIliMode.ili2mssql importer.configuration = configuration # importer.stderr.connect(self.on_stderr) self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator( DbIliMode.ili2mssql, 'DRIVER={{ODBC Driver 17 for SQL Server}};SERVER={host},1433;DATABASE={db};UID={user};PWD={pwd}' .format(db=configuration.database, user=configuration.dbusr, pwd=configuration.dbpwd, host=configuration.dbhost, port=configuration.dbport), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 156)
def test_import_data_in_gpkg(self): print("\nINFO: Validate Import Data in GPKG...") gpkg_path = get_test_copy_path( 'geopackage/test_import_data_ladm_v1_0.gpkg') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = ImportDataConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2gpkg configuration.dbfile = gpkg_path configuration.srs_auth = DEFAULT_SRS_AUTH configuration.srs_code = DEFAULT_SRS_CODE configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS configuration.delete_data = True configuration.ilimodels = ';'.join([ self.ladmcol_models.model( LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name() ]) importer = iliimporter.Importer(dataImport=True) importer.tool = DbIliMode.ili2gpkg importer.configuration = configuration importer.configuration.xtffile = testdata_path( 'xtf/test_ladm_col_queries_v1_0.xtf') # importer.stderr.connect(self.on_stderr) self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) config_manager = GpkgCommandConfigManager(importer.configuration) generator = Generator(DbIliMode.ili2gpkg, config_manager.get_uri(), configuration.inheritance) available_layers = generator.layers() self.assertEqual(len(available_layers), 156) db_gpkg = get_gpkg_conn_from_path(config_manager.get_uri()) res, code, msg = db_gpkg.test_connection() self.assertTrue(res, msg) test_layer = self.app.core.get_layer(db_gpkg, db_gpkg.names.LC_BOUNDARY_POINT_T, load=True) self.assertEqual(test_layer.featureCount(), 390) db_gpkg.conn.close()
def test_import_data_in_pg(self): print("\nINFO: Validate Import Data in PG...") restore_schema('test_import_data') db_pg = get_pg_conn('test_import_data') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path('models/LADM_COL') base_config.custom_model_directories_enabled = True configuration = ImportDataConfiguration() configuration.base_configuration = base_config configuration.dbhost = 'postgres' configuration.dbusr = '******' configuration.dbpwd = 'clave_ladm_col' configuration.database = 'ladm_col' configuration.epsg = DEFAULT_EPSG configuration.inheritance = LADMNames.DEFAULT_INHERITANCE configuration.create_basket_col = LADMNames.CREATE_BASKET_COL configuration.create_import_tid = LADMNames.CREATE_IMPORT_TID configuration.stroke_arcs = LADMNames.STROKE_ARCS configuration.dbschema = 'test_import_data' configuration.delete_data = True configuration.ilimodels = ';'.join([ LADMNames.SUPPORTED_LADM_MODEL, LADMNames.SUPPORTED_SNR_DATA_MODEL, LADMNames.SUPPORTED_SUPPLIES_MODEL, LADMNames.SUPPORTED_SUPPLIES_INTEGRATION_MODEL, LADMNames.SUPPORTED_OPERATION_MODEL, LADMNames.SUPPORTED_ANT_MODEL, LADMNames.SUPPORTED_CADASTRAL_FORM_MODEL, LADMNames.SUPPORTED_VALUATION_MODEL ]) importer = iliimporter.Importer(dataImport=True) importer.tool = DbIliMode.ili2pg importer.configuration = configuration importer.configuration.xtffile = testdata_path( 'xtf/test_ladm_col_queries_v2.9.6.xtf') self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator( DbIliMode.ili2pg, 'dbname={} user={} password={} host={}'.format( configuration.database, configuration.dbusr, configuration.dbpwd, configuration.dbhost), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 189) res, code, msg = db_pg.test_connection() self.assertTrue(res, msg) test_layer = self.qgis_utils.get_layer(db_pg, db_pg.names.OP_BOUNDARY_POINT_T, load=True) self.assertEqual(test_layer.featureCount(), 390) db_pg.conn.close()
def test_import_data_in_pg(self): print("\nINFO: Validate Import Data in PG...") restore_schema('test_import_data') db_pg = get_pg_conn('test_import_data') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = ImportDataConfiguration() configuration.base_configuration = base_config configuration.dbhost = 'postgres' configuration.dbusr = '******' configuration.dbpwd = 'clave_ladm_col' configuration.database = 'ladm_col' configuration.srs_auth = DEFAULT_SRS_AUTH configuration.srs_code = DEFAULT_SRS_CODE configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS configuration.dbschema = 'test_import_data' configuration.delete_data = True configuration.ilimodels = ';'.join([self.ladmcol_models.model(LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name()]) importer = iliimporter.Importer(dataImport=True) importer.tool = DbIliMode.ili2pg importer.configuration = configuration importer.configuration.xtffile = testdata_path('xtf/test_ladm_col_queries_v1_0.xtf') self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator( DbIliMode.ili2pg, 'dbname={} user={} password={} host={}'.format(configuration.database, configuration.dbusr, configuration.dbpwd, configuration.dbhost), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 156) res, code, msg = db_pg.test_connection() self.assertTrue(res, msg) test_layer = self.app.core.get_layer(db_pg, db_pg.names.LC_BOUNDARY_POINT_T, load=True) self.assertEqual(test_layer.featureCount(), 390) db_pg.conn.close()
def test_import_schema_in_pg(self): print("\nINFO: Validate Import Schema in PG...") base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path( 'xtf') + ';' + testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True configuration = SchemaImportConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2pg configuration.dbhost = 'postgres' configuration.dbusr = '******' configuration.dbpwd = 'clave_ladm_col' configuration.database = 'ladm_col' configuration.dbschema = 'test_import_schema' configuration.tomlfile = TOML_FILE_DIR configuration.srs_code = 3116 configuration.inheritance = ILI2DBNames.DEFAULT_INHERITANCE configuration.create_basket_col = ILI2DBNames.CREATE_BASKET_COL configuration.create_import_tid = ILI2DBNames.CREATE_IMPORT_TID configuration.stroke_arcs = ILI2DBNames.STROKE_ARCS configuration.ilimodels = ';'.join([ self.ladmcol_models.model( LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.CADASTRAL_CARTOGRAPHY_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.VALUATION_MODEL_KEY).full_name() ]) importer = iliimporter.Importer() importer.tool = DbIliMode.ili2pg importer.configuration = configuration # importer.stderr.connect(self.on_stderr) self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator( DbIliMode.ili2pg, 'dbname={} user={} password={} host={}'.format( configuration.database, configuration.dbusr, configuration.dbpwd, configuration.dbhost), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 184)
def test_import_data_in_gpkg(self): print("\nINFO: Validate Import Data in GPKG...") gpkg_path = get_test_copy_path('geopackage/test_import_data.gpkg') base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path('models/LADM_COL') base_config.custom_model_directories_enabled = True configuration = ImportDataConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2gpkg configuration.dbfile = gpkg_path configuration.epsg = DEFAULT_EPSG configuration.inheritance = LADMNames.DEFAULT_INHERITANCE configuration.create_basket_col = LADMNames.CREATE_BASKET_COL configuration.create_import_tid = LADMNames.CREATE_IMPORT_TID configuration.stroke_arcs = LADMNames.STROKE_ARCS configuration.delete_data = True configuration.ilimodels = ';'.join([ LADMNames.SUPPORTED_LADM_MODEL, LADMNames.SUPPORTED_SNR_DATA_MODEL, LADMNames.SUPPORTED_SUPPLIES_MODEL, LADMNames.SUPPORTED_SUPPLIES_INTEGRATION_MODEL, LADMNames.SUPPORTED_OPERATION_MODEL, LADMNames.SUPPORTED_ANT_MODEL, LADMNames.SUPPORTED_CADASTRAL_FORM_MODEL, LADMNames.SUPPORTED_VALUATION_MODEL ]) importer = iliimporter.Importer(dataImport=True) importer.tool = DbIliMode.ili2gpkg importer.configuration = configuration importer.configuration.xtffile = testdata_path( 'xtf/test_ladm_col_queries_v2.9.6.xtf') self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) config_manager = GpkgCommandConfigManager(importer.configuration) generator = Generator(DbIliMode.ili2gpkg, config_manager.get_uri(), configuration.inheritance) available_layers = generator.layers() self.assertEqual(len(available_layers), 189) db_gpkg = get_gpkg_conn_from_path(config_manager.get_uri()) res, code, msg = db_gpkg.test_connection() self.assertTrue(res, msg) test_layer = self.qgis_utils.get_layer( db_gpkg, db_gpkg.names.OP_BOUNDARY_POINT_T, load=True) self.assertEqual(test_layer.featureCount(), 390) db_gpkg.conn.close()
def test_export_data_in_mssql(self): print("\nINFO: Validate Export Data in MS SQL Server...") schema = 'test_export_data' reset_db_mssql(schema) restore_schema_mssql(schema) db_conn = get_mssql_conn(schema) base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path(MODELS_PATH) base_config.custom_model_directories_enabled = True model_list = [ self.ladmcol_models.model( LADMNames.LADM_COL_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SNR_DATA_SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_MODEL_KEY).full_name(), self.ladmcol_models.model( LADMNames.SUPPLIES_INTEGRATION_MODEL_KEY).full_name(), self.ladmcol_models.model(LADMNames.SURVEY_MODEL_KEY).full_name() ] configuration = ExportConfiguration() configuration.base_configuration = base_config configuration.dbhost = 'mssql' configuration.dbusr = '******' configuration.dbpwd = '<YourStrong!Passw0rd>' configuration.dbport = '1433' configuration.database = schema # use schema because delete schemas in mssql is difficult configuration.dbschema = schema configuration.db_odbc_driver = 'ODBC Driver 17 for SQL Server' configuration.delete_data = True configuration.ilimodels = ';'.join(model_list) exporter = iliexporter.Exporter() exporter.tool = DbIliMode.ili2mssql exporter.configuration = configuration exporter.configuration.xtffile = os.path.join(tempfile.mkdtemp(), 'test_export_data.xtf') # exporter.stderr.connect(self.on_stderr) self.assertEqual(exporter.run(), iliexporter.Exporter.SUCCESS) self.check_export_xtf(exporter.configuration.xtffile) db_conn.conn.close()
def test_import_schema_in_pg(self): print("\nINFO: Validate Import Schema in PG...") base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path( 'xtf') + ';' + testdata_path('models/LADM_COL') base_config.custom_model_directories_enabled = True configuration = SchemaImportConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2pg configuration.dbhost = 'postgres' configuration.dbusr = '******' configuration.dbpwd = 'clave_ladm_col' configuration.database = 'ladm_col' configuration.dbschema = 'test_import_schema' configuration.tomlfile = TOML_FILE_DIR configuration.epsg = DEFAULT_EPSG configuration.inheritance = LADMNames.DEFAULT_INHERITANCE configuration.create_basket_col = LADMNames.CREATE_BASKET_COL configuration.create_import_tid = LADMNames.CREATE_IMPORT_TID configuration.stroke_arcs = LADMNames.STROKE_ARCS configuration.ilimodels = ';'.join([ LADMNames.SUPPORTED_LADM_MODEL, LADMNames.SUPPORTED_SNR_DATA_MODEL, LADMNames.SUPPORTED_SUPPLIES_MODEL, LADMNames.SUPPORTED_SUPPLIES_INTEGRATION_MODEL, LADMNames.SUPPORTED_OPERATION_MODEL, LADMNames.SUPPORTED_ANT_MODEL, LADMNames.SUPPORTED_CADASTRAL_FORM_MODEL, LADMNames.SUPPORTED_REFERENCE_CARTOGRAPHY, LADMNames.SUPPORTED_VALUATION_MODEL ]) importer = iliimporter.Importer() importer.tool = DbIliMode.ili2pg importer.configuration = configuration self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) generator = Generator( DbIliMode.ili2pg, 'dbname={} user={} password={} host={}'.format( configuration.database, configuration.dbusr, configuration.dbpwd, configuration.dbhost), configuration.inheritance, importer.configuration.dbschema) available_layers = generator.layers() self.assertEqual(len(available_layers), 207)
def test_import_schema_in_gpkg(self): print("\nINFO: Validate Import Schema in GPKG...") base_config = BaseConfiguration() base_config.custom_model_directories = testdata_path('models/LADM_COL') base_config.custom_model_directories_enabled = True configuration = SchemaImportConfiguration() configuration.base_configuration = base_config configuration.tool = DbIliMode.ili2gpkg configuration.dbfile = os.path.join(self.base_test_path, 'tmp_import_schema.gpkg') configuration.tomlfile = TOML_FILE_DIR configuration.epsg = DEFAULT_EPSG configuration.inheritance = LADMNames.DEFAULT_INHERITANCE configuration.create_basket_col = LADMNames.CREATE_BASKET_COL configuration.create_import_tid = LADMNames.CREATE_IMPORT_TID configuration.stroke_arcs = LADMNames.STROKE_ARCS configuration.ilimodels = ';'.join([ LADMNames.SUPPORTED_LADM_MODEL, LADMNames.SUPPORTED_SNR_DATA_MODEL, LADMNames.SUPPORTED_SUPPLIES_MODEL, LADMNames.SUPPORTED_SUPPLIES_INTEGRATION_MODEL, LADMNames.SUPPORTED_OPERATION_MODEL, LADMNames.SUPPORTED_ANT_MODEL, LADMNames.SUPPORTED_CADASTRAL_FORM_MODEL, LADMNames.SUPPORTED_REFERENCE_CARTOGRAPHY, LADMNames.SUPPORTED_VALUATION_MODEL ]) importer = iliimporter.Importer() importer.tool = DbIliMode.ili2gpkg importer.configuration = configuration self.assertEqual(importer.run(), iliimporter.Importer.SUCCESS) config_manager = GpkgCommandConfigManager(importer.configuration) generator = Generator(DbIliMode.ili2gpkg, config_manager.get_uri(), configuration.inheritance) available_layers = generator.layers() self.assertEqual(len(available_layers), 207)