Skip to content
This repository has been archived by the owner on Aug 1, 2022. It is now read-only.

Parser hdbview

Antoaneta edited this page Sep 24, 2021 · 6 revisions

Parser for hdbview

The information on how to develop the design-time data-persistence model for an XSK application using the HDBView syntax

Reference

  • SAP Help

https://help.sap.com/viewer/cc2b23beaa3344aebffa2f6e717df049/2.0.03/en-US/78dcb8e2f4f14b53b0d333bcd24f8721.html

  • Sample Hana version1 syntax
schema="MYSCHEMA";
query="SELECT T1.\"Column2\" FROM \"MYSCHEMA\".\"acme.com.test.views::MY_VIEW1\" AS T1 LEFT JOIN \"MYSCHEMA\".\"acme.com.test.views::MY_VIEW2\" AS T2 ON T1.\"Column1\" = T2.\"Column1\"";
depends_on=["acme.com.test.views::MY_VIEW1", "acme.com.test.views::MY_VIEW2"];
  • Parser Hana version1 behavior (issue)
  1. Currently the Parser take into account if a given property is mandatory.
  2. If the property order is misplaced the parser will still parse the values.
  3. If more than one value of one property is provided then only the last one is taken.
  • Sample HANA version2 syntax
VIEW "hdb_view.db::ItemsByOrderHANAv2"
AS SELECT "Id" FROM "hdb_view::Item";
  • Which syntax is supported from the parser
hdbview syntax (Hana v1) hdbview syntax (XSKViewParser) Comments
schema schema
query query
public public default=true
depends_on depends_on
depends_on_table depends_on_table
depends_on_view depends_on_view

depends_on, depends_on_table and depends_on_view are defining the order of import of the artifacts. For example if there is a project that contains a lots of artifacts as hdbtable and hdbview which depends on each other, in order the Processor to create the artifacts on their dependency the depends* sections in each file must be dinened.

  • Sample

https://github.com/SAP/xsk/tree/main/samples/hdb-view-simple

  • Modules

https://github.com/SAP/xsk/tree/main/modules/parsers/parser-hdbview

https://github.com/SAP/xsk/tree/main/modules/engines/engine-core/src/main/java/com/sap/xsk/hdb/ds/parser/hdbview

  • Tests

https://github.com/SAP/xsk/tree/main/modules/parsers/parser-hdbview/com.sap.xsk.parser.hdbview/src/test/java https://github.com/SAP/xsk/tree/main/modules/engines/engine-core/src/test/java/com/sap/xsk/hdb/ds/test/XSKViewParserTest.java

Project

Architecture

Tips & Tricks

Infrastructure

Troubleshooting guide

Clone this wiki locally