XML files in xmlmetadata directory describe properties and structure of objects that can be created with Oracle SQL Developer Data Modeler UI or using scripting. They are used by Data Modeler (DM) in its functionality thus any changes introduced to them could break normal functionality of DM.
XML files follow internal object model used by DM and all properties of specific object can be found following parent class link. There is an HTML presentation of XML files in doc directory (use index.html) which allow faster navigation in class hierarchy direct descendents of each class are also presented there.
Two important groups can be found in each XML file properties and collections. They can be marked as external which means that property or collection is stored outside the file that represents the object. As example Table has internal collection columns i.e. columns are stored in the file that represents table; RelationalDesign class (representing relational model) has external collection Tables. Design class (representing the whole design) has external property LogicalModel and external collection RelationalModels.
Each property has getter and setter method defined that can be used to get property or set it using scripting. Collection definition provide createItem method that can be used to create item of that collection using instance of surrounding object back to Tables collection we see that table can be created using model.createTable().
ModelObject is the root of the hierarchy and each model is also instance of DesignPart class.
Changed object should be marked as changed using setDirty(true) method otherwise they wont be saved during save operation.
Each collection with type xxxxxSet allows objects to be found by name ( method getByName(name) ) and by object ID (method getObjectByID(objectID) ). Collections for tables and views in relational model also allows object to be found by schema and name using method getBySchemaAndName(schema, name). Method iterator() can be used to iterate over objects or toArray() to get them in array.
Each object has unique ID (method getObjectID() ) that can be used to get the object using method of Design instance in scripting itll be model.getDesign().getDesignObject( ID ) - that doesnt cover objects in physical models. Objects in relational and data types models have counterpart in physical model that has the same ID and can be found through instance of physical model (StorageDesign class) for relational model model.getStorageDesign().getStorageObject( ID ).
Though DM store design in set of directories and files, one can use scripting to store the whole design (or one model) into single file and to restore the status from such file:
- Saving:
model.getAppView().getXMLTransformationManager().saveObjectWithExternals("D:/SVN_Local_files/handy_whole_des_big.xml",model.getDesign());
- Loading
Since design will take the status as its stored in the file its good to be sure design is empty method isEmpty() can be used for models (DesignPart class).
model.getAppView().getXMLTransformationManager().loadObjectWithExternals("D:/SVN_Local_files/handy_whole_des_big.xml",model.getDesign());
Note about physical models only Oracle physical models are described in current revision of XML metadata thus non Oracle physical models cannot be saved into single file.
Difference between transformation and design rule design rule is invoked for each object its set to while transformation is invoked only once.
Objects appearing in search result are available using method getLastSearchResult() of model or physical model. Following code will cycle through all objects in search result:
objs = model.getLastSearchResult().toArray();
for(var i = 0;i<objs.length;i++){
obj = objs[i];
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
oracle datamodeler 数据建模绿色版 (1765个子文件)
ANTLR-LICENSE 1KB
ide.boot 3KB
ojwebupdate.boot 1006B
datamodeler.boot 769B
ide.conf 6KB
jdk.conf 5KB
ojwebupdate.conf 2KB
swing-thread-violations.conf 2KB
datamodeler.conf 2KB
datamodeler-Darwin.conf 408B
logging.conf 362B
ide-logging-debug.conf 327B
ide-logging.conf 252B
ojwebupdate-logging.conf 247B
headless-logging.conf 141B
headless-logging-debug.conf 138B
COPYING 3KB
COPYING 3KB
osddm_main.css 4KB
main.css 3KB
osddm_vs.css 2KB
footer_style.css 1KB
osddm_toc_tree.css 1KB
ABBREVS_SAMPLE.csv 45KB
plurals.csv 2KB
datamodeler 3KB
launcher64.dll 164KB
launcher.dll 132KB
jnidispatch-422.dll 130KB
idenative64.dll 125KB
idenative.dll 109KB
jnidispatch-422.dll 102KB
SQLDeveloperDataModelerScripting.docx 845KB
libLaunchService.dylib 10KB
datamodeler64W.exe 77KB
datamodeler64.exe 77KB
datamodeler.exe 77KB
datamodelerW.exe 77KB
datamodeler.exe 77KB
product64.exe 9KB
product.exe 8KB
details.html 2.81MB
list.html 77KB
creating_themes.html 26KB
welcome.html 7KB
index.html 290B
oracle.ide.sqldev.bundles.info 11KB
bundles.info 4KB
oracle.datamodeler.jar 23.13MB
pdfbox-app-2.0.2.jar 7.57MB
oracle.sqldeveloper.jar 7MB
dbtools-common.jar 6.77MB
poi-ooxml-schemas.jar 5.65MB
oracle.ide.jar 5.57MB
saxon-9.1.0.8.jar 4.81MB
svnkit.jar 4.02MB
dvt-jclient.jar 3.95MB
ojdbc8.jar 3.85MB
batik-all-1.8.jar 3.33MB
javatools-nodeps.jar 3.16MB
xalan-2.7.0.jar 2.94MB
xmlbeans.jar 2.6MB
poi.jar 2.58MB
xmlbeans-2.3.0.jar 2.54MB
jewt4.jar 2.52MB
dvt-jclient-gui.jar 2.5MB
kvclient.jar 2.39MB
ActiveQueryBuilder.jar 2.31MB
org-netbeans-core-windows.jar 2.31MB
oracle_ice.jar 2.25MB
fop.jar 2.16MB
itextpdf.jar 2.04MB
com.sun.xml.bind.jaxb-xjc.jar 1.96MB
oracle.jdeveloper.runner.jar 1.94MB
uic.jar 1.93MB
oracle.ide.db.jar 1.87MB
org-openide-explorer.jar 1.79MB
org-eclipse-jgit.jar 1.77MB
jna-platform-4.2.2.jar 1.77MB
javatools.jar 1.76MB
dbapi-impl.jar 1.76MB
oracle.jdeveloper.java.core.jar 1.73MB
ewt3.jar 1.73MB
xmlparserv2.jar 1.62MB
dbapi.jar 1.61MB
orai18n.jar 1.58MB
xmleditor.jar 1.54MB
log4j-core.jar 1.48MB
oracle.jdeveloper.common.jar 1.44MB
olap_api.jar 1.44MB
poi-ooxml.jar 1.41MB
oracle.jdeveloper.vcs.jar 1.41MB
org-openide-loaders.jar 1.38MB
oracle.ide.audit.jar 1.36MB
org.eclipse.osgi_3.9.1.v20140110-1610.jar 1.28MB
adf-share-ca.jar 1.21MB
je-3.3.98.jar 1.2MB
jackson-databind.jar 1.18MB
oracle.jdeveloper.subversion.jar 1.17MB
dvt-utils.jar 1.16MB
共 1765 条
- 1
- 2
- 3
- 4
- 5
- 6
- 18
资源评论
欢乐的八爪鱼
- 粉丝: 658
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功