- Observe-commits - mailman.cloud.codelutin.com

[Git][ultreiaio/ird-observe][develop] move metadata model to service sql and clean all API - See ultreiaio/topia-extension#112
by Tony CHEMIT (＠tchemit) 07 Mar '22

07 Mar '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: df53fa17 by Tony Chemit at 2022-03-07T14:05:24+01:00 move metadata model to service sql and clean all API - See ultreiaio/topia-extension#112 - - - - - 11 changed files: - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaApplicationContext.java - core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlCopyPlanModel.json - core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlDeletePlanModel.json - + core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlReplicatePlanModel.json - core/persistence/java/src/test/java/fr/ird/observe/spi/script/UpdateLastUpdateDateFieldScriptTest.java - core/persistence/java/src/test/java/fr/ird/observe/spi/script/UpdateLastUpdateDateTableScriptTest.java - core/persistence/test/src/main/java/fr/ird/observe/persistence/test/PersistenceTestSupportRead.java - core/persistence/test/src/main/java/fr/ird/observe/persistence/test/PersistenceTestSupportWrite.java - core/persistence/test/src/test/java/fr/ird/observe/persistence/test/DefinitionContentTest.java - core/persistence/test/src/test/java/fr/ird/observe/persistence/test/PersistenceModelWriteTest.java - core/persistence/test/src/test/java/fr/ird/observe/persistence/test/ValidationContentTest.java Changes: ===================================== core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaApplicationContext.java ===================================== @@ -40,14 +40,15 @@ import org.nuiton.topia.persistence.TopiaConfigurationExtension; import org.nuiton.topia.persistence.TopiaEntity; import org.nuiton.topia.persistence.TopiaIdFactory; import org.nuiton.topia.persistence.TopiaPersistenceContextConstructorParameterSupport; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModelPaths; import org.nuiton.topia.persistence.script.TopiaSqlScript; import org.nuiton.topia.service.migration.TopiaMigrationService; import org.nuiton.topia.service.sql.blob.TopiaEntitySqlBlobModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModelPaths; import org.nuiton.topia.service.sql.model.TopiaEntitySqlModel; import org.nuiton.topia.service.sql.plan.copy.TopiaEntitySqlCopyPlanModel; import org.nuiton.topia.service.sql.plan.delete.TopiaEntitySqlDeletePlanModel; +import org.nuiton.topia.service.sql.plan.replicate.TopiaEntitySqlReplicatePlanModel; import org.nuiton.topia.service.sql.request.CreateDatabaseRequest; import org.nuiton.topia.service.sql.usage.TopiaEntitySqlUsageModel; @@ -120,6 +121,11 @@ public class ObserveTopiaApplicationContext extends AbstractObserveTopiaApplicat return ObserveTopiaEntitySqlModelResource.get().getCopyPlanModel(); } + @Override + public TopiaEntitySqlReplicatePlanModel getReplicatePlanModel() { + return ObserveTopiaEntitySqlModelResource.get().getReplicatePlanModel(); + } + @Override public TopiaEntitySqlDeletePlanModel getDeletePlanModel() { return ObserveTopiaEntitySqlModelResource.get().getDeletePlanModel(); ===================================== core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlCopyPlanModel.json ===================================== The diff for this file was not included because it is too large. ===================================== core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlDeletePlanModel.json ===================================== @@ -1,5 +1,5 @@ { - "typeDeletePlans": { + "plans": { "fr.ird.observe.entities.data.ll.common.GearUseFeatures": [ "DELETE FROM ll_common.gearUseFeaturesMeasurement WHERE gearUseFeaturesMeasurement.gearUseFeatures %s;", "DELETE FROM ll_common.gearUseFeatures WHERE gearUseFeatures.topiaId %s;" ===================================== core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlReplicatePlanModel.json ===================================== @@ -0,0 +1,1476 @@ +{ + "plans": { + "fr.ird.observe.entities.data.ll.common.GearUseFeatures": [ + { + "gav": "ll_common.gearUseFeatures", + "selectedSql": "SELECT %s FROM ll_common.gearUseFeatures WHERE gearUseFeatures.topiaId %s", + "insertSql": "INSERT INTO ll_common.gearUseFeatures(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,gear,homeid,lastupdatedate,number,topiacreatedate,topiaversion,trip,usedintrip", + "entryPoint": true + }, + { + "gav": "ll_common.gearUseFeaturesMeasurement", + "selectedSql": "SELECT %s FROM ll_common.gearUseFeaturesMeasurement gearUseFeaturesMeasurement WHERE gearUseFeaturesMeasurement.gearUseFeatures %s", + "insertSql": "INSERT INTO ll_common.gearUseFeaturesMeasurement(%s) VALUES (%%s);", + "parentColumnName": "gearUseFeatures", + "columnNames": "topiaid,gearcharacteristic,gearusefeatures,homeid,lastupdatedate,measurementvalue,topiacreatedate,topiaversion" + } + ], + "fr.ird.observe.entities.data.ll.common.GearUseFeaturesMeasurement": [ + { + "gav": "ll_common.gearUseFeaturesMeasurement", + "selectedSql": "SELECT %s FROM ll_common.gearUseFeaturesMeasurement WHERE gearUseFeaturesMeasurement.topiaId %s", + "insertSql": "INSERT INTO ll_common.gearUseFeaturesMeasurement(%s) VALUES (%%s);", + "parentColumnName": "gearUseFeatures", + "columnNames": "topiaid,gearcharacteristic,gearusefeatures,homeid,lastupdatedate,measurementvalue,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.landing.Landing": [ + { + "gav": "ll_landing.landing", + "selectedSql": "SELECT %s FROM ll_landing.landing WHERE landing.topiaId %s", + "insertSql": "INSERT INTO ll_landing.landing(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,brokeragecompany,comment,datasource,enddate,harbour,homeid,lastupdatedate,person,processingcompany,shippingcompany,startdate,topiacreatedate,topiaversion,trip,vessel", + "entryPoint": true + }, + { + "gav": "ll_landing.landingPart", + "selectedSql": "SELECT %s FROM ll_landing.landingPart landingPart WHERE landingPart.landing %s", + "insertSql": "INSERT INTO ll_landing.landingPart(%s) VALUES (%%s);", + "parentColumnName": "landing", + "columnNames": "topiaid,categorymax,categorymin,conservation,count,dataquality,homeid,landing,lastupdatedate,onboardprocessing,species,topiacreatedate,topiaversion,weight,weightmeasuremethod" + } + ], + "fr.ird.observe.entities.data.ll.landing.LandingPart": [ + { + "gav": "ll_landing.landingPart", + "selectedSql": "SELECT %s FROM ll_landing.landingPart WHERE landingPart.topiaId %s", + "insertSql": "INSERT INTO ll_landing.landingPart(%s) VALUES (%%s);", + "parentColumnName": "landing", + "columnNames": "topiaid,categorymax,categorymin,conservation,count,dataquality,homeid,landing,lastupdatedate,onboardprocessing,species,topiacreatedate,topiaversion,weight,weightmeasuremethod", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.Activity": [ + { + "gav": "ll_logbook.set", + "selectedSql": "SELECT %s FROM ll_logbook.set set INNER JOIN ll_logbook.activity activity ON activity.set = set.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.set(%s) VALUES (%%s);", + "columnNames": "topiaid,basketlinelength,basketspersectioncount,branchlinesperbasketcount,comment,haulingbreaks,haulingdirectionsameassetting,haulingendlatitude,haulingendlongitude,haulingendtimestamp,haulingstartlatitude,haulingstartlongitude,haulingstarttimestamp,homeid,lastupdatedate,lengthbetweenbranchlines,lightstickscolor,lightsticksperbasketcount,lightstickstype,lightsticksused,linetype,maxdepthtargeted,monitored,number,settingendlatitude,settingendlongitude,settingendtimestamp,settingshape,settingstartlatitude,settingstartlongitude,settingstarttimestamp,settingvesselspeed,shooterspeed,shooterused,snapweight,swivelweight,timebetweenhooks,topiacreatedate,topiaversion,totalbasketscount,totalhookscount,totallightstickscount,totallinelength,totalsectionscount,weightedsnap,weightedswivel" + }, + { + "gav": "ll_logbook.sample", + "selectedSql": "SELECT %s FROM ll_logbook.sample sample INNER JOIN ll_logbook.activity activity ON activity.sample = sample.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.sample(%s) VALUES (%%s);", + "columnNames": "topiaid,comment,homeid,lastupdatedate,latitude,longitude,timestamp,topiacreatedate,topiaversion,trip" + }, + { + "gav": "ll_logbook.activity", + "selectedSql": "SELECT %s FROM ll_logbook.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.activity(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,currentdirection,currentspeed,dataquality,endtimestamp,fpazone,homeid,lastupdatedate,latitude,longitude,relatedobservedactivity,sample,seasurfacetemperature,set,starttimestamp,topiacreatedate,topiaversion,trip,vesselactivity,wind,winddirection", + "columnsToReplace": "set,sample", + "columnsToDetach": "relatedObservedActivity~ll_observation.activity", + "entryPoint": true + }, + { + "gav": "ll_logbook.baitsComposition", + "selectedSql": "SELECT %s FROM ll_logbook.baitsComposition baitsComposition INNER JOIN ll_logbook.activity activity ON activity.set = baitsComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.branchlinesComposition branchlinesComposition INNER JOIN ll_logbook.activity activity ON activity.set = branchlinesComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype" + }, + { + "gav": "ll_logbook.catch", + "selectedSql": "SELECT %s FROM ll_logbook.catch catch INNER JOIN ll_logbook.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,beatdiameter,catchfate,catchhealthstatus,comment,count,countdepredated,depredated,depredatedproportion,discardhealthstatus,homeid,hookwhendiscarded,lastupdatedate,number,onboardprocessing,photoreferences,set,set_idx,species,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ll_logbook.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.floatlinesComposition floatlinesComposition INNER JOIN ll_logbook.activity activity ON activity.set = floatlinesComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.hooksComposition", + "selectedSql": "SELECT %s FROM ll_logbook.hooksComposition hooksComposition INNER JOIN ll_logbook.activity activity ON activity.set = hooksComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.samplePart", + "selectedSql": "SELECT %s FROM ll_logbook.samplePart samplePart INNER JOIN ll_logbook.activity activity ON activity.sample = samplePart.sample WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.samplePart(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,lastupdatedate,length,lengthmeasuremethod,sample,sample_idx,sex,sizemeasuretype,species,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + }, + { + "gav": "ll_logbook.set_mitigationtype", + "selectedSql": "SELECT %s FROM ll_logbook.set set INNER JOIN ll_logbook.activity activity ON activity.set = set.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.set_mitigationtype(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "mitigationtype,set", + "columnsToReplace": "set" + }, + { + "gav": "ll_logbook.catch_predator", + "selectedSql": "SELECT %s FROM ll_logbook.catch catch INNER JOIN ll_logbook.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.logbook.BaitsComposition": [ + { + "gav": "ll_logbook.baitsComposition", + "selectedSql": "SELECT %s FROM ll_logbook.baitsComposition WHERE baitsComposition.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.BranchlinesComposition": [ + { + "gav": "ll_logbook.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.branchlinesComposition WHERE branchlinesComposition.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.Catch": [ + { + "gav": "ll_logbook.catch", + "selectedSql": "SELECT %s FROM ll_logbook.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,beatdiameter,catchfate,catchhealthstatus,comment,count,countdepredated,depredated,depredatedproportion,discardhealthstatus,homeid,hookwhendiscarded,lastupdatedate,number,onboardprocessing,photoreferences,set,set_idx,species,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "entryPoint": true + }, + { + "gav": "ll_logbook.catch_predator", + "selectedSql": "SELECT %s FROM ll_logbook.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.logbook.FloatlinesComposition": [ + { + "gav": "ll_logbook.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.floatlinesComposition WHERE floatlinesComposition.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.HooksComposition": [ + { + "gav": "ll_logbook.hooksComposition", + "selectedSql": "SELECT %s FROM ll_logbook.hooksComposition WHERE hooksComposition.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.Sample": [ + { + "gav": "ll_logbook.sample", + "selectedSql": "SELECT %s FROM ll_logbook.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.sample(%s) VALUES (%%s);", + "updateReverseAssociationSql": "UPDATE ll_logbook.activity activity SET activity.sample = '%s' WHERE activity.topiaId = '%'", + "columnNames": "topiaid,comment,homeid,lastupdatedate,latitude,longitude,timestamp,topiacreatedate,topiaversion,trip", + "entryPoint": true + }, + { + "gav": "ll_logbook.samplePart", + "selectedSql": "SELECT %s FROM ll_logbook.samplePart samplePart WHERE samplePart.sample %s", + "insertSql": "INSERT INTO ll_logbook.samplePart(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,lastupdatedate,length,lengthmeasuremethod,sample,sample_idx,sex,sizemeasuretype,species,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + } + ], + "fr.ird.observe.entities.data.ll.logbook.SamplePart": [ + { + "gav": "ll_logbook.samplePart", + "selectedSql": "SELECT %s FROM ll_logbook.samplePart WHERE samplePart.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.samplePart(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,lastupdatedate,length,lengthmeasuremethod,sample,sample_idx,sex,sizemeasuretype,species,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.logbook.Set": [ + { + "gav": "ll_logbook.set", + "selectedSql": "SELECT %s FROM ll_logbook.set WHERE set.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.set(%s) VALUES (%%s);", + "updateReverseAssociationSql": "UPDATE ll_logbook.activity activity SET activity.set = '%s' WHERE activity.topiaId = '%'", + "columnNames": "topiaid,basketlinelength,basketspersectioncount,branchlinesperbasketcount,comment,haulingbreaks,haulingdirectionsameassetting,haulingendlatitude,haulingendlongitude,haulingendtimestamp,haulingstartlatitude,haulingstartlongitude,haulingstarttimestamp,homeid,lastupdatedate,lengthbetweenbranchlines,lightstickscolor,lightsticksperbasketcount,lightstickstype,lightsticksused,linetype,maxdepthtargeted,monitored,number,settingendlatitude,settingendlongitude,settingendtimestamp,settingshape,settingstartlatitude,settingstartlongitude,settingstarttimestamp,settingvesselspeed,shooterspeed,shooterused,snapweight,swivelweight,timebetweenhooks,topiacreatedate,topiaversion,totalbasketscount,totalhookscount,totallightstickscount,totallinelength,totalsectionscount,weightedsnap,weightedswivel", + "entryPoint": true + }, + { + "gav": "ll_logbook.baitsComposition", + "selectedSql": "SELECT %s FROM ll_logbook.baitsComposition baitsComposition WHERE baitsComposition.set %s", + "insertSql": "INSERT INTO ll_logbook.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.branchlinesComposition branchlinesComposition WHERE branchlinesComposition.set %s", + "insertSql": "INSERT INTO ll_logbook.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype" + }, + { + "gav": "ll_logbook.catch", + "selectedSql": "SELECT %s FROM ll_logbook.catch catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,beatdiameter,catchfate,catchhealthstatus,comment,count,countdepredated,depredated,depredatedproportion,discardhealthstatus,homeid,hookwhendiscarded,lastupdatedate,number,onboardprocessing,photoreferences,set,set_idx,species,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ll_logbook.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_logbook.floatlinesComposition floatlinesComposition WHERE floatlinesComposition.set %s", + "insertSql": "INSERT INTO ll_logbook.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.hooksComposition", + "selectedSql": "SELECT %s FROM ll_logbook.hooksComposition hooksComposition WHERE hooksComposition.set %s", + "insertSql": "INSERT INTO ll_logbook.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_logbook.set_mitigationtype", + "selectedSql": "SELECT %s FROM ll_logbook.set WHERE set.topiaId %s", + "insertSql": "INSERT INTO ll_logbook.set_mitigationtype(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "mitigationtype,set", + "columnsToReplace": "set" + }, + { + "gav": "ll_logbook.catch_predator", + "selectedSql": "SELECT %s FROM ll_logbook.catch catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_logbook.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.observation.Activity": [ + { + "gav": "ll_observation.set", + "selectedSql": "SELECT %s FROM ll_observation.set set INNER JOIN ll_observation.activity activity ON activity.set = set.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.set(%s) VALUES (%%s);", + "columnNames": "topiaid,basketspersectioncount,branchlinesperbasketcount,comment,haulingbreaks,haulingdirectionsameassetting,haulingendlatitude,haulingendlongitude,haulingendtimestamp,haulingstartlatitude,haulingstartlongitude,haulingstarttimestamp,homeid,lastupdatedate,lightstickscolor,lightsticksperbasketcount,lightstickstype,linetype,maxdepthtargeted,monitored,number,settingendlatitude,settingendlongitude,settingendtimestamp,settingshape,settingstartlatitude,settingstartlongitude,settingstarttimestamp,settingvesselspeed,shooterspeed,shooterused,snapweight,swivelweight,timebetweenhooks,topiacreatedate,topiaversion,totalbasketscount,totalhookscount,totalsectionscount,weightedsnap,weightedswivel" + }, + { + "gav": "ll_observation.activity", + "selectedSql": "SELECT %s FROM ll_observation.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.activity(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,dataquality,fpazone,homeid,lastupdatedate,latitude,longitude,seasurfacetemperature,set,timestamp,topiacreatedate,topiaversion,trip,vesselactivity", + "columnsToReplace": "set", + "entryPoint": true + }, + { + "gav": "ll_observation.encounter", + "selectedSql": "SELECT %s FROM ll_observation.encounter encounter WHERE encounter.activity %s", + "insertSql": "INSERT INTO ll_observation.encounter(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,count,distance,encountertype,homeid,lastupdatedate,species,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.sensorUsed", + "selectedSql": "SELECT %s FROM ll_observation.sensorUsed sensorUsed WHERE sensorUsed.activity %s", + "insertSql": "INSERT INTO ll_observation.sensorUsed(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,data,datafilename,datalocation,homeid,lastupdatedate,sensorbrand,sensordataformat,sensorserialno,sensortype,topiacreatedate,topiaversion", + "useBlob": true + }, + { + "gav": "ll_observation.baitsComposition", + "selectedSql": "SELECT %s FROM ll_observation.baitsComposition baitsComposition INNER JOIN ll_observation.activity activity ON activity.set = baitsComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.branchlinesComposition branchlinesComposition INNER JOIN ll_observation.activity activity ON activity.set = branchlinesComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype" + }, + { + "gav": "ll_observation.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.floatlinesComposition floatlinesComposition INNER JOIN ll_observation.activity activity ON activity.set = floatlinesComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.hooksComposition", + "selectedSql": "SELECT %s FROM ll_observation.hooksComposition hooksComposition INNER JOIN ll_observation.activity activity ON activity.set = hooksComposition.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.section", + "selectedSql": "SELECT %s FROM ll_observation.section section INNER JOIN ll_observation.activity activity ON activity.set = section.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.section(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,haulingidentifier,homeid,lastupdatedate,set,settingidentifier,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.basket", + "selectedSql": "SELECT %s FROM ll_observation.basket basket INNER JOIN ll_observation.section section ON section.topiaId = basket.section INNER JOIN ll_observation.activity activity ON activity.set = section.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.basket(%s) VALUES (%%s);", + "parentColumnName": "section", + "columnNames": "topiaid,floatline1length,floatline2length,haulingidentifier,homeid,lastupdatedate,section,settingidentifier,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.branchline", + "selectedSql": "SELECT %s FROM ll_observation.branchline branchline INNER JOIN ll_observation.basket basket ON basket.topiaId = branchline.basket INNER JOIN ll_observation.section section ON section.topiaId = basket.section INNER JOIN ll_observation.activity activity ON activity.set = section.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.branchline(%s) VALUES (%%s);", + "parentColumnName": "basket", + "columnNames": "topiaid,baithaulingstatus,baitsettingstatus,baittype,basket,branchlinelength,comment,depthrecorder,haulingidentifier,homeid,hooklost,hookoffset,hooksize,hooktype,lastupdatedate,settingidentifier,snapweight,swivelweight,timer,timertimeonboard,timesincecontact,topiacreatedate,topiaversion,toptype,tracecutoff,tracelinelength,tracelinetype,weightedsnap,weightedswivel" + }, + { + "gav": "ll_observation.tdr", + "selectedSql": "SELECT %s FROM ll_observation.tdr tdr INNER JOIN ll_observation.activity activity ON activity.set = tdr.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.tdr(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,basket,branchline,data,datafilename,datalocation,deploymentend,deploymentstart,fishingend,fishingenddepth,fishingstart,fishingstartdepth,floatline1length,floatline2length,homeid,itemhorizontalposition,itemverticalposition,lastupdatedate,maxfishingdepth,meandeploymentdepth,meanfishingdepth,mediandeploymentdepth,medianfishingdepth,minfishingdepth,section,sensorbrand,serialno,set,topiacreatedate,topiaversion", + "columnsToReplace": "section,basket,branchline", + "useBlob": true + }, + { + "gav": "ll_observation.catch", + "selectedSql": "SELECT %s FROM ll_observation.catch catch INNER JOIN ll_observation.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,basket,beatdiameter,branchline,catchfate,catchhealthstatus,comment,count,depredated,discardhealthstatus,gonadeweight,homeid,hookposition,hookwhendiscarded,lastupdatedate,maturitystatus,number,photoreferences,section,set,set_idx,sex,species,stomachfullness,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "columnsToReplace": "section,basket,branchline" + }, + { + "gav": "ll_observation.sizeMeasure", + "selectedSql": "SELECT %s FROM ll_observation.sizeMeasure sizeMeasure INNER JOIN ll_observation.catch catch ON catch.topiaId = sizeMeasure.catch INNER JOIN ll_observation.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.sizeMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,size,sizemeasuretype,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.weightMeasure", + "selectedSql": "SELECT %s FROM ll_observation.weightMeasure weightMeasure INNER JOIN ll_observation.catch catch ON catch.topiaId = weightMeasure.catch INNER JOIN ll_observation.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.weightMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,topiacreatedate,topiaversion,weight,weightmeasuretype" + }, + { + "gav": "ll_observation.set_mitigationtype", + "selectedSql": "SELECT %s FROM ll_observation.set set INNER JOIN ll_observation.activity activity ON activity.set = set.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.set_mitigationtype(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "mitigationtype,set", + "columnsToReplace": "set" + }, + { + "gav": "ll_observation.tdr_species", + "selectedSql": "SELECT %s FROM ll_observation.tdr tdr INNER JOIN ll_observation.activity activity ON activity.set = tdr.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.tdr_species(%s) VALUES (%%s);", + "parentColumnName": "tdr", + "columnNames": "species,tdr", + "columnsToReplace": "tdr" + }, + { + "gav": "ll_observation.catch_predator", + "selectedSql": "SELECT %s FROM ll_observation.catch catch INNER JOIN ll_observation.activity activity ON activity.set = catch.set WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ll_observation.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.observation.BaitsComposition": [ + { + "gav": "ll_observation.baitsComposition", + "selectedSql": "SELECT %s FROM ll_observation.baitsComposition WHERE baitsComposition.topiaId %s", + "insertSql": "INSERT INTO ll_observation.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.Basket": [ + { + "gav": "ll_observation.basket", + "selectedSql": "SELECT %s FROM ll_observation.basket WHERE basket.topiaId %s", + "insertSql": "INSERT INTO ll_observation.basket(%s) VALUES (%%s);", + "parentColumnName": "section", + "columnNames": "topiaid,floatline1length,floatline2length,haulingidentifier,homeid,lastupdatedate,section,settingidentifier,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ll_observation.branchline", + "selectedSql": "SELECT %s FROM ll_observation.branchline branchline WHERE branchline.basket %s", + "insertSql": "INSERT INTO ll_observation.branchline(%s) VALUES (%%s);", + "parentColumnName": "basket", + "columnNames": "topiaid,baithaulingstatus,baitsettingstatus,baittype,basket,branchlinelength,comment,depthrecorder,haulingidentifier,homeid,hooklost,hookoffset,hooksize,hooktype,lastupdatedate,settingidentifier,snapweight,swivelweight,timer,timertimeonboard,timesincecontact,topiacreatedate,topiaversion,toptype,tracecutoff,tracelinelength,tracelinetype,weightedsnap,weightedswivel" + } + ], + "fr.ird.observe.entities.data.ll.observation.Branchline": [ + { + "gav": "ll_observation.branchline", + "selectedSql": "SELECT %s FROM ll_observation.branchline WHERE branchline.topiaId %s", + "insertSql": "INSERT INTO ll_observation.branchline(%s) VALUES (%%s);", + "parentColumnName": "basket", + "columnNames": "topiaid,baithaulingstatus,baitsettingstatus,baittype,basket,branchlinelength,comment,depthrecorder,haulingidentifier,homeid,hooklost,hookoffset,hooksize,hooktype,lastupdatedate,settingidentifier,snapweight,swivelweight,timer,timertimeonboard,timesincecontact,topiacreatedate,topiaversion,toptype,tracecutoff,tracelinelength,tracelinetype,weightedsnap,weightedswivel", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.BranchlinesComposition": [ + { + "gav": "ll_observation.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.branchlinesComposition WHERE branchlinesComposition.topiaId %s", + "insertSql": "INSERT INTO ll_observation.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.Catch": [ + { + "gav": "ll_observation.catch", + "selectedSql": "SELECT %s FROM ll_observation.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ll_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,basket,beatdiameter,branchline,catchfate,catchhealthstatus,comment,count,depredated,discardhealthstatus,gonadeweight,homeid,hookposition,hookwhendiscarded,lastupdatedate,maturitystatus,number,photoreferences,section,set,set_idx,sex,species,stomachfullness,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "columnsToDetach": "section~ll_observation.section,basket~ll_observation.basket,branchline~ll_observation.branchline", + "entryPoint": true + }, + { + "gav": "ll_observation.sizeMeasure", + "selectedSql": "SELECT %s FROM ll_observation.sizeMeasure sizeMeasure WHERE sizeMeasure.catch %s", + "insertSql": "INSERT INTO ll_observation.sizeMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,size,sizemeasuretype,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.weightMeasure", + "selectedSql": "SELECT %s FROM ll_observation.weightMeasure weightMeasure WHERE weightMeasure.catch %s", + "insertSql": "INSERT INTO ll_observation.weightMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,topiacreatedate,topiaversion,weight,weightmeasuretype" + }, + { + "gav": "ll_observation.catch_predator", + "selectedSql": "SELECT %s FROM ll_observation.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ll_observation.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.observation.Encounter": [ + { + "gav": "ll_observation.encounter", + "selectedSql": "SELECT %s FROM ll_observation.encounter WHERE encounter.topiaId %s", + "insertSql": "INSERT INTO ll_observation.encounter(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,count,distance,encountertype,homeid,lastupdatedate,species,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.FloatlinesComposition": [ + { + "gav": "ll_observation.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.floatlinesComposition WHERE floatlinesComposition.topiaId %s", + "insertSql": "INSERT INTO ll_observation.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.HooksComposition": [ + { + "gav": "ll_observation.hooksComposition", + "selectedSql": "SELECT %s FROM ll_observation.hooksComposition WHERE hooksComposition.topiaId %s", + "insertSql": "INSERT INTO ll_observation.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.Section": [ + { + "gav": "ll_observation.section", + "selectedSql": "SELECT %s FROM ll_observation.section WHERE section.topiaId %s", + "insertSql": "INSERT INTO ll_observation.section(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,haulingidentifier,homeid,lastupdatedate,set,settingidentifier,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ll_observation.basket", + "selectedSql": "SELECT %s FROM ll_observation.basket basket WHERE basket.section %s", + "insertSql": "INSERT INTO ll_observation.basket(%s) VALUES (%%s);", + "parentColumnName": "section", + "columnNames": "topiaid,floatline1length,floatline2length,haulingidentifier,homeid,lastupdatedate,section,settingidentifier,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.branchline", + "selectedSql": "SELECT %s FROM ll_observation.branchline branchline INNER JOIN ll_observation.basket basket ON basket.topiaId = branchline.basket WHERE basket.section %s", + "insertSql": "INSERT INTO ll_observation.branchline(%s) VALUES (%%s);", + "parentColumnName": "basket", + "columnNames": "topiaid,baithaulingstatus,baitsettingstatus,baittype,basket,branchlinelength,comment,depthrecorder,haulingidentifier,homeid,hooklost,hookoffset,hooksize,hooktype,lastupdatedate,settingidentifier,snapweight,swivelweight,timer,timertimeonboard,timesincecontact,topiacreatedate,topiaversion,toptype,tracecutoff,tracelinelength,tracelinetype,weightedsnap,weightedswivel" + } + ], + "fr.ird.observe.entities.data.ll.observation.SensorUsed": [ + { + "gav": "ll_observation.sensorUsed", + "selectedSql": "SELECT %s FROM ll_observation.sensorUsed WHERE sensorUsed.topiaId %s", + "insertSql": "INSERT INTO ll_observation.sensorUsed(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,data,datafilename,datalocation,homeid,lastupdatedate,sensorbrand,sensordataformat,sensorserialno,sensortype,topiacreatedate,topiaversion", + "useBlob": true, + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.Set": [ + { + "gav": "ll_observation.set", + "selectedSql": "SELECT %s FROM ll_observation.set WHERE set.topiaId %s", + "insertSql": "INSERT INTO ll_observation.set(%s) VALUES (%%s);", + "updateReverseAssociationSql": "UPDATE ll_observation.activity activity SET activity.set = '%s' WHERE activity.topiaId = '%'", + "columnNames": "topiaid,basketspersectioncount,branchlinesperbasketcount,comment,haulingbreaks,haulingdirectionsameassetting,haulingendlatitude,haulingendlongitude,haulingendtimestamp,haulingstartlatitude,haulingstartlongitude,haulingstarttimestamp,homeid,lastupdatedate,lightstickscolor,lightsticksperbasketcount,lightstickstype,linetype,maxdepthtargeted,monitored,number,settingendlatitude,settingendlongitude,settingendtimestamp,settingshape,settingstartlatitude,settingstartlongitude,settingstarttimestamp,settingvesselspeed,shooterspeed,shooterused,snapweight,swivelweight,timebetweenhooks,topiacreatedate,topiaversion,totalbasketscount,totalhookscount,totalsectionscount,weightedsnap,weightedswivel", + "entryPoint": true + }, + { + "gav": "ll_observation.baitsComposition", + "selectedSql": "SELECT %s FROM ll_observation.baitsComposition baitsComposition WHERE baitsComposition.set %s", + "insertSql": "INSERT INTO ll_observation.baitsComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,baitsettingstatus,baittype,homeid,individualsize,individualweight,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.branchlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.branchlinesComposition branchlinesComposition WHERE branchlinesComposition.set %s", + "insertSql": "INSERT INTO ll_observation.branchlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,proportion,set,topiacreatedate,topiaversion,toptype,tracelinelength,tracelinetype" + }, + { + "gav": "ll_observation.floatlinesComposition", + "selectedSql": "SELECT %s FROM ll_observation.floatlinesComposition floatlinesComposition WHERE floatlinesComposition.set %s", + "insertSql": "INSERT INTO ll_observation.floatlinesComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,length,linetype,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.hooksComposition", + "selectedSql": "SELECT %s FROM ll_observation.hooksComposition hooksComposition WHERE hooksComposition.set %s", + "insertSql": "INSERT INTO ll_observation.hooksComposition(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,hookoffset,hooksize,hooktype,lastupdatedate,proportion,set,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.section", + "selectedSql": "SELECT %s FROM ll_observation.section section WHERE section.set %s", + "insertSql": "INSERT INTO ll_observation.section(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,haulingidentifier,homeid,lastupdatedate,set,settingidentifier,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.basket", + "selectedSql": "SELECT %s FROM ll_observation.basket basket INNER JOIN ll_observation.section section ON section.topiaId = basket.section WHERE section.set %s", + "insertSql": "INSERT INTO ll_observation.basket(%s) VALUES (%%s);", + "parentColumnName": "section", + "columnNames": "topiaid,floatline1length,floatline2length,haulingidentifier,homeid,lastupdatedate,section,settingidentifier,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.branchline", + "selectedSql": "SELECT %s FROM ll_observation.branchline branchline INNER JOIN ll_observation.basket basket ON basket.topiaId = branchline.basket INNER JOIN ll_observation.section section ON section.topiaId = basket.section WHERE section.set %s", + "insertSql": "INSERT INTO ll_observation.branchline(%s) VALUES (%%s);", + "parentColumnName": "basket", + "columnNames": "topiaid,baithaulingstatus,baitsettingstatus,baittype,basket,branchlinelength,comment,depthrecorder,haulingidentifier,homeid,hooklost,hookoffset,hooksize,hooktype,lastupdatedate,settingidentifier,snapweight,swivelweight,timer,timertimeonboard,timesincecontact,topiacreatedate,topiaversion,toptype,tracecutoff,tracelinelength,tracelinetype,weightedsnap,weightedswivel" + }, + { + "gav": "ll_observation.tdr", + "selectedSql": "SELECT %s FROM ll_observation.tdr tdr WHERE tdr.set %s", + "insertSql": "INSERT INTO ll_observation.tdr(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,basket,branchline,data,datafilename,datalocation,deploymentend,deploymentstart,fishingend,fishingenddepth,fishingstart,fishingstartdepth,floatline1length,floatline2length,homeid,itemhorizontalposition,itemverticalposition,lastupdatedate,maxfishingdepth,meandeploymentdepth,meanfishingdepth,mediandeploymentdepth,medianfishingdepth,minfishingdepth,section,sensorbrand,serialno,set,topiacreatedate,topiaversion", + "columnsToReplace": "section,basket,branchline", + "useBlob": true + }, + { + "gav": "ll_observation.catch", + "selectedSql": "SELECT %s FROM ll_observation.catch catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,basket,beatdiameter,branchline,catchfate,catchhealthstatus,comment,count,depredated,discardhealthstatus,gonadeweight,homeid,hookposition,hookwhendiscarded,lastupdatedate,maturitystatus,number,photoreferences,section,set,set_idx,sex,species,stomachfullness,tagnumber,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "columnsToReplace": "section,basket,branchline" + }, + { + "gav": "ll_observation.sizeMeasure", + "selectedSql": "SELECT %s FROM ll_observation.sizeMeasure sizeMeasure INNER JOIN ll_observation.catch catch ON catch.topiaId = sizeMeasure.catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_observation.sizeMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,size,sizemeasuretype,topiacreatedate,topiaversion" + }, + { + "gav": "ll_observation.weightMeasure", + "selectedSql": "SELECT %s FROM ll_observation.weightMeasure weightMeasure INNER JOIN ll_observation.catch catch ON catch.topiaId = weightMeasure.catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_observation.weightMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,topiacreatedate,topiaversion,weight,weightmeasuretype" + }, + { + "gav": "ll_observation.set_mitigationtype", + "selectedSql": "SELECT %s FROM ll_observation.set WHERE set.topiaId %s", + "insertSql": "INSERT INTO ll_observation.set_mitigationtype(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "mitigationtype,set", + "columnsToReplace": "set" + }, + { + "gav": "ll_observation.tdr_species", + "selectedSql": "SELECT %s FROM ll_observation.tdr tdr WHERE tdr.set %s", + "insertSql": "INSERT INTO ll_observation.tdr_species(%s) VALUES (%%s);", + "parentColumnName": "tdr", + "columnNames": "species,tdr", + "columnsToReplace": "tdr" + }, + { + "gav": "ll_observation.catch_predator", + "selectedSql": "SELECT %s FROM ll_observation.catch catch WHERE catch.set %s", + "insertSql": "INSERT INTO ll_observation.catch_predator(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "catch,species", + "columnsToReplace": "catch" + } + ], + "fr.ird.observe.entities.data.ll.observation.SizeMeasure": [ + { + "gav": "ll_observation.sizeMeasure", + "selectedSql": "SELECT %s FROM ll_observation.sizeMeasure WHERE sizeMeasure.topiaId %s", + "insertSql": "INSERT INTO ll_observation.sizeMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,size,sizemeasuretype,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ll.observation.Tdr": [ + { + "gav": "ll_observation.tdr", + "selectedSql": "SELECT %s FROM ll_observation.tdr WHERE tdr.topiaId %s", + "insertSql": "INSERT INTO ll_observation.tdr(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,basket,branchline,data,datafilename,datalocation,deploymentend,deploymentstart,fishingend,fishingenddepth,fishingstart,fishingstartdepth,floatline1length,floatline2length,homeid,itemhorizontalposition,itemverticalposition,lastupdatedate,maxfishingdepth,meandeploymentdepth,meanfishingdepth,mediandeploymentdepth,medianfishingdepth,minfishingdepth,section,sensorbrand,serialno,set,topiacreatedate,topiaversion", + "columnsToDetach": "section~ll_observation.section,basket~ll_observation.basket,branchline~ll_observation.branchline", + "useBlob": true, + "entryPoint": true + }, + { + "gav": "ll_observation.tdr_species", + "selectedSql": "SELECT %s FROM ll_observation.tdr WHERE tdr.topiaId %s", + "insertSql": "INSERT INTO ll_observation.tdr_species(%s) VALUES (%%s);", + "parentColumnName": "tdr", + "columnNames": "species,tdr", + "columnsToReplace": "tdr" + } + ], + "fr.ird.observe.entities.data.ll.observation.WeightMeasure": [ + { + "gav": "ll_observation.weightMeasure", + "selectedSql": "SELECT %s FROM ll_observation.weightMeasure WHERE weightMeasure.topiaId %s", + "insertSql": "INSERT INTO ll_observation.weightMeasure(%s) VALUES (%%s);", + "parentColumnName": "catch", + "columnNames": "topiaid,catch,homeid,lastupdatedate,topiacreatedate,topiaversion,weight,weightmeasuretype", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.common.GearUseFeatures": [ + { + "gav": "ps_common.gearUseFeatures", + "selectedSql": "SELECT %s FROM ps_common.gearUseFeatures WHERE gearUseFeatures.topiaId %s", + "insertSql": "INSERT INTO ps_common.gearUseFeatures(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,gear,homeid,lastupdatedate,number,topiacreatedate,topiaversion,trip,usedintrip", + "entryPoint": true + }, + { + "gav": "ps_common.gearUseFeaturesMeasurement", + "selectedSql": "SELECT %s FROM ps_common.gearUseFeaturesMeasurement gearUseFeaturesMeasurement WHERE gearUseFeaturesMeasurement.gearUseFeatures %s", + "insertSql": "INSERT INTO ps_common.gearUseFeaturesMeasurement(%s) VALUES (%%s);", + "parentColumnName": "gearUseFeatures", + "columnNames": "topiaid,gearcharacteristic,gearusefeatures,homeid,lastupdatedate,measurementvalue,topiacreatedate,topiaversion" + } + ], + "fr.ird.observe.entities.data.ps.common.GearUseFeaturesMeasurement": [ + { + "gav": "ps_common.gearUseFeaturesMeasurement", + "selectedSql": "SELECT %s FROM ps_common.gearUseFeaturesMeasurement WHERE gearUseFeaturesMeasurement.topiaId %s", + "insertSql": "INSERT INTO ps_common.gearUseFeaturesMeasurement(%s) VALUES (%%s);", + "parentColumnName": "gearUseFeatures", + "columnNames": "topiaid,gearcharacteristic,gearusefeatures,homeid,lastupdatedate,measurementvalue,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.landing.Landing": [ + { + "gav": "ps_landing.landing", + "selectedSql": "SELECT %s FROM ps_landing.landing WHERE landing.topiaId %s", + "insertSql": "INSERT INTO ps_landing.landing(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,date,destination,fate,fatevessel,homeid,lastupdatedate,species,topiacreatedate,topiaversion,trip,trip_idx,weight,weightcategory", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.localmarket.Batch": [ + { + "gav": "ps_localmarket.batch", + "selectedSql": "SELECT %s FROM ps_localmarket.batch WHERE batch.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.batch(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,count,date,homeid,lastupdatedate,origin,packaging,species,survey,topiacreatedate,topiaversion,trip,weight,weightcomputedsource", + "columnsToDetach": "survey~ps_localmarket.survey", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.localmarket.Sample": [ + { + "gav": "ps_localmarket.sample", + "selectedSql": "SELECT %s FROM ps_localmarket.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.sample(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,date,homeid,lastupdatedate,number,sampletype,topiacreatedate,topiaversion,trip", + "entryPoint": true + }, + { + "gav": "ps_localmarket.sampleSpecies", + "selectedSql": "SELECT %s FROM ps_localmarket.sampleSpecies sampleSpecies WHERE sampleSpecies.sample %s", + "insertSql": "INSERT INTO ps_localmarket.sampleSpecies(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,comment,homeid,lastupdatedate,measuredcount,sample,sizemeasuretype,species,topiacreatedate,topiaversion" + }, + { + "gav": "ps_localmarket.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_localmarket.sampleSpeciesMeasure sampleSpeciesMeasure INNER JOIN ps_localmarket.sampleSpecies sampleSpecies ON sampleSpecies.topiaId = sampleSpeciesMeasure.sampleSpecies WHERE sampleSpecies.sample %s", + "insertSql": "INSERT INTO ps_localmarket.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion" + }, + { + "gav": "ps_localmarket.sample_well", + "selectedSql": "SELECT %s FROM ps_localmarket.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.sample_well(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "sample,well", + "columnsToReplace": "sample" + } + ], + "fr.ird.observe.entities.data.ps.localmarket.SampleSpecies": [ + { + "gav": "ps_localmarket.sampleSpecies", + "selectedSql": "SELECT %s FROM ps_localmarket.sampleSpecies WHERE sampleSpecies.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.sampleSpecies(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,comment,homeid,lastupdatedate,measuredcount,sample,sizemeasuretype,species,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ps_localmarket.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_localmarket.sampleSpeciesMeasure sampleSpeciesMeasure WHERE sampleSpeciesMeasure.sampleSpecies %s", + "insertSql": "INSERT INTO ps_localmarket.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion" + } + ], + "fr.ird.observe.entities.data.ps.localmarket.SampleSpeciesMeasure": [ + { + "gav": "ps_localmarket.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_localmarket.sampleSpeciesMeasure WHERE sampleSpeciesMeasure.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.localmarket.Survey": [ + { + "gav": "ps_localmarket.survey", + "selectedSql": "SELECT %s FROM ps_localmarket.survey WHERE survey.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.survey(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,date,homeid,lastupdatedate,number,topiacreatedate,topiaversion,trip", + "entryPoint": true + }, + { + "gav": "ps_localmarket.surveyPart", + "selectedSql": "SELECT %s FROM ps_localmarket.surveyPart surveyPart WHERE surveyPart.survey %s", + "insertSql": "INSERT INTO ps_localmarket.surveyPart(%s) VALUES (%%s);", + "parentColumnName": "survey", + "columnNames": "topiaid,homeid,lastupdatedate,proportion,species,survey,topiacreatedate,topiaversion" + } + ], + "fr.ird.observe.entities.data.ps.localmarket.SurveyPart": [ + { + "gav": "ps_localmarket.surveyPart", + "selectedSql": "SELECT %s FROM ps_localmarket.surveyPart WHERE surveyPart.topiaId %s", + "insertSql": "INSERT INTO ps_localmarket.surveyPart(%s) VALUES (%%s);", + "parentColumnName": "survey", + "columnNames": "topiaid,homeid,lastupdatedate,proportion,species,survey,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.Activity": [ + { + "gav": "ps_logbook.activity", + "selectedSql": "SELECT %s FROM ps_logbook.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.activity(%s) VALUES (%%s);", + "parentColumnName": "route", + "columnNames": "topiaid,comment,currentdirection,currentspeed,dataquality,fpazone,homeid,informationsource,lastupdatedate,latitude,latitudeoriginal,longitude,longitudeoriginal,number,originaldatamodified,positioncorrected,reasonfornofishing,reasonfornullset,relatedobservedactivity,route,schooltype,seasurfacetemperature,setcount,setsuccessstatus,time,topiacreatedate,topiaversion,totalweight,vesselactivity,vmsdivergent,wind,winddirection", + "columnsToDetach": "relatedObservedActivity~ps_observation.activity", + "entryPoint": true + }, + { + "gav": "ps_logbook.catch", + "selectedSql": "SELECT %s FROM ps_logbook.catch catch WHERE catch.activity %s", + "insertSql": "INSERT INTO ps_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,activity_idx,comment,count,homeid,lastupdatedate,species,speciesfate,topiacreatedate,topiaversion,weight,weightcategory,weightmeasuremethod,well" + }, + { + "gav": "ps_logbook.floatingObject", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObject floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_logbook.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_logbook.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObjectPart floatingObjectPart INNER JOIN ps_logbook.floatingObject floatingObject ON floatingObject.topiaId = floatingObjectPart.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_logbook.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_logbook.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_logbook.transmittingBuoy transmittingBuoy INNER JOIN ps_logbook.floatingObject floatingObject ON floatingObject.topiaId = transmittingBuoy.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_logbook.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + }, + { + "gav": "ps_logbook.activity_observedsystem", + "selectedSql": "SELECT %s FROM ps_logbook.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.activity_observedsystem(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "activity,observedsystem", + "columnsToReplace": "activity" + } + ], + "fr.ird.observe.entities.data.ps.logbook.Catch": [ + { + "gav": "ps_logbook.catch", + "selectedSql": "SELECT %s FROM ps_logbook.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,activity_idx,comment,count,homeid,lastupdatedate,species,speciesfate,topiacreatedate,topiaversion,weight,weightcategory,weightmeasuremethod,well", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.FloatingObject": [ + { + "gav": "ps_logbook.floatingObject", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObject WHERE floatingObject.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ps_logbook.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObjectPart floatingObjectPart WHERE floatingObjectPart.floatingObject %s", + "insertSql": "INSERT INTO ps_logbook.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_logbook.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_logbook.transmittingBuoy transmittingBuoy WHERE transmittingBuoy.floatingObject %s", + "insertSql": "INSERT INTO ps_logbook.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + } + ], + "fr.ird.observe.entities.data.ps.logbook.FloatingObjectPart": [ + { + "gav": "ps_logbook.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObjectPart WHERE floatingObjectPart.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.Route": [ + { + "gav": "ps_logbook.route", + "selectedSql": "SELECT %s FROM ps_logbook.route WHERE route.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.route(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,date,fishingtime,homeid,lastupdatedate,timeatsea,topiacreatedate,topiaversion,trip", + "entryPoint": true + }, + { + "gav": "ps_logbook.activity", + "selectedSql": "SELECT %s FROM ps_logbook.activity activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.activity(%s) VALUES (%%s);", + "parentColumnName": "route", + "columnNames": "topiaid,comment,currentdirection,currentspeed,dataquality,fpazone,homeid,informationsource,lastupdatedate,latitude,latitudeoriginal,longitude,longitudeoriginal,number,originaldatamodified,positioncorrected,reasonfornofishing,reasonfornullset,relatedobservedactivity,route,schooltype,seasurfacetemperature,setcount,setsuccessstatus,time,topiacreatedate,topiaversion,totalweight,vesselactivity,vmsdivergent,wind,winddirection", + "columnsToDetach": "relatedObservedActivity~ps_observation.activity" + }, + { + "gav": "ps_logbook.catch", + "selectedSql": "SELECT %s FROM ps_logbook.catch catch INNER JOIN ps_logbook.activity activity ON activity.topiaId = catch.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.catch(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,activity_idx,comment,count,homeid,lastupdatedate,species,speciesfate,topiacreatedate,topiaversion,weight,weightcategory,weightmeasuremethod,well" + }, + { + "gav": "ps_logbook.floatingObject", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObject floatingObject INNER JOIN ps_logbook.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_logbook.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_logbook.floatingObjectPart floatingObjectPart INNER JOIN ps_logbook.floatingObject floatingObject ON floatingObject.topiaId = floatingObjectPart.floatingObject INNER JOIN ps_logbook.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_logbook.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_logbook.transmittingBuoy transmittingBuoy INNER JOIN ps_logbook.floatingObject floatingObject ON floatingObject.topiaId = transmittingBuoy.floatingObject INNER JOIN ps_logbook.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + }, + { + "gav": "ps_logbook.activity_observedsystem", + "selectedSql": "SELECT %s FROM ps_logbook.activity activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_logbook.activity_observedsystem(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "activity,observedsystem", + "columnsToReplace": "activity" + } + ], + "fr.ird.observe.entities.data.ps.logbook.Sample": [ + { + "gav": "ps_logbook.sample", + "selectedSql": "SELECT %s FROM ps_logbook.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.sample(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,bigsweight,comment,homeid,lastupdatedate,number,samplequality,sampletype,smallsweight,supersample,topiacreatedate,topiaversion,totalweight,trip,well", + "entryPoint": true + }, + { + "gav": "ps_logbook.sampleActivity", + "selectedSql": "SELECT %s FROM ps_logbook.sampleActivity sampleActivity WHERE sampleActivity.sample %s", + "insertSql": "INSERT INTO ps_logbook.sampleActivity(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,activity,homeid,lastupdatedate,sample,topiacreatedate,topiaversion,weightedweight", + "columnsToDetach": "activity~ps_logbook.activity" + }, + { + "gav": "ps_logbook.sampleSpecies", + "selectedSql": "SELECT %s FROM ps_logbook.sampleSpecies sampleSpecies WHERE sampleSpecies.sample %s", + "insertSql": "INSERT INTO ps_logbook.sampleSpecies(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,comment,endtime,homeid,lastupdatedate,measuredcount,sample,sample_idx,sizemeasuretype,species,starttime,subsamplenumber,topiacreatedate,topiaversion,totalcount" + }, + { + "gav": "ps_logbook.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_logbook.sampleSpeciesMeasure sampleSpeciesMeasure INNER JOIN ps_logbook.sampleSpecies sampleSpecies ON sampleSpecies.topiaId = sampleSpeciesMeasure.sampleSpecies WHERE sampleSpecies.sample %s", + "insertSql": "INSERT INTO ps_logbook.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion" + }, + { + "gav": "ps_logbook.sample_person", + "selectedSql": "SELECT %s FROM ps_logbook.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.sample_person(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "person,sample", + "columnsToReplace": "sample" + } + ], + "fr.ird.observe.entities.data.ps.logbook.SampleActivity": [ + { + "gav": "ps_logbook.sampleActivity", + "selectedSql": "SELECT %s FROM ps_logbook.sampleActivity WHERE sampleActivity.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.sampleActivity(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,activity,homeid,lastupdatedate,sample,topiacreatedate,topiaversion,weightedweight", + "columnsToDetach": "activity~ps_logbook.activity", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.SampleSpecies": [ + { + "gav": "ps_logbook.sampleSpecies", + "selectedSql": "SELECT %s FROM ps_logbook.sampleSpecies WHERE sampleSpecies.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.sampleSpecies(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,comment,endtime,homeid,lastupdatedate,measuredcount,sample,sample_idx,sizemeasuretype,species,starttime,subsamplenumber,topiacreatedate,topiaversion,totalcount", + "entryPoint": true + }, + { + "gav": "ps_logbook.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_logbook.sampleSpeciesMeasure sampleSpeciesMeasure WHERE sampleSpeciesMeasure.sampleSpecies %s", + "insertSql": "INSERT INTO ps_logbook.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion" + } + ], + "fr.ird.observe.entities.data.ps.logbook.SampleSpeciesMeasure": [ + { + "gav": "ps_logbook.sampleSpeciesMeasure", + "selectedSql": "SELECT %s FROM ps_logbook.sampleSpeciesMeasure WHERE sampleSpeciesMeasure.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.sampleSpeciesMeasure(%s) VALUES (%%s);", + "parentColumnName": "sampleSpecies", + "columnNames": "topiaid,count,homeid,lastupdatedate,samplespecies,sizeclass,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.TransmittingBuoy": [ + { + "gav": "ps_logbook.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_logbook.transmittingBuoy WHERE transmittingBuoy.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.logbook.WellPlan": [ + { + "gav": "ps_logbook.wellPlan", + "selectedSql": "SELECT %s FROM ps_logbook.wellPlan WHERE wellPlan.topiaId %s", + "insertSql": "INSERT INTO ps_logbook.wellPlan(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,activity,homeid,lastupdatedate,species,topiacreatedate,topiaversion,trip,trip_idx,weight,weightcategory,well,wellsamplingconformity,wellsamplingstatus", + "columnsToDetach": "activity~ps_logbook.activity", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.Activity": [ + { + "gav": "ps_observation.set", + "selectedSql": "SELECT %s FROM ps_observation.set set INNER JOIN ps_observation.activity activity ON activity.set = set.topiaId WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.set(%s) VALUES (%%s);", + "columnNames": "topiaid,comment,currentdirection,currentmeasuredepth,currentspeed,endtimestamp,haulingendtimestamp,haulingstarttimestamp,homeid,lastupdatedate,maxgeardepth,reasonfornullset,schoolmeandepth,schoolthickness,schooltopdepth,schooltype,starttime,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.activity", + "selectedSql": "SELECT %s FROM ps_observation.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.activity(%s) VALUES (%%s);", + "parentColumnName": "route", + "columnNames": "topiaid,comment,currentfpazone,dataquality,detectionmode,ersid,homeid,lastupdatedate,latitude,longitude,nextfpazone,observedsystemdistance,previousfpazone,reasonfornofishing,route,seasurfacetemperature,set,surroundingactivity,time,topiacreatedate,topiaversion,vesselactivity,vesselspeed,wind", + "columnsToReplace": "set", + "entryPoint": true + }, + { + "gav": "ps_observation.catch", + "selectedSql": "SELECT %s FROM ps_observation.catch catch INNER JOIN ps_observation.activity activity ON activity.set = catch.set INNER JOIN ps_observation.route route ON route.topiaId = activity.route WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,catchweight,catchweightcomputedsource,comment,homeid,informationsource,lastupdatedate,lengthmeasuremethod,meanlength,meanlengthcomputedsource,meanweight,meanweightcomputedsource,reasonfordiscard,set,set_idx,species,speciesfate,topiacreatedate,topiaversion,totalcount,totalcountcomputedsource,weightmeasuremethod,well" + }, + { + "gav": "ps_observation.floatingObject", + "selectedSql": "SELECT %s FROM ps_observation.floatingObject floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_observation.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_observation.floatingObjectPart floatingObjectPart INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = floatingObjectPart.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_observation.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_observation.nonTargetCatchRelease", + "selectedSql": "SELECT %s FROM ps_observation.nonTargetCatchRelease nonTargetCatchRelease INNER JOIN ps_observation.activity activity ON activity.set = nonTargetCatchRelease.set INNER JOIN ps_observation.route route ON route.topiaId = activity.route WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.nonTargetCatchRelease(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,comment,conformity,count,homeid,lastupdatedate,length,lengthmeasuremethod,releasingtime,set,set_idx,sex,species,speciesgroupreleasemode,status,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.objectObservedSpecies", + "selectedSql": "SELECT %s FROM ps_observation.objectObservedSpecies objectObservedSpecies INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = objectObservedSpecies.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_observation.objectObservedSpecies(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,count,floatingobject,homeid,lastupdatedate,species,speciesstatus,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.objectSchoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.objectSchoolEstimate objectSchoolEstimate INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = objectSchoolEstimate.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_observation.objectSchoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.schoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.schoolEstimate schoolEstimate INNER JOIN ps_observation.activity activity ON activity.set = schoolEstimate.set INNER JOIN ps_observation.route route ON route.topiaId = activity.route WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.schoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,meanweight,set,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_observation.transmittingBuoy transmittingBuoy INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = transmittingBuoy.floatingObject WHERE floatingObject.activity %s", + "insertSql": "INSERT INTO ps_observation.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + }, + { + "gav": "ps_observation.sample", + "selectedSql": "SELECT %s FROM ps_observation.sample sample INNER JOIN ps_observation.activity activity ON activity.set = sample.set INNER JOIN ps_observation.route route ON route.topiaId = activity.route WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.sample(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,comment,homeid,lastupdatedate,set,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.sampleMeasure", + "selectedSql": "SELECT %s FROM ps_observation.sampleMeasure sampleMeasure INNER JOIN ps_observation.sample sample ON sample.topiaId = sampleMeasure.sample INNER JOIN ps_observation.activity activity ON activity.set = sample.set INNER JOIN ps_observation.route route ON route.topiaId = activity.route WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.sampleMeasure(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,islengthcomputed,isweightcomputed,lastupdatedate,length,lengthmeasuremethod,picturesreferences,sample,sample_idx,sex,sizemeasuretype,species,speciesfate,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + }, + { + "gav": "ps_observation.activity_observedsystem", + "selectedSql": "SELECT %s FROM ps_observation.activity WHERE activity.topiaId %s", + "insertSql": "INSERT INTO ps_observation.activity_observedsystem(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "activity,observedsystem", + "columnsToReplace": "activity" + } + ], + "fr.ird.observe.entities.data.ps.observation.Catch": [ + { + "gav": "ps_observation.catch", + "selectedSql": "SELECT %s FROM ps_observation.catch WHERE catch.topiaId %s", + "insertSql": "INSERT INTO ps_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,catchweight,catchweightcomputedsource,comment,homeid,informationsource,lastupdatedate,lengthmeasuremethod,meanlength,meanlengthcomputedsource,meanweight,meanweightcomputedsource,reasonfordiscard,set,set_idx,species,speciesfate,topiacreatedate,topiaversion,totalcount,totalcountcomputedsource,weightmeasuremethod,well", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.FloatingObject": [ + { + "gav": "ps_observation.floatingObject", + "selectedSql": "SELECT %s FROM ps_observation.floatingObject WHERE floatingObject.topiaId %s", + "insertSql": "INSERT INTO ps_observation.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ps_observation.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_observation.floatingObjectPart floatingObjectPart WHERE floatingObjectPart.floatingObject %s", + "insertSql": "INSERT INTO ps_observation.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_observation.objectObservedSpecies", + "selectedSql": "SELECT %s FROM ps_observation.objectObservedSpecies objectObservedSpecies WHERE objectObservedSpecies.floatingObject %s", + "insertSql": "INSERT INTO ps_observation.objectObservedSpecies(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,count,floatingobject,homeid,lastupdatedate,species,speciesstatus,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.objectSchoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.objectSchoolEstimate objectSchoolEstimate WHERE objectSchoolEstimate.floatingObject %s", + "insertSql": "INSERT INTO ps_observation.objectSchoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_observation.transmittingBuoy transmittingBuoy WHERE transmittingBuoy.floatingObject %s", + "insertSql": "INSERT INTO ps_observation.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + } + ], + "fr.ird.observe.entities.data.ps.observation.FloatingObjectPart": [ + { + "gav": "ps_observation.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_observation.floatingObjectPart WHERE floatingObjectPart.topiaId %s", + "insertSql": "INSERT INTO ps_observation.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.NonTargetCatchRelease": [ + { + "gav": "ps_observation.nonTargetCatchRelease", + "selectedSql": "SELECT %s FROM ps_observation.nonTargetCatchRelease WHERE nonTargetCatchRelease.topiaId %s", + "insertSql": "INSERT INTO ps_observation.nonTargetCatchRelease(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,comment,conformity,count,homeid,lastupdatedate,length,lengthmeasuremethod,releasingtime,set,set_idx,sex,species,speciesgroupreleasemode,status,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.ObjectObservedSpecies": [ + { + "gav": "ps_observation.objectObservedSpecies", + "selectedSql": "SELECT %s FROM ps_observation.objectObservedSpecies WHERE objectObservedSpecies.topiaId %s", + "insertSql": "INSERT INTO ps_observation.objectObservedSpecies(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,count,floatingobject,homeid,lastupdatedate,species,speciesstatus,topiacreatedate,topiaversion", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.ObjectSchoolEstimate": [ + { + "gav": "ps_observation.objectSchoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.objectSchoolEstimate WHERE objectSchoolEstimate.topiaId %s", + "insertSql": "INSERT INTO ps_observation.objectSchoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.Route": [ + { + "gav": "ps_observation.route", + "selectedSql": "SELECT %s FROM ps_observation.route WHERE route.topiaId %s", + "insertSql": "INSERT INTO ps_observation.route(%s) VALUES (%%s);", + "parentColumnName": "trip", + "columnNames": "topiaid,comment,date,endlogvalue,homeid,lastupdatedate,startlogvalue,topiacreatedate,topiaversion,trip", + "entryPoint": true + }, + { + "gav": "ps_observation.set", + "selectedSql": "SELECT %s FROM ps_observation.set set INNER JOIN ps_observation.activity activity ON activity.set = set.topiaId WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.set(%s) VALUES (%%s);", + "columnNames": "topiaid,comment,currentdirection,currentmeasuredepth,currentspeed,endtimestamp,haulingendtimestamp,haulingstarttimestamp,homeid,lastupdatedate,maxgeardepth,reasonfornullset,schoolmeandepth,schoolthickness,schooltopdepth,schooltype,starttime,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.activity", + "selectedSql": "SELECT %s FROM ps_observation.activity activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.activity(%s) VALUES (%%s);", + "parentColumnName": "route", + "columnNames": "topiaid,comment,currentfpazone,dataquality,detectionmode,ersid,homeid,lastupdatedate,latitude,longitude,nextfpazone,observedsystemdistance,previousfpazone,reasonfornofishing,route,seasurfacetemperature,set,surroundingactivity,time,topiacreatedate,topiaversion,vesselactivity,vesselspeed,wind", + "columnsToReplace": "set" + }, + { + "gav": "ps_observation.catch", + "selectedSql": "SELECT %s FROM ps_observation.catch catch INNER JOIN ps_observation.activity activity ON activity.set = catch.set WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,catchweight,catchweightcomputedsource,comment,homeid,informationsource,lastupdatedate,lengthmeasuremethod,meanlength,meanlengthcomputedsource,meanweight,meanweightcomputedsource,reasonfordiscard,set,set_idx,species,speciesfate,topiacreatedate,topiaversion,totalcount,totalcountcomputedsource,weightmeasuremethod,well" + }, + { + "gav": "ps_observation.floatingObject", + "selectedSql": "SELECT %s FROM ps_observation.floatingObject floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.floatingObject(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "topiaid,activity,comment,computedwhenarrivingbiodegradable,computedwhenarrivingnonentangling,computedwhenarrivingsimplifiedobjecttype,computedwhenleavingbiodegradable,computedwhenleavingnonentangling,computedwhenleavingsimplifiedobjecttype,homeid,lastupdatedate,objectoperation,supportvesselname,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.floatingObjectPart", + "selectedSql": "SELECT %s FROM ps_observation.floatingObjectPart floatingObjectPart INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = floatingObjectPart.floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.floatingObjectPart(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,objectmaterial,topiacreatedate,topiaversion,whenarriving,whenleaving" + }, + { + "gav": "ps_observation.nonTargetCatchRelease", + "selectedSql": "SELECT %s FROM ps_observation.nonTargetCatchRelease nonTargetCatchRelease INNER JOIN ps_observation.activity activity ON activity.set = nonTargetCatchRelease.set WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.nonTargetCatchRelease(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,comment,conformity,count,homeid,lastupdatedate,length,lengthmeasuremethod,releasingtime,set,set_idx,sex,species,speciesgroupreleasemode,status,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.objectObservedSpecies", + "selectedSql": "SELECT %s FROM ps_observation.objectObservedSpecies objectObservedSpecies INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = objectObservedSpecies.floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.objectObservedSpecies(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,count,floatingobject,homeid,lastupdatedate,species,speciesstatus,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.objectSchoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.objectSchoolEstimate objectSchoolEstimate INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = objectSchoolEstimate.floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.objectSchoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,floatingobject,homeid,lastupdatedate,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.schoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.schoolEstimate schoolEstimate INNER JOIN ps_observation.activity activity ON activity.set = schoolEstimate.set WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.schoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,meanweight,set,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_observation.transmittingBuoy transmittingBuoy INNER JOIN ps_observation.floatingObject floatingObject ON floatingObject.topiaId = transmittingBuoy.floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel" + }, + { + "gav": "ps_observation.sample", + "selectedSql": "SELECT %s FROM ps_observation.sample sample INNER JOIN ps_observation.activity activity ON activity.set = sample.set WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.sample(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,comment,homeid,lastupdatedate,set,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.sampleMeasure", + "selectedSql": "SELECT %s FROM ps_observation.sampleMeasure sampleMeasure INNER JOIN ps_observation.sample sample ON sample.topiaId = sampleMeasure.sample INNER JOIN ps_observation.activity activity ON activity.set = sample.set WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.sampleMeasure(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,islengthcomputed,isweightcomputed,lastupdatedate,length,lengthmeasuremethod,picturesreferences,sample,sample_idx,sex,sizemeasuretype,species,speciesfate,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + }, + { + "gav": "ps_observation.activity_observedsystem", + "selectedSql": "SELECT %s FROM ps_observation.activity activity WHERE activity.route %s", + "insertSql": "INSERT INTO ps_observation.activity_observedsystem(%s) VALUES (%%s);", + "parentColumnName": "activity", + "columnNames": "activity,observedsystem", + "columnsToReplace": "activity" + } + ], + "fr.ird.observe.entities.data.ps.observation.Sample": [ + { + "gav": "ps_observation.sample", + "selectedSql": "SELECT %s FROM ps_observation.sample WHERE sample.topiaId %s", + "insertSql": "INSERT INTO ps_observation.sample(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,comment,homeid,lastupdatedate,set,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ps_observation.sampleMeasure", + "selectedSql": "SELECT %s FROM ps_observation.sampleMeasure sampleMeasure WHERE sampleMeasure.sample %s", + "insertSql": "INSERT INTO ps_observation.sampleMeasure(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,islengthcomputed,isweightcomputed,lastupdatedate,length,lengthmeasuremethod,picturesreferences,sample,sample_idx,sex,sizemeasuretype,species,speciesfate,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + } + ], + "fr.ird.observe.entities.data.ps.observation.SampleMeasure": [ + { + "gav": "ps_observation.sampleMeasure", + "selectedSql": "SELECT %s FROM ps_observation.sampleMeasure WHERE sampleMeasure.topiaId %s", + "insertSql": "INSERT INTO ps_observation.sampleMeasure(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,islengthcomputed,isweightcomputed,lastupdatedate,length,lengthmeasuremethod,picturesreferences,sample,sample_idx,sex,sizemeasuretype,species,speciesfate,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.SchoolEstimate": [ + { + "gav": "ps_observation.schoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.schoolEstimate WHERE schoolEstimate.topiaId %s", + "insertSql": "INSERT INTO ps_observation.schoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,meanweight,set,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod", + "entryPoint": true + } + ], + "fr.ird.observe.entities.data.ps.observation.Set": [ + { + "gav": "ps_observation.set", + "selectedSql": "SELECT %s FROM ps_observation.set WHERE set.topiaId %s", + "insertSql": "INSERT INTO ps_observation.set(%s) VALUES (%%s);", + "updateReverseAssociationSql": "UPDATE ps_observation.activity activity SET activity.set = '%s' WHERE activity.topiaId = '%'", + "columnNames": "topiaid,comment,currentdirection,currentmeasuredepth,currentspeed,endtimestamp,haulingendtimestamp,haulingstarttimestamp,homeid,lastupdatedate,maxgeardepth,reasonfornullset,schoolmeandepth,schoolthickness,schooltopdepth,schooltype,starttime,supportvesselname,topiacreatedate,topiaversion", + "entryPoint": true + }, + { + "gav": "ps_observation.catch", + "selectedSql": "SELECT %s FROM ps_observation.catch catch WHERE catch.set %s", + "insertSql": "INSERT INTO ps_observation.catch(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,catchweight,catchweightcomputedsource,comment,homeid,informationsource,lastupdatedate,lengthmeasuremethod,meanlength,meanlengthcomputedsource,meanweight,meanweightcomputedsource,reasonfordiscard,set,set_idx,species,speciesfate,topiacreatedate,topiaversion,totalcount,totalcountcomputedsource,weightmeasuremethod,well" + }, + { + "gav": "ps_observation.nonTargetCatchRelease", + "selectedSql": "SELECT %s FROM ps_observation.nonTargetCatchRelease nonTargetCatchRelease WHERE nonTargetCatchRelease.set %s", + "insertSql": "INSERT INTO ps_observation.nonTargetCatchRelease(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,acquisitionmode,comment,conformity,count,homeid,lastupdatedate,length,lengthmeasuremethod,releasingtime,set,set_idx,sex,species,speciesgroupreleasemode,status,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.schoolEstimate", + "selectedSql": "SELECT %s FROM ps_observation.schoolEstimate schoolEstimate WHERE schoolEstimate.set %s", + "insertSql": "INSERT INTO ps_observation.schoolEstimate(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,homeid,lastupdatedate,meanweight,set,species,topiacreatedate,topiaversion,totalweight,weightmeasuremethod" + }, + { + "gav": "ps_observation.sample", + "selectedSql": "SELECT %s FROM ps_observation.sample sample WHERE sample.set %s", + "insertSql": "INSERT INTO ps_observation.sample(%s) VALUES (%%s);", + "parentColumnName": "set", + "columnNames": "topiaid,comment,homeid,lastupdatedate,set,topiacreatedate,topiaversion" + }, + { + "gav": "ps_observation.sampleMeasure", + "selectedSql": "SELECT %s FROM ps_observation.sampleMeasure sampleMeasure INNER JOIN ps_observation.sample sample ON sample.topiaId = sampleMeasure.sample WHERE sample.set %s", + "insertSql": "INSERT INTO ps_observation.sampleMeasure(%s) VALUES (%%s);", + "parentColumnName": "sample", + "columnNames": "topiaid,acquisitionmode,count,homeid,islengthcomputed,isweightcomputed,lastupdatedate,length,lengthmeasuremethod,picturesreferences,sample,sample_idx,sex,sizemeasuretype,species,speciesfate,tagnumber,topiacreatedate,topiaversion,weight,weightmeasuremethod,weightmeasuretype" + } + ], + "fr.ird.observe.entities.data.ps.observation.TransmittingBuoy": [ + { + "gav": "ps_observation.transmittingBuoy", + "selectedSql": "SELECT %s FROM ps_observation.transmittingBuoy WHERE transmittingBuoy.topiaId %s", + "insertSql": "INSERT INTO ps_observation.transmittingBuoy(%s) VALUES (%%s);", + "parentColumnName": "floatingObject", + "columnNames": "topiaid,code,comment,country,floatingobject,homeid,lastupdatedate,latitude,longitude,topiacreatedate,topiaversion,transmittingbuoyoperation,transmittingbuoyownership,transmittingbuoytype,vessel", + "entryPoint": true + } + ] + } +} \ No newline at end of file ===================================== core/persistence/java/src/test/java/fr/ird/observe/spi/script/UpdateLastUpdateDateFieldScriptTest.java ===================================== @@ -23,12 +23,10 @@ package fr.ird.observe.spi.script; */ import fr.ird.observe.entities.ObserveTopiaEntitySqlModelResource; -import fr.ird.observe.spi.script.ToolkitEntitySqlScriptModel; -import fr.ird.observe.spi.script.UpdateLastUpdateDateFieldScript; import org.junit.Assert; import org.junit.Before; import org.junit.Test; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; import java.util.Date; import java.util.List; ===================================== core/persistence/java/src/test/java/fr/ird/observe/spi/script/UpdateLastUpdateDateTableScriptTest.java ===================================== @@ -23,12 +23,10 @@ package fr.ird.observe.spi.script; */ import fr.ird.observe.entities.ObserveTopiaEntitySqlModelResource; -import fr.ird.observe.spi.script.ToolkitEntitySqlScriptModel; -import fr.ird.observe.spi.script.UpdateLastUpdateDateTableScript; import org.junit.Assert; import org.junit.Before; import org.junit.Test; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; import java.util.Date; import java.util.List; ===================================== core/persistence/test/src/main/java/fr/ird/observe/persistence/test/PersistenceTestSupportRead.java ===================================== @@ -33,8 +33,8 @@ import fr.ird.observe.test.spi.DatabaseVersionConfiguration; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; import org.junit.ClassRule; -import org.nuiton.topia.persistence.metadata.TopiaMetadataEntity; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataEntity; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; import org.nuiton.topia.service.sql.model.TopiaEntitySqlModel; import java.util.List; ===================================== core/persistence/test/src/main/java/fr/ird/observe/persistence/test/PersistenceTestSupportWrite.java ===================================== @@ -39,7 +39,7 @@ import org.junit.After; import org.junit.Assert; import org.junit.ClassRule; import org.junit.Rule; -import org.nuiton.topia.persistence.metadata.TopiaMetadataEntity; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataEntity; import org.nuiton.topia.service.sql.model.TopiaEntitySqlDescriptors; import org.nuiton.topia.service.sql.model.TopiaEntitySqlModel; import org.nuiton.topia.service.sql.plan.copy.TopiaEntitySqlCopyPlan; ===================================== core/persistence/test/src/test/java/fr/ird/observe/persistence/test/DefinitionContentTest.java ===================================== @@ -29,7 +29,7 @@ import fr.ird.observe.spi.context.DtoEntityContext; import org.junit.Assert; import org.junit.Before; import org.junit.Test; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; /** * Created on 22/11/2021. ===================================== core/persistence/test/src/test/java/fr/ird/observe/persistence/test/PersistenceModelWriteTest.java ===================================== @@ -111,7 +111,7 @@ public class PersistenceModelWriteTest extends PersistenceTestSupportWrite { TopiaEntitySqlCopyPlan copyPlan = copyPlan(classifier, applicationContext); createRequest(classifier); if (!classifier.equals(CLASSIFIER_REFERENTIAL)) { - request.addReplicateTableRequest(applicationContext.getSqlService().getCopyPlanModel().getStandalonePlan(), null); + request.addCopyTableRequest(applicationContext.getSqlService().getCopyPlanModel().getStandalonePlan(), null); selectArgument = TopiaEntitySqlSelectArgument.of(tripId); } importScriptAndAssertCount(applicationContext, copyPlan, selectArgument, expectedCount); @@ -136,7 +136,7 @@ public class PersistenceModelWriteTest extends PersistenceTestSupportWrite { } void importScriptAndAssertCount(ObserveTopiaApplicationContext applicationContext, TopiaEntitySqlCopyPlan copyPlan, TopiaEntitySqlSelectArgument selectArgument, Map<String, Long> expectedResults) throws Exception { - request.addReplicateTableRequest(copyPlan, selectArgument); + request.addCopyTableRequest(copyPlan, selectArgument); TopiaSqlScript script = applicationContext.getSqlService().consume(request); log.info(String.format("Generated script: %s", scriptFile)); File targetDatabaseDirectory = new File(localTestMethodResource.getTestDirectory(), "import-" + scriptFile.getName()); ===================================== core/persistence/test/src/test/java/fr/ird/observe/persistence/test/ValidationContentTest.java ===================================== @@ -29,7 +29,7 @@ import fr.ird.observe.spi.context.DtoEntityContext; import org.junit.Assert; import org.junit.Before; import org.junit.Test; -import org.nuiton.topia.persistence.metadata.TopiaMetadataModel; +import org.nuiton.topia.service.sql.metadata.TopiaMetadataModel; /** * Created on 22/11/2021. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/df53fa17927f568fea595513b… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/df53fa17927f568fea595513b… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 2 commits: Replace TopiaEntityScript by TopiaEntitySqlScript - See ultreiaio/topia-extension#110
by Tony CHEMIT (＠tchemit) 06 Mar '22

06 Mar '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 41e71c90 by Tony Chemit at 2022-03-06T10:33:37+01:00 Replace TopiaEntityScript by TopiaEntitySqlScript - See ultreiaio/topia-extension#110 - - - - - cb2eca7e by Tony Chemit at 2022-03-06T15:43:30+01:00 Replace paths entity centric by sql model centric approach - See ultreiaio/topia-extension#111 - - - - - 4 changed files: - core/persistence/java/pom.xml - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaApplicationContext.java - + core/persistence/java/src/main/resources/META-INF/persistence/Observe/ToolkitEntitySqlScriptModel.json - core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaMetadataModel.json The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/77d275276c0ecc03c01e3bc5… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/77d275276c0ecc03c01e3bc5… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 4 commits: Introduce CopyPlan and clean sql service API - See ultreiaio/topia-extension#107
by Tony CHEMIT (＠tchemit) 05 Mar '22

05 Mar '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 92a9615e by Tony Chemit at 2022-03-05T17:13:19+01:00 Introduce CopyPlan and clean sql service API - See ultreiaio/topia-extension#107 - - - - - ea6d8fdd by Tony Chemit at 2022-03-05T17:13:19+01:00 Improve Json API (add default adapters) - See ultreiaio/http#48 - - - - - bf970664 by Tony Chemit at 2022-03-05T17:13:19+01:00 Improve application context models loading - See ultreiaio/topia-extension#108 - - - - - 77d27527 by Tony Chemit at 2022-03-05T17:32:27+01:00 update pom - - - - - 9 changed files: - client/configuration/pom.xml - client/configuration/src/main/java/fr/ird/observe/client/configuration/ClientConfig.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/tree/NavigationScopes.java - core/api/dto/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaApplicationContext.java - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaPersistenceContext.java - + core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlBlobModel.json The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/d45676d1cdb4ff50bdafbcd1… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/d45676d1cdb4ff50bdafbcd1… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 4 commits: tidy pom
by Tony CHEMIT (＠tchemit) 05 Mar '22

05 Mar '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: ff608299 by Tony Chemit at 2022-03-05T09:03:11+01:00 tidy pom toolkit in snapshot - - - - - cd204a70 by Tony Chemit at 2022-03-05T11:34:40+01:00 Introduce CopyPlan and clean sql service API - See ultreiaio/topia-extension#107 - - - - - 963d1a28 by Tony Chemit at 2022-03-05T11:34:40+01:00 Improve Json API (add default adapters) - See ultreiaio/http#48 - - - - - d45676d1 by Tony Chemit at 2022-03-05T15:47:36+01:00 Improve application context models loading - See ultreiaio/topia-extension#108 - - - - - 10 changed files: - client/configuration/pom.xml - client/configuration/src/main/java/fr/ird/observe/client/configuration/ClientConfig.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/tree/NavigationScopes.java - client/runner/pom.xml - core/api/dto/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaApplicationContext.java - core/persistence/java/src/main/java/fr/ird/observe/entities/ObserveTopiaPersistenceContext.java - + core/persistence/java/src/main/resources/META-INF/persistence/Observe/TopiaEntitySqlBlobModel.json The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/20f65eee73e52bca7fd9d7be… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/20f65eee73e52bca7fd9d7be… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 3 commits: Création d'un programme : exiger 'Observations' ou 'Livre de bord' - Closes...
by Tony CHEMIT (＠tchemit) 04 Mar '22

04 Mar '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: e802b2cb by Tony Chemit at 2022-03-04T02:57:00+01:00 Création d'un programme : exiger 'Observations' ou 'Livre de bord' - Closes ultreiaio/ird-observe#2183 - - - - - f77db716 by Tony Chemit at 2022-03-04T02:57:00+01:00 Fix ChangeId not enabled - - - - - 20f65eee by Tony Chemit at 2022-03-04T03:15:40+01:00 toolkit in snapshot - - - - - 30 changed files: - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/content/actions/id/ChangeId.java - client/datasource/editor/common/src/main/i18n/getters/jaxx.getter - client/datasource/editor/common/src/main/java/fr/ird/observe/client/datasource/editor/common/referential/common/PersonUI.jaxx - client/datasource/editor/ll/src/main/i18n/getters/jaxx.getter - client/datasource/editor/ll/src/main/java/fr/ird/observe/client/datasource/editor/ll/data/common/TripUI.jaxx - client/datasource/editor/ll/src/main/java/fr/ird/observe/client/datasource/editor/ll/referential/common/ProgramUI.jaxx - client/datasource/editor/ps/src/main/i18n/getters/jaxx.getter - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/AcquisitionStatusUI.jaxx - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/ObjectOperationUI.jaxx - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/ObservedSystemUI.jaxx - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/ProgramUI.jaxx - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/SampleTypeUI.jaxx - client/datasource/editor/ps/src/main/java/fr/ird/observe/client/datasource/editor/ps/referential/common/WeightCategoryUI.jaxx - core/api/dto/src/main/java/fr/ird/observe/spi/decoration/ObserveI18nLabelsBuilder.java - core/api/services/src/main/i18n/getters/labels.getter - core/api/services/src/main/resources/META-INF/i18n/Observe-labels.properties - core/api/validation/src/main/i18n/getters/eugene.getter - core/api/validation/src/main/i18n/getters/validation-messages.getter - core/persistence/resources/src/main/resources/fr/ird/observe/entities/data/ll/common/Trip/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/data/ll/common/Trip/validation-update.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/common/Person/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/common/Person/validation-update.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ll/common/Program/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ll/common/Program/validation-update.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/AcquisitionStatus/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/AcquisitionStatus/validation-update.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/ObjectOperation/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/ObjectOperation/validation-update.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/ObservedSystem/validation-create.json - core/persistence/resources/src/main/resources/fr/ird/observe/entities/referential/ps/common/ObservedSystem/validation-update.json The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/ddacd1ffda610dcfaa949969… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/ddacd1ffda610dcfaa949969… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][pages] Site checkin for project ObServe (version 9.0.0-RC-25)
by Tony CHEMIT (＠tchemit) 03 Mar '22

03 Mar '22

Tony CHEMIT pushed to branch pages at ultreiaio / ird-observe Commits: 2677a047 by Tony Chemit at 2022-03-03T10:29:22+01:00 Site checkin for project ObServe (version 9.0.0-RC-25) - - - - - 8 changed files: - + 9.0.0-RC-25/CHANGELOG.html - + 9.0.0-RC-25/architecture-logicielle.html - + 9.0.0-RC-25/avdth/common.html - + 9.0.0-RC-25/avdth/index.html - + 9.0.0-RC-25/avdth/landing.html - + 9.0.0-RC-25/avdth/local_market.html - + 9.0.0-RC-25/avdth/logbook.html - + 9.0.0-RC-25/avdth/referential.html The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/2677a047ec34bd7e0de148820… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/2677a047ec34bd7e0de148820… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe] Deleted branch release/9.0.0-RC-25
by Tony CHEMIT (＠tchemit) 03 Mar '22

03 Mar '22

Tony CHEMIT deleted branch release/9.0.0-RC-25 at ultreiaio / ird-observe -- You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe] Pushed new tag v9.0.0-RC-25
by Tony CHEMIT (＠tchemit) 03 Mar '22

03 Mar '22

Tony CHEMIT pushed new tag v9.0.0-RC-25 at ultreiaio / ird-observe -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/tree/v9.0.0-RC-25 You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][master] 22 commits: [jgitflow-maven-plugin]updating poms for 9.0.0-RC-25-SNAPSHOT development[skip ci]
by Tony CHEMIT (＠tchemit) 03 Mar '22

03 Mar '22

Tony CHEMIT pushed to branch master at ultreiaio / ird-observe Commits: 3a245346 by Tony Chemit at 2022-02-23T11:35:25+01:00 [jgitflow-maven-plugin]updating poms for 9.0.0-RC-25-SNAPSHOT development[skip ci] - - - - - dc20b445 by Tony Chemit at 2022-02-23T13:06:48+01:00 [jgitflow-maven-plugin]updating develop poms to master versions to avoid merge conflicts[skip ci] - - - - - d375962b by Tony Chemit at 2022-02-23T13:06:49+01:00 [jgitflow-maven-plugin]merging 'master' into 'develop' - - - - - 105742ff by Tony Chemit at 2022-02-23T13:06:51+01:00 [jgitflow-maven-plugin]Updating develop poms back to pre merge state[skip ci] - - - - - cf6f88e9 by Tony Chemit at 2022-03-01T15:45:02+01:00 Introduce TopiaSqlService - See ultreiaio/topia-extension#106 - - - - - 2183d2b4 by Tony Chemit at 2022-03-01T15:45:02+01:00 skip close method on some tests... - - - - - f458d376 by Tony Chemit at 2022-03-01T15:45:02+01:00 fix observe release artifacts - - - - - 0eaf8bd4 by Tony Chemit at 2022-03-01T15:45:02+01:00 update pom - - - - - 312eba06 by Tony Chemit at 2022-03-01T17:42:55+01:00 Création du programme LL FINSS ? - See ultreiaio/ird-observe#2193 - - - - - 7cfc0e6e by Tony Chemit at 2022-03-02T08:51:34+01:00 Fix NPE (See #2180) - - - - - faffe51b by Tony Chemit at 2022-03-02T09:05:17+01:00 On pourrait empêcher de configurer l'arbre sans référentiels ni marées - Closes #2184 - - - - - 71e82f1c by Tony Chemit at 2022-03-02T10:09:10+01:00 Import AVDTH ne devrait pas être visible en mode serveur - Closes #2188 - - - - - 0508f6fb by Tony Chemit at 2022-03-02T10:09:38+01:00 Souci lors de la configuration de l'arbre 2 - Closes #2180 - - - - - 93eaf835 by Tony Chemit at 2022-03-02T10:36:31+01:00 Souci lors de la configuration de l'arbre 1 avec base vierge - Closes #2178 Soucis lors de la configuration de l'arbre 3 avec base vierge - Closes #2181 - - - - - 4e494512 by Tony Chemit at 2022-03-02T11:15:53+01:00 Exception sur chargement de l'arbre (mode serveur) PS / Par bateaux - Closes #2190 - - - - - 30d2a07d by Tony Chemit at 2022-03-02T14:27:27+01:00 Création d'un programme : exiger 'Observations' ou 'Livre de bord' - See ultreiaio/ird-observe#2183 - - - - - 6f2b24e4 by Tony Chemit at 2022-03-02T15:15:40+01:00 Web service public RC24 ne fonctionne pas ? - See ultreiaio/ird-observe#2192 - - - - - 3f79276b by Tony Chemit at 2022-03-03T09:31:49+01:00 update CHANGELOG [skip ci] - - - - - db3be2c3 by Tony Chemit at 2022-03-03T09:32:18+01:00 update toolkit - - - - - 4c268cc3 by Tony Chemit at 2022-03-03T09:33:02+01:00 [jgitflow-maven-plugin]updating poms for 9.0.0-RC-25 branch with snapshot versions[skip ci] - - - - - 18af4102 by Tony Chemit at 2022-03-03T09:54:10+01:00 [jgitflow-maven-plugin]updating poms for branch'release/9.0.0-RC-25' with non-snapshot versions[skip ci] - - - - - 2cd82cc3 by Tony Chemit at 2022-03-03T09:54:17+01:00 [jgitflow-maven-plugin]merging 'release/9.0.0-RC-25' into 'master' - - - - - 30 changed files: - CHANGELOG.md - client/configuration/pom.xml - client/core/pom.xml - client/core/src/main/java/fr/ird/observe/client/datasource/api/ObserveSwingDataSource.java - client/datasource/actions/pom.xml - client/datasource/actions/src/main/java/fr/ird/observe/client/datasource/actions/config/SelectDataModel.java - client/datasource/actions/src/main/java/fr/ird/observe/client/datasource/actions/save/actions/Start.java - client/datasource/editor/api-test/pom.xml - client/datasource/editor/api/pom.xml - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/avdth/actions/Import.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/TreeConfigUI.jaxx - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/TreeConfigUI.jcss - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/TreeConfigUIModel.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/actions/ApplyConfigurationSupport.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/actions/ApplyNavigationConfiguration.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/config/actions/ApplySelectionConfiguration.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/NavigationUIHandler.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/tree/root/RootNavigationNode.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/tree/select/SelectNodesByModelNode.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/navigation/tree/select/SelectNodesByPath.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/wizard/DataSourceHelper.java - client/datasource/editor/api/src/main/java/fr/ird/observe/client/datasource/editor/api/wizard/tabs/SelectDataUIHandler.java - client/datasource/editor/common/pom.xml - client/datasource/editor/common/src/main/i18n/getters/jaxx.getter - client/datasource/editor/common/src/main/java/fr/ird/observe/client/datasource/editor/common/referential/common/PersonUI.jaxx - client/datasource/editor/ll/pom.xml - client/datasource/editor/pom.xml - client/datasource/editor/ps/pom.xml - client/datasource/editor/spi/pom.xml - client/datasource/pom.xml The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/6063d180f24e769337eae94b… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/6063d180f24e769337eae94b… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][release/9.0.0-RC-25] [jgitflow-maven-plugin]updating poms for branch'release/9.0.0-RC-25' with...
by Tony CHEMIT (＠tchemit) 03 Mar '22

03 Mar '22

Tony CHEMIT pushed to branch release/9.0.0-RC-25 at ultreiaio / ird-observe Commits: 18af4102 by Tony Chemit at 2022-03-03T09:54:10+01:00 [jgitflow-maven-plugin]updating poms for branch'release/9.0.0-RC-25' with non-snapshot versions[skip ci] - - - - - 30 changed files: - client/configuration/pom.xml - client/core/pom.xml - client/datasource/actions/pom.xml - client/datasource/editor/api-test/pom.xml - client/datasource/editor/api/pom.xml - client/datasource/editor/common/pom.xml - client/datasource/editor/ll/pom.xml - client/datasource/editor/pom.xml - client/datasource/editor/ps/pom.xml - client/datasource/editor/spi/pom.xml - client/datasource/pom.xml - client/pom.xml - client/runner/pom.xml - core/api/dto/pom.xml - core/api/pom.xml - core/api/services/pom.xml - core/api/tree/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/pom.xml - core/persistence/resources/pom.xml - core/persistence/test/pom.xml - core/pom.xml - core/services/client/pom.xml - core/services/i18n/pom.xml - core/services/local/pom.xml - core/services/pom.xml - core/services/test/pom.xml - model/pom.xml - observe/pom.xml The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/18af4102634c4efb98da305bf… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/18af4102634c4efb98da305bf… You're receiving this email because of your account on gitlab.com.

1 0