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")
