private void InitDatabase()
{
string mongoUrl = File.ReadAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "settings\\mongoConnection"));
CountersDatabase.InitConnection(mongoUrl);
}
static void Main(string[] args)
{
if (!File.Exists("state"))
{
File.Create("state").Close();
}
string[] states = File.ReadAllLines("state");
Console.WriteLine("Readed " + states.Length + " states");
string mongoUrl = File.ReadAllText("settings\\mongoConnection");
CountersDatabase.InitConnection(mongoUrl);
Console.WriteLine("Connection initialized");
for (int i = 0; i < states.Length; i++)
{
string[] state = states[i].Split('\t');
string category = state[0];
string counterName = state[1];
string counterSource = state[2];
string counterInstance = state[3];
string counterExtData = state[4];
string statName = state[6];
Console.WriteLine("Reading data for " + statName);
List <object> allSeriesData = new List <object>();
DateTime dt = DateTime.Now;
DateTime now = DateTime.Now;
DateTime startDate = state.Length == 6 ? DateTime.Parse(state[5]) : DateTime.MinValue;
CounterDataParameters parameters = new CounterDataParameters(startDate.ToString("dd.MM.yyyy HH:mm:ss"),
DateTime.MaxValue.ToString("dd.MM.yyyy HH:mm:ss"),
Int32.Parse(category),
Int32.Parse(counterName),
Int32.Parse(counterSource),
Int32.Parse(counterInstance),
Int32.Parse(counterExtData),
"*");
SqlConnection connection = new SqlConnection("Data Source=app77;Initial Catalog=KeLiteDownloads;Connect Timeout=300; Max Pool Size=1000;Integrated Security=SSPI;Application Name=stats;");
connection.Open();
string commandText =
@"IF EXISTS(select 1 from Stats where [date]=@date and [statKey]=@statKey and [extend]=@extend)
UPDATE Stats SET [value] = @value WHERE [date]=@date and [statKey]=@statKey and [extend]=@extend
ELSE
INSERT INTO Stats ([date], [statKey], [extend], [value]) VALUES (@date, @statKey, @extend, @value)" ;
SqlCommand command = new SqlCommand(commandText, connection);
/*List<CounterSeriesData> result = CountersDatabase.Instance.GetCounterData(
* startDate, DateTime.MaxValue, Int32.Parse(category),
* Int32.Parse(counterName), Int32.Parse(counterSource), Int32.Parse(counterInstance),
* Int32.Parse(counterExtData), new List<string> { "*" });*/
List <CounterSeriesData> result = parameters.Sources.AsParallel().SelectMany(
source => parameters.Instances.AsParallel().SelectMany(
instance => parameters.ExtendedDatas.AsParallel().SelectMany(
extData =>
CountersDatabase.Instance.GetCounterData(parameters.BeginDate, parameters.EndDate,
parameters.CounterCategoryId,
parameters.CounterNameId, source.Id, instance.Id,
extData.Id, parameters.Series)
))).ToList();
Console.WriteLine("Data for " + statName + " readed. Total " + result.Count + " values");
foreach (CounterSeriesData counterSeriesData in result)
{
foreach (SeriesPoint seriesPoint in counterSeriesData.Points)
{
if (!seriesPoint.Value.HasValue)
{
continue;
}
command.Parameters.Clear();
command.Parameters.AddWithValue("date", seriesPoint.DateTime.RoundTo5Minutes().ToLocalTime());
command.Parameters.AddWithValue("statKey", statName);
command.Parameters.AddWithValue("extend", counterSeriesData.CounterSource);
command.Parameters.AddWithValue("value", seriesPoint.Value);
command.ExecuteNonQuery();
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}",
counterSeriesData.CounterCategory, counterSeriesData.CounterName, counterSeriesData.CounterSource, counterSeriesData.CounterInstance, counterSeriesData.CounterExtData,
counterSeriesData.SeriesName, seriesPoint.DateTime.RoundTo5Minutes().ToLocalTime(), seriesPoint.Value);
}
}
Console.WriteLine("Data saved to SQL Server");
states[i] = String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}", category, counterName, counterSource,
counterInstance, counterExtData, now, statName);
}
File.WriteAllLines("state", states);
}
static void Main(string[] args)
{
var list = new List <int> {
1, 2, 3
};
//var x1 = new { Items = ((IEnumerable<int>)list).GetEnumerator() };
/* while (x1.Items.MoveNext())
* {
* Console.WriteLine(x1.Items.Current);
* }*/
//Console.ReadLine();
var x2 = new { Items = list.GetEnumerator() };
var en = list.GetEnumerator();
while (en.MoveNext())
{
Console.WriteLine(en.Current);
}
Console.ReadLine();
return;
Program pr = new Program();
pr.Test();
return;
ReadLastDates();
string mongoUrl = File.ReadAllText("settings\\mongoConnection");
CountersDatabase.InitConnection(mongoUrl);
List <CounterCategoryInfo> categories = CountersDatabase.Instance.GetCounterCategories().ToList();
foreach (CounterCategoryInfo counterCategoryInfo in categories)
{
List <CounterNameInfo> counterNames =
CountersDatabase.Instance.GetCounterNamesInCategory(counterCategoryInfo.Id).ToList();
foreach (CounterNameInfo counterNameInfo in counterNames)
{
Console.WriteLine("Чистим " + counterCategoryInfo.Name + "." + counterNameInfo.Name);
DateTime left, right;
left = right = GetLastProcessedDateForCounter(counterCategoryInfo, counterNameInfo);
while (right < DateTime.Now.AddMinutes(-20))
{
var possibleLeftDate = CountersDatabase.Instance.GetFreshestAfterDate(counterCategoryInfo.Name, counterNameInfo.Name, left);
if (!possibleLeftDate.HasValue)
{
break;
}
left = possibleLeftDate.Value;
right = left.AddMinutes(5).AddSeconds(-1);
CountersDatabase.Instance.RemoveCountersValuesBetweenDates(counterCategoryInfo.Name, counterNameInfo.Name, left, right);
//left = right.AddSeconds(1);
}
Console.WriteLine("Почистили " + counterCategoryInfo.Name + "." + counterNameInfo.Name);
File.AppendAllText("lastDates", counterCategoryInfo.Name + "\t" + counterNameInfo.Name + "\t" + left + "\r\n");
}
}
}