Hi All,
Do DBCleaner and and DB Cleaner on Steroids use "DBCleaner API" for all DB delete actions? Do these components have any direct access to any tables to execute any queries, like executing a delete query on a log table?
Hi Ilay,
Yes, both DBCleaner and DB Cleaner on Steroids primarily use the DBCleaner API provided by OutSystems for executing delete actions. The DBCleaner API exposes functions that allow safe deletion of records from various system entities and application modules, ensuring dependencies are managed correctly.
Generally, these tools do not directly access or execute raw SQL queries (like DELETE FROM {Table}) on OutSystems system tables or user-defined tables.
They rely on OutSystems public APIs or extension mechanisms to ensure:
Referential integrity is maintained.
Platform rules and constraints are respected.
However, In custom implementations (especially with "DB Cleaner on Steroids"), we can extend the tool to execute custom SQL or logic.
Thanks for the response @JR.
One thing I am not very clear about... DBCleaner API doesn't seem to have any methods to delete from so called "LOG" tables. I can only see "ModuleVersion_Delete" and "ModuleVersion_DeleteAll"