public void ToCsv_Test()
{
_sut.Truncate().Execute();
INovaResult result = _sut.Select().Result();
string csv = result.ToCsv();
Assert.IsTrue(csv.Trim() == "id,col1,col2");
var entity = _sut.New();
entity["col1"] = 3;
entity["col2"] = "qwerty";
entity.Save();
_sut.Insert()
.Column("col1", 7)
.Column("col2", "asdfqwer")
.Execute();
csv = _sut.Select().Order("col1").Result().ToCsv();
string[] parts = csv.Split('\n');
Assert.IsTrue(parts.Count() > 1);
string[] cells = parts[1].Split(',');
Assert.IsTrue(cells.Count() > 0);
Assert.IsTrue(cells[1] == "3");
Assert.IsTrue(cells[2] == "\"qwerty\"");
}
public void ToJson_Test()
{
_sut.Truncate().Execute();
INovaResult result = _sut.Select().Result();
string json = result.ToJson();
Assert.IsTrue(json.Trim() == "[ ]");
var entity = _sut.New();
entity["col1"] = 3;
entity["col2"] = "qwerty";
entity.Save();
_sut.Insert()
.Column("col1", 7)
.Column("col2", "asdfqwer")
.Execute();
json = _sut.Select().Order("col1").Result().ToJson();
string json_shouldBe = "[ { \"id\" : 1,\"col1\" : 3,\"col2\" : \"qwerty\" }, { \"id\" : 2,\"col1\" : 7,\"col2\" : \"asdfqwer\" } ]";
var jObj = JArray.Parse(json);
var token = jObj.First;
var col1 = token["col1"].Value <int>();
var col2 = token["col2"].Value <string>();
Assert.IsTrue(col1 == 3);
Assert.IsTrue(col2 == "qwerty");
}
