hdbview - codbex/codbex-kronos GitHub Wiki
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
- Currently the parser takes into account if a given property is mandatory.
- If the property order is misplaced the parser will still parse the values.
- 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
- Processor
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