public void Test_run_return_table_int()
{
DBConnection db = new DBConnection();
db.connect(SERVER, PORT);
BasicTable tb = (BasicTable)db.run("table(1..100 as id,take(`aaa,100) as name)");
Assert.IsTrue(tb.isTable());
Assert.AreEqual(100, tb.rows());
Assert.AreEqual(2, tb.columns());
Assert.AreEqual(3, ((BasicInt)tb.getColumn(0).get(2)).getValue());
}
public void blob_imemory_table_download()
{
DBConnection db = new DBConnection();
db.connect(SERVER, PORT);
db.run("a=table(100:0, `id`value`memo, [INT, DOUBLE, BLOB])");
db.run("insert into a values(10,0.5, '[{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"},{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"},{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"}]')");
BasicTable tb = (BasicTable)db.run("a");
Assert.IsTrue(tb.isTable());
Assert.AreEqual(1, tb.rows());
Assert.AreEqual(3, tb.columns());
Assert.AreEqual("[{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"},{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"},{\"name\":\"shily\",\"sex\":\"女\",\"age\":\"23\"}]", ((BasicString)tb.getColumn(2).get(0)).getValue());
db.close();
}
