Skip to content

Instantly share code, notes, and snippets.

@phantomjinx

phantomjinx/gist:4c286689d6f0ecd94734660cfb18417d

Created February 17, 2017 11:20
Show Gist options
  • Save phantomjinx/4c286689d6f0ecd94734660cfb18417d to your computer and use it in GitHub Desktop.
Save phantomjinx/4c286689d6f0ecd94734660cfb18417d to your computer and use it in GitHub Desktop.
Download ZIP
Portfolio Vdb laid out in modeshape workspace
Raw
gistfile1.txt
Portfolio
@vdb:description=The Portfolio Dynamic VDB
@mode:sha1=2ca93bbcc42cb322bba4e949a57e1bb289464509
@jcr:uuid=86f8cf4c-684b-4be5-8d26-88e1eb126dfb
@jcr:primaryType=vdb:virtualDatabase
@vdb:originalFile=/tko:komodo/tko:workspace/user/Portfolio
@vdb:preview=false
@vdb:version=1
@UseConnectorMetadata=true
@vdb:name=Portfolio
jcr:content
@jcr:primaryType=nt:unstructured
@jcr:data=<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="Portfolio" version="1">
<description>The Portfolio Dynamic VDB</description>
<!--
Setting to use connector supplied metadata. Can be "true" or "cached".
"true" will obtain metadata once for every launch of Teiid.
"cached" will save a file containing the metadata into
the deploy/<vdb name>/<vdb version/META-INF directory
-->
<property name="UseConnectorMetadata" value="true" />
<!--
Each model represents a access to one or more sources.
The name of the model will be used as a top level schema name
for all of the metadata imported from the connector.
NOTE: Multiple models, with different import settings, can be bound to
the same connector binding and will be treated as the same source at
runtime.
-->
<model name="MarketData">
<!--
Each source represents a translator and data source. There are
pre-defined translators, or you can create one.
-->
<source name="text-connector" translator-name="file" connection-jndi-name="java:/marketdata-file"/>
</model>
<model name="Accounts">
<!--
JDBC Import settings
importer.useFullSchemaName directs the importer to drop the source
schema from the Teiid object name, so that the Teiid fully qualified name
will be in the form of <model name>.<table name>
-->
<property name="importer.useFullSchemaName" value="false"/>
<!--
This connector is defined to reference the H2 localDS"
-->
<source name="h2-connector" translator-name="h2" connection-jndi-name="java:/accounts-ds"/>
</model>
<model name="PersonalValuations">
<property name="importer.headerRowNumber" value="1"/>
<property name="importer.ExcelFileName" value="otherholdings.xls"/>
<source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
<metadata type="DDL"><![CDATA[
SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
CREATE FOREIGN TABLE Sheet1 (
ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
ACCOUNT_ID integer OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
PRODUCT_TYPE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
PRODUCT_VALUE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
]]> </metadata>
</model>
<model name="Stocks" type="VIRTUAL">
<metadata type="DDL"><![CDATA[
CREATE VIEW StockPrices (
symbol string,
price bigdecimal
)
AS
SELECT SP.symbol, SP.price
FROM (EXEC MarketData.getTextFiles('*.txt')) AS f,
TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) AS SP;
CREATE VIEW Stock (
product_id integer,
symbol string,
price bigdecimal,
company_name varchar(256)
)
AS
SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME
FROM StockPrices AS S, Accounts.PRODUCT AS A
WHERE S.symbol = A.SYMBOL;
]]> </metadata>
</model>
<model name="StocksMatModel" type="VIRTUAL">
<metadata type="DDL"><![CDATA[
CREATE view stockPricesMatView
(
product_id integer,
symbol string,
price bigdecimal,
company_name varchar(256)
) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE',
MATERIALIZED_TABLE 'Accounts.h2_stock_mat',
"teiid_rel:MATVIEW_TTL" 120000,
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native('''')',
"teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''',
"teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat',
"teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
"teiid_rel:MATVIEW_STATUS_TABLE" 'status',
"teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE',
"teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION')
AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME
FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A
WHERE S.symbol = A.SYMBOL;
]]>
</metadata>
</model>
</vdb>
MarketData
@jcr:uuid=9f25350b-069e-4a86-9618-bb84cbe046d6
@jcr:primaryType=vdb:declarativeModel
@mmcore:modelType=PHYSICAL
@vdb:visible=true
@vdb:metadataType=DDL
vdb:sources
@jcr:primaryType=vdb:sources
text-connector
@jcr:primaryType=vdb:source
@vdb:sourceJndiName=java:/marketdata-file
@vdb:sourceTranslator=file
Accounts
@jcr:uuid=68b929b6-f8ec-4d0c-94cf-508ffac3013b
@jcr:primaryType=vdb:declarativeModel
@importer.useFullSchemaName=false
@mmcore:modelType=PHYSICAL
@vdb:visible=true
@vdb:metadataType=DDL
vdb:sources
@jcr:primaryType=vdb:sources
h2-connector
@jcr:primaryType=vdb:source
@vdb:sourceJndiName=java:/accounts-ds
@vdb:sourceTranslator=h2
PersonalValuations
@importer.ExcelFileName=otherholdings.xls
@jcr:uuid=f94f3e96-7e20-4a5b-a57d-e280dacbab92
@jcr:primaryType=vdb:declarativeModel
@mmcore:modelType=PHYSICAL
@importer.headerRowNumber=1
@vdb:visible=true
@vdb:modelDefinition=SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; CREATE FOREIGN TABLE Sheet1 ( ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), ACCOUNT_ID integer OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), PRODUCT_TYPE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), PRODUCT_VALUE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), CONSTRAINT PK0 PRIMARY KEY(ROW_ID) ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
@vdb:metadataType=DDL
vdb:sources
@jcr:primaryType=vdb:sources
excelconnector
@jcr:primaryType=vdb:source
@vdb:sourceJndiName=java:/excel-file
@vdb:sourceTranslator=excel
teiid_excel
@ddl:startCharIndex=0
@teiidddl:uri=http://www.teiid.org/translator/excel/2014
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:optionNamespace]
@ddl:expression=SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
@ddl:length=74
@ddl:startLineNumber=1
@ddl:startColumnNumber=1
Sheet1
@ddl:startCharIndex=75
@teiidddl:schemaElementType=FOREIGN
@jcr:uuid=636a3042-d07e-4b4f-87f6-6bbd8e4f70d4
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:createTable]
@ddl:expression=CREATE FOREIGN TABLE Sheet1 ( ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), ACCOUNT_ID integer OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), PRODUCT_TYPE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), PRODUCT_VALUE string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), CONSTRAINT PK0 PRIMARY KEY(ROW_ID) ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
@ddl:length=512
@ddl:startLineNumber=1
@ddl:startColumnNumber=76
ROW_ID
@ddl:nullable=NULL
@jcr:uuid=f9cafe1a-445a-4a72-a5ed-58f91e3c56d3
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=INTEGER
SEARCHABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=All_Except_Like
teiid_excel:CELL_NUMBER
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=ROW_ID
ACCOUNT_ID
@ddl:nullable=NULL
@jcr:uuid=9f98c258-41e9-4524-a88d-77a12276e5a0
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=INTEGER
SEARCHABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=Unsearchable
teiid_excel:CELL_NUMBER
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=1
PRODUCT_TYPE
@ddl:nullable=NULL
@jcr:uuid=6eb82152-c3fd-4219-bdfa-d14481fcf7ce
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=STRING
SEARCHABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=Unsearchable
teiid_excel:CELL_NUMBER
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=2
PRODUCT_VALUE
@ddl:nullable=NULL
@jcr:uuid=024e863a-dec8-4cbc-ad13-33a2c7ad63d3
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=STRING
SEARCHABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=Unsearchable
teiid_excel:CELL_NUMBER
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=3
PK0
@teiidddl:constraintType=PRIMARY KEY
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElementConstraint]
@teiidddl:tableElementRefs=[/tko:komodo/tko:workspace/user/Portfolio/PersonalValuations/Sheet1/ROW_ID]
teiid_excel:FIRST_DATA_ROW_NUMBER
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=2
teiid_excel:FILE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=otherholdings.xls
Stocks
@jcr:uuid=23bfc69b-eb38-46f5-a97c-fed3da59cb93
@jcr:primaryType=vdb:declarativeModel
@mmcore:modelType=VIRTUAL
@vdb:visible=true
@vdb:modelDefinition=CREATE VIEW StockPrices ( symbol string, price bigdecimal ) AS SELECT SP.symbol, SP.price FROM (EXEC MarketData.getTextFiles('*.txt')) AS f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) AS SP; CREATE VIEW Stock ( product_id integer, symbol string, price bigdecimal, company_name varchar(256) ) AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL;
@vdb:metadataType=DDL
StockPrices
@ddl:startCharIndex=0
@teiidddl:schemaElementType=VIRTUAL
@jcr:uuid=ae58ed6c-f637-4da2-a808-ea4a61dd7cf8
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:createView]
@ddl:expression=CREATE VIEW StockPrices ( symbol string, price bigdecimal ) AS SELECT SP.symbol, SP.price FROM (EXEC MarketData.getTextFiles('*.txt')) AS f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) AS SP;
@ddl:length=212
@ddl:startLineNumber=1
@ddl:startColumnNumber=1
@teiidddl:queryExpression=SELECT SP.symbol, SP.price FROM (EXEC MarketData.getTextFiles('*.txt')) AS f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) AS SP
symbol
@ddl:nullable=NULL
@jcr:uuid=af6a1315-2de2-47e8-a06c-42d96532f883
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=STRING
price
@ddl:nullable=NULL
@jcr:uuid=26c7ada4-07e9-403f-97e0-9355c150c4c3
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=BIGDECIMAL
tsqlquery
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:query]
@tsql:isResolved=false
@tsql:type=1
@tsql:teiidVersion=9.1.1
tsqlselect
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:select]
@tsql:distinct=false
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=symbol
@tsql:outputName=SP.symbol
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=SP.symbol
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=SP
@tsql:outputName=SP
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=SP
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=price
@tsql:outputName=SP.price
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=SP.price
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=SP
@tsql:outputName=SP
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=SP
@tsql:teiidVersion=9.1.1
tsqlfrom
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:from]
@tsql:teiidVersion=9.1.1
tsqlclauses
@tsql:table=false
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:subqueryFromClause]
@tsql:name=f
@tsql:optional=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlcommand
@tsql:callableStatement=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:storedProcedure]
@tsql:isResolved=false
@tsql:calledWithReturn=false
@tsql:type=6
@tsql:teiidVersion=9.1.1
@tsql:displayNamedParameters=false
@tsql:procedureName=MarketData.getTextFiles
tsqlgroup
@tsql:shortName=getTextFiles
@tsql:outputName=MarketData.getTextFiles
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=MarketData.getTextFiles
@tsql:teiidVersion=9.1.1
tsqlparameters
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:spParameter]
@tsql:teiidVersion=9.1.1
@tsql:index=1
@tsql:parameterType=1
@tsql:usingDefault=false
@tsql:varArg=false
tsqlexpression
@tsql:multiValued=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:constant]
@tsql:value=*.txt
@tsql:teiidVersion=9.1.1
@tsql:typeClass=STRING
tsqlclauses
@tsql:header=1
@tsql:name=SP
@tsql:optional=false
@tsql:fixedWidth=false
@tsql:usingRowDelimiter=true
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:textTable]
@tsql:escape=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlfile
@tsql:shortName=file
@tsql:outputName=f.file
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=f.file
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=f
@tsql:outputName=f
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=f
@tsql:teiidVersion=9.1.1
tsqlcolumns
@tsql:noTrim=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:textColumn]
@tsql:name=symbol
@tsql:type=string
@tsql:ordinal=false
@tsql:teiidVersion=9.1.1
tsqlcolumns
@tsql:noTrim=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:textColumn]
@tsql:name=price
@tsql:type=bigdecimal
@tsql:ordinal=false
@tsql:teiidVersion=9.1.1
Stock
@ddl:startCharIndex=213
@teiidddl:schemaElementType=VIRTUAL
@jcr:uuid=cdf59185-f400-4ba0-98b9-965592066930
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:createView]
@ddl:expression=CREATE VIEW Stock ( product_id integer, symbol string, price bigdecimal, company_name varchar(256) ) AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL;
@ddl:length=222
@ddl:startLineNumber=1
@ddl:startColumnNumber=214
@teiidddl:queryExpression=SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL
product_id
@ddl:nullable=NULL
@jcr:uuid=436af506-3f36-4568-a80d-1e4285699a58
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=INTEGER
symbol
@ddl:nullable=NULL
@jcr:uuid=cb570068-cd8d-4b71-831a-760099966933
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=STRING
price
@ddl:nullable=NULL
@jcr:uuid=ed8b059d-888b-4c26-99b0-d355fb6c9911
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=BIGDECIMAL
company_name
@ddl:nullable=NULL
@jcr:uuid=2631990c-9b66-45fb-a706-0e2ba9b6f84d
@jcr:primaryType=nt:unstructured
@ddl:datatypeLength=256
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=VARCHAR
tsqlquery
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:query]
@tsql:isResolved=false
@tsql:type=1
@tsql:teiidVersion=9.1.1
tsqlselect
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:select]
@tsql:distinct=false
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=ID
@tsql:outputName=A.ID
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.ID
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=symbol
@tsql:outputName=S.symbol
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.symbol
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=price
@tsql:outputName=S.price
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.price
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=COMPANY_NAME
@tsql:outputName=A.COMPANY_NAME
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.COMPANY_NAME
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlfrom
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:from]
@tsql:teiidVersion=9.1.1
tsqlclauses
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:unaryFromClause]
@tsql:optional=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlgroup
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@tsql:definition=StockPrices
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlclauses
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:unaryFromClause]
@tsql:optional=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlgroup
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@tsql:definition=Accounts.PRODUCT
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlcriteria
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:compareCriteria]
@tsql:operator=EQ
@tsql:optional=false
@tsql:teiidVersion=9.1.1
tsqlrightExpression
@tsql:shortName=SYMBOL
@tsql:outputName=A.SYMBOL
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.SYMBOL
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlleftExpression
@tsql:shortName=symbol
@tsql:outputName=S.symbol
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.symbol
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
StocksMatModel
@jcr:uuid=81e5328d-8a0e-497c-a028-cf6a14ab5109
@jcr:primaryType=vdb:declarativeModel
@mmcore:modelType=VIRTUAL
@vdb:visible=true
@vdb:modelDefinition=CREATE view stockPricesMatView ( product_id integer, symbol string, price bigdecimal, company_name varchar(256) ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', MATERIALIZED_TABLE 'Accounts.h2_stock_mat', "teiid_rel:MATVIEW_TTL" 120000, "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native('''')', "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''', "teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat', "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', "teiid_rel:MATVIEW_STATUS_TABLE" 'status', "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE', "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION') AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL;
@vdb:metadataType=DDL
stockPricesMatView
@ddl:startCharIndex=0
@teiidddl:schemaElementType=VIRTUAL
@jcr:uuid=67339d89-2179-40e4-baa0-fde804bcb860
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:createView]
@ddl:expression=CREATE view stockPricesMatView ( product_id integer, symbol string, price bigdecimal, company_name varchar(256) ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', MATERIALIZED_TABLE 'Accounts.h2_stock_mat', "teiid_rel:MATVIEW_TTL" 120000, "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native('''')', "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''', "teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat', "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', "teiid_rel:MATVIEW_STATUS_TABLE" 'status', "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE', "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION') AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL;
@ddl:length=892
@ddl:startLineNumber=1
@ddl:startColumnNumber=1
@teiidddl:queryExpression=SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL
product_id
@ddl:nullable=NULL
@jcr:uuid=eb2c3982-d240-44d9-885c-84c24ff69742
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=INTEGER
symbol
@ddl:nullable=NULL
@jcr:uuid=498bee44-9df2-4f63-a81c-4b66c4b059eb
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=STRING
price
@ddl:nullable=NULL
@jcr:uuid=65f50541-389c-468a-aad8-aaaca289d5c1
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=BIGDECIMAL
company_name
@ddl:nullable=NULL
@jcr:uuid=9dba1320-5abd-44a3-b51a-c6e3cb9cb010
@jcr:primaryType=nt:unstructured
@ddl:datatypeLength=256
@jcr:mixinTypes=[teiidddl:tableElement]
@teiidddl:autoIncrement=false
@ddl:datatypeArrayDimensions=0
@ddl:datatypeName=VARCHAR
UPDATABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=TRUE
teiid_relALLOW_MATVIEW_MANAGEMENT
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=true
teiid_relMATVIEW_ONERROR_ACTION
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=THROW_EXCEPTION
teiid_relMATVIEW_AFTER_LOAD_SCRIPT
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=execute accounts.native('''')
teiid_relMATVIEW_SHARE_SCOPE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=NONE
MATERIALIZED_TABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=Accounts.h2_stock_mat
teiid_relMATVIEW_TTL
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=120000
teiid_relON_VDB_DROP_SCRIPT
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''
teiid_relMATVIEW_STATUS_TABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=status
MATERIALIZED
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=TRUE
teiid_relMATVIEW_BEFORE_LOAD_SCRIPT
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=execute accounts.native(''truncate table h2_stock_mat'');
teiid_relMATERIALIZED_STAGE_TABLE
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[ddl:statementOption]
@ddl:value=Accounts.h2_stock_mat
tsqlquery
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:query]
@tsql:isResolved=false
@tsql:type=1
@tsql:teiidVersion=9.1.1
tsqlselect
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:select]
@tsql:distinct=false
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=ID
@tsql:outputName=A.ID
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.ID
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=symbol
@tsql:outputName=S.symbol
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.symbol
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=price
@tsql:outputName=S.price
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.price
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlsymbols
@tsql:shortName=COMPANY_NAME
@tsql:outputName=A.COMPANY_NAME
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.COMPANY_NAME
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlfrom
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:from]
@tsql:teiidVersion=9.1.1
tsqlclauses
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:unaryFromClause]
@tsql:optional=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlgroup
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@tsql:definition=Stocks.StockPrices
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
tsqlclauses
@tsql:noUnnest=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:unaryFromClause]
@tsql:optional=false
@tsql:teiidVersion=9.1.1
@tsql:makeNotDep=false
@tsql:preserve=false
tsqlgroup
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@tsql:definition=Accounts.PRODUCT
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlcriteria
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:compareCriteria]
@tsql:operator=EQ
@tsql:optional=false
@tsql:teiidVersion=9.1.1
tsqlrightExpression
@tsql:shortName=SYMBOL
@tsql:outputName=A.SYMBOL
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=A.SYMBOL
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=A
@tsql:outputName=A
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=A
@tsql:teiidVersion=9.1.1
tsqlleftExpression
@tsql:shortName=symbol
@tsql:outputName=S.symbol
@jcr:primaryType=nt:unstructured
@tsql:displayMode=OUTPUT_NAME
@jcr:mixinTypes=[tsql:elementSymbol]
@tsql:name=S.symbol
@tsql:displayFullyQualified=false
@tsql:externalReference=false
@tsql:teiidVersion=9.1.1
@tsql:typeClass=NULL
tsqlgroupSymbol
@tsql:shortName=S
@tsql:outputName=S
@tsql:procedure=false
@jcr:primaryType=nt:unstructured
@jcr:mixinTypes=[tsql:groupSymbol]
@tsql:name=S
@tsql:teiidVersion=9.1.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment