uladz-zubrycki / reseed Goto Github PK

        {
            var deviceLogTable = new ObjectName("DeviceActivityLog");
            string deviceQuery = $"DELETE FROM [dbo].[DeviceActivityLog] where DeviceId = {TestData.DeviceId.ToString()}";

            var actions = _reseeder.Generate(
                dbConnection, SeedMode.Basic(
                    BasicInsertDefinition.Script(),
                    CleanupDefinition.Script(
                        CleanupMode.Delete(),
                        CleanupTarget.Including(
                            configure: c => c.IncludeTables(new ObjectName("DeviceActivityLog")),
                            customScripts: new[]
                            {
                                (deviceLogTable, deviceQuery)

                            }
                            
                        )),
                    DataProviders.Inline(builder => builder


                         //Add barcode
                         .AddEntities(
                            new Entity("DeviceActivityLog",
                            new[]
                            {
                                new Property("DeviceActivityLogId",TestData.DeviceActivityLogId.ToString()),
                                new Property("ActivityUnique",TestData.DeviceActivityUnique.ToString()),
                                new Property("Timestamp","2022-05-31 19:56:39.000"),
                                new Property("DeviceActivityTypeId","23"),
                                new Property("EntityId",TestData.LocationId.ToString()),
                                new Property("DeviceId",TestData.DeviceId.ToString()),
                                new Property("TransAmount","0.00"),
                                new Property("TicketPrice","0.00"),
                                new Property("ActivityLogFileName","220531195639"),
                                new Property("IsError","1"),
                                new Property("DrawerNumber",""),
                                new Property("ErrorMessage",""),
                            }
                          ))

                         .Build())));
            return actions;
        }

[Collection("Database Collection")]
    public class BaseApiTest
    {
        protected readonly TestFixture fixture;
        protected readonly ITestOutputHelper testOutput;
        public DatabaseHelper databaseHelper;
        


        //constructor is called before each test
        public BaseApiTest(TestFixture _fixture, ITestOutputHelper testOutputHelper)
        {
            fixture = _fixture;
            testOutput = testOutputHelper;

            fixture.Databases.ForEach(db => db.RestoreDatabase());

        }



        //Returns authenticated HTTP client with  bearer token
        public HttpClient GetClient()
        {
            var client = fixture.Client;

            return client;
        }
    }

public TestFixture()
        {
            Client = new HttpClient();

            TmsConnection = new SqlConnection(TmsConnectionString);
            TmsConnection.Open();
            DbTMS = new DatabaseHelperTMS(TmsConnection);

            LoggingConnection = new SqlConnection(LoggingConnectionString);
            LoggingConnection.Open();
            DbLogging = new DatabaseHelperLogging(LoggingConnection);
            
            Databases = new List<IDatabaseSeedManager>() { DbTMS, DbLogging };
            Databases.ForEach(db => db.PrepareDatabaseSeed());
        }


        //runs after class is created before any tests run
        //Get bearer token to authenticate client
        public async Task InitializeAsync()
        {
            await AuthenticateClient();
            
        }


        public async Task DisposeAsync()
        {
            
        }


        public void Dispose()
        {
            Databases.ForEach(db => db.CleanDatabase());
        }