private IList <IRow> ExecuteExtract(string xml, string rowPath, SqlMap <string, string> columnMappings, USqlSchema schema, SqlMap <string, string> namespaces = null)
{
using (var dataStream = new MemoryStream(Encoding.UTF8.GetBytes(xml)))
{
var reader = new USqlStreamReader(dataStream);
var extractor = new XmlExtractor(rowPath, columnMappings, namespaces);
return(extractor.Extract(reader, new USqlRow(schema, null).AsUpdatable()).ToList());
}
}
public void Extract_ValidUsersInputFromBoardgames_Succeeds()
{
IUpdatableRow output = GetUserRow().AsUpdatable();
IEnumerable <IRow> result;
using (FileStream fileReader = new FileStream("Input/Board-Games/Users.xml", FileMode.Open, FileAccess.Read))
{
USqlStreamReader streamReader = new USqlStreamReader(fileReader);
XmlExtractor extractor = new XmlExtractor();
result = extractor.Extract(streamReader, output);
Assert.Equal(9352, result.Count());
}
}
public void Extract_ValidCommentsInputFromCoffee_Succeeds()
{
IUpdatableRow output = GetCommentRow().AsUpdatable();
IEnumerable <IRow> result;
using (FileStream fileReader = new FileStream("Input/Coffee/Comments.xml", FileMode.Open, FileAccess.Read))
{
USqlStreamReader streamReader = new USqlStreamReader(fileReader);
XmlExtractor extractor = new XmlExtractor();
result = extractor.Extract(streamReader, output);
Assert.Equal(1279, result.Count());
}
}
public void Extract_ValidUsersInputFromCoffee_Succeeds()
{
IUpdatableRow output = GetUserRow().AsUpdatable();
IEnumerable<IRow> result;
using (FileStream fileReader = new FileStream("Input/Coffee/Users.xml", FileMode.Open, FileAccess.Read))
{
USqlStreamReader streamReader = new USqlStreamReader(fileReader);
XmlExtractor extractor = new XmlExtractor();
result = extractor.Extract(streamReader, output);
Assert.Equal(1162, result.Count());
}
}
public void Extract_ValidCommentsInputFromBoardgames_Succeeds()
{
IUpdatableRow output = GetCommentRow().AsUpdatable();
IEnumerable<IRow> result;
using (FileStream fileReader = new FileStream("Input/Board-Games/Comments.xml", FileMode.Open, FileAccess.Read))
{
USqlStreamReader streamReader = new USqlStreamReader(fileReader);
XmlExtractor extractor = new XmlExtractor();
result = extractor.Extract(streamReader, output);
Assert.Equal(23343, result.Count());
}
}
