def store_all_info
if session[:user_id] and session[:level] > 2
@database = Database.find_by_database_nm(Database.find_first.currentDatabaseName)
@change = Change.new({:object_path => @database.database_nm, :data_changed => "database_desc",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => @database.description, :date => Time.now})
@change.save
for schema in @database.schemas
@change = Change.new({:object_path => schema.Database.database_nm + '/' + schema.schema_nm, :data_changed => "schema_desc",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => schema.description, :date => Time.now})
@change.save
@change = Change.new({:object_path => schema.Database.database_nm + '/' + schema.schema_nm, :data_changed => "schema_title",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => schema.title, :date => Time.now})
@change.save
for table in schema.tables
@change = Change.new({:object_path => table.Schema.Database.database_nm + '/' + table.Schema.schema_nm + '/' + table.table_nm, :data_changed => "description",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => table.description, :date => Time.now})
@change.save
for column in table.columns
@change = Change.new({:object_path => column.Table.Schema.Database.database_nm + '/' + column.Table.Schema.schema_nm + '/' + column.Table.table_nm + '/' + column.column_nm, :data_changed => "column_desc",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => column.description, :date => Time.now})
@change.save
@change = Change.new({:object_path => column.Table.Schema.Database.database_nm + '/' + column.Table.Schema.schema_nm + '/' + column.Table.table_nm + '/' + column.column_nm, :data_changed => "sample_data_txt",
:user_id => session[:user_id], :comment => 'FULL STORE',
:new_value => column.sample_data_txt, :date => Time.now})
@change.save
end
end
end
end
redirect_to :action => 'browser'
end