MPOSAirDataCleanUp 1.2.6

MPOSAirDataCleanUp

MPOSAirDataCleanUp is a database table rows clean up library. It's usage it's enforced with the methods described bellow. However, the explanation can be simplified:

• Specify the DbContext type to be used.
• Add 1 or more entities.
• Add a start time.
• Add a clean up period.
• Optional: add restrictions

Installation

To install the package, simply search the MPOSAirDataCleanUp package on nuget.org and install it in the same project where Entity Framework Core resides.

The following example illustrates the usage within a Web API project.

1. ServiceCollectionsExtensions Define the clean up services like so:

public static void AddDataCleanUp(this IServiceCollection services)
{
	services.AddDataCleanUpServices();

	services.AddSingleton<ICleanUpService, CleanUpService<VoucherDbContext>>();
}

2. ApplicationBuilderExtensions The following method configures the clean up service:

public static void ConfigureDataCleanUp(this IApplicationBuilder app)
{
            var cleanUpService = (ICleanUpService)app.ApplicationServices.GetService(typeof(ICleanUpService));

            var service = cleanUpService.WithContext(typeof(YourContext))
                                                          .ForEntity(typeof(YourEntity), (x) => x.CreatedDate > DateTime.Now.AddDays(-1))
                                                          .WithPeriod(CleanUpPeriod.Minutely)
                                                          .WithUtcStartTime("12:10:00")
                                                          .WithRestrictions(null);

            Task.Run(async () => await service.InitializeCleanUp(new System.Threading.CancellationToken()));
}

Then, in StartUp.cs, you have the following:

1. ConfigureServices

         services.AddDataCleanUp();

2. Configure

          app.ConfigureDataCleanUp();

Dependencies

MPOSAirDataCleanUp is heavily dependent on MposAirDataContracts v2.0.0. The dependency is so strong, that if you do not inherit your project entities from DataContracts, it will result in null elements being selected for your DbContext.

A new table will need to be created in your database. This table is used by MPOSAirDataCleanUp to keep track of cleaned entities. To this end, the DataCleaningEntityTypeConfiguration file already exists in the package. Simply add it to your Entity Framework configuration. Example:

 protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.ApplyConfiguration(new DataCleaningEntityTypeConfiguration());
        }

It's ok if you are not using Configuration files. When overriding OnModelCreating just configure the DataCleaning entity type.

Remember to add the migration when using Code First approach.

Any and all Unit of Work, Repositories or Entities should rely and inherit from MposAirDataContracts.

Method Description

Currently, the CleanUpService supports the following methods. Their usage is strictly enforced.

[REQUIRED] - WithContext(DbContext context) - The database context that needs cleaning. [REQUIRED] - ForEntity(Type entityType, Func<IEntity, bool> filter) - The entity that will be cleaned, along with a filter. Remember to cast the entity to it's type when using the filter, as above. [OPTIONAL] - AndForEntity(Type entityType, Func<IEntity, bool> filter) - Add another entity that will be cleaned, along with a filter. Remember to cast the entity to it's type when using the filter, as above. [REQUIRED] - WithUtcStartTime(string startTime) - Add the UTC start time to the cleaning process. Supported format: "14:00:00". [REQUIRED] - WithPeriod(CleanUpPeriod period) - Add the period to the cleaning process. V1.0.0 does not support other dates than the predefined ones for Weekly, Monthly and Yearly periods. [OPTIONAL] - WithRestrictions(CleanUpRestrictions restrictions) - Add restrictions to the cleaning process. Current restrictions include not cleaning during business hours. [REQUIRED] - InitializeCleanUp() - Starts the cleaning process.

CleanUpPeriod Options

• Daily - if the set time is before the current UTC time, then the next cleaning process will take place the next day.
• Weekly - every Sunday
• Monthly - the 1st of every month
• Yearly - the last day of the year

CAUTION

Any and all exceptions are captured and shown into the console output of the application that uses the nuget.

Make sure the table DataCleanings exists, otherwise, the nuget throws the error into the console and the cleaning will not take place.