📄 pctest.csx
字号:
<?xml version="1.0" encoding="UTF-8"?>
<!--
This is an example conceptual schema for ToscanaJ.
It is meant to be used together with a database as defined by the SQL script
pctest.sql, which should have been provided along this file. With the setup
given this script will be loaded into the embedded database system.
If you want to use another DBMS, you have to change the definition from using
the <embed> element into something like:
<url driver="sun.jdbc.odbc.JdbcOdbcDriver" user="user" password="secret">
jdbc:odbc:PCTest80
</url>
In this example the JDBC-ODBC bridge is used to connect to a data source named
"PCTest80" with the given username/password combination.
Refer to the documentation of your DBMS which class and URL scheme to use.
-->
<conceptualSchema version="TJ1.0">
<description>
<externalHTML url="pctest.html" />
</description>
<databaseConnection>
<embed url="pctest.sql" />
<table>PCTest</table>
<key>PCname</key>
</databaseConnection>
<views>
<objectView name="HTML View..." class="net.sourceforge.toscanaj.dbviewer.HTMLDatabaseViewer">
<template>
<html>
<body>
<h1>
<field content="PCname" />
</h1>
<table border="1" width="100%">
<tr>
<th colspan="2">Features</th>
</tr>
<tr>
<td>Type of case:</td>
<td>
<field content="typeCase" />
</td>
</tr>
<tr>
<td>Size of harddisk:</td>
<td>
<field content="harddisk" />
</td>
</tr>
<tr>
<td>Bus system:</td>
<td>
<field content="typeBus" />
</td>
</tr>
<tr>
<td>Software:</td>
<td>
<field content="software" />
</td>
</tr>
</table>
<div align="right">
<font size="+1">
<b>
Price:
<field content="price" />
</b>
</font>
</div>
</body>
</html>
</template>
</objectView>
<objectView name="HTML View (Color)..." class="net.sourceforge.toscanaj.dbviewer.HTMLDatabaseViewer">
<template url="views/coloredSummary.html" />
</objectView>
<objectView name="Short View..." class="net.sourceforge.toscanaj.dbviewer.SimpleDatabaseViewer">
<template url="views/simple.txt" />
<parameter name="openDelimiter" value="$" />
<parameter name="closeDelimiter" value="$" />
</objectView>
<objectListView name="HTML Report..." class="net.sourceforge.toscanaj.dbviewer.HTMLDatabaseViewer">
<template url="views/listView.html" />
</objectListView>
<objectListView name="Benchmark View..." class="net.sourceforge.toscanaj.dbviewer.BarChartDatabaseViewer">
<template>
<column sqlname="dosmark" displayname="Dos Benchmark" mincolor="#00ffff" maxcolor="#ff00ff" linecolor="#ff0000" />
<column sqlname="diskmark" displayname="Disk Benchmark" mincolor="#00ffff" maxcolor="#ff00ff" linecolor="#ff0000" />
<column sqlname="price" displayname="Price" mincolor="#ff0000" maxcolor="#ffff00" linecolor="#ffffff" />
</template>
</objectListView>
<objectListView name="Video/Graphics View..." class="net.sourceforge.toscanaj.dbviewer.BarChartDatabaseViewer">
<template>
<column sqlname="video" displayname="Video" mincolor="#00ffff" maxcolor="#ff00ff" linecolor="#ff0000" />
<column sqlname="graphics" displayname="Graphics" mincolor="#00ffff" maxcolor="#ff00ff" linecolor="#ff0000" />
<column sqlname="price" displayname="Price" mincolor="#ff0000" maxcolor="#ffff00" linecolor="#ffffff" />
</template>
</objectListView>
<!-- This one is just showing syntax, it does not do anything useful. It would if the program would be found
and there would be a table AttributeURLs, mapping AttributeNames to DescriptionURLs.
since we don't have those, we don't actually use the setting. -->
<!--
<attributeView class="net.sourceforge.toscanaj.dbviewer.ProgramCallDatabaseViewer" name="Open description...">
<parameter name="openDelimiter" value="$$$"/>
<parameter name="closeDelimiter" value="%%%"/>
<parameter name="commandLine" value="/some/path/to/mozilla/bin/mozilla $$$DescriptionURL%%%"/>
<table>AttributeURLs</table>
<key>AttributeName</key>
</attributeView>
-->
</views>
<queries>
<distinctListQuery name="Cases">
<queryField>typeCase</queryField>
</distinctListQuery>
<listQuery name="Name with type of case" head="Case: ">
<queryField name="Case" separator=" - PC: ">typeCase</queryField>
<queryField name="Name">PCname</queryField>
</listQuery>
<aggregateQuery name="Average Price">
<queryField format="$ 0.00">AVG(price)</queryField>
</aggregateQuery>
<aggregateQuery name="Average Price (relative)">
<queryField format="$ 0.00" separator=" (">AVG(price)</queryField>
<queryField format="0.00 %" relative="true" separator=")">AVG(price)</queryField>
</aggregateQuery>
<aggregateQuery name="Min/Max Prices">
<queryField separator=" - " format="$0.00">MIN(price)</queryField>
<queryField format="$0.00">MAX(price)</queryField>
</aggregateQuery>
<aggregateQuery name="Counts (relative)">
<queryField separator=" (">count(*)</queryField>
<queryField format="0.00 %" relative="true" separator=")">count(*)</queryField>
</aggregateQuery>
</queries>
<diagram title="Prices for 486/66 PCs">
<description>
<html>
<body>
<h1>Prices</h1>
This diagrams gives a general overview on the price distribution
in the PC set.
</body>
</html>
</description>
<node id="1">
<position x="0.0" y="-0.0" />
<attributeLabelStyle>
<offset x="-3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>right</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent />
</concept>
</node>
<node id="2">
<position x="20.0" y="20.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute>>=2500$</attribute>
</attributeContingent>
</concept>
</node>
<node id="3">
<position x="40.0" y="40.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute>>=3000$</attribute>
</attributeContingent>
</concept>
</node>
<node id="4">
<position x="60.0" y="60.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute>>=3500$</attribute>
</attributeContingent>
</concept>
</node>
<node id="5">
<position x="80.0" y="80.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute>>=4000$</attribute>
</attributeContingent>
</concept>
</node>
<node id="6">
<position x="100.0" y="100.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute>>=4500$</attribute>
</attributeContingent>
</concept>
</node>
<node id="7">
<position x="120.0" y="120.0" />
<attributeLabelStyle>
<offset x="3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="4.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>center</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent>
<object>price>=5000</object>
</objectContingent>
<attributeContingent>
<attribute>>=5000$</attribute>
</attributeContingent>
</concept>
</node>
<node id="8">
<position x="-20.0" y="20.0" />
<attributeLabelStyle>
<offset x="-3.0" y="-3.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>right</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent>
<attribute><5000$</attribute>
</attributeContingent>
</concept>
</node>
<node id="9">
<position x="0.0" y="40.0" />
<attributeLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent />
</concept>
</node>
<node id="10">
<position x="20.0" y="60.0" />
<attributeLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
<attributeContingent />
</concept>
</node>
<node id="11">
<position x="40.0" y="80.0" />
<attributeLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</attributeLabelStyle>
<objectLabelStyle>
<offset x="0.0" y="-0.0" />
<backgroundColor>#ffffffff</backgroundColor>
<textColor>#ff000000</textColor>
<textAlignment>left</textAlignment>
</objectLabelStyle>
<concept>
<objectContingent />
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -