public void SqlBuilderTestBit() { SqlResultBuilder builder = SqlResultBuilder.NewInstance(2); builder.SetColumnType(0, "bit"); builder.SetColumnType(1, "bit"); builder.SetColumnName(0, "Col-0"); builder.SetColumnName(1, "Col-1"); builder.PushRow(); builder.AddValue(0); builder.AddValue(1); builder.PopRow(); builder.PushRow(); builder.AddValue(false); builder.AddValue(true); builder.PopRow(); ISqlResultSet result = builder.Build(); Assert.IsTrue(result.GetColumnCount() == 2, "Column count is not equal to 5!"); Assert.IsTrue(result.GetRowCount() == 2, "Row count is not equal to 5!"); Assert.IsTrue(result.GetValue(0, 0).AsBool() == false); Assert.IsTrue(result.GetValue(1, 0).AsBool() == true); Assert.IsTrue(result.GetValue(0, 1).AsBool() == false); Assert.IsTrue(result.GetValue(1, 1).AsBool() == true); }
public void SqlBuilderTestString() { SqlResultBuilder builder = SqlResultBuilder.NewInstance(5); builder.SetColumnType(0, "nvarchar"); builder.SetColumnType(1, "nvarchar"); builder.SetColumnType(2, "nvarchar"); builder.SetColumnType(3, "nvarchar"); builder.SetColumnType(4, "nvarchar"); builder.SetColumnName(0, "Col-0"); builder.SetColumnName(1, "Col-1"); builder.SetColumnName(2, "Col-2"); builder.SetColumnName(3, "Col-3"); builder.SetColumnName(4, "Col-4"); builder.PushRow(); builder.AddValue("R0-C0"); builder.AddValue("R0-C1"); builder.AddValue("R0-C2"); builder.AddValue("R0-C3"); builder.AddValue("R0-C4"); builder.PopRow(); builder.PushRow(); builder.AddValue("R1-C0"); builder.AddValue("R1-C1"); builder.AddValue("R1-C2"); builder.AddValue("R1-C3"); builder.AddValue("R1-C4"); builder.PopRow(); builder.PushRow(); builder.AddValue("R2-C0"); builder.AddValue("R2-C1"); builder.AddValue("R2-C2"); builder.AddValue("R2-C3"); builder.AddValue("R2-C4"); builder.PopRow(); ISqlResultSet result = builder.Build(); Assert.IsTrue(result.GetColumnCount() == 5, "Column count is not equal to 5!"); Assert.IsTrue(result.GetRowCount() == 3, "Row count is not equal to 5!"); for (int i = 0; i < result.GetColumnCount(); i++) { string expected0 = "Col-" + i; string actual0 = result.GetColumnName(i); Assert.IsTrue(expected0.Equals(actual0), "Expected value{0}, current value {1}", expected0, actual0); for (int j = 0; j < result.GetRowCount(); j++) { string actual1 = result.GetValue(i, j).AsString(); string expected1 = "R" + j + "-C" + i; Assert.IsTrue(expected1.Equals(actual1), "Expected value{0}, current value {1}", expected1, actual1); } } }
public void SqlBuilderTestInt() { SqlResultBuilder builder = SqlResultBuilder.NewInstance(3); builder.SetColumnType(0, "int"); builder.SetColumnType(1, "int"); builder.SetColumnType(2, "int"); builder.SetColumnName(0, "Col-0"); builder.SetColumnName(1, "Col-1"); builder.SetColumnName(2, "Col-2"); builder.PushRow(); builder.AddValue(0); builder.AddValue(1); builder.AddValue(2); builder.PopRow(); builder.PushRow(); builder.AddValue(3); builder.AddValue(4); builder.AddValue(5); builder.PopRow(); ISqlResultSet result = builder.Build(); Assert.IsTrue(result.GetColumnCount() == 3, "Column count is not equal to 5!"); Assert.IsTrue(result.GetRowCount() == 2, "Row count is not equal to 5!"); Assert.IsTrue(result.GetValue(0, 0).AsInt() == 0); Assert.IsTrue(result.GetValue(1, 0).AsInt() == 1); Assert.IsTrue(result.GetValue(2, 0).AsInt() == 2); Assert.IsTrue(result.GetValue(0, 1).AsInt() == 3); Assert.IsTrue(result.GetValue(1, 1).AsInt() == 4); Assert.IsTrue(result.GetValue(2, 1).AsInt() == 5); }