On Wed, 13 Apr 2005 19:26:47 +0200, snpe <[EMAIL PROTECTED]> wrote:
Looks great what you are doing.
If I understand you correctly this stuff simply just get some names
from the Data Explorer to limit what metadata our rev.eng. will get, correct ?
If that is the case then if you wait a day or two you'll see stuff happening
that should make this much easier for you.
I've just added the filter method you are referring too together with a very flexible way of filtering tables - only possible in code at first, but i'll expose it in the ui too.
/max
Hello,
I try integrate any database explorer and hibernate tools
I want, for example, that choose object (table,views ) from explorer
and call hibernate reverse engineering wizard.
I use sqlexplorer (patched), but I will try webtools when M4 be out (April 22)
I have any request from tools
1) I need new method (or replace current) in JDBCFilter :
boolean acceptTableName(String catalogName,String schemaName,String tableName);
and call to this method when/except call acceptTableName(String name)
I export extension point in sqlexplorer and define popupMenu like this
(I add in org.hibernate.eclipse.console plugin;TableNode class is from sqlexplorer)
...
<extension
point="org.eclipse.ui.popupMenus">
<objectContribution
objectClass="net.java.sqlexplorer.dbviewer.model.TableNode"
id="net.java.sqlexplorer.hibernate.wizard">
<action
label="Hibernate Artifact Generator Wizard"
class="org.hibernate.reveng.ArtifactGeneratorAction"
menubarPath="additions"
id="net.java.sqlexplorer.hibernate.item">
</action>
</objectContribution>
</extension>
...
ArtifactGeneratorAction call ArtifactGeneratorWizard like this :
...
public void run() {
wizard = new ArtifactGeneratorWizard();
IWorkbench workbench = PlatformUI.getWorkbench();
wizard.init(workbench, (IStructuredSelection) selection);
dialog = new WizardDialog(workbench.getActiveWorkbenchWindow()
.getShell(), wizard);
dialog.open();
}
...
this is screenshoot http://www.snpe.co.yu/artifactwizard.png
Hibernate Artifact Generator Wizard call ArtifactGeneratorWizard from console plugin with next change
(line 244 change is only JDBCFilter#acceptTableName):
public Object execute() {
cfg.readFromJDBC(new JDBCFilter() {
public boolean acceptTableName(String name) {
if (selection == null
|| !(selection instanceof IStructuredSelection))
return !name.startsWith("BIN$"); // oracle hack
else {
IStructuredSelection structuredSelection = (IStructuredSelection) selection;
for (Iterator iter = structuredSelection
.iterator(); iter.hasNext();) {
Object object = iter.next();
String tableName = null;
String schemaName = null;
String catalogName = null;
if (object instanceof TableNode) {
TableNode node = (TableNode) object;
tableName = node.getTableInfo()
.getSimpleName();
schemaName = node
.getTableInfo()
.getSchemaName();
catalogName = node
.getTableInfo()
.getCatalogName();
}
// I want check tableName,schemaName and catalogName,
// but JDBCFilter need new method
if (name.equals(tableName))
return true;
}
}
return false;
}
});
Problem is yet with dependencies (for example, when I get table A with foreign key to B
I get exceptions, because JDBCBinder work with complete schema)
I can find all dependencies (exported and imported key table) and return true in JDBCFilter#acceptTableName
for dependencies table - with this we haven't to change JDBCBinder or
add checkBox in ArtifactGeneratorWizard for generate or not many-to-one,one-to many etc - Can JDBCBinder
skip generate collection (one-to-many,many-to-one ...) ?
I can set patched sqlexplorer if You want try this (It work with eclipse 3.1M6,last cvs hibernate and hibernate tools)
Comments ?
Haris Peco
-- -- Max Rydahl Andersen callto://max.rydahl.andersen
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
