hdbview

SQL Views (.hdbview)

This object type represents a database view.

Reference

The information on how to develop the design-time data-persistence view model for a Kronos application.

SAP Help

https://help.sap.com/docs/SAP_HANA_PLATFORM/58d81eb4c9bc4899ba972c9fe7a1a115/0e3dd028eb394e8b9c6e17c29eb7e6ca.html https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/2bf9a6f2db824fbd84315196a9c318d5.html

Sample Hana Version 1 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 Version 1 Behavior

1. Currently the parser takes 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 Version 2 Syntax

VIEW "hdb_view.db::ItemsByOrderHANAv2"
AS SELECT "Id" FROM "hdb_view::Item";

Sample

https://github.com/codbex/codbex-kronos/tree/main/samples/hdb-view-simple

Modules

• ANTLR Parser

https://github.com/codbex/codbex-kronos/tree/main/modules/parsers/parser-hdbview/src/main

• Data Structure Parser

https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/main/java/com/codbex/kronos/hdb/ds/parser/hdbview

• Processor

https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/main/java/com/codbex/kronos/hdb/ds/processors/view

Unit Tests

https://github.com/codbex/codbex-kronos/tree/main/modules/parsers/parser-hdbview/src/test https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/parser/hdbview https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/processors/view

Integration Tests

https://github.com/codbex/codbex-kronos/tree/main/integration-tests/engine-hdb/src/test/java/com/codbex/kronos/integration/tests/hdb/ds/itest/hdbview