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));
}
