Great - Suggestion

[Paul Pasquel]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi,
 
Firstly, congratulations this functionality is really amazing.
 
Well, my question, How about the documentation ? how can keep related the database estructure and their "documentation".
 
We use to put comment on each table field (Oracle Funcionality). How can I extracT and keep those information? or may be I'm wrong and there is another way to do it ?
 
Thanks on Advanced
 

---

Explore the seven wonders of the world Learn more!
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[Voxland, Nathan]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Take a look at the DBDoc functionality (http://www.liquibase.org/manual/dbdoc) If you take a look at the “commenttest” table in the sample (http://www.liquibase.org/dbdoc/index.html) you will see some examples of changes with comments in the changelog xml.

 

If you put comments on tables in oracle, that data is stored in the database.  I believe that the comments are pulled out in an initial generateChangeLog command, but they are not looked at afterwords by liquibase.

 

Nathan

 

From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of Paul Pasquel
Sent: Thursday, July 10, 2008 2:05 PM
To: liquibase-user@...
Subject: [Liquibase-user] Great - Suggestion

 

Hi,
 
Firstly, congratulations this functionality is really amazing.
 
Well, my question, How about the documentation ? how can keep related the database estructure and their "documentation".
 
We use to put comment on each table field (Oracle Funcionality). How can I extracT and keep those information? or may be I'm wrong and there is another way to do it ?
 
Thanks on Advanced
 

 

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[choreo]

Hi,

I've just started using liquibase and sorry if I am off the topic, but
is commenting to column supported, contrary to the dbdoc?
It would be great if liquibase generates a comment on column like

COMMENT ON COLUMN sampletable.foo_flag IS 'true when xxxxx';

for PostgreSQL, for example.  It seems that "remarks" attribute for
 <addColumn/> is not reflected.

regards,
Satoshi

[Voxland, Nathan]

There isn't a built in tag for setting the remarks attribute, but you can always use the <sql> tag and specify the comment SQL yourself.  Or use the custom refactoring functionality if that makes it easier for you.
 
Nathan

________________________________

From: liquibase-user-bounces@... on behalf of choreo
Sent: Sat 7/12/2008 3:26 PM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Great - Suggestion




Hi,

I've just started using liquibase and sorry if I am off the topic, but
is commenting to column supported, contrary to the dbdoc?
It would be great if liquibase generates a comment on column like

COMMENT ON COLUMN sampletable.foo_flag IS 'true when xxxxx';

for PostgreSQL, for example.  It seems that "remarks" attribute for
 <addColumn/> is not reflected.

regards,
Satoshi
--
View this message in context: http://www.nabble.com/Great---Suggestion-tp18389849p18423340.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user




-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[choreo]

Hi Nathan,

Thanks!  I'll try the <sql> tag since migrating to another DBMS won't  
be a pita
for comment SQL is so simple.
I'm getting to be a big fan of Liquibase!

regards,
Satoshi

On 2008/07/13, at 10:27, Voxland, Nathan wrote:

> There isn't a built in tag for setting the remarks attribute, but  
> you can always use the <sql> tag and specify the comment SQL  
> yourself.  Or use the custom refactoring functionality if that makes  
> it easier for you.
>
> Nathan
>
> ________________________________
>
> From: liquibase-user-bounces@... on behalf of choreo
> Sent: Sat 7/12/2008 3:26 PM
> To: liquibase-user@...
> Subject: Re: [Liquibase-user] Great - Suggestion
>
>
>
>
> Hi,
>
> I've just started using liquibase and sorry if I am off the topic, but
> is commenting to column supported, contrary to the dbdoc?
> It would be great if liquibase generates a comment on column like
>
> COMMENT ON COLUMN sampletable.foo_flag IS 'true when xxxxx';
>
> for PostgreSQL, for example.  It seems that "remarks" attribute for
> <addColumn/> is not reflected.
>
> regards,
> Satoshi
> --
> View this message in context: http://www.nabble.com/Great---Suggestion-tp18389849p18423340.html
> Sent from the LiquiBase - User mailing list archive at Nabble.com.
>
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>
> <
> winmail
> .dat
> >
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08_______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user