mongo的objectid如果重复插入如何解决

最新推荐文章于 2025-06-05 22:45:30 发布

蓝色水

最新推荐文章于 2025-06-05 22:45:30 发布

阅读量5.1k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/orichisonic/article/details/45968439

数据库专栏收录该内容

35 篇文章

订阅专栏

本文介绍了一个从实时股票报价(stockquotes)同步数据至历史报价(HistoricalQuote)的策略，特别是如何处理重复插入相同ObjectId的问题，通过为每日最新的股票数据创建新的ObjectId来确保数据的唯一性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这边遇到一个从stockquotes插入每天的股票数据到HistoricalQuote的情况，在重复插入这条一样的ObjectId的时候要新建一条objectId。

        public void PopulateLatestStockQuotesToHistoricalQuotesPerDay()
        {
           
                lock (Locker)
                {
                    Task a = new Task(() =>
                    {
                       
                        Logger.Debug("Getting LatestStockQuoteInfo");
                        var tradeDate = DateTime.UtcNow;
                        var lastWriteTime = MarketDataProvider.GetLastWriteTime();
                        if (lastWriteTime.ToShortDateString() != tradeDate.ToShortDateString())
                        {
                            Logger.Debug("The show2003 Dbf doesn't change intraday.");
                            return;
                        }
                        var stockQuotesInfo = _uow.StockQuotesInfo.GetAll().ToList();
                        foreach (var stockQuote in stockQuotesInfo)
                        {
                            var histQuotes = _uow.HistoricalQuotes.GetAll().Where(m => m.StockCode == stockQuote.SecurityCode).ToList();
                           
                            if (histQuotes.Count > 0)
                            {
                                var latestQuote = histQuotes.OrderByDescending(m => m.TradeDate).First();
                                if (latestQuote.TradeDate < tradeDate)
                                {
                                    HistoricalQuote historicalQuote = Mapper.Map<StockQuoteInfo, HistoricalQuote>(stockQuote);
                                    historicalQuote.Id = new MongoDB.Bson.ObjectId();
                                    historicalQuote.TradeDate = tradeDate;
                                    _uow.HistoricalQuotes.Add(historicalQuote);
                                }
                            }
                            else
                            {
                                HistoricalQuote historicalQuote = Mapper.Map<StockQuoteInfo, HistoricalQuote>(stockQuote);
                                //historicalQuote.Id = new MongoDB.Bson.ObjectId();
                                historicalQuote.TradeDate = tradeDate;
                                _uow.HistoricalQuotes.Add(historicalQuote);
                            }
                         
                        }
                        Logger.Debug("PopulateLatestStockQuotesToHistoricalQuotesPerDay Completed");
                    });
                    a.Start();
                    Task.WaitAll(a);
                }
           

        }