Home » Eclipse Projects » DTP » Batch ddl generation?
| Batch ddl generation? [message #12539] |
Thu, 04 May 2006 11:06  |
Eclipse User |
|
|
|
Hi,
I posted the following question on the eclipse.technology.dali forum, but
Karen suggested that I post the question to DTP since that is (or will be)
used for all ddl generation for Dali.
I'm sure this is another enhancement request, but I'm wondering whether
there's been any thought to providing a batch (command line) interface for
the DDL generation tooling? After the initial development activities are
complete, I could see where the "production" ddl generation could be a
build activity outside of the Eclipse environment. Has this capability
been a thought or is the ddl generation too dependent on the Eclipse ui?
Thanks for your thoughts.
Karen had also asked for reasons why this would be helpful since pure ddl
generation would not be suitable for a solid database model. I totally
agree. I suppose my usage of "production" was too strong. I meant more
along the lines of generating the ddl for multiple platforms and target
databases without requiring the use of the ui-based Eclipse environment.
Comments?
Thanks,
Kevin
|
|
|
| Re: Batch ddl generation? [message #12628 is a reply to message #12539] |
Fri, 05 May 2006 18:01  |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Kevin,
I think the ability to generate DDL is a great idea, and something we'll
look into for DTP Callisto. We're currently planning to leverage code that
drops the generated DDL into an editor in Eclipse, but we hadn't thought of
doing anything on the command line. Would it also work for you to be able to
export DDL to an external file?
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:0509489e732c7054447718b60ffa5ed8$1@www.eclipse.org...
> Hi,
> I posted the following question on the eclipse.technology.dali forum, but
> Karen suggested that I post the question to DTP since that is (or will be)
> used for all ddl generation for Dali.
>
> I'm sure this is another enhancement request, but I'm wondering whether
> there's been any thought to providing a batch (command line) interface for
> the DDL generation tooling? After the initial development activities are
> complete, I could see where the "production" ddl generation could be a
> build activity outside of the Eclipse environment. Has this capability
> been a thought or is the ddl generation too dependent on the Eclipse ui?
> Thanks for your thoughts.
>
> Karen had also asked for reasons why this would be helpful since pure ddl
> generation would not be suitable for a solid database model. I totally
> agree. I suppose my usage of "production" was too strong. I meant more
> along the lines of generating the ddl for multiple platforms and target
> databases without requiring the use of the ui-based Eclipse environment.
>
> Comments?
> Thanks,
> Kevin
>
|
|
| |
| Re: Batch ddl generation? [message #13478 is a reply to message #12835] |
Mon, 08 May 2006 17:47 |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Hi Kevin,
We have this in our work plan, so there's no need to enter a feature
enhancement.
>Exporting the generated DDL to an external file from a command-line based
>tool is exactly what I was looking for.
DDL generation that we're looking at (for now, at least) would be driven by
the Data Source Explorer tree. For example, you'd go to a table, right click
context, and choose something like "Generate DDL". You would then get an
Eclipse editor window opened with the generated DDL in it. You could then
use the Eclipse "export" functionality to push that out to a file outside
Eclipse. Will this work for your case?
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:a4109526f3e14fe6d5bb6a29047e7c07$1@www.eclipse.org...
> John Graham wrote:
>
>> Kevin,
>
>> I think the ability to generate DDL is a great idea, and something we'll
>> look into for DTP Callisto. We're currently planning to leverage code
>> that drops the generated DDL into an editor in Eclipse, but we hadn't
>> thought of doing anything on the command line. Would it also work for you
>> to be able to export DDL to an external file?
>
> John,
> Excellent. Should I open an enhancement request for this functionality?
> Or, do you have it logged in a current report somewhere?
>
> Exporting the generated DDL to an external file from a command-line based
> tool is exactly what I was looking for.
>
> Thank you,
> Kevin
>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>
>
>
|
|
|
| Re: Batch ddl generation? [message #13644 is a reply to message #13478] |
Tue, 09 May 2006 11:55 |
| Eclipse User |
|
|
|
John Graham wrote:
> Hi Kevin,
> We have this in our work plan, so there's no need to enter a feature
> enhancement.
>>Exporting the generated DDL to an external file from a command-line based
>>tool is exactly what I was looking for.
> DDL generation that we're looking at (for now, at least) would be driven by
> the Data Source Explorer tree. For example, you'd go to a table, right click
> context, and choose something like "Generate DDL". You would then get an
> Eclipse editor window opened with the generated DDL in it. You could then
> use the Eclipse "export" functionality to push that out to a file outside
> Eclipse. Will this work for your case?
John,
Not exactly. Actually, with the Dali plugin, we already have that level
of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
Persistence API support. They are currently using the rdb support, but
plan to move to dtp after their 0.5 release.) With the Dali support, I
can right mouse click on my Java project and select "Generate DDL..".
This brings up a wizard for selecting which Entities to process and where
to put the resulting ddl scripts. With a few minor glitches, this is
working quite well.
My request is whether this type of functionality could be made via a
command line tool outside of the Eclipse environment. When I brought up
this request to the Dali team, they suggested that I contact both the rdb
and dtp teams since they rely on these projects for generating the ddl. I
know that some of the tooling features within Eclipse and the various
plugins actually have a command-line interface. But, others are so
in-grained with the Eclipse ui that they can't be run from the
command-line. I was wondering whether the dtp team would be architecting
this support to allow for a command-line interface.
Thanks again for this discussion,
Kevin
|
|
|
| Re: Batch ddl generation? [message #13706 is a reply to message #13644] |
Tue, 09 May 2006 16:29 |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Hi Kevin,
The main trick for using this outside Eclipse would be getting access to our
connection profile objects outside, since they are what would provide the
plumbing for DDL generation support. We are working on being able to use
connectivity in "headless" (no Eclipse UI) environments, so maybe that will
give us the necessary pieces to do something like this. (It would still
require some Eclipse components, but at least run on the command line.)
Could you file an enhancement request for this, and we'll pass it by our
connectivity team to get the thought process going.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:11d6d1eaaeb3d3294e9fe93f083ee1f0$1@www.eclipse.org...
> John Graham wrote:
>
>> Hi Kevin,
>
>> We have this in our work plan, so there's no need to enter a feature
>> enhancement.
>
>>>Exporting the generated DDL to an external file from a command-line based
>>>tool is exactly what I was looking for.
>
>> DDL generation that we're looking at (for now, at least) would be driven
>> by the Data Source Explorer tree. For example, you'd go to a table, right
>> click context, and choose something like "Generate DDL". You would then
>> get an Eclipse editor window opened with the generated DDL in it. You
>> could then use the Eclipse "export" functionality to push that out to a
>> file outside Eclipse. Will this work for your case?
>
> John,
> Not exactly. Actually, with the Dali plugin, we already have that level
> of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
> Persistence API support. They are currently using the rdb support, but
> plan to move to dtp after their 0.5 release.) With the Dali support, I
> can right mouse click on my Java project and select "Generate DDL..".
> This brings up a wizard for selecting which Entities to process and where
> to put the resulting ddl scripts. With a few minor glitches, this is
> working quite well.
>
> My request is whether this type of functionality could be made via a
> command line tool outside of the Eclipse environment. When I brought up
> this request to the Dali team, they suggested that I contact both the rdb
> and dtp teams since they rely on these projects for generating the ddl. I
> know that some of the tooling features within Eclipse and the various
> plugins actually have a command-line interface. But, others are so
> in-grained with the Eclipse ui that they can't be run from the
> command-line. I was wondering whether the dtp team would be architecting
> this support to allow for a command-line interface.
>
> Thanks again for this discussion,
> Kevin
>
|
|
|
| Re: Batch ddl generation? [message #13780 is a reply to message #13706] |
Wed, 10 May 2006 14:18 |
| Eclipse User |
|
|
|
John Graham wrote:
> Hi Kevin,
> The main trick for using this outside Eclipse would be getting access to our
> connection profile objects outside, since they are what would provide the
> plumbing for DDL generation support. We are working on being able to use
> connectivity in "headless" (no Eclipse UI) environments, so maybe that will
> give us the necessary pieces to do something like this. (It would still
> require some Eclipse components, but at least run on the command line.)
> Could you file an enhancement request for this, and we'll pass it by our
> connectivity team to get the thought process going.
Thanks, John. I have opened enhancement request 141112 against Data Tools
for this problem. I wasn't sure about the sub-component, so you might
need to adjust that. Thanks again for the discussion.
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
> "Kevin" <kwsutter@gmail.com> wrote in message
> news:11d6d1eaaeb3d3294e9fe93f083ee1f0$1@www.eclipse.org...
>> John Graham wrote:
>>
>>> Hi Kevin,
>>
>>> We have this in our work plan, so there's no need to enter a feature
>>> enhancement.
>>
>>>>Exporting the generated DDL to an external file from a command-line based
>>>>tool is exactly what I was looking for.
>>
>>> DDL generation that we're looking at (for now, at least) would be driven
>>> by the Data Source Explorer tree. For example, you'd go to a table, right
>>> click context, and choose something like "Generate DDL". You would then
>>> get an Eclipse editor window opened with the generated DDL in it. You
>>> could then use the Eclipse "export" functionality to push that out to a
>>> file outside Eclipse. Will this work for your case?
>>
>> John,
>> Not exactly. Actually, with the Dali plugin, we already have that level
>> of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
>> Persistence API support. They are currently using the rdb support, but
>> plan to move to dtp after their 0.5 release.) With the Dali support, I
>> can right mouse click on my Java project and select "Generate DDL..".
>> This brings up a wizard for selecting which Entities to process and where
>> to put the resulting ddl scripts. With a few minor glitches, this is
>> working quite well.
>>
>> My request is whether this type of functionality could be made via a
>> command line tool outside of the Eclipse environment. When I brought up
>> this request to the Dali team, they suggested that I contact both the rdb
>> and dtp teams since they rely on these projects for generating the ddl. I
>> know that some of the tooling features within Eclipse and the various
>> plugins actually have a command-line interface. But, others are so
>> in-grained with the Eclipse ui that they can't be run from the
>> command-line. I was wondering whether the dtp team would be architecting
>> this support to allow for a command-line interface.
>>
>> Thanks again for this discussion,
>> Kevin
>>
|
|
|
| Re: Batch ddl generation? [message #573747 is a reply to message #12539] |
Fri, 05 May 2006 18:01 |
| Eclipse User |
|
|
|
Kevin,
I think the ability to generate DDL is a great idea, and something we'll
look into for DTP Callisto. We're currently planning to leverage code that
drops the generated DDL into an editor in Eclipse, but we hadn't thought of
doing anything on the command line. Would it also work for you to be able to
export DDL to an external file?
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:0509489e732c7054447718b60ffa5ed8$1@www.eclipse.org...
> Hi,
> I posted the following question on the eclipse.technology.dali forum, but
> Karen suggested that I post the question to DTP since that is (or will be)
> used for all ddl generation for Dali.
>
> I'm sure this is another enhancement request, but I'm wondering whether
> there's been any thought to providing a batch (command line) interface for
> the DDL generation tooling? After the initial development activities are
> complete, I could see where the "production" ddl generation could be a
> build activity outside of the Eclipse environment. Has this capability
> been a thought or is the ddl generation too dependent on the Eclipse ui?
> Thanks for your thoughts.
>
> Karen had also asked for reasons why this would be helpful since pure ddl
> generation would not be suitable for a solid database model. I totally
> agree. I suppose my usage of "production" was too strong. I meant more
> along the lines of generating the ddl for multiple platforms and target
> databases without requiring the use of the ui-based Eclipse environment.
>
> Comments?
> Thanks,
> Kevin
>
|
|
|
| Re: Batch ddl generation? [message #574098 is a reply to message #12628] |
Mon, 08 May 2006 09:41 |
| Eclipse User |
|
|
|
John Graham wrote:
> Kevin,
> I think the ability to generate DDL is a great idea, and something we'll
> look into for DTP Callisto. We're currently planning to leverage code that
> drops the generated DDL into an editor in Eclipse, but we hadn't thought of
> doing anything on the command line. Would it also work for you to be able to
> export DDL to an external file?
John,
Excellent. Should I open an enhancement request for this functionality?
Or, do you have it logged in a current report somewhere?
Exporting the generated DDL to an external file from a command-line based
tool is exactly what I was looking for.
Thank you,
Kevin
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
|
|
|
| Re: Batch ddl generation? [message #574259 is a reply to message #12835] |
Mon, 08 May 2006 17:47 |
| Eclipse User |
|
|
|
Hi Kevin,
We have this in our work plan, so there's no need to enter a feature
enhancement.
>Exporting the generated DDL to an external file from a command-line based
>tool is exactly what I was looking for.
DDL generation that we're looking at (for now, at least) would be driven by
the Data Source Explorer tree. For example, you'd go to a table, right click
context, and choose something like "Generate DDL". You would then get an
Eclipse editor window opened with the generated DDL in it. You could then
use the Eclipse "export" functionality to push that out to a file outside
Eclipse. Will this work for your case?
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:a4109526f3e14fe6d5bb6a29047e7c07$1@www.eclipse.org...
> John Graham wrote:
>
>> Kevin,
>
>> I think the ability to generate DDL is a great idea, and something we'll
>> look into for DTP Callisto. We're currently planning to leverage code
>> that drops the generated DDL into an editor in Eclipse, but we hadn't
>> thought of doing anything on the command line. Would it also work for you
>> to be able to export DDL to an external file?
>
> John,
> Excellent. Should I open an enhancement request for this functionality?
> Or, do you have it logged in a current report somewhere?
>
> Exporting the generated DDL to an external file from a command-line based
> tool is exactly what I was looking for.
>
> Thank you,
> Kevin
>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>
>
>
|
|
|
| Re: Batch ddl generation? [message #574506 is a reply to message #13478] |
Tue, 09 May 2006 11:55 |
| Eclipse User |
|
|
|
John Graham wrote:
> Hi Kevin,
> We have this in our work plan, so there's no need to enter a feature
> enhancement.
>>Exporting the generated DDL to an external file from a command-line based
>>tool is exactly what I was looking for.
> DDL generation that we're looking at (for now, at least) would be driven by
> the Data Source Explorer tree. For example, you'd go to a table, right click
> context, and choose something like "Generate DDL". You would then get an
> Eclipse editor window opened with the generated DDL in it. You could then
> use the Eclipse "export" functionality to push that out to a file outside
> Eclipse. Will this work for your case?
John,
Not exactly. Actually, with the Dali plugin, we already have that level
of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
Persistence API support. They are currently using the rdb support, but
plan to move to dtp after their 0.5 release.) With the Dali support, I
can right mouse click on my Java project and select "Generate DDL..".
This brings up a wizard for selecting which Entities to process and where
to put the resulting ddl scripts. With a few minor glitches, this is
working quite well.
My request is whether this type of functionality could be made via a
command line tool outside of the Eclipse environment. When I brought up
this request to the Dali team, they suggested that I contact both the rdb
and dtp teams since they rely on these projects for generating the ddl. I
know that some of the tooling features within Eclipse and the various
plugins actually have a command-line interface. But, others are so
in-grained with the Eclipse ui that they can't be run from the
command-line. I was wondering whether the dtp team would be architecting
this support to allow for a command-line interface.
Thanks again for this discussion,
Kevin
|
|
|
| Re: Batch ddl generation? [message #574619 is a reply to message #13644] |
Tue, 09 May 2006 16:29 |
| Eclipse User |
|
|
|
Hi Kevin,
The main trick for using this outside Eclipse would be getting access to our
connection profile objects outside, since they are what would provide the
plumbing for DDL generation support. We are working on being able to use
connectivity in "headless" (no Eclipse UI) environments, so maybe that will
give us the necessary pieces to do something like this. (It would still
require some Eclipse components, but at least run on the command line.)
Could you file an enhancement request for this, and we'll pass it by our
connectivity team to get the thought process going.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Kevin" <kwsutter@gmail.com> wrote in message
news:11d6d1eaaeb3d3294e9fe93f083ee1f0$1@www.eclipse.org...
> John Graham wrote:
>
>> Hi Kevin,
>
>> We have this in our work plan, so there's no need to enter a feature
>> enhancement.
>
>>>Exporting the generated DDL to an external file from a command-line based
>>>tool is exactly what I was looking for.
>
>> DDL generation that we're looking at (for now, at least) would be driven
>> by the Data Source Explorer tree. For example, you'd go to a table, right
>> click context, and choose something like "Generate DDL". You would then
>> get an Eclipse editor window opened with the generated DDL in it. You
>> could then use the Eclipse "export" functionality to push that out to a
>> file outside Eclipse. Will this work for your case?
>
> John,
> Not exactly. Actually, with the Dali plugin, we already have that level
> of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
> Persistence API support. They are currently using the rdb support, but
> plan to move to dtp after their 0.5 release.) With the Dali support, I
> can right mouse click on my Java project and select "Generate DDL..".
> This brings up a wizard for selecting which Entities to process and where
> to put the resulting ddl scripts. With a few minor glitches, this is
> working quite well.
>
> My request is whether this type of functionality could be made via a
> command line tool outside of the Eclipse environment. When I brought up
> this request to the Dali team, they suggested that I contact both the rdb
> and dtp teams since they rely on these projects for generating the ddl. I
> know that some of the tooling features within Eclipse and the various
> plugins actually have a command-line interface. But, others are so
> in-grained with the Eclipse ui that they can't be run from the
> command-line. I was wondering whether the dtp team would be architecting
> this support to allow for a command-line interface.
>
> Thanks again for this discussion,
> Kevin
>
|
|
|
| Re: Batch ddl generation? [message #574722 is a reply to message #13706] |
Wed, 10 May 2006 14:18 |
| Eclipse User |
|
|
|
John Graham wrote:
> Hi Kevin,
> The main trick for using this outside Eclipse would be getting access to our
> connection profile objects outside, since they are what would provide the
> plumbing for DDL generation support. We are working on being able to use
> connectivity in "headless" (no Eclipse UI) environments, so maybe that will
> give us the necessary pieces to do something like this. (It would still
> require some Eclipse components, but at least run on the command line.)
> Could you file an enhancement request for this, and we'll pass it by our
> connectivity team to get the thought process going.
Thanks, John. I have opened enhancement request 141112 against Data Tools
for this problem. I wasn't sure about the sub-component, so you might
need to adjust that. Thanks again for the discussion.
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
> "Kevin" <kwsutter@gmail.com> wrote in message
> news:11d6d1eaaeb3d3294e9fe93f083ee1f0$1@www.eclipse.org...
>> John Graham wrote:
>>
>>> Hi Kevin,
>>
>>> We have this in our work plan, so there's no need to enter a feature
>>> enhancement.
>>
>>>>Exporting the generated DDL to an external file from a command-line based
>>>>tool is exactly what I was looking for.
>>
>>> DDL generation that we're looking at (for now, at least) would be driven
>>> by the Data Source Explorer tree. For example, you'd go to a table, right
>>> click context, and choose something like "Generate DDL". You would then
>>> get an Eclipse editor window opened with the generated DDL in it. You
>>> could then use the Eclipse "export" functionality to push that out to a
>>> file outside Eclipse. Will this work for your case?
>>
>> John,
>> Not exactly. Actually, with the Dali plugin, we already have that level
>> of support to some extent. (Dali is the Eclipse plugin for JSR-220 Java
>> Persistence API support. They are currently using the rdb support, but
>> plan to move to dtp after their 0.5 release.) With the Dali support, I
>> can right mouse click on my Java project and select "Generate DDL..".
>> This brings up a wizard for selecting which Entities to process and where
>> to put the resulting ddl scripts. With a few minor glitches, this is
>> working quite well.
>>
>> My request is whether this type of functionality could be made via a
>> command line tool outside of the Eclipse environment. When I brought up
>> this request to the Dali team, they suggested that I contact both the rdb
>> and dtp teams since they rely on these projects for generating the ddl. I
>> know that some of the tooling features within Eclipse and the various
>> plugins actually have a command-line interface. But, others are so
>> in-grained with the Eclipse ui that they can't be run from the
>> command-line. I was wondering whether the dtp team would be architecting
>> this support to allow for a command-line interface.
>>
>> Thanks again for this discussion,
>> Kevin
>>
|
|
|
Goto Forum:
Current Time: Thu May 08 17:53:29 EDT 2025
Powered by FUDForum. Page generated in 0.04977 seconds |
Home