public void Test_Upload_DataTable()
{
DataTable dt = new DataTable();
DataColumn dc = new DataColumn("dt_string", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_short", Type.GetType("System.Int16"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_int", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_long", Type.GetType("System.Int64"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_double", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_datetime", Type.GetType("System.DateTime"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_bool", Type.GetType("System.Boolean"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_byte", Type.GetType("System.Byte"));
dt.Columns.Add(dc);
dc = new DataColumn("dt_string", Type.GetType("System.String"));
dt.Columns.Add(dc);
DataRow dr = dt.NewRow();
dr["dt_short"] = 1;
dr["dt_int"] = 2147483646;
dr["dt_long"] = 2147483649;
dr["dt_double"] = 3.14159893984;
dr["dt_datetime"] = new DateTime(2018, 03, 30, 14, 59, 02, 111);
dr["dt_bool"] = false;
dr["dt_byte"] = (byte)97;
dr["dt_string"] = "test_string";
dt.Rows.Add(dr);
DBConnection db = new DBConnection();
db.connect(SERVER, PORT);
BasicTable bt = new BasicTable(dt);
Dictionary <string, IEntity> obj = new Dictionary <string, IEntity>();
obj.Add("up_datatable", (IEntity)bt);
db.upload(obj);
BasicIntVector v = (BasicIntVector)db.run("up_datatable.dt_int");
Assert.AreEqual(2147483646, v.get(0));
}
