private static void WriteFile(IEnumerable <CommonStock> commonStocks, string fileName)
{
IStockProfileQuery stockProfileQuery = new StockProfileQuery();
using (System.IO.StreamWriter file = new System.IO.StreamWriter(fileName))
{
foreach (var stock in commonStocks)
{
try
{
Console.WriteLine("StockId:" + stock.Id);
Task.Delay(1000).Wait();
var criteria = new SearchStockProfileCriteria()
{
StockId = stock.Id, Symbol = stock.Symbol
};
var info = stockProfileQuery.SearchStockProfile(criteria);
string index = $"{{ \"index\": {{ \"_index\": \"set_commonstockinfo\", \"_type\": \"commonstockinfo\", \"_id\": \"{info.Id}\"}} }}";
file.WriteLine(index);
//string result = JsonConvert.SerializeObject(info);
string indexData = $"{{ \"id\":{info.Id}, \"stockId\":{info.StockId},\"symbol\":\"{info.Symbol}\",\"address\":\"{info.Address}\",\"telephone\":\"{info.Telephone}\",\"fax\":\"{info.Fax}\",\"webSite\":\"{info.WebSite}\",\"market\":\"{info.Market}\",\"securityName\":\"{info.SecurityName}\",\"industry\":\"{info.Industry}\",\"sector\":\"{info.Sector}\",\"firstTradeDate\":\"{info.FirstTradeDate}\",\"parValue\":{info.ParValue},\"authorizedCapital\":{info.AuthorizedCapital},\"paidUpCapital\":{info.PaidUpCapital},\"listedShare\":{info.ListedShare},\"paidUpStock\":{info.PaidUpStock} }}";
file.WriteLine(indexData);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
public void SearchStockProfileTest()
{
IStockProfileQuery query = new StockProfileQuery();
var criteria = new SearchStockProfileCriteria();
criteria.Symbol = "A";
criteria.StockId = 1;
var stockInfo = query.SearchStockProfile(criteria);
string result = JsonConvert.SerializeObject(stockInfo);
}
public void IndexCommonStockInfo()
{
var context = new EsContext(new Uri("http://*****:*****@"./../../../SourceFiles/");
WriteFile(commonStocks.Skip(0).Take(100), Path.Combine(path, "commonStockProfileEn_0-100.json"));
/*
* var amt = commonStocks.Count();
* int start = 0;
* do
* {
* WriteFile(commonStocks.Skip(start).Take(100), Path.Combine(path, $"commonStockProfileEn_{start}-{start+100}.json"));
* start += (start+101 < amt ? start+(amt-start): 101);
* } while (start <= commonStocks.Count());
*
*/
}
