search

zghib / dbdeploy

Automatically exported from code.google.com/p/dbdeploy
0 stars 0 forks source link

Record comments on table or field in one separate table #6

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
As a DBA, 
I want to comment some words in dbdeploy script file to describe table or
field, and dbdeploy can treat those comments as a part of database
dictionary and store in them in a separate table, 
so that I can get the exact meanings easily by searching the field in the table

here is my proposal:

if this comment is provided in db script file("001 insert field in table.sql")
--//@meta: table.field="field in table"
then we can insert into the database dictionary table like this:
"insert into db_dictionay(tablename, objectname, description,
createversion) values ('table','field', 'field in table' , 1)"

BTW, looking forward to get your response, otherwise we'll add this feature
by ourselves:)

Original issue reported on code.google.com by skyai...@gmail.com on 23 Dec 2008 at 7:48

GoogleCodeExporter commented 8 years ago 
When would you use this feature?  

Why not just put the required insert statement into the change script?

Original comment by gtack...@googlemail.com on 5 Jan 2009 at 9:28