public void Check_if_Table_Where_returned_Right_record()
{
var db = FakeDatabaseData.GetDatabaseWithData();
var rows = db["Accounts"].Where(row => row["FirstName"].Equals("Krzysztof"));
Assert.Equal(1, rows.Count());
}
public void Check_if_multiple_tables_with_same_field_will_be_returned()
{
var db = FakeDatabaseData.GetDatabaseWithData();
var query = db.Where(row => row["CountryName"].Equals("Poland"));
Assert.Equal(2, query.Count);
Assert.Equal(1, query[db["Accounts"]].Count);
}
public void Test_if_table_record_was_added_successfully()
{
var db = FakeDatabaseData.GetDatabaseWithData();
var accTable = db["Accounts"];
Assert.True(4 <= accTable.Columns.Count());
Assert.True(4 <= accTable.Rows.Count());
Assert.Equal("Krzysztof", accTable.GetRow(0)["FirstName"]);
}
public void Test_if_IFakeDatabase_was_converted_to_DataSet()
{
var fakeDb = FakeDatabaseData.GetDatabaseWithData();
var dataSet = fakeDb.ToDataSet();
Assert.True(dataSet.Tables.Count >= 2);
Assert.True(dataSet.Tables["Accounts"].Columns.Count >= 4);
Assert.True(dataSet.Tables["Accounts"].Rows.Count >= 4);
Assert.Equal(dataSet.Tables["Accounts"].Rows[0]["FirstName"], "Krzysztof");
}
public void Check_if_Table_with_List_in_Where_returned_Right_record()
{
var db = FakeDatabaseData.GetDatabaseWithData();
var rows = db["Accounts"].Where(new List <Func <IFakeRow, bool> >()
{
row => row["FirstName"].Equals("Krzysztof"),
row => row["LastName"].Equals("Dobrzynski")
});
Assert.Equal(1, rows.Count());
}
public void Try_to_get_joined_row()
{
var db = FakeDatabaseData.GetDatabaseWithData();
var joined = db["Accounts"][0].ToJoinedRow();
Assert.Equal("Krzysztof", joined["FirstName"]);
var toJoin = db["Countries"][0].ToJoinedRow();
Assert.Equal(2, toJoin.Values.Values.Count);
Assert.NotNull(toJoin["CountryId"]);
var afterJoin = joined.JoinToNew(toJoin);
Assert.Equal(toJoin["CountryId"], afterJoin["CountryId"]);
}
public void Export_IFakeDatabase_to_CSV_File()
{
try
{
File.Delete(PATH);
}
catch (Exception) { }
var exporter = new FakeDbExporter <FileStream>()
{
Configuration = new FakeDbExporterCSVConfiguration()
};
var fileStream = new FileStream(PATH, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
var fakeDb = FakeDatabaseData.GetDatabaseWithData();
exporter.Export(fileStream, fakeDb);
Assert.True(fileStream != null);
}
public void Try_to_write_Database_to_JSON()
{
try
{
File.Delete(PATH);
}
catch (Exception) { }
var db = FakeDatabaseData.GetDatabaseWithData();
using (JsonWriter writer = new JsonTextWriter(File.CreateText(PATH)))
{
var serializer = new FakeDbSerializer <JsonReader, JsonWriter>()
{
Database = db,
Configuration = new FakeDbJSONByColumnConfiguration()
};
serializer.WriteDatabase(writer);
}
Assert.True(db != null);
}
public void Test_if_IFakeDatabase_was_saved_to_file_using_DataSet()
{
try
{
File.Delete(PATH);
}
catch (Exception) { }
var db = FakeDatabaseData.GetDatabaseWithData();
var fileStream = new FileStream(PATH, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
using (var writer = XmlWriter.Create(fileStream))
{
var serializer = new FakeDbSerializer <XmlReader, XmlWriter>()
{
Database = db,
Configuration = new FakeDbDataSetConfiguration()
};
serializer.WriteDatabase(writer);
}
Assert.True(fileStream != null);
}
public void Try_to_read_IFakeDatabase_from_file_using_DataSet()
{
try
{
File.Delete(PATH_2);
}
catch (Exception) { }
var db = FakeDatabaseData.GetDatabaseWithData();
var fileStream = new FileStream(PATH_2, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
var serializer = new FakeDbSerializer <XmlReader, XmlWriter>()
{
Database = db,
Configuration = new FakeDbDataSetConfiguration()
};
lock (new object())
{
serializer.WriteDatabase(XmlWriter.Create(fileStream));
fileStream.Flush();
fileStream.Close();
}
// Prepare to read
serializer.Database = FakeDatabaseFactory.NewDatabase("New empty Database for Read Test");
fileStream = new FileStream(PATH_2, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
serializer.ReadDatabase(XmlReader.Create(fileStream));
var dbReaded = serializer.Database;
Assert.True(db != null);
Assert.Equal("Test Database", db.Name);
Assert.True(db.Tables.Count() == 2);
Assert.Equal("Poland", db["Countries"]["CountryName"][0]);
}
