Esempio n. 1
0
        public void testKeepWritingTask()
        {
            DBConnection conn = new DBConnection();

            conn.connect(SERVER, PORT, USER, PASSWORD, WRITE_FUNCTION_SCRIPT, true, HA_SITES);
            int    count      = 0;
            Random rnd        = new Random();
            string funcScript = String.Format("saveData{{{0}}}", TBNAME);

            Console.WriteLine(funcScript);
            for (int i = 0; i < 86400000; i++)
            {
                IList <IEntity>   args     = new List <IEntity>();
                DateTime          dt       = new DateTime(2021, 1, 1);
                BasicDateVector   bdv      = new BasicDateVector(new int[] { Utils.countDays(2021, 4, 7) });
                BasicTimeVector   btv      = new BasicTimeVector(new int[] { i });
                BasicStringVector bsv      = new BasicStringVector(new string[] { SYMBOLS[rnd.Next(3)] });
                BasicIntVector    bqv      = new BasicIntVector(new int[] { rnd.Next(80, 100) });
                BasicDoubleVector bpv      = new BasicDoubleVector(new double[] { rnd.NextDouble() });
                List <String>     colNames = new List <string>()
                {
                    "date", "time", "sym", "qty", "price"
                };
                List <IVector> cols = new List <IVector>()
                {
                    bdv, btv, bsv, bqv, bpv
                };
                BasicTable table1 = new BasicTable(colNames, cols);
                args.Add(table1);

                BasicInt re = (BasicInt)conn.run(funcScript, args);
                Console.WriteLine(re.getInt());
            }
        }
Esempio n. 2
0
 public Projectile(string name)
 {
     damage  = new BasicInt(name + " damage");
     delay   = new BasicInt(name + " delay"); // ms
     energy  = new BasicInt(name + " energy");
     speed   = new StepInt(name + " speed");
     bounces = new BasicInt(name + " bounces");
 }
Esempio n. 3
0
        /// <summary>
        /// Append a list of columns to the table. </summary>
        /// <param name="row"> </param>
        /// <returns> number of rows appended. </returns>
        /// <exception cref="IOException"> </exception>
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in .NET:
//ORIGINAL LINE: public int append(java.util.List<Entity> row) throws java.io.IOException
        public virtual int append(IList <Entity> row)
        {
            if (row.Count != cols)
            {
                throw new Exception("expect " + cols + " columns of values, got " + row.Count + " columns of values");
            }
            IList <Entity> args = new List <Entity>();

            args.Add(tableName);
            ((List <Entity>)args).AddRange(row);
            BasicInt affected = (BasicInt)conn.run("tableInsert", args);

            return(affected.Int);
        }
            bool writeAllData()
            {
                lock (writeAllDataLock_)
                {
                    List <IVector> items;
                    int            addRowCount;
                    lock (writeQueue_)
                    {
                        items       = writeQueue_[0];
                        addRowCount = items[0].rows();
                        if (addRowCount < 1)
                        {
                            return(false);
                        }
                        writeQueue_.RemoveAt(0);
                        if (writeQueue_.Count == 0)
                        {
                            writeQueue_.Add(tableWriter_.createListVector());
                        }
                    }
                    bool       isWriteDone = true;
                    string     runscript   = "";
                    BasicTable writeTable  = null;

                    writeTable = new BasicTable(tableWriter_.colNames_, items);
                    if (writeTable != null && addRowCount > 0)
                    {
                        runscript = "";
                        try
                        {
                            List <IEntity> args = new List <IEntity>();
                            args.Add(writeTable);
                            runscript = scriptTableInsert_;
                            BasicInt result = (BasicInt)conn_.run(runscript, args);
                            sentRows_ += addRowCount;
                        }
                        catch (Exception e)
                        {
                            Console.Out.WriteLine("threadid= {0}, Save Table error: {1}, script: {2}", threadId_, e.Message, runscript);
                            //System.Console.Out.WriteLine(e.Message);
                            //System.Console.Out.WriteLine(e.StackTrace);
                            //tableWriter_.logger_.warning("threadid=" + writeThread_.getId() + " sendindex=" + sentRows_ + " Save table error: " + e + " script:" + runscript);
                            tableWriter_.setError(ErrorCodeInfo.Code.EC_Server, "Save table error: " + e + " script: " + runscript);
                            isWriteDone = false;
                            //std::cerr << Util::createTimestamp(Util::getEpochTime())->getString() << " Backgroud thread of table (" << tableWriter_.dbName_ << " " << tableWriter_.tableName_ << "). Failed to send data to server, with exception: " << e.what() << std::endl;
                        }
                    }

                    if (!isWriteDone)
                    {
                        lock (failedQueue_)
                        {
                            int cols = items.Count;
                            int rows = items[0].rows();
                            for (int i = 0; i < rows; ++i)
                            {
                                List <IEntity> tmp = new List <IEntity>();

                                for (int j = 0; j < cols; ++j)
                                {
                                    if ((int)tableWriter_.colTypes_[j] < AbstractVector.ARRAY_VECTOR_BASE)
                                    {
                                        tmp.Add(items[j].get(i));
                                    }
                                    else
                                    {
                                        tmp.Add(((BasicArrayVector)items[j]).getSubVector(i));
                                    }
                                }
                                failedQueue_.Enqueue(tmp);
                            }
                        }
                    }
                }
                return(true);
            }
        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();
        }