public void XmlToDB(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "SELECT * FROM resource WHERE id=1";
string actual = toDB.ConvertXmlToSQL(xmlReq);
Assert.AreEqual(expected, actual);
}
public void cenvertResponseToXmlNotOk2(string status, int statusCode, string payload)
{
var pom = new Mock <IXmlToDB>();
XmlToDB xml2DB = new XmlToDB(pom.Object);
Assert.Throws <ArgumentException>(() =>
{
string fResult = xml2DB.ConvertResponseToXml(status, statusCode, payload);
});
}
public void DetermineAndConvertToSQLTestOk9(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "UPDATE resource SET surname='petrovic' WHERE id=1";
string actual = toDB.DetermineAndConvertToSQL(xmlReq);
Assert.AreEqual(expected, actual);
}
public void XmlToDBQueryFields(string xml)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "SELECT id,name FROM resource WHERE id=1 AND name='mika' AND surname='mikic'";
string actual = toDB.ConvertToSqlQueryFields(xml);
Assert.AreEqual(expected, actual);
}
public void XmlToDBFields4(string xml)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "SELECT name,surname FROM resource WHERE id=1";
string actual = toDB.ConvertToSqlFields(xml);
Assert.AreEqual(expected, actual);
}
public void XmlToDBQuery3(string xml)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "SELECT * FROM resource WHERE name='pera' AND surname='peric'";
string actual = toDB.ConvertToSqlQuery(xml);
Assert.AreEqual(expected, actual);
}
public void DetermineAndConvertToSQLFail2(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
Assert.Throws <ArgumentException>(() =>
{
toDB.DetermineAndConvertToSQL(xmlReq);
});
}
public void DetermineAndConvertToSQLTestDelete0(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "DELETE FROM resource WHERE id=1";
string actual = toDB.DetermineAndConvertToSQL(xmlReq);
Assert.AreEqual(expected, actual);
}
public void cenvertResponseToXmlOk31(string status, int statusCode, string payload)
{
var pom = new Mock <IXmlToDB>();
XmlToDB xml2DB = new XmlToDB(pom.Object);
string output = "<response>\n <status>SUCCESS</status>\n <statusCode>2000</statusCode>\n <surname>Federer</surname>\n <name>Roger</name>\n <surname>Nadal</surname>\n <name>Rafael</name>\n <surname>Djokovic</surname>\n <name>Novak</name>\n</response>";
string fResult = xml2DB.ConvertResponseToXml(status, statusCode, payload);
Assert.AreEqual(output, fResult);
}
public void cenvertResponseToXmlOk23(string status, int statusCode, string payload)
{
var pom = new Mock <IXmlToDB>();
XmlToDB xml2DB = new XmlToDB(pom.Object);
string output = "<response>\n <status>SUCCESS</status>\n <statusCode>2000</statusCode>\n <surname>Federer</surname>\n <id>1</id>\n</response>";
string fResult = xml2DB.ConvertResponseToXml(status, statusCode, payload);
Assert.AreEqual(output, fResult);
}
public void cenvertResponseToXmlOk1(string status, int statusCode, string payload)
{
var pom = new Mock <IXmlToDB>();
XmlToDB xml2DB = new XmlToDB(pom.Object);
string output = "<response>\n <status>REJECTED</status>\n <statusCode>3000</statusCode>\n <errorMessage>ERROR</errorMessage>\n</response>";
string fResult = xml2DB.ConvertResponseToXml(status, statusCode, payload);
Assert.AreEqual(output, fResult);
}
public void DetermineAndConvertToSQLTestOk2(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "SELECT * FROM resource WHERE id=1 AND name='pera' AND surname='petrovic'";
string actual = toDB.DetermineAndConvertToSQL(xmlReq);
Assert.AreEqual(expected, actual);
}
public void DetermineAndConvertToSQLTestOk1(string xmlReq)
{
var pom = new Mock <IXmlToDB>();
XmlToDB toDB = new XmlToDB(pom.Object);
string expected = "INSERT INTO resource (id,name,surname) VALUES ('1','pera','peric')";
string actual = toDB.DetermineAndConvertToSQL(xmlReq);
Assert.AreEqual(expected, actual);
}
