Personal Environment: Database Cleanup Function

Gavin Horne

CTO at Think Tasmania

+ 1

#5 698

in Community Rank

Service Studio

Implemented

on 27 Apr 2015

OutSystems 9

Database Integrity Suggestion - Inconsistent database table and entity definitions: column 'OSUSR_45r_Restring.CLIENTTYPEID' exists in database, but there is no corresponding attribute in entity 'Restring'.

The ability to right click on a Database Integrity Suggestion and delete a database field would be handy.

Cheers,
GH

Created on 19 Feb 2014

Comments (2)

Davide Marquês

20 Feb 2014

Davide Marquês

Things at OutSystems

+ 5

#145

in Community Rank

+1 This isn't specific to the personal environment.

Gonçalo Borrêga

27 Apr 2015

Gonçalo Borrêga

Sr. Director, Product Management at OutSystems

+ 3

#22

in Community Rank

The new DbCleaner API was designed for this purpose. Check the documentation to understand the required privileges when using it.
As a lot of you mentioned, this is a very sensitive operation that we must ensure is only performed by the right person and under the right conditions. Therefore we will not make it available from the Studio.

This component at the Forge shows a small example of how to use the API. You can use it to adapt to your own security restrictions and policies.

views

644

Followers