Exemplo n.º 1
0
        public async Task TestLoadMaxRecordsWithLatestValueDateTime()
        {
            #region ARRANGE
            //ADD A DATABASE AND PUT nrPostsToAdd data into table
            ISerializeData sd = new SerializeDataInMemory();

            var connection = new SqliteConnection();
            connection.ConnectionString = "DataSource=:memory:";
            connection.Open();

            var options = new DbContextOptionsBuilder <ApiContext>()
                          .UseSqlite(connection)
                          .Options;
            using (var context = new ApiContext(options))
            {
                context.Database.EnsureCreated();
            }
            int nrPostsToAdd = 10;
            using (var contextAdd = new ApiContext(options))
            {
                for (int i = 0; i < nrPostsToAdd; i++)
                {
                    contextAdd.Posts.Add(new Post()
                    {
                        Id      = i + 1,
                        UserId  = i * 2,
                        Content = "Post" + i
                    });
                }
                await contextAdd.SaveChangesAsync();
            }
            int MaxRecordsToLoad = 3;
            #endregion
            #region ACT
            using (var dt = new DBTableDataSqliteMemory <DateTime>(connection, sd)
            {
                ConnectionString = "DataSource=:memory:",
                FieldNameToMark = "LastModifiedOrCreatedTime",
                TableName = "Posts",
                MaxRecordsToRead = MaxRecordsToLoad
            })
            {
                IReceive <DateTime> r = new ReceiverTableSQLiteDateTime(dt);
                await r.LoadData();

                #endregion
                #region ASSERT

                Assert.AreEqual(MaxRecordsToLoad, r.valuesRead.Length);
                Assert.AreEqual(0, (int)r.LastValue.Subtract(DateTime.Now).TotalSeconds);
                #endregion
            }
        }
Exemplo n.º 2
0
        public async Task TestOneReceiverAndOneSender()
        {
            #region ARRANGE
            var    dir      = AppContext.BaseDirectory;
            string filename = Path.Combine(dir, "a.csv");
            if (File.Exists(filename))
            {
                File.Delete(filename);
            }
            ISend csvExport = new Sender_CSV(filename);

            //ADD A DATABASE AND PUT nrPostsToAdd data into table
            ISerializeData sd = new SerializeDataInMemory();

            var connection = new SqliteConnection();
            connection.ConnectionString = "DataSource=:memory:";
            connection.Open();

            var options = new DbContextOptionsBuilder <ApiContext>()
                          .UseSqlite(connection)
                          .Options;
            using (var context = new ApiContext(options))
            {
                context.Database.EnsureCreated();
            }
            int nrPostsToAdd = 10;
            using (var contextAdd = new ApiContext(options))
            {
                for (int i = 0; i < nrPostsToAdd; i++)
                {
                    contextAdd.Posts.Add(new Post()
                    {
                        Id      = i + 1,
                        UserId  = i * 2,
                        Content = "Post" + i
                    });
                }
                await contextAdd.SaveChangesAsync();
            }
            using (var dt = new DBTableDataSqliteMemory <int>(connection, sd)
            {
                ConnectionString = "DataSource=:memory:",
                FieldNameToMark = "Id",
                TableName = "Posts"
            })
            {
                #endregion
                #region act
                IReceive   r   = new ReceiverTableSQLiteInt(dt);
                ISimpleJob job = new SimpleJob();
                job.Receivers.Add(0, r);
                job.Senders.Add(0, csvExport);
                await job.Execute();

                #endregion

                #region assert
                Assert.IsTrue(File.Exists(filename), $"file {filename} must exists in export csv");
                var lines = File.ReadAllLines(filename);
                Assert.AreEqual(nrPostsToAdd + 1, lines.Length);
                var lineNames = lines[0].Split(',');
                Assert.AreEqual("Id", lineNames[0]);
                Assert.AreEqual("Content", lineNames[1]);
                Assert.AreEqual("LastModifiedOrCreatedTime", lineNames[2]);
                Assert.AreEqual("UserId", lineNames[3]);

                #endregion
            }
        }
Exemplo n.º 3
0
        public async Task TestLoadWholeTableEachTime()
        {
            #region ARRANGE
            //ADD A DATABASE AND PUT nrPostsToAdd data into table
            ISerializeData sd = new SerializeDataInMemory();

            var connection = new SqliteConnection();
            connection.ConnectionString = "DataSource=:memory:";
            connection.Open();

            var options = new DbContextOptionsBuilder <ApiContext>()
                          .UseSqlite(connection)
                          .Options;
            using (var context = new ApiContext(options))
            {
                context.Database.EnsureCreated();
            }
            int nrPostsToAdd = 10;
            using (var contextAdd = new ApiContext(options))
            {
                for (int i = 0; i < nrPostsToAdd; i++)
                {
                    contextAdd.Posts.Add(new Post()
                    {
                        Id      = i + 1,
                        UserId  = i * 2,
                        Content = "Post" + i
                    });
                }
                await contextAdd.SaveChangesAsync();
            }

            #endregion
            #region ACT
            using (var dt = new DBTableDataSqliteMemory <FakeComparable>(connection, sd)
            {
                ConnectionString = "DataSource=:memory:",
                TableName = "Posts"
            })
            {
                IReceive r = new ReceiverWholeTableSQLite(dt);
                await r.LoadData();

                #endregion
                #region ASSERT

                Assert.AreEqual(nrPostsToAdd, r.valuesRead.Length);
                #endregion
                #region arange add new data into table
                using (var contextAddNew = new ApiContext(options))
                {
                    contextAddNew.Posts.Add(new Post()
                    {
                        Id      = nrPostsToAdd * 2,
                        UserId  = nrPostsToAdd,
                        Content = "Post" + nrPostsToAdd
                    });
                    await contextAddNew.SaveChangesAsync();
                }
                #endregion
                #region act
                await r.LoadData();

                #endregion
                #region assert
                Assert.AreEqual(nrPostsToAdd + 1, r.valuesRead.Length);
                #endregion
                #region arange
                //load from the beginning

                #endregion
                #region act
                await r.LoadData();

                #endregion
                #region assert
                Assert.AreEqual(nrPostsToAdd + 1, r.valuesRead.Length);

                #endregion
            }
        }