def testImport(): manager = getArena2ImportManager() dialog = manager.createImportDialog() dialog.arena2filePicker.coerceAndSet( getResource(__file__, "..", "Arena2Reader", "datos", "test", "TV_03_2019_01_Q1", "victimas.xml")) dialog.showWindow("ARENA2 Importar accidentes")
def selfRegister(): manager = getArena2ImportManager() manager.addTransformFactory(CodigoINETransformFactory()) manager.addRuleFactory(CodigoINERuleFactory()) manager.addRuleFixer(IgnoreCodigoINEErrorAction()) manager.addRuleErrorCode( CODERR_CODIGO_INE_NO_ENCONTRADO, "%s - Codigo INE no encontrado" % CODERR_CODIGO_INE_NO_ENCONTRADO) manager.addRuleErrorCode( CODERR_CODIGO_INE_ERRONEO, "%s - Codigo INE erroneo" % CODERR_CODIGO_INE_ERRONEO) manager.addReportAttribute("INE_PROVINCIA", Integer, size=02, label="Codigo INE Provincia propuesto", isEditable=True) manager.addReportAttribute("INE_MUNICIPIO", Integer, size=05, label="Codigo INE Municipio propuesto", isEditable=True) manager.addReportAttribute("PPROVINCIA", String, size=100, label="Provincia propuesto", isEditable=True) manager.addReportAttribute("PMUNICIPIO", String, size=100, label="Municipio propuesto", isEditable=True)
def validateData(folderData, issues_pathname, slot, slotsize, workspaceName): status = LoggerTaskStatus("ValidateArena2Files") issues_pathname = issues_pathname % slot fnames, slots = calculateSlots(folderData, slotsize, slot, status) status.logger("validate slot %d/%d" % (slot, slots)) if not connectToWorkspace(workspaceName, status): return importManager = getArena2ImportManager() report = MyReport(importManager) report.setEnabledEvents(False) dataManager = DALLocator.getDataManager() workspace = dataManager.getDatabaseWorkspace("ARENA2_DB") if workspace == None: status.logger("Can't access to workspace ARENA2_DB", gvsig.LOGGER_WARN) p = ValidatorProcess(importManager, fnames, report, workspace, status) p.run() if os.path.exists(issues_pathname): status.logger("removing file %r" % issues_pathname) os.unlink(issues_pathname) explorer = dataManager.openServerExplorer("FilesystemExplorer") store = report.getStore() status.logger("export issues to %r" % issues_pathname) store.export(explorer, "CSV", explorer.getAddParameters(File(issues_pathname)))
def importData(issues_pathname, slot, slotsize, workspaceName): status = LoggerTaskStatus("ImportArena2Files") issues_pathname = issues_pathname % slot fnames, slots = calculateSlots(folderData, slotsize, slot, status) status.logger("import slot %d/%d" % (slot, slots)) if not connectToWorkspace(workspaceName, status): return importManager = getArena2ImportManager() report = Report(importManager) report.setEnabledEvents(False) dataManager = DALLocator.getDataManager() workspace = dataManager.getDatabaseWorkspace("ARENA2_DB") if workspace==None: status.logger("Can't access to workspace ARENA2_DB", gvsig.LOGGER_WARN) return issues = dataManager.openStore("CSV","File", issues_pathname) report.addIssues(issues.getFeatureSet()) if len(report) != issues.getFeatureCount(): status.logger("Can't load issues in report", gvsig.LOGGER_WARN) return p = ImportProcess(importManager, fnames, workspace, report, status) p.run()
def validatorData(self): manager = getArena2ImportManager() messages = manager.checkRequirements() if messages != None: msgbox("\n".join(messages)) return dialog = manager.createPostValidatorDialog() dialog.showWindow("ARENA2 Validador accidentes")
def createTables(self): manager = getArena2ImportManager() #messages = manager.checkRequirements() #if messages!=None: #msgbox("\n".join(messages)) #return dialog = manager.createTablestDialog() dialog.showWindow("Accidentes - Crear tablas de accidentes")
def importData(self): manager = getArena2ImportManager() messages = manager.checkRequirements() if messages != None: msgbox("\n".join(messages)) return dialog = manager.createImportDialog() dialog.showWindow("Accidentes - Importar accidentes")
def main(*args): #testCreateTables()() #selfRegister() #geocode.selfRegister() manager = getArena2ImportManager() print manager.checkRequirements()
def main(*args): from addons.Arena2Importer.Arena2ImportLocator import getArena2ImportManager manager = getArena2ImportManager() messages = manager.checkRequirements() if messages != None: msgbox("\n".join(messages)) return dialog = manager.createImportDialog() dialog.showWindow("ARENA2 Importar accidentes")
def selfRegister(): manager = getArena2ImportManager() manager.addRuleFactory(DateLockRuleFactory()) #manager.addRuleFixer() manager.addRuleErrorCode( CODERR_VALUES_FECHA_CIERRE, u"%s - está fuera de la fecha de cierre" % CODERR_VALUES_FECHA_CIERRE ) manager.addReportAttribute("DATE_LOCK_CONSTRAINT",Date, size=40, label="Valor anterior a la fecha de cierre", isEditable=True)
def selfRegister(): valoresTitularidad = OrderedDict() valoresTitularidad[ TITULARIDAD_DESCONOCIDA] = "%s - Desconocida" % TITULARIDAD_DESCONOCIDA valoresTitularidad[ TITULARIDAD_ESTATAL] = "%s - Estatal" % TITULARIDAD_ESTATAL valoresTitularidad[ TITULARIDAD_AUTONOMICA] = "%s - Autonomica" % TITULARIDAD_AUTONOMICA valoresTitularidad[ TITULARIDAD_PROVINCIAL] = "%s - Provincial, Cabildo/Consell" % TITULARIDAD_PROVINCIAL valoresTitularidad[ TITULARIDAD_MUNICIPAL] = "%s - Municipal" % TITULARIDAD_MUNICIPAL valoresTitularidad[TITULARIDAD_OTRA] = "%s - Otra" % TITULARIDAD_OTRA manager = getArena2ImportManager() manager.addRuleFactory(OwnershipRuleFactory()) manager.addRuleFixer(SetOwnershipRuleFixer()) manager.addRuleErrorCode( CODERR_CARRETERAKM_NO_ENCONTRADA, "%s - Carretera/km no encontrada" % CODERR_CARRETERAKM_NO_ENCONTRADA) manager.addRuleErrorCode(CODERR_KM_NO_ENCONTRADO, "%s - km no encontrado" % CODERR_KM_NO_ENCONTRADO) manager.addRuleErrorCode( CODERR_TITULARIDADCARRETERAKM_NO_ENCONTRADA, "%s - Titularidad autonomica y carretera/km no encontrada" % CODERR_TITULARIDADCARRETERAKM_NO_ENCONTRADA) manager.addRuleErrorCode( CODERR_TITULARIDAD_INCORRECTA, "%s - Titularidad incorrecta" % CODERR_TITULARIDAD_INCORRECTA) manager.addRuleErrorCode( CODERR_TITULARIDAD_AUTONOMICA_SIN_CARETERA, "%s - Titularidad autonomica sin especificar carretera" % CODERR_TITULARIDAD_AUTONOMICA_SIN_CARETERA) manager.addReportAttribute("CARRETERA", String, size=45, label="Carretera") manager.addReportAttribute("PK", Integer, label="PK") manager.addReportAttribute("TITULARIDAD", Integer, size=10, label="Titularidad", isEditable=True, availableValues=valoresTitularidad) manager.addReportAttribute("TITULARIDAD_ACCIDENTE", Integer, size=10, label="Titularidad acc.", availableValues=valoresTitularidad) manager.addReportAttribute("TITULARIDAD_TRAMO", Integer, size=10, label="Titularidad tramo", availableValues=valoresTitularidad) manager.addReportAttribute("FECHA", String, size=45, label="Fecha") manager.addReportAttribute("PROVINCIA", String, size=45, label="Provincia")
def importData(self): manager = getArena2ImportManager() messages = manager.checkRequirements() if messages != None: msgbox("\n".join(messages)) return dialog = manager.createImportDialog() dialog.arena2filePicker.coerceAndSet( getResource(__file__, "..", "Arena2Reader", "datos", "test", "TV_03_2019_01_Q1", "victimas.xml")) dialog.showWindow("ARENA2 Importar accidentes")
def selfRegister(): manager = getArena2ImportManager() manager.addRuleFactory(PeatonesRuleFactory()) manager.addRuleFixer(AssignPeatonesFromTableFixer()) manager.addRuleErrorCode( CODERR_PEATONES_NO_COINCIDEN, "%s - Peatones no coinciden" % CODERR_PEATONES_NO_COINCIDEN) manager.addReportAttribute("TOTAL_PEATONES", Integer, size=10, label="Total Peatones", isEditable=True)
def selfRegister(): manager = getArena2ImportManager() manager.addRuleFactory(AvailableValuesRuleFactory()) #manager.addRuleFixer() manager.addRuleErrorCode( CODERR_VALUES_NO_DISPONIBLES, "%s - Valor no es un valor disponible del campo" % CODERR_VALUES_NO_DISPONIBLES) manager.addReportAttribute("FIELD_NO_AVAILABLE", String, size=120, label="Campo con valor no disponible", isEditable=True)
def selfRegister(): manager = getArena2ImportManager() manager.addRuleFactory(CountVehiclesRuleFactory()) manager.addRuleFixer(UpdateCountVehicles()) manager.addRuleErrorCode( CODERR_VEHICULOS_NO_COINCIDEN, "%s - Numero vehiculos no coinciden" % CODERR_VEHICULOS_NO_COINCIDEN) manager.addReportAttribute("NUM_TURISMOS", Integer, size=10, label="Turismos", isEditable=True) manager.addReportAttribute("NUM_FURGONETAS", Integer, size=10, label="Furgonetas", isEditable=True) manager.addReportAttribute("NUM_CAMIONES", Integer, size=10, label="Camiones", isEditable=True) manager.addReportAttribute("NUM_AUTOBUSES", Integer, size=10, label="Autobus", isEditable=True) manager.addReportAttribute("NUM_CICLOMOTORES", Integer, size=10, label="Ciclomotor", isEditable=True) manager.addReportAttribute("NUM_MOTOCICLETAS", Integer, size=10, label="Motocileta", isEditable=True) manager.addReportAttribute("NUM_BICICLETAS", Integer, size=10, label="Bicicleta", isEditable=True) manager.addReportAttribute("NUM_OTROS_VEHI", Integer, size=10, label="Otros Vehiculos", isEditable=True)
def selfRegister(): valoresTitularidad = OrderedDict() valoresTitularidad[0] = "0 - Desconocida" valoresTitularidad[1] = "1 - Estatal" valoresTitularidad[2] = "2 - Autonomica" valoresTitularidad[3] = "3 - Provincial, Cabildo/Consell" valoresTitularidad[4] = "4 - Municipal" valoresTitularidad[5] = "5 - Otra" manager = getArena2ImportManager() manager.addRuleFactory(OwnershipRuleFactory()) manager.addRuleFixer(SetOwnershipRuleFixer()) manager.addRuleErrorCode(100,"100 - Carretera/km no encontrada") manager.addRuleErrorCode(101,"101 - Titularidad autonomica y carretera/km no encontrada") manager.addRuleErrorCode(102,"102 - Titularidad incorrecta") manager.addReportAttribute("CARRETERA",String, size=45, label="Carretera") manager.addReportAttribute("PK",Integer, label="PK") manager.addReportAttribute("TITULARIDAD",Integer, size=10, label="Titularidad", isEditable=True, availableValues=valoresTitularidad) manager.addReportAttribute("TITULARIDAD_ACCIDENTE",Integer, size=10, label="Titularidad acc.", availableValues=valoresTitularidad) manager.addReportAttribute("TITULARIDAD_TRAMO",Integer, size=10, label="Titularidad tramo", availableValues=valoresTitularidad) manager.addReportAttribute("FECHA",String, size=45, label="Fecha") manager.addReportAttribute("PROVINCIA",String, size=45, label="Provincia")
def validateData(issues_pathname, workspaceName): status = LoggerTaskStatus("ValidateArena2DB") #issues_pathname = issues_pathname % slot #status.logger("validate slot %d/%d" % (slot, slots)) print "Printing" if not connectToWorkspace(workspaceName, status): print "out 1" return print "Printing 2" importManager = getArena2ImportManager() report = MyReport(importManager) report.setEnabledEvents(False) print "Checking access to database work space.." dataManager = DALLocator.getDataManager() workspace = dataManager.getDatabaseWorkspace('ARENA2_DB') if workspace==None: print "..out" status.logger("Can't access to workspace ARENA2_DB", gvsig.LOGGER_WARN) return print "PostValidating process.." p = PostValidatorProcess(importManager, report, workspace, status) print ".. preparing.." p.run() print ".. after run." if os.path.exists(issues_pathname): status.logger("removing file %r" % issues_pathname) os.unlink(issues_pathname) explorer = dataManager.openServerExplorer("FilesystemExplorer") store = report.getStore() status.logger("export issues to %r" % issues_pathname) import ntpath base = ntpath.basename(issues_pathname) #store.export(explorer,"CSV",explorer.getAddParameters(File(issues_pathname)), base) print "## DONE EXPORT"
def importData(self): manager = getArena2ImportManager() dialog = manager.createImportDialog() dialog.showWindow("Accidentes - Importar accidentes")
def testCreateTables(): manager = getArena2ImportManager() dialog = manager.createTablestDialog() dialog.showWindow("ARENA2 Crear tablas de accidentes")
def main(*args): p = ComprobarTitularidadPanel(getArena2ImportManager()) p.showWindow("Comprobar titularidad")
def createTables(self): manager = getArena2ImportManager() dialog = manager.createTablestDialog() dialog.showWindow("Accidentes - Crear tablas de accidentes")
def selfRegister(): manager = getArena2ImportManager() manager.addRuleFactory(ConflictRuleFactory()) manager.addRuleErrorCode( 200, "200 - Conflicto en CARRETERA/TIPO_VIA/KM/TITULARIDAD_VIA")
def selfRegister(): manager = getArena2ImportManager() manager.addTransformFactory(GeocodeTransformFactory()) manager.addRuleFactory(GeocodeRuleFactory()) manager.addRuleFixer(IgnoreGeocodeErrorAction()) manager.addRuleErrorCode(100, "100 - Carretera/km no encontrada")