Package io.github.mfvanek.pg.spring

Class DatabaseStructureChecksAutoConfiguration

java.lang.Object

io.github.mfvanek.pg.spring.DatabaseStructureChecksAutoConfiguration

@AutoConfiguration(after=DatabaseStructureHealthAutoConfiguration.class)
@ConditionalOnBean(io.github.mfvanek.pg.connection.PgConnection.class)
public class DatabaseStructureChecksAutoConfiguration
extends Object

Autoconfiguration for database checks.

Since:

0.13.2

Constructor Summary

Constructors

Constructor	Description
DatabaseStructureChecksAutoConfiguration()

Method Summary

Modifier and Type	Method	Description
BtreeIndexesOnArrayColumnsCheckOnHost	btreeIndexesOnArrayColumnsCheckOnHost(PgConnection pgConnection)
ColumnsNotFollowingNamingConventionCheckOnHost	columnsNotFollowingNamingConventionCheckOnHost(PgConnection pgConnection)
ColumnsWithFixedLengthVarcharCheckOnHost	columnsWithFixedLengthVarcharCheckOnHost(PgConnection pgConnection)
ColumnsWithJsonTypeCheckOnHost	columnsWithJsonTypeCheckOnHost(PgConnection pgConnection)
ColumnsWithoutDescriptionCheckOnHost	columnsWithoutDescriptionCheckOnHost(PgConnection pgConnection)
ColumnsWithSerialTypesCheckOnHost	columnsWithSerialTypesCheckOnHost(PgConnection pgConnection)
DuplicatedForeignKeysCheckOnHost	duplicatedForeignKeysCheckOnHost(PgConnection pgConnection)
DuplicatedIndexesCheckOnHost	duplicatedIndexesCheckOnHost(PgConnection pgConnection)
ForeignKeysNotCoveredWithIndexCheckOnHost	foreignKeysNotCoveredWithIndexCheckOnHost(PgConnection pgConnection)
ForeignKeysWithUnmatchedColumnTypeCheckOnHost	foreignKeysWithUnmatchedColumnTypeCheckOnHost(PgConnection pgConnection)
FunctionsWithoutDescriptionCheckOnHost	functionsWithoutDescriptionCheckOnHost(PgConnection pgConnection)
IndexesWithBloatCheckOnHost	indexesWithBloatCheckOnHost(PgConnection pgConnection)
IndexesWithBooleanCheckOnHost	indexesWithBooleanCheckOnHost(PgConnection pgConnection)
IndexesWithNullValuesCheckOnHost	indexesWithNullValuesCheckOnHost(PgConnection pgConnection)
IndexesWithUnnecessaryWhereClauseCheckOnHost	indexesWithUnnecessaryWhereClauseCheckOnHost(PgConnection pgConnection)
IntersectedForeignKeysCheckOnHost	intersectedForeignKeysCheckOnHost(PgConnection pgConnection)
IntersectedIndexesCheckOnHost	intersectedIndexesCheckOnHost(PgConnection pgConnection)
InvalidIndexesCheckOnHost	invalidIndexesCheckOnHost(PgConnection pgConnection)
NotValidConstraintsCheckOnHost	notValidConstraintsCheckOnHost(PgConnection pgConnection)
ObjectsNotFollowingNamingConventionCheckOnHost	objectsNotFollowingNamingConventionCheckOnHost(PgConnection pgConnection)
PossibleObjectNameOverflowCheckOnHost	possibleObjectNameOverflowCheckOnHost(PgConnection pgConnection)
PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost	primaryKeysThatMostLikelyNaturalKeysCheckOnHost(PgConnection pgConnection)
PrimaryKeysWithSerialTypesCheckOnHost	primaryKeysWithSerialTypesCheckOnHost(PgConnection pgConnection)
PrimaryKeysWithVarcharCheckOnHost	primaryKeysWithVarcharCheckOnHost(PgConnection pgConnection)
SequenceOverflowCheckOnHost	sequenceOverflowCheckOnHost(PgConnection pgConnection)
StatisticsMaintenanceOnHost	statisticsMaintenanceOnHost(PgConnection pgConnection)
TablesNotLinkedToOthersCheckOnHost	tablesNotLinkedToOthersCheckOnHost(PgConnection pgConnection)
TablesWithBloatCheckOnHost	tablesWithBloatCheckOnHost(PgConnection pgConnection)
TablesWithMissingIndexesCheckOnHost	tablesWithMissingIndexesCheckOnHost(PgConnection pgConnection)
TablesWithoutDescriptionCheckOnHost	tablesWithoutDescriptionCheckOnHost(PgConnection pgConnection)
TablesWithoutPrimaryKeyCheckOnHost	tablesWithoutPrimaryKeyCheckOnHost(PgConnection pgConnection)
TablesWithZeroOrOneColumnCheckOnHost	tablesWithZeroOrOneColumnCheckOnHost(PgConnection pgConnection)
UnusedIndexesCheckOnHost	unusedIndexesCheckOnHost(PgConnection pgConnection)

Methods inherited from class java.lang.Object

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

Constructor Details

DatabaseStructureChecksAutoConfiguration

public DatabaseStructureChecksAutoConfiguration()

Method Details

duplicatedIndexesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.DuplicatedIndexesCheckOnHost.class)
@ConditionalOnMissingBean
public DuplicatedIndexesCheckOnHost duplicatedIndexesCheckOnHost(PgConnection pgConnection)

foreignKeysNotCoveredWithIndexCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ForeignKeysNotCoveredWithIndexCheckOnHost.class)
@ConditionalOnMissingBean
public ForeignKeysNotCoveredWithIndexCheckOnHost foreignKeysNotCoveredWithIndexCheckOnHost(PgConnection pgConnection)

indexesWithBloatCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IndexesWithBloatCheckOnHost.class)
@ConditionalOnMissingBean
public IndexesWithBloatCheckOnHost indexesWithBloatCheckOnHost(PgConnection pgConnection)

indexesWithNullValuesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IndexesWithNullValuesCheckOnHost.class)
@ConditionalOnMissingBean
public IndexesWithNullValuesCheckOnHost indexesWithNullValuesCheckOnHost(PgConnection pgConnection)

intersectedIndexesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IntersectedIndexesCheckOnHost.class)
@ConditionalOnMissingBean
public IntersectedIndexesCheckOnHost intersectedIndexesCheckOnHost(PgConnection pgConnection)

invalidIndexesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.InvalidIndexesCheckOnHost.class)
@ConditionalOnMissingBean
public InvalidIndexesCheckOnHost invalidIndexesCheckOnHost(PgConnection pgConnection)

tablesWithBloatCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesWithBloatCheckOnHost.class)
@ConditionalOnMissingBean
public TablesWithBloatCheckOnHost tablesWithBloatCheckOnHost(PgConnection pgConnection)

tablesWithMissingIndexesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesWithMissingIndexesCheckOnHost.class)
@ConditionalOnMissingBean
public TablesWithMissingIndexesCheckOnHost tablesWithMissingIndexesCheckOnHost(PgConnection pgConnection)

tablesWithoutPrimaryKeyCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesWithoutPrimaryKeyCheckOnHost.class)
@ConditionalOnMissingBean
public TablesWithoutPrimaryKeyCheckOnHost tablesWithoutPrimaryKeyCheckOnHost(PgConnection pgConnection)

unusedIndexesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.UnusedIndexesCheckOnHost.class)
@ConditionalOnMissingBean
public UnusedIndexesCheckOnHost unusedIndexesCheckOnHost(PgConnection pgConnection)

tablesWithoutDescriptionCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesWithoutDescriptionCheckOnHost.class)
@ConditionalOnMissingBean
public TablesWithoutDescriptionCheckOnHost tablesWithoutDescriptionCheckOnHost(PgConnection pgConnection)

columnsWithoutDescriptionCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ColumnsWithoutDescriptionCheckOnHost.class)
@ConditionalOnMissingBean
public ColumnsWithoutDescriptionCheckOnHost columnsWithoutDescriptionCheckOnHost(PgConnection pgConnection)

columnsWithJsonTypeCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ColumnsWithJsonTypeCheckOnHost.class)
@ConditionalOnMissingBean
public ColumnsWithJsonTypeCheckOnHost columnsWithJsonTypeCheckOnHost(PgConnection pgConnection)

columnsWithSerialTypesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ColumnsWithSerialTypesCheckOnHost.class)
@ConditionalOnMissingBean
public ColumnsWithSerialTypesCheckOnHost columnsWithSerialTypesCheckOnHost(PgConnection pgConnection)

functionsWithoutDescriptionCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.FunctionsWithoutDescriptionCheckOnHost.class)
@ConditionalOnMissingBean
public FunctionsWithoutDescriptionCheckOnHost functionsWithoutDescriptionCheckOnHost(PgConnection pgConnection)

indexesWithBooleanCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IndexesWithBooleanCheckOnHost.class)
@ConditionalOnMissingBean
public IndexesWithBooleanCheckOnHost indexesWithBooleanCheckOnHost(PgConnection pgConnection)

notValidConstraintsCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.NotValidConstraintsCheckOnHost.class)
@ConditionalOnMissingBean
public NotValidConstraintsCheckOnHost notValidConstraintsCheckOnHost(PgConnection pgConnection)

btreeIndexesOnArrayColumnsCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.BtreeIndexesOnArrayColumnsCheckOnHost.class)
@ConditionalOnMissingBean
public BtreeIndexesOnArrayColumnsCheckOnHost btreeIndexesOnArrayColumnsCheckOnHost(PgConnection pgConnection)

sequenceOverflowCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.SequenceOverflowCheckOnHost.class)
@ConditionalOnMissingBean
public SequenceOverflowCheckOnHost sequenceOverflowCheckOnHost(PgConnection pgConnection)

primaryKeysWithSerialTypesCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithSerialTypesCheckOnHost.class)
@ConditionalOnMissingBean
public PrimaryKeysWithSerialTypesCheckOnHost primaryKeysWithSerialTypesCheckOnHost(PgConnection pgConnection)

duplicatedForeignKeysCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.DuplicatedForeignKeysCheckOnHost.class)
@ConditionalOnMissingBean
public DuplicatedForeignKeysCheckOnHost duplicatedForeignKeysCheckOnHost(PgConnection pgConnection)

intersectedForeignKeysCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IntersectedForeignKeysCheckOnHost.class)
@ConditionalOnMissingBean
public IntersectedForeignKeysCheckOnHost intersectedForeignKeysCheckOnHost(PgConnection pgConnection)

possibleObjectNameOverflowCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.PossibleObjectNameOverflowCheckOnHost.class)
@ConditionalOnMissingBean
public PossibleObjectNameOverflowCheckOnHost possibleObjectNameOverflowCheckOnHost(PgConnection pgConnection)

tablesNotLinkedToOthersCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesNotLinkedToOthersCheckOnHost.class)
@ConditionalOnMissingBean
public TablesNotLinkedToOthersCheckOnHost tablesNotLinkedToOthersCheckOnHost(PgConnection pgConnection)

foreignKeysWithUnmatchedColumnTypeCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ForeignKeysWithUnmatchedColumnTypeCheckOnHost.class)
@ConditionalOnMissingBean
public ForeignKeysWithUnmatchedColumnTypeCheckOnHost foreignKeysWithUnmatchedColumnTypeCheckOnHost(PgConnection pgConnection)

tablesWithZeroOrOneColumnCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.TablesWithZeroOrOneColumnCheckOnHost.class)
@ConditionalOnMissingBean
public TablesWithZeroOrOneColumnCheckOnHost tablesWithZeroOrOneColumnCheckOnHost(PgConnection pgConnection)

objectsNotFollowingNamingConventionCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ObjectsNotFollowingNamingConventionCheckOnHost.class)
@ConditionalOnMissingBean
public ObjectsNotFollowingNamingConventionCheckOnHost objectsNotFollowingNamingConventionCheckOnHost(PgConnection pgConnection)

columnsNotFollowingNamingConventionCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ColumnsNotFollowingNamingConventionCheckOnHost.class)
@ConditionalOnMissingBean
public ColumnsNotFollowingNamingConventionCheckOnHost columnsNotFollowingNamingConventionCheckOnHost(PgConnection pgConnection)

primaryKeysWithVarcharCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithVarcharCheckOnHost.class)
@ConditionalOnMissingBean
public PrimaryKeysWithVarcharCheckOnHost primaryKeysWithVarcharCheckOnHost(PgConnection pgConnection)

columnsWithFixedLengthVarcharCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.ColumnsWithFixedLengthVarcharCheckOnHost.class)
@ConditionalOnMissingBean
public ColumnsWithFixedLengthVarcharCheckOnHost columnsWithFixedLengthVarcharCheckOnHost(PgConnection pgConnection)

indexesWithUnnecessaryWhereClauseCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.IndexesWithUnnecessaryWhereClauseCheckOnHost.class)
@ConditionalOnMissingBean
public IndexesWithUnnecessaryWhereClauseCheckOnHost indexesWithUnnecessaryWhereClauseCheckOnHost(PgConnection pgConnection)

primaryKeysThatMostLikelyNaturalKeysCheckOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.checks.host.PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost.class)
@ConditionalOnMissingBean
public PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost primaryKeysThatMostLikelyNaturalKeysCheckOnHost(PgConnection pgConnection)

statisticsMaintenanceOnHost

@Bean
@ConditionalOnClass(io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHost.class)
@ConditionalOnMissingBean
public StatisticsMaintenanceOnHost statisticsMaintenanceOnHost(PgConnection pgConnection)