public void Test_run_return_scalar_long() { DBConnection db = new DBConnection(); db.connect(SERVER, PORT); BasicLong re = (BasicLong)db.run("1l"); Assert.AreEqual(1, re.getValue()); }
public void append_test() { DBConnection conn = new DBConnection(false); conn.connect(SERVER, PORT, USER, PASSWORD); conn.run("dbPath = \"dfs://demohash\";if(existsDatabase(dbPath)) dropDatabase(dbPath); db = database(dbPath, HASH,[STRING, 2]);t= table(100:0,`股票代码`股票日期`买方报价`卖方报价`时间戳`备注`timespan,[STRING,MONTH,DOUBLE,DOUBLE,DATE,STRING,TIME]);pt=db.createPartitionedTable(t,`pt,`股票代码);"); autoFitTableAppender aft = new autoFitTableAppender("dfs://demohash", "pt", false, conn); DataTable dt = new DataTable(); List <DataColumn> cols = new List <DataColumn>() { new DataColumn("股票代码", Type.GetType("System.String")), new DataColumn("股票日期", Type.GetType("System.DateTime")), new DataColumn("买方报价", Type.GetType("System.Double")), new DataColumn("卖方报价", Type.GetType("System.Double")), new DataColumn("时间戳", Type.GetType("System.DateTime")), new DataColumn("备注", Type.GetType("System.String")), new DataColumn("timespan", Type.GetType("System.TimeSpan")) }; dt.Columns.AddRange(cols.ToArray()); for (int i = 0; i < 1000; i++) { DataRow dr = dt.NewRow(); dr["股票代码"] = new string[] { "GGG", "MSSS", "FBBBB" }[i % 3]; dr["股票日期"] = DateTime.Now.Date; dr["买方报价"] = 22222.5544; dr["卖方报价"] = 3333.33322145; dr["时间戳"] = new DateTime(2021, 1, 26, 15, 1, 2); dr["备注"] = "备注" + i.ToString(); dr["timespan"] = new TimeSpan(0, 15, 15, 14, 123); dt.Rows.Add(dr); } IEntity res = aft.append(dt); //Assert.AreEqual(res, null); DBConnection db = new DBConnection(); db.connect(SERVER, PORT, USER, PASSWORD); for (int i = 0; i < 10; i++) { Thread.Sleep(1000); try { BasicLong x = (BasicLong)db.run("exec count(*) from loadTable(\"dfs://demohash\",`pt)"); if (x.getValue() == 1000) { break; } } catch (Exception ex) { BasicInt x = (BasicInt)db.run("exec count(*) from loadTable(\"dfs://demohash\",`pt)"); if (x.getValue() == 1000) { break; } } } BasicLong re = (BasicLong)db.run("exec count(*) from loadTable(\"dfs://demohash\",`pt)"); Assert.AreEqual(re.getValue(), 1000); db.run("dropDatabase(\"dfs://demohash\")"); db.close(); }