Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot export in base model format when catalogue is used #488

Open
signedav opened this issue Sep 16, 2022 · 0 comments
Open

Cannot export in base model format when catalogue is used #488

signedav opened this issue Sep 16, 2022 · 0 comments

Comments

@signedav
Copy link

ili2db stops in the middle of the export when exporting base model with --exportModels and having a catalogue in the base model.

When having a database created with the model SimpleExtend, I add an entry of the House (of SimpleExtend).

I can export the data without any problem in the structure of SimpleExtend.
I cannot export the data in the structure of SimpleBase (with --exportModels SimpleBase): ili2db blocks (see log below).

Cataloguemodel:

MODEL SimpleCatalogue (en)
AT "mailto:[[email protected]](mailto:[email protected])"
VERSION "2022-04-06" =
  IMPORTS CatalogueObjects_V1;

  TOPIC Catalogues =
    OID AS INTERLIS.UUIDOID;
    CLASS MaterialItem
    EXTENDS CatalogueObjects_V1.Catalogues.Item =
      Code : MANDATORY TEXT;
    END MaterialItem;

    STRUCTURE MaterialRef
    EXTENDS CatalogueObjects_V1.Catalogues.MandatoryCatalogueReference =
      Reference (EXTENDED) : MANDATORY REFERENCE TO (EXTERNAL) MaterialItem;
    END MaterialRef;
  END Catalogues;

END SimpleCatalogue.

Cataloguedata:

<?xml version="1.0" encoding="UTF-8"?><TRANSFER xmlns="http://www.interlis.ch/INTERLIS2.3">
<HEADERSECTION SENDER="ili2gpkg-4.6.1-63db90def1260a503f0f2d4cb846686cd4851184" VERSION="2.3"><MODELS><MODEL NAME="SimpleCatalogue" VERSION="2022-03-01" URI="https://www.opengis.ch/"></MODEL></MODELS></HEADERSECTION>
<DATASECTION>
<SimpleCatalogue.Catalogues BID="75459a3c-f2e9-4008-b5ff-01d04cde7597">
<SimpleCatalogue.Catalogues.MaterialItem TID="a0e3bb6d-daa0-4cbe-a76f-32b54e5031fe"><Code>other</Code></SimpleCatalogue.Catalogues.MaterialItem>
<SimpleCatalogue.Catalogues.MaterialItem TID="023d9561-265a-42de-8ad7-43161e535764"><Code>wood</Code></SimpleCatalogue.Catalogues.MaterialItem>
<SimpleCatalogue.Catalogues.MaterialItem TID="e15b8919-0451-4cd9-991a-777e15b7ddaf"><Code>stone</Code></SimpleCatalogue.Catalogues.MaterialItem>
</SimpleCatalogue.Catalogues>
</DATASECTION>
</TRANSFER>

Base model

MODEL SimpleBase (en)
AT "mailto:[[email protected]](mailto:[email protected])"
VERSION "2022-04-06" =
  IMPORTS SimpleCatalogue;

  TOPIC Buildings =
    OID AS INTERLIS.UUIDOID;
    DEPENDS ON SimpleCatalogue.Catalogues;

    CLASS House =
      Name : TEXT;
      Format : MANDATORY SimpleCatalogue.Catalogues.MaterialRef;
    END House;

  END Buildings;

END SimpleBase.

Extended model

MODEL SimpleExtend (en)
AT "mailto:[[email protected]](mailto:[email protected])"
VERSION "2022-04-06" =
    IMPORTS SimpleBase;

  TOPIC Buildings 
    EXTENDS SimpleBase.Buildings =
    OID AS INTERLIS.UUIDOID;

    CLASS House (EXTENDED) =
      IsNice : BOOLEAN;
    END House;

  END Buildings;

END SimpleExtend.

Log

java -jar /home/cheapdave/.local/share/QGIS/QGIS3/profiles/tester/python/plugins/QgisModelBaker/libs/modelbaker/iliwrapper/bin/ili2gpkg-4.9.0/ili2gpkg-4.9.0.jar --dbfile /home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplemodel_06.gpkg --trace --verbose --export --exportTid --modeldir /home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats;https://models.interlis.ch/ --exportModels SimpleBase --models SimpleBase;SimpleExtend /home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplebase_export.xtf
Info: dburl <jdbc:sqlite:/home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplemodel_06.gpkg>
Info: dbusr <>
Info: readSettings(): SELECT tag,setting FROM T_ILI2DB_SETTINGS (TransferFromIli.java:698)
Info: ili2gpkg-4.9.0-eb3a0d51869bd2adeeb51fe7aba4b526fe002c1a
Info: ili2c-5.2.8-61f7212579ac3c4ae219d511afb5a0615855bc73
Info: iox-ili-1.21.12-87afbf0c8bd2241377fc518d8c40e4e99946bb23
Info: java.version 18.0.2-ea
Info: [user.name](http://user.name/) <cheapdave>
Info: maxMemory 8163328 KB
Info: currentTime 2022-09-16 12:55:51
Info: dburl <jdbc:sqlite:/home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplemodel_06.gpkg>
Info: dbusr <>
Info: databaseProduct <SQLite>
Info: databaseVersion <3.8.11>
Info: driverName <SQLiteJDBC>
Info: driverVersion <native>
Info: max active DB statements <0>
Info: getBasketSqlIdsFromModel(): SELECT T_Id,topic FROM T_ILI2DB_BASKET (Ili2db.java:2282)
Info: readIliFiles(): SELECT filename,iliversion,modelName FROM T_ILI2DB_MODEL (TransferFromIli.java:454)
Info: compile models...
Info: setRepositories(): uri </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats> (IliManager.java:89)
Info: setRepositories(): uri <https://models.interlis.ch/> (IliManager.java:89)
Info: setIliFiles(): uri <jdbc:sqlite:/home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplemodel_06.gpkg/> (IliManager.java:96)
Info: lookup model <SimpleExtend> in repository </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/>
Info: getIliFiles(): scan ili-files in folder </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/>... (RepositoryAccess.java:109)
Info: lookup model <SimpleBase> 2.3 in repository </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/>
Info: lookup model <SimpleCatalogue> 2.3 in repository </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/>
Info: lookup model <CatalogueObjects_V1> 2.3 in repository </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/>
Info: lookup model <CatalogueObjects_V1> 2.3 in repository <https://models.interlis.ch/>
Info: getIliFiles(): read ilimodels.xml from <https://models.interlis.ch/>... (RepositoryAccess.java:123)
Info: getIliSite(): read ilisite.xml from </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats>... (RepositoryAccess.java:165)
Info: getIliSite(): read ilisite.xml from <https://models.interlis.ch/>... (RepositoryAccess.java:165)
Info: lookup model <CatalogueObjects_V1> 2.3 in repository <http://models.geo.admin.ch/>
Info: getIliFiles(): read ilimodels.xml from <http://models.geo.admin.ch/>... (RepositoryAccess.java:123)
Info: ilifile </home/cheapdave/.ilicache/[models.geo.admin.ch/CH/CHBase_Part3_CATALOGUEOBJECTS_V1.ili](http://models.geo.admin.ch/CH/CHBase_Part3_CATALOGUEOBJECTS_V1.ili)>
Info: ilifile </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/SimpleCatalogue.ili>
Info: ilifile </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/SimpleBase.ili>
Info: ilifile </home/cheapdave/dev/thirdparty/dmAssets/src/SimpleExtendWithCats/SimpleExtend.ili>
Info: addMetaAttrsFromDb(): SELECT ilielement, attr_name, attr_value FROM T_ILI2DB_META_ATTRS (MetaAttrUtility.java:104)
Info: read(): SELECT iliname,tag,setting FROM T_ILI2DB_TRAFO (TrafoConfig.java:46)
Info: runExport(): modelname <SimpleExtend> (Ili2db.java:1808)
Info: runExport(): modelname <SimpleBase> (Ili2db.java:1808)
Info: runExport(): modelname <SimpleBase> (Ili2db.java:1808)
Info: doSmart2(): viewable CatalogueObjects_V1.Catalogues.Item subClass, item (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable CatalogueObjects_V1.Catalogues.CatalogueReference subClass, cataloguereference (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable CatalogueObjects_V1.Catalogues.MandatoryCatalogueReference subClass, mandatorycataloguereference (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable SimpleCatalogue.Catalogues.MaterialItem newAndSubClass, materialitem (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable SimpleCatalogue.Catalogues.MaterialRef newAndSubClass, materialref (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable SimpleBase.Buildings.House newAndSubClass, house (Viewable2TableMapper.java:289)
Info: doSmart2(): viewable SimpleExtend.Buildings.House newAndSubClass, simpleextendbuildings_house (Viewable2TableMapper.java:289)
Info: process data...
Info: data </home/cheapdave/qgis_projects/geolassets_followup/baseexporttest/simplebase_export.xtf>
Info: setConfigValue(): modelele <PARAMETER>, param <areaOverlapValidation>, value <null> (ValidationConfig.java:150)
Info: setConfigValue(): modelele <PARAMETER>, param <defaultGeometryTypeValidation>, value <null> (ValidationConfig.java:150)
Info: setConfigValue(): modelele <PARAMETER>, param <allowOnlyMultiplicityReduction>, value <null> (ValidationConfig.java:150)
Info: assume unknown external objects
Info: first validation pass...
Info: getTopicByBasketId(): SELECT topic,T_Ili_Tid,domains FROM T_ILI2DB_BASKET WHERE T_Id= ? (TransferToXtf.java:422)
Info: SimpleExtend.Buildings BID <8ddfcac3-762e-43e6-a52b-663efea5b241>...
Info: SimpleExtend.Buildings.House...
Info: dumpObjHelper(): SELECT r0.T_Id, r0.T_Ili_Tid,r0.isnice,r0.aname,r0.aformat FROM simpleextendbuildings_house r0 WHERE r0.T_basket=? (TransferToXtf.java:1113)
Info: readObjectTid(): SELECT T_Id,T_Ili_Tid,T_Type FROM (SELECT r1.T_Id, r1.T_Ili_Tid, 'materialitem' T_Type FROM materialitem r1) r0 WHERE r0.T_Id=? (TransferToXtf.java:692)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant