| need suggestions about new plugin [message #302847] |
Mon, 01 May 2006 08:13  |
Eclipse User |
|
|
|
Originally posted by: bricconi.netscape.net
Hello,
I am developing an open source tool called SPWrapper; this tool looks into
database system tables, finds stored procedures and writes out java
sources able to invoke these stored procedures handling parameter setting
and getting, type conversions etc.
I would like to write an eclipse plug-in to make it easier to use
SPWrapper, but I am completely new to eclipse plug-in development. I saw a
lot of extension points in the platform documentation, too many to simply
start trying to develop something.
So I am looking for suggestions on how to implement the features I am
planning to provide.
Can someone suggest me what to study/look for each feature?
Thank you!
Giovanni
Feature 1 - connection view
I would like to provide a view that allows user to add/modify/delete
database connections.
Each connection decription will be described by name, jdbc jar location,
driver class name, username and password.
Question 1.1 - These settings should be associated to the workspace: is
there an api to store and retrieve workspace associated data? Is it
possible to serialize classes or data should be transaled to xml?
Question 1.2 - the jdbc drivers should be added to the workbench
classpath, since are needed to show the list of available stored
procedure/packages for each connection. How to do this?
Feature 2 - stored procedure translation settings
I would like to provide a new wizad to create a java stored procedure
wrapper. During the wizard steps the user will alter the default sql ->
java type mapping and will optionally chose custom data type mappings. As
result a new java source file is produced.
Question 2.1 - The user input should be saved. Is it possible to associate
this data to the generated java file?
Question 2.2 - the java file must be rewritten if the user input changes
or the database stored procedure changes. Is it possible to intercept
project build events to check for db changes and rewrite the java code
during the build process?
Question 2.3 - user input must be saved into cvs/versioning system. Is
enough to store this information into a new file with a new extension?
|
|
|
|
| Re: need suggestions about new plugin [message #302914 is a reply to message #302847] |
Tue, 02 May 2006 15:32  |
| Eclipse User |
|
|
|
Originally posted by: rvraaphorst.hotmail.com
This is a multi-part message in MIME format.
------=_NextPart_000_002D_01C66E2F.E107A250
Content-Type: text/plain;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Hi Giovanni,
Like you I'm a newby but very intersted in the plugin (and emf/emft) =
stuff.
My starting point are the books from the eclipse series, especially
"Eclipse: Building Commercial-Quality Plug-ins" and "Eclipse Modeling =
Framework"
but that's also because I prefer to have some context to start with =
instead of spitting through (small) code examples.
I was also pointed at the http://www.eclipse.org/emft/projects/ page =
which I hadn't spotted directly.
Cheers,
Ronald
"Giovanni" <bricconi@netscape.net> schreef in bericht =
news:e3d0f89f56c52673bb760cb46bde1d57$1@www.eclipse.org...
> Hello,
>=20
> I am developing an open source tool called SPWrapper; this tool looks =
into=20
> database system tables, finds stored procedures and writes out java=20
> sources able to invoke these stored procedures handling parameter =
setting=20
> and getting, type conversions etc.
>=20
> I would like to write an eclipse plug-in to make it easier to use=20
> SPWrapper, but I am completely new to eclipse plug-in development. I =
saw a=20
> lot of extension points in the platform documentation, too many to =
simply=20
> start trying to develop something.
>=20
> So I am looking for suggestions on how to implement the features I am=20
> planning to provide.=20
>=20
> Can someone suggest me what to study/look for each feature?
>=20
> Thank you!
>=20
> Giovanni
>=20
>=20
> Feature 1 - connection view
> I would like to provide a view that allows user to add/modify/delete=20
> database connections.
> Each connection decription will be described by name, jdbc jar =
location,=20
> driver class name, username and password. =20
>=20
> Question 1.1 - These settings should be associated to the workspace: =
is=20
> there an api to store and retrieve workspace associated data? Is it=20
> possible to serialize classes or data should be transaled to xml?
> Question 1.2 - the jdbc drivers should be added to the workbench=20
> classpath, since are needed to show the list of available stored=20
> procedure/packages for each connection. How to do this?
>=20
> Feature 2 - stored procedure translation settings
> I would like to provide a new wizad to create a java stored procedure=20
> wrapper. During the wizard steps the user will alter the default sql =
->=20
> java type mapping and will optionally chose custom data type mappings. =
As=20
> result a new java source file is produced.
>=20
> Question 2.1 - The user input should be saved. Is it possible to =
associate=20
> this data to the generated java file?=20
> Question 2.2 - the java file must be rewritten if the user input =
changes=20
> or the database stored procedure changes. Is it possible to intercept=20
> project build events to check for db changes and rewrite the java code =
> during the build process?
> Question 2.3 - user input must be saved into cvs/versioning system. Is =
> enough to store this information into a new file with a new extension?
>=20
>
------=_NextPart_000_002D_01C66E2F.E107A250
Content-Type: text/html;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-15">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi Giovanni,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Like you I'm a newby but very intersted =
in the=20
plugin (and emf/emft) stuff.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>My starting point are the books from =
the eclipse=20
series, especially</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Eclipse: Building Commercial-Quality =
Plug-ins"=20
</FONT><FONT face=3DArial size=3D2>and "</FONT><FONT face=3DArial =
size=3D2>Eclipse=20
Modeling Framework"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>but that's also because I prefer to =
have some=20
context to start with instead of spitting through (small) code=20
examples.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I was also pointed at the <A=20
href=3D"http://www.eclipse.org/emft/projects/">http://www.eclipse.org/emf=
t/projects/</A> page=20
which I hadn't spotted directly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Ronald</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Giovanni" <</FONT><A=20
href=3D"mailto:bricconi@netscape.net"><FONT face=3DArial=20
size=3D2>bricconi@netscape.net</FONT></A><FONT face=3DArial =
size=3D2>> schreef in=20
bericht </FONT><A=20
href=3D"news:e3d0f89f56c52673bb760cb46bde1d57$1@www.eclipse.org"><FONT =
face=3DArial=20
size=3D2>news:e3d0f89f56c52673bb760cb46bde1d57$1@www.eclipse.org</FONT></=
A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
Hello,<BR>>=20
<BR>> I am developing an open source tool called SPWrapper; this tool =
looks=20
into <BR>> database system tables, finds stored procedures and writes =
out=20
java <BR>> sources able to invoke these stored procedures handling =
parameter=20
setting <BR>> and getting, type conversions etc.<BR>> <BR>> I =
would=20
like to write an eclipse plug-in to make it easier to use <BR>> =
SPWrapper,=20
but I am completely new to eclipse plug-in development. I saw a <BR>> =
lot of=20
extension points in the platform documentation, too many to simply =
<BR>>=20
start trying to develop something.<BR>> <BR>> So I am looking for=20
suggestions on how to implement the features I am <BR>> planning to =
provide.=20
<BR>> <BR>> Can someone suggest me what to study/look for each=20
feature?<BR>> <BR>> Thank you!<BR>> <BR>> Giovanni<BR>> =
<BR>>=20
<BR>> Feature 1 - connection view<BR>> I would like to provide a =
view that=20
allows user to add/modify/delete <BR>> database connections.<BR>> =
Each=20
connection decription will be described by name, jdbc jar location, =
<BR>>=20
driver class name, username and password. <BR>> <BR>> =
Question 1.1 -=20
These settings should be associated to the workspace: is <BR>> there =
an api=20
to store and retrieve workspace associated data? Is it <BR>> possible =
to=20
serialize classes or data should be transaled to xml?<BR>> Question =
1.2 - the=20
jdbc drivers should be added to the workbench <BR>> classpath, since =
are=20
needed to show the list of available stored <BR>> procedure/packages =
for each=20
connection. How to do this?<BR>> <BR>> Feature 2 - stored =
procedure=20
translation settings<BR>> I would like to provide a new wizad to =
create a=20
java stored procedure <BR>> wrapper. During the wizard steps the user =
will=20
alter the default sql -> <BR>> java type mapping and will =
optionally chose=20
custom data type mappings. As <BR>> result a new java source file is=20
produced.<BR>> <BR>> Question 2.1 - The user input should be =
saved. Is it=20
possible to associate <BR>> this data to the generated java file? =
<BR>>=20
Question 2.2 - the java file must be rewritten if the user input changes =
<BR>> or the database stored procedure changes. Is it possible to =
intercept=20
<BR>> project build events to check for db changes and rewrite the =
java code=20
<BR>> during the build process?<BR>> Question 2.3 - user input =
must be=20
saved into cvs/versioning system. Is <BR>> enough to store this =
information=20
into a new file with a new extension?<BR>> =
<BR>></FONT></BODY></HTML>
------=_NextPart_000_002D_01C66E2F.E107A250--
|
|
|
| Re: need suggestions about new plugin [message #302922 is a reply to message #302847] |
Tue, 02 May 2006 17:17 |
| Eclipse User |
|
|
|
I'm not going to claim that I can answer all of your questions exhaustively
or that I know much about the particulars of database processing, but here
are some of my thoughts about your questions:
"Giovanni" <bricconi@netscape.net> wrote in message
news:e3d0f89f56c52673bb760cb46bde1d57$1@www.eclipse.org...
> (.....)
>
> Feature 1 - connection view
> I would like to provide a view that allows user to add/modify/delete
> database connections.
> Each connection decription will be described by name, jdbc jar location,
> driver class name, username and password.
> Question 1.1 - These settings should be associated to the workspace: is
> there an api to store and retrieve workspace associated data? Is it
> possible to serialize classes or data should be transaled to xml?
The IPreferenceStore interface provides as simple way of saving key/value
pairs in the context of a workspace. However that architecture is flat, so
it is hard to get multi-depth structure. If you want something more
complicated then you could create your own settings file (in XML or any
other format) that can be saved in a plug-in specific location in your
workspace (in a subfolder of the .metadata folder in your workspace); you
would use the AbstractUIPlugin.getStateLocation() method.
> Question 1.2 - the jdbc drivers should be added to the workbench
> classpath, since are needed to show the list of available stored
> procedure/packages for each connection. How to do this?
not sure about this one
> Feature 2 - stored procedure translation settings
> I would like to provide a new wizad to create a java stored procedure
> wrapper. During the wizard steps the user will alter the default sql ->
> java type mapping and will optionally chose custom data type mappings. As
> result a new java source file is produced.
>
> Question 2.1 - The user input should be saved. Is it possible to associate
> this data to the generated java file?
there's a way for associating small bits of information with resources
(check docs for IResource). However, since it seems like you might want
something more complicated, you would probably be better of creating some
sort of file that stores these settings and maps it to a particular java
file (this of course might get tricky if you want to capture renaming or
other forms of refactoring, but should be possible). You could create a
*nix-hidden (. folder) directory within the project directory where you
could save these files. this would be useful for purposes of question 2.3.
> Question 2.2 - the java file must be rewritten if the user input changes
> or the database stored procedure changes. Is it possible to intercept
> project build events to check for db changes and rewrite the java code
> during the build process?
yes, you would have to look into builders and natures. using them you can
add functionality that responds to build commands for a project.
> Question 2.3 - user input must be saved into cvs/versioning system. Is
> enough to store this information into a new file with a new extension?
if you create special files for the user settings within a project, they
would automatically be added to the cvs repository and synchronized.
|
|
|
Powered by
FUDForum. Page generated in 0.44269 seconds
Home