コード例 #1
0
        public void TransformationTableToString_CorrectTable_ReturnIEnumerable()
        {
            var table = new Table(new string[] { "id", "User", "Balance", "Date" });

            table.AddRow("1234", "Иван Иванов", "10000.10", "10.10.2000");
            table.AddRow("1243", "Петор Петров", "100000", "2000-12-12");

            var result = step.TransformationTableToString(table);

            result.Should().NotBeNull();
            result.Should().HaveCount(2);
        }
コード例 #2
0
        public void ToSqlQuery_CorrectTable_ReturnString()
        {
            var table = new Table(new string[] { "id", "User", "Balance", "Date", "Bool" });

            table.AddRow("1243", "Петор Петров", "100000", "2000-12-12", "false");

            var ListParams = step.TransformationTableToString(table);

            var result = ListParams.ToSqlQuery(tableName);

            result.Should().BeEquivalentTo("INSERT INTO Table (id,User,Balance,Date,Bool)" +
                                           " VALUES (1243,'Петор Петров',100000,'2000-12-12',False)");
        }