public void SetField_IndexValue_NullColumnThrows() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); Assert.Throws <IndexOutOfRangeException>(() => DataRowExtensions.SetField(row, columnIndex: -1, value: 0)); }
public void TrySetFieldWithNullThis() { var e = Assert.Throws <ArgumentNullException>(() => DataRowExtensions.TrySetField(null, "Monty", "Python")); Assert.Equal("row", e.ParamName); }
public void Field_String_NullColumnNameThrows() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); AssertExtensions.Throws <ArgumentNullException>("name", () => DataRowExtensions.Field <int>(row, columnName: null)); }
public void SetField_ColumnValue_NullColumnThrows() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); AssertExtensions.Throws <ArgumentNullException>("column", () => DataRowExtensions.SetField(row, column: null, value: 0)); }
public void Field_IndexVersion_NegativeIndexThrows() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); Assert.Throws <IndexOutOfRangeException>(() => DataRowExtensions.Field <int>(row, columnIndex: -1, version: DataRowVersion.Default)); }
public void Field_ColumnVersion_NullColumnThrows() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); AssertExtensions.Throws <ArgumentNullException>("column", () => DataRowExtensions.Field <int>(row, column: null, version: DataRowVersion.Default)); }
public void PointsToSameDataSameArray() { var a = new[] { StringValue, IntValue, DoubleValue, DateTimeValue, ObjectValue }; var actual = DataRowExtensions.PointsToSameData(a, a); Assert.IsTrue(actual); }
public void PointsToSameDataDifferentSizes() { var a = new object[] { StringValue, IntValue }; var b = new object[] { StringValue, IntValue, DoubleValue }; var actual = DataRowExtensions.PointsToSameData(a, b); Assert.IsFalse(actual); }
public void PointsToSameDataEmptyArrays() { var a = new object[] {}; var b = new object[] {}; var actual = DataRowExtensions.PointsToSameData(a, b); Assert.IsTrue(actual); }
public void PointsToSameDataEquivalentValues() { var a = new object[] { StringValue, IntValue, DoubleValue, DateTimeValue }; var b = new object[] { "StringValue", 42, 3.1415926535897932384626433832795, new DateTime(2012, 03, 12, 16, 05, 29) }; var actual = DataRowExtensions.PointsToSameData(a, b); Assert.IsTrue(actual); }
public void AssertHasValue_WithDataRowNull() { //Arrange DataRow dataRow = null; string columnName = "Column1"; string rowIdentifier = Guid.NewGuid().ToString(); // Action DataRowExtensions.AssertHasValue <string>(dataRow, columnName, rowIdentifier); }
public void AssertAreEqual_WithDataRowNull() { //Arrange DataRow dataRow = null; string columnName = "Column1"; string expectedValue = Guid.NewGuid().ToString(); // Action DataRowExtensions.AssertAreEqual(dataRow, columnName, expectedValue); }
public void SetField_NameValue_NullValueReplacedByDBNull() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); table.Columns.Add(new DataColumn("foo")); DataRowExtensions.SetField <string>(row, columnName: "foo", value: null); Assert.Equal(DBNull.Value, row["foo"]); }
public void SetField_ColumnValue_NullValueReplacedByDBNull() { DataTable table = new DataTable("test"); DataRow row = table.NewRow(); DataColumn column = new DataColumn(); table.Columns.Add(column); DataRowExtensions.SetField <string>(row, column: column, value: null); Assert.Equal(DBNull.Value, row[column]); }
public void GetFirstValue_WithNullDataRow() { //Arrange DataRow dataRow = null; string columnName = "Column1"; // Action var actual = DataRowExtensions.GetFirstValue(dataRow, columnName); // Assert Assert.IsNull(actual); }
public void Field_NullSource_ThrowsArgumentNullException() { var table = new DataTable(); DataColumn column = table.Columns.Add("Column"); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column)); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, 0)); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, "Column")); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column, DataRowVersion.Current)); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, 0, DataRowVersion.Current)); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, "Column", DataRowVersion.Current)); }
public void GetWhereClause_wrap_only_spaces() { Dictionary <string, string> d = new Dictionary <string, string>(); d.Add("first name", "'john'"); d.Add("last", "'smith'"); SqlGeneratorConfig config = new SqlGeneratorConfig("table"); config.NameWrappingPattern = IdentifierWrappingPattern.WrapOnlyObjectNamesThatContainSpaces; string where = DataRowExtensions.GetWhereClause(config, d); Assert.Equal("WHERE `first name` = 'john' AND last = 'smith'", where); }
public void GetSetClause_wrap_all() { Dictionary <string, string> d = new Dictionary <string, string>(); d.Add("first name", "'john'"); d.Add("last", "'smith'"); SqlGeneratorConfig config = new SqlGeneratorConfig("table"); config.NameWrappingPattern = IdentifierWrappingPattern.WrapAllObjectNames; string set = DataRowExtensions.GetSetClause(config, d); Assert.Equal("SET `first name` = 'john', `last` = 'smith'", set); }
public void AssertHasValue_WithColumnNameStringEmpty() { //Arrange var dataTable = new DataTable(); string columnName = string.Empty; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); // Action DataRowExtensions.AssertHasValue <string>(dataRow, columnName); }
public void GetWhereClause_wrap_all_prefix_columns() { Dictionary <string, string> d = new Dictionary <string, string>(); d.Add("first name", "'john'"); d.Add("last", "'smith'"); SqlGeneratorConfig config = new SqlGeneratorConfig("table"); config.NameWrappingPattern = IdentifierWrappingPattern.WrapAllObjectNames; config.PrefixColumnNameWithTableName = true; string where = DataRowExtensions.GetWhereClause(config, d); Assert.Equal("WHERE `table`.`first name` = 'john' AND `table`.`last` = 'smith'", where); }
public void GetFirstValue_WithNullColumnNames() { //Arrange var dataTable = new DataTable(); string[] columnNames = null; var dataColumn = new DataColumn(Guid.NewGuid().ToString()); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); // Action DataRowExtensions.GetFirstValue(dataRow, columnNames); }
public void AssertHasValue_WithNonMatchingTypeValue() { //Arrange var dataTable = new DataTable(); string columnName = "Column1"; var dataColumn = new DataColumn(columnName, typeof(Guid)); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); dataRow[dataColumn] = Guid.NewGuid(); // Action DataRowExtensions.AssertHasValue <string>(dataRow, columnName); }
public void AssertHasValue_WithNullValue() { //Arrange var dataTable = new DataTable(); string columnName = "Column1"; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); dataRow[dataColumn] = null; // Action DataRowExtensions.AssertHasValue <string>(dataRow, columnName); }
public void AssertHasValue_WithValue() { //Arrange var dataTable = new DataTable(); string columnName = "Column1"; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); dataRow[dataColumn] = Guid.NewGuid().ToString(); // Action DataRowExtensions.AssertHasValue(dataRow, columnName); }
public void AssertAreEqual_WithColumnNameStringEmpty() { //Arrange var dataTable = new DataTable(); string columnName = string.Empty; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); string expectedValue = Guid.NewGuid().ToString(); // Action DataRowExtensions.AssertAreEqual(dataRow, columnName, expectedValue); }
public void AssertAreEqual_WithNonEqualValues() { //Arrange var dataTable = new DataTable(); string columnName = "Column1"; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); var expectedValue = Guid.NewGuid().ToString(); dataRow[columnName] = Guid.NewGuid().ToString(); // Action DataRowExtensions.AssertAreEqual(dataRow, columnName, expectedValue); }
public void GetFirstValue_WithValidValue() { //Arrange var dataTable = new DataTable(); string columnName = "Column1"; var dataColumn = new DataColumn(columnName); dataTable.Columns.Add(dataColumn); var dataRow = dataTable.NewRow(); var expected = Guid.NewGuid().ToString(); dataRow[dataColumn] = expected; // Action var actual = DataRowExtensions.GetFirstValue(dataRow, columnName); // Assert Assert.AreEqual(expected, actual); }
//選択された日付の日記を探すメソッド public void FindDiary() { //2箇所のdateTextBoxに表示するメソッドを呼び出す SetDate(); Form1Data.diaryEditTextBoxText = null; //選択された日付の日記を探す var row = dataSet.diaryDataTable.Rows.Find(Form1Data.date); var colum = dataSet.diaryDataTable.Columns.IndexOf("日記"); //選択された日付の日記が存在しなければ return if (row == null) { return; } //選択された日付の日記が存在していれば、内容を TextBox に代入 var value = DataRowExtensions.Field <string>(row, colum); Form1Data.diaryEditTextBoxText = value; }
public void Field_ColumnVersion_NullRowThrows() { DataColumn column = new DataColumn(); AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column: column, version: DataRowVersion.Default)); }
public void Field_NameVersion_NullRowThrows() { AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, columnName: "foo", version: DataRowVersion.Default)); }