Wandora's configuration file

From WandoraWiki
(Difference between revisions)
Jump to: navigation, search
 
Line 54: Line 54:
 
       <connection2>
 
       <connection2>
 
         <script>create table TOPIC(
 
         <script>create table TOPIC(
−
TOPICID varchar(50) primary key,
+
                TOPICID varchar(50) primary key,
−
BASENAME varchar(900) ,
+
                BASENAME varchar(900) ,
−
SUBJECTLOCATOR varchar(900)  
+
                SUBJECTLOCATOR varchar(900)  
−
);
+
                );
−
 
+
               
−
create table TOPICTYPE(
+
                create table TOPICTYPE(
−
TOPIC varchar(50) not null,
+
                TOPIC varchar(50) not null,
−
TYPE varchar(50) not null,
+
                TYPE varchar(50) not null,
−
foreign key (TOPIC) references TOPIC(TOPICID),
+
                foreign key (TOPIC) references TOPIC(TOPICID),
−
foreign key (TYPE) references TOPIC(TOPICID),
+
                foreign key (TYPE) references TOPIC(TOPICID),
−
primary key(TOPIC,TYPE)
+
                primary key(TOPIC,TYPE)
−
);
+
                );
−
 
+
               
−
create table DATA(
+
                create table DATA(
−
TOPIC varchar(50) not null,
+
                TOPIC varchar(50) not null,
−
TYPE varchar(50) not null,
+
                TYPE varchar(50) not null,
−
VERSION varchar(50) not null,
+
                VERSION varchar(50) not null,
−
DATA longvarchar,
+
                DATA longvarchar,
−
foreign key (TOPIC) references TOPIC(TOPICID),
+
                foreign key (TOPIC) references TOPIC(TOPICID),
−
foreign key (TYPE) references TOPIC(TOPICID),
+
                foreign key (TYPE) references TOPIC(TOPICID),
−
foreign key (VERSION) references TOPIC(TOPICID),
+
                foreign key (VERSION) references TOPIC(TOPICID),
−
primary key(TOPIC,TYPE,VERSION)
+
                primary key(TOPIC,TYPE,VERSION)
−
);
+
                );
−
 
+
               
−
create table VARIANT(
+
                create table VARIANT(
−
VARIANTID varchar(50) primary key,
+
                VARIANTID varchar(50) primary key,
−
TOPIC varchar(50) not null,
+
                TOPIC varchar(50) not null,
−
VALUE longvarchar,
+
                VALUE longvarchar,
−
foreign key (TOPIC) references TOPIC(TOPICID)
+
                foreign key (TOPIC) references TOPIC(TOPICID)
−
);
+
                );
−
 
+
               
−
create table VARIANTSCOPE(
+
                create table VARIANTSCOPE(
−
VARIANT varchar(50) not null,
+
                VARIANT varchar(50) not null,
−
TOPIC varchar(50) not null,
+
                TOPIC varchar(50) not null,
−
foreign key (VARIANT) references VARIANT(VARIANTID),
+
                foreign key (VARIANT) references VARIANT(VARIANTID),
−
foreign key (TOPIC) references TOPIC(TOPICID),
+
                foreign key (TOPIC) references TOPIC(TOPICID),
−
primary key(VARIANT,TOPIC)
+
                primary key(VARIANT,TOPIC)
−
);
+
                );
−
 
+
               
−
create table SUBJECTIDENTIFIER(
+
                create table SUBJECTIDENTIFIER(
−
SI varchar(255) primary key,
+
                SI varchar(255) primary key,
−
TOPIC varchar(50) not null,
+
                TOPIC varchar(50) not null,
−
foreign key (TOPIC) references TOPIC(TOPICID)
+
                foreign key (TOPIC) references TOPIC(TOPICID)
−
);
+
                );
−
 
+
               
−
create table ASSOCIATION(
+
                create table ASSOCIATION(
−
ASSOCIATIONID varchar(50) primary key,
+
                ASSOCIATIONID varchar(50) primary key,
−
TYPE varchar(50) not null,
+
                TYPE varchar(50) not null,
−
foreign key (TYPE) references TOPIC(TOPICID)
+
                foreign key (TYPE) references TOPIC(TOPICID)
−
);
+
                );
−
 
+
               
−
create table MEMBER(
+
                create table MEMBER(
−
ASSOCIATION varchar(50) not null,
+
                ASSOCIATION varchar(50) not null,
−
PLAYER varchar(50) not null,
+
                PLAYER varchar(50) not null,
−
ROLE varchar(50) not null,
+
                ROLE varchar(50) not null,
−
foreign key (ASSOCIATION) references ASSOCIATION(ASSOCIATIONID),
+
                foreign key (ASSOCIATION) references ASSOCIATION(ASSOCIATIONID),
−
foreign key (PLAYER) references TOPIC(TOPICID),
+
                foreign key (PLAYER) references TOPIC(TOPICID),
−
foreign key (ROLE) references TOPIC(TOPICID),
+
                foreign key (ROLE) references TOPIC(TOPICID),
−
primary key(ASSOCIATION,ROLE)
+
                primary key(ASSOCIATION,ROLE)
−
);
+
                );
−
 
+
               
−
create index BASENAME_INDEX ON TOPIC(BASENAME);
+
                create index BASENAME_INDEX ON TOPIC(BASENAME);
−
create index SUBJECTLOCATOR_INDEX ON TOPIC(SUBJECTLOCATOR);
+
                create index SUBJECTLOCATOR_INDEX ON TOPIC(SUBJECTLOCATOR);
−
create index SITOPIC_INDEX on SUBJECTIDENTIFIER(TOPIC);
+
                create index SITOPIC_INDEX on SUBJECTIDENTIFIER(TOPIC);
−
create index ASSOCTYPE_INDEX on ASSOCIATION(TYPE);
+
                create index ASSOCTYPE_INDEX on ASSOCIATION(TYPE);
−
create index MEMBERPLAYER_INDEX on MEMBER(PLAYER);
+
                create index MEMBERPLAYER_INDEX on MEMBER(PLAYER);
−
create index MEMBERROLE_INDEX on MEMBER(ROLE);
+
                create index MEMBERROLE_INDEX on MEMBER(ROLE);
−
create index VARIANTTOPIC_INDEX on VARIANT(TOPIC);
+
                create index VARIANTTOPIC_INDEX on VARIANT(TOPIC);
−
create index DATATOPIC_INDEX on DATA(TOPIC);
+
                create index DATATOPIC_INDEX on DATA(TOPIC);
−
create index DATATYPE_INDEX on DATA(TYPE);
+
                create index DATATYPE_INDEX on DATA(TYPE);
−
create index DATAVERSION_INDEX on DATA(VERSION);</script>
+
                create index DATAVERSION_INDEX on DATA(VERSION);
 +
        </script>
 
         <user>sa</user>
 
         <user>sa</user>
 
         <name>HSQL Memory</name>
 
         <name>HSQL Memory</name>

Revision as of 18:39, 16 November 2006

Wandora keeps all important settings in specific options file. Files locates in build/classes/conf/options.xml. You should edit this file only in emergency. Example of options file is below. 

<?xml version="1.0" encoding="UTF-8"?>
<options>
  <gui>
     <topicTable>
        <hilights>
           <hilight0>
              <color>ff0000</color>
              <si>http://www.wandora.net/core/role</si>
           </hilight0>
        </hilights>
        <leftMouseButtonSelects>true</leftMouseButtonSelects>
     </topicTable>
     <topicPanels>
        <current>Traditional topic panel</current>
        <path1>com/gripstudios/applications/wandora/admin/gui/topicpanels</path1>
     </topicPanels>
     <traditionalTopicPanel>
        <view>
           <typedAssociationPanel>true</typedAssociationPanel>
           <subjectIdentifierRootPanel>true</subjectIdentifierRootPanel>
           <instancesPanel>true</instancesPanel>
           <subjectLocatorIcons>false</subjectLocatorIcons>
           <associationRootPanel>true</associationRootPanel>
           <dataRootPanel>true</dataRootPanel>
           <variantPanel>true</variantPanel>
           <classesRootPanel>true</classesRootPanel>
        </view>
     </traditionalTopicPanel>
     <antiAliasing>false</antiAliasing>
     <topicRenders>130</topicRenders>
     <tabbedTopicPanel>
        <view>
           <dataPanelContainer>true</dataPanelContainer>
           <typedAssociationPanel>true</typedAssociationPanel>
           <classesPanelContainer>true</classesPanelContainer>
           <associationPanelContainer>true</associationPanelContainer>
           <subjectPanelContainer>true</subjectPanelContainer>
           <instancesPanelContainer>true</instancesPanelContainer>
           <variantPanelContainer>true</variantPanelContainer>
        </view>
     </tabbedTopicPanel>
  </gui>
  <dbconnections>
     <connection3>
        <user>sa</user>
        <name>HSQL testdb</name>
        <type>Other</type>
        <constring>jdbc:hsqldb:file:C:\wandora\testdb</constring>
        <pass></pass>
        <driver>org.hsqldb.jdbcDriver</driver>
     </connection3>
     <connection2>
        <script>create table TOPIC(
                TOPICID varchar(50) primary key,
                BASENAME varchar(900) ,
                SUBJECTLOCATOR varchar(900) 
                );
                
                create table TOPICTYPE(
                TOPIC varchar(50) not null,
                TYPE varchar(50) not null,
                foreign key (TOPIC) references TOPIC(TOPICID),
                foreign key (TYPE) references TOPIC(TOPICID),
                primary key(TOPIC,TYPE)
                );
                
                create table DATA(
                TOPIC varchar(50) not null,
                TYPE varchar(50) not null,
                VERSION varchar(50) not null,
                DATA longvarchar,
                foreign key (TOPIC) references TOPIC(TOPICID),
                foreign key (TYPE) references TOPIC(TOPICID),
                foreign key (VERSION) references TOPIC(TOPICID),
                primary key(TOPIC,TYPE,VERSION)
                );
                
                create table VARIANT(
                VARIANTID varchar(50) primary key,
                TOPIC varchar(50) not null,
                VALUE longvarchar,
                foreign key (TOPIC) references TOPIC(TOPICID)
                );
                
                create table VARIANTSCOPE(
                VARIANT varchar(50) not null,
                TOPIC varchar(50) not null,
                foreign key (VARIANT) references VARIANT(VARIANTID),
                foreign key (TOPIC) references TOPIC(TOPICID),
                primary key(VARIANT,TOPIC)
                );
                
                create table SUBJECTIDENTIFIER(
                SI varchar(255) primary key,
                TOPIC varchar(50) not null,
                foreign key (TOPIC) references TOPIC(TOPICID)
                );
                
                create table ASSOCIATION(
                ASSOCIATIONID varchar(50) primary key,
                TYPE varchar(50) not null,
                foreign key (TYPE) references TOPIC(TOPICID)
                );
                
                create table MEMBER(
                ASSOCIATION varchar(50) not null,
                PLAYER varchar(50) not null,
                ROLE varchar(50) not null,
                foreign key (ASSOCIATION) references ASSOCIATION(ASSOCIATIONID),
                foreign key (PLAYER) references TOPIC(TOPICID),
                foreign key (ROLE) references TOPIC(TOPICID),
                primary key(ASSOCIATION,ROLE)
                );
                
                create index BASENAME_INDEX ON TOPIC(BASENAME);
                create index SUBJECTLOCATOR_INDEX ON TOPIC(SUBJECTLOCATOR);
                create index SITOPIC_INDEX on SUBJECTIDENTIFIER(TOPIC);
                create index ASSOCTYPE_INDEX on ASSOCIATION(TYPE);
                create index MEMBERPLAYER_INDEX on MEMBER(PLAYER);
                create index MEMBERROLE_INDEX on MEMBER(ROLE);
                create index VARIANTTOPIC_INDEX on VARIANT(TOPIC);
                create index DATATOPIC_INDEX on DATA(TOPIC);
                create index DATATYPE_INDEX on DATA(TYPE);
                create index DATAVERSION_INDEX on DATA(VERSION);
        </script>
        <user>sa</user>
        <name>HSQL Memory</name>
        <type>Other</type>
        <pass></pass>
        <constring>jdbc:hsqldb:mem:aname</constring>
        <driver>org.hsqldb.jdbcDriver</driver>
     </connection2>
     <connection1>
        <user>wandora</user>
        <name>MySQL test</name>
        <type>MySQL</type>
        <pass>wandora</pass>
        <database>wandora</database>
        <server>127.0.0.1</server>
     </connection1>
     <connection0>
        <user>wandora</user>
        <name>MS SQL Server test</name>
        <type>Microsoft SQL Server</type>
        <pass>wandora</pass>
        <database>wandora</database>
        <server>127.0.0.1</server>
     </connection0>
  </dbconnections>
  <topictreetypes>
     <type1>
        <name>Subclasses</name>
        <assocsi>http://www.topicmaps.org/xtm/1.0/core.xtm#superclass-subclass</assocsi>
        <subsi>http://www.topicmaps.org/xtm/1.0/core.xtm#subclass</subsi>
        <icon>gui/icons/topictree/folder01.png</icon>
        <supersi>http://www.topicmaps.org/xtm/1.0/core.xtm#superclass</supersi>
     </type1>
     <type0>
        <name>Instances</name>
        <assocsi></assocsi>
        <icon>gui/icons/topictree/document01.png</icon>
        <subsi></subsi>
        <supersi></supersi>
     </type0>
  </topictreetypes>
  <documentviewer>explorer __URL__</documentviewer>
  <tools>
     <extract>
        <item3>
           <instanceName>Extract HTML Link Structure Extractor...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.HTMLLinkStructureExtractor</class>
        </item3>
        <item2>
           <instanceName>Extract PS3.0 metadata from JPEGs...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.ExtractFromJPEG</class>
        </item2>
        <item1>
           <instanceName>Extract ID3V[12] from MP3s...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.ExtractFromMP3</class>
        </item1>
        <item0>
           <instanceName>Extract directory structure...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.DirectoryStructureExtractor</class>
        </item0>
        <item6>
           <instanceName>IMDB Extractor...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.IMDBExtractor</class>
        </item6>
        <item5>
           <instanceName>Simple Email Extractor...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.SimpleEmailExtractor</class>
        </item5>
        <item4>
           <instanceName>Simple PDF Extractor...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.extractors.SimplePDFExtractor</class>
        </item4>
     </extract>
     <path8>com/gripstudios/applications/fng/tools</path8>
     <path7>com/gripstudios/applications/wandora/admin/tools/selections</path7>
     <path6>com/gripstudios/applications/wandora/admin/tools/subjects</path6>
     <path5>com/gripstudios/applications/wandora/admin/tools/layers</path5>
     <path4>com/gripstudios/applications/wandora/admin/tools/importers</path4>
     <path3>com/gripstudios/applications/wandora/admin/tools/extractors</path3>
     <path2>com/gripstudios/applications/wandora/admin/tools/exporters</path2>
     <path1>com/gripstudios/applications/wandora/admin/tools</path1>
     <export>
        <item3>
           <instanceName>Export site...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.exporters.ExportSite</class>
        </item3>
        <item2>
           <instanceName>Export schema as topic map...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.exporters.ExportSchemaMap</class>
        </item2>
        <item1>
           <instanceName>Export N3...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.exporters.RDFExport</class>
        </item1>
        <item0>
           <instanceName>Export topic map...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.exporters.ExportTopicMap</class>
        </item0>
        <item4>
           <instanceName>Lucene index builder</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.IndexBuilderTool</class>
        </item4>
     </export>
     <generic>
        <item0>
           <instanceName>About...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.AboutWandora</class>
        </item0>
     </generic>
     <import>
        <item3>
           <instanceName>Simple N3 import...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.importers.SimpleN3Import</class>
        </item3>
        <item2>
           <instanceName>Simple RDF(S) import...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.importers.SimpleRDFImport</class>
        </item2>
        <item1>
           <instanceName>Transform and merge xml...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.importers.XSLImport</class>
        </item1>
        <item0>
           <instanceName>Merge topic map...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.importers.TopicMapImport</class>
        </item0>
        <item4>
           <instanceName>SQL topic map import...</instanceName>
           <class>com.gripstudios.applications.wandora.admin.tools.importers.SQLTopicMapImport</class>
        </item4>
     </import>
  </tools>
  <basemap>classes/conf/wandora.xtm</basemap>
  <remoteconnections>
     <connection0>
        <user>admin</user>
        <port>8989</port>
        <name>example</name>
        <pass>wandorapass</pass>
        <host>127.0.0.1</host>
        <map>mytopicmap</map>
     </connection0>
  </remoteconnections>
  <shortcuts>
     <cut0>http://www.fng.fi/wandora/wandora-fng.xtm#kp-teos</cut0>
  </shortcuts>
  <defaultSIprefix>http://www.wandora.net/SI</defaultSIprefix>
  <current>
     <directory>C:\Documents and Settings\akivela\Desktop\fng.wpr</directory>
     <user></user>
     <port></port>
     <host></host>
     <map></map>
  </current>
  <window>
     <height>607</height>
     <horizontalsplitter>200</horizontalsplitter>
     <x>108</x>
     <verticalsplitter>300</verticalsplitter>
     <width>900</width>
     <y>24</y>
  </window>
  <regexp>
     <expression0>
        <partialMatch>true</partialMatch>
        <caseSensitive>true</caseSensitive>
        <name>flip name</name>
        <replacement>$2 - $1</replacement>
        <pattern>(.+) - (.+)</pattern>
     </expression0>
  </regexp>
  <bsh>
     <path></path>
  </bsh>
  <trees>
     <tree0>
        <root>http://www.wandora.net/core/wandoraclass</root>
        <name>Topics</name>
        <association1>Subclasses</association1>
        <association0>Instances</association0>
     </tree0>
  </trees>
</options>
Retrieved from "http://wandora.org/w/index.php?title=Wandora%27s_configuration_file&oldid=2103"
Personal tools