org.sonar.plugins.dbcleaner.api
Class PurgeUtils

java.lang.Object
  org.sonar.plugins.dbcleaner.api.PurgeUtils

public final class PurgeUtils
extends Object

Since:

2.5

Field Summary

static int	DEFAULT_MINIMUM_PERIOD_IN_HOURS
static int	MAX_IN_ELEMENTS Maximum elements in the SQL statement "IN" due to an Oracle limitation (see error ORA-01795)
static String	PROP_KEY_MINIMUM_PERIOD_IN_HOURS

Method Summary

static void	deleteDependencies(DatabaseSession session, List<Integer> snapshotIds)
static void	deleteEvents(DatabaseSession session, List<Integer> snapshotIds) Delete EVENTS table
static void	deleteMeasuresById(DatabaseSession session, List<Integer> measureIds) Delete all measures, including MEASURE_DATA
static void	deleteMeasuresBySnapshotId(DatabaseSession session, List<Integer> snapshotIds) Delete all measures, including MEASURE_DATA
static void	deleteResourceIndex(DatabaseSession session, List<Integer> resourceIds) Delete RESOURCE_INDEX table
static void	deleteResources(DatabaseSession session, List<Integer> ids)
static void	deleteSnapshots(DatabaseSession session, List<Integer> snapshotIds) Delete SNAPSHOTS table
static void	deleteSnapshotsData(DatabaseSession session, List<Integer> snapshotIds)
static void	deleteSources(DatabaseSession session, List<Integer> snapshotIds) Delete SNAPSHOT_SOURCES table
static void	deleteViolations(DatabaseSession session, List<Integer> snapshotIds) Delete violations (RULE_FAILURES table)
static void	executeQuery(DatabaseSession session, String description, List<Integer> ids, String hql) Paginate execution of SQL requests to avoid exceeding size of rollback segment
static int	getMinimumPeriodInHours(org.apache.commons.configuration.Configuration conf)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DEFAULT_MINIMUM_PERIOD_IN_HOURS

public static final int DEFAULT_MINIMUM_PERIOD_IN_HOURS

See Also:

Constant Field Values

PROP_KEY_MINIMUM_PERIOD_IN_HOURS

public static final String PROP_KEY_MINIMUM_PERIOD_IN_HOURS

See Also:

Constant Field Values

MAX_IN_ELEMENTS

public static final int MAX_IN_ELEMENTS

Maximum elements in the SQL statement "IN" due to an Oracle limitation (see error ORA-01795)

See Also:

Constant Field Values

Method Detail

getMinimumPeriodInHours

public static int getMinimumPeriodInHours(org.apache.commons.configuration.Configuration conf)

deleteSnapshotsData

public static void deleteSnapshotsData(DatabaseSession session,
                                       List<Integer> snapshotIds)

deleteDependencies

public static void deleteDependencies(DatabaseSession session,
                                      List<Integer> snapshotIds)

deleteMeasuresBySnapshotId

public static void deleteMeasuresBySnapshotId(DatabaseSession session,
                                              List<Integer> snapshotIds)

Delete all measures, including MEASURE_DATA

deleteMeasuresById

public static void deleteMeasuresById(DatabaseSession session,
                                      List<Integer> measureIds)

Delete all measures, including MEASURE_DATA

deleteSources

public static void deleteSources(DatabaseSession session,
                                 List<Integer> snapshotIds)

Delete SNAPSHOT_SOURCES table

deleteViolations

public static void deleteViolations(DatabaseSession session,
                                    List<Integer> snapshotIds)

Delete violations (RULE_FAILURES table)

deleteEvents

public static void deleteEvents(DatabaseSession session,
                                List<Integer> snapshotIds)

Delete EVENTS table

deleteSnapshots

public static void deleteSnapshots(DatabaseSession session,
                                   List<Integer> snapshotIds)

Delete SNAPSHOTS table

deleteResources

public static void deleteResources(DatabaseSession session,
                                   List<Integer> ids)

deleteResourceIndex

public static void deleteResourceIndex(DatabaseSession session,
                                       List<Integer> resourceIds)

Delete RESOURCE_INDEX table

executeQuery

public static void executeQuery(DatabaseSession session,
                                String description,
                                List<Integer> ids,
                                String hql)

Paginate execution of SQL requests to avoid exceeding size of rollback segment