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