示例#1
0
        static void add(DateTime date, IEnumerable <SerializablePrices> table, KdbData type)
        {
            if (!table.Any())
            {
                return;
            }
            createDirectoryIfNotFound(date, type);
            string targetPath = createFileName(date, type);

            try {
                var seri = new XmlSerializer(typeof(SerializablePrices[]));
                using (FileStream fs = new FileStream(targetPath, FileMode.Create)) {
                    seri.Serialize(fs, table.ToArray());
                }
                StockPriceManager.SetMessage(
                    DataSource.Kdb,
                    type.ToString() + ", " + date.ToString("yyyy-MM-dd") + ", 書き込み完了"
                    );
            } catch (Exception e) {
                StockPriceManager.SetMessage(new ManagementMessage()
                {
                    Sender  = DataSource.Kdb,
                    Signal  = MessageSignal.Error,
                    Message = type.ToString() + " " + date.ToString("yyyy-MM-dd") + " のデータの書き込みに失敗しました。",
                    Detail  = e.Message,
                });
            }
        }
示例#2
0
        static void createDirectoryIfNotFound(DateTime date, KdbData type)
        {
            string s = localPath + type.ToString() + Path.DirectorySeparatorChar + date.Year.ToString();

            if (!Directory.Exists(s))
            {
                Directory.CreateDirectory(s);
            }
        }
示例#3
0
 static IEnumerable <DateTime> getExistingDataDate(KdbData type)
 {
     try {
         return(Directory.GetFiles(localPath + type.ToString() + Path.DirectorySeparatorChar, "*", SearchOption.AllDirectories)
                .Select(a => Path.GetFileNameWithoutExtension(a))
                .Select(a => ResultWithValue.Of <string, DateTime>(DateTime.TryParse, a))
                .Where(a => a.Result)
                .Select(a => a.Value)
                .OrderBy(a => a));
     } catch (DirectoryNotFoundException) {
         return(new DateTime[0]);
     }
 }
示例#4
0
        static string _download(DateTime dt, KdbData type)
        {
            //try {
            //ダウンロード元のURL
            //string url = "http://k-db.com/stocks/" + dt.ToString("yyyy-MM-dd") + "?download=csv";
            string url = "http://k-db.com/" + type.ToString() + "/" + dt.ToString("yyyy-MM-dd") + "?download=csv";

            //データを文字列としてダウンロードする
            return(wc.DownloadString(url));
            //} catch {
            //	return "";
            //}
        }
示例#5
0
        internal static IEnumerable <SerializablePrices> Acquire(KdbData kdb, DateTime since, DateTime until, Func <SerializablePrices, bool> pred)
        {
            var span = getExistingDataDate(kdb).SkipWhile(a => a < since).TakeWhile(a => a <= until);

            foreach (var dt in span)
            {
                var d = tryGet(dt, kdb).OfType <SerializablePrices>()
                        .Where(a => pred(a));
                foreach (var c in d)
                {
                    yield return(c);
                }
            }
        }
示例#6
0
 static SerializablePrices[] tryGet(DateTime date, KdbData type)
 {
     if (!getExistingDataDate(type).Any(a => a == date))
     {
         return(new SerializablePrices[0]);
     }
     try {
         var deseri = new XmlSerializer(typeof(SerializablePrices[]));
         using (FileStream fs = new FileStream(createFileName(date, type), FileMode.Open)) {
             return(deseri.Deserialize(fs) as SerializablePrices[]);
         }
     }catch (Exception e) {
         StockPriceManager.SetMessage(new ManagementMessage()
         {
             Sender  = DataSource.Kdb,
             Signal  = MessageSignal.Error,
             Message = type.ToString() + " " + date.ToString("yyyy-MM-dd") + " のデータの読み込みに失敗しました。",
             Detail  = e.Message
         });
         return(new SerializablePrices[0]);
     }
 }
示例#7
0
 static string createFileName(DateTime date, KdbData type)
 {
     return(localPath + type.ToString() + Path.DirectorySeparatorChar + date.Year.ToString() + Path.DirectorySeparatorChar + date.ToString("yyyy-MM-dd") + ".xml");
 }
示例#8
0
        static IEnumerable <Tuple <DateTime, IEnumerable <SerializablePrices> > > download(DateTime start, DateTime end, KdbData type)
        {
            Func <DateTime, DateTime, DateTime> nxt = (c, e) => {
                return((c < e) ? c.AddDays(1) : (c > e) ? c.AddDays(-1) : c);
            };
            DateTime current = start;

            do
            {
                if (current.DayOfWeek != DayOfWeek.Saturday && current.DayOfWeek != DayOfWeek.Sunday)
                {
                    Thread.Sleep(2000);
                    var s = _download(current, type);
                    StockPriceManager.SetMessage(
                        DataSource.Kdb,
                        type.ToString() + ", " + current.ToString("yyyy-MM-dd") + ", ダウンロード完了"
                        );
                    if (!string.IsNullOrEmpty(s))
                    {
                        using (var str = new StreamReader(new MemoryStream(Encoding.UTF8.GetBytes(s))))
                            using (var csv = new CsvReader(str)) {
                                switch (type)
                                {
                                case KdbData.stocks:
                                    csv.Configuration.RegisterClassMap <StockCsvMap>();
                                    break;

                                case KdbData.indices:
                                    csv.Configuration.RegisterClassMap <IndexCsvMap>();
                                    break;
                                }
                                var rec = csv.GetRecords <SerializablePrices>().ToArray();
                                foreach (var r in rec)
                                {
                                    r.Date = current;
                                }
                                yield return(new Tuple <DateTime, IEnumerable <SerializablePrices> >(current, rec));
                            }
                    }
                    Thread.Sleep(3000);
                }
                current = nxt(current, end);
            } while (current != end);
        }