public async Task Test_ReceiverBookmarkFileChrome()
{
var dir = AppContext.BaseDirectory;
#region ARRANGE
string pathFile = Path.Combine(dir, "bookmarks_7_25_17.html");
if (!File.Exists(pathFile))
{
throw new ArgumentException($"not found {pathFile}");
}
var receiver = new ReceiverBookmarkFileChrome(pathFile);
string transformExpression =
"var secs = double.Parse((oldValue??null).ToString());" +
"var val=new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(secs);" +
"val";
var transform = new TransformOneValueGeneral(transformExpression, "ADD_DATE", "realDate");
#endregion
#region ACT
ISimpleJob job = new SimpleJob();
job.Receivers.Add(0, receiver);
job.FiltersAndTransformers.Add(0, transform);
await job.Execute();
#endregion
#region ASSERT
Assert.AreEqual(5676, transform.valuesRead.Length);
Assert.AreEqual(5676, transform.valuesTransformed.Length);
Assert.AreEqual(new DateTime(2015, 5, 14, 19, 15, 50).ToString(), transform.valuesTransformed[0].Values["realDate"].ToString());
#endregion
}
public async Task TestSerializeReceiveBKChromeTransformOneValueSendCSV()
{
var dir = AppContext.BaseDirectory;
#region arange
string filename = Path.Combine(dir, "a.csv");
if (File.Exists(filename))
{
File.Delete(filename);
}
var receiver = new ReceiverBookmarkFileChrome(@"bookmarks_7_25_17.html");
string transformExpression =
"var secs = double.Parse((oldValue??null).ToString());" +
"var val=new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(secs);" +
"val";
var transform = new TransformOneValueGeneral(transformExpression, "ADD_DATE", "realDate");
var sender = new Sender_CSV(filename);
ISimpleJob job = new SimpleJob();
job.Receivers.Add(0, receiver);
job.FiltersAndTransformers.Add(0, transform);
job.Senders.Add(0, sender);
#endregion
#region act
var newJob = new SimpleJob();
newJob.UnSerialize(job.SerializeMe());
await newJob.Execute();
#endregion
#region assert
Assert.AreEqual(job.Senders.Count, newJob.Senders.Count);
Assert.AreEqual(job.Receivers.Count, newJob.Receivers.Count);
Assert.AreEqual(job.FiltersAndTransformers.Count, newJob.FiltersAndTransformers.Count);
Assert.IsTrue(File.Exists(filename), $"file {filename} must exists in export csv");
Assert.AreEqual(5677, File.ReadAllLines(filename).Length);
#endregion
}
static void Main(string[] args)
{
var testClass = new TestClass {
TheEncoding = Encoding.UTF8
};
var json = JsonConvert.SerializeObject(testClass, Formatting.Indented, new JsonEncodingConverter());
var obj = JsonConvert.DeserializeObject <TestClass>(json, new JsonEncodingConverter());
return;
//var f = new TransformerIntString("asd", "bas");
//var settings1 = new JsonSerializerSettings()
//{
// TypeNameHandling = TypeNameHandling.Objects,
// Formatting = Formatting.Indented,
// Error = HandleDeserializationError
// //ConstructorHandling= ConstructorHandling.AllowNonPublicDefaultConstructor
//};
//settings1.Converters.Add(new ExpressionJsonConverter(Assembly.GetEntryAssembly()));
//var x = JsonConvert.SerializeObject(f,settings1);
//Console.WriteLine(x);
//return;
brrbrrrr(); return;
var receiver = new ReceiverBookmarkFileChrome(@"C:\Users\admin\Documents\bookmarks_7_25_17.html");
//var tr = new TransformAddField<string, DateTime>(
// (addDate) =>
// {
// var secs = double.Parse(addDate);
// return new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(secs);
// }
// , "ADD_DATE", "realDate");
//var tr = new TransformAddField<string, DateTime>(
// (addDate) =>
// new DateTime(1970, 1, 1, 0, 0, 0, 0)
// .AddSeconds(double.Parse(addDate))
// , "ADD_DATE", "realDate");
string transformExpression =
"var secs = double.Parse((oldValue??null).ToString());" +
"var val=new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(secs);" +
"val";
var tr = new TransformOneValueGeneral(transformExpression, "ADD_DATE", "realDate");
var sender = new Sender_HTMLRazor("BKChrome.cshtml", "b.html");
SimpleJob sj = new SimpleJob();
sj.Receivers.Add(0, receiver);
sj.FiltersAndTransformers.Add(0, tr);
sj.Senders.Add(0, sender);
sj.Execute().Wait();
return;
//var x = MemoryMappedFile.CreateNew("testmap", 2);
//using (var writer = x.CreateViewAccessor(0,200, MemoryMappedFileAccess.Write))
//{
// // Write to MMF
// for(int s = 0; s < 20; s++)
// {
// Console.WriteLine(s);
// writer.Write(s, ('a'+s));
// }
//}
//using (var reader = x.CreateViewAccessor(0, 2000, MemoryMappedFileAccess.Read))
//{
// // Write to MMF
// for (int s = 0; s < 20; s++)
// {
// Console.WriteLine(s);
// var d= reader.ReadByte(s);
// Console.WriteLine((char)d);
// }
//}
//return;
ISerializeData sd = new SerializeDataInMemory();
ISend csvExport = new Sender_CSV("a.csv");
ISend xmlExport = new Sender_XML("a.xml", "values");
ISend jsonExport = new Sender_JSON("a.json");
//ISend influx = new SenderDB_Influx("http://localhost:8086", "mydb", "logical_reads", "cpu_time_ms", "total_elapsed_time_ms");
var data = new DBTableData <int, SqlConnection>(sd)
{
ConnectionString = "Server=.;Database=DatePtAndrei;Trusted_Connection=True;",
FieldNameToMark = "id",
TableName = "active_slowquery",
//Fields=new string[] { "id", "[session_id]" }
};
IReceive r = new ReceiverTableSQLServerInt(data);
ISimpleJob job = new SimpleJob();
job.Receivers.Add(0, r);
job.Senders.Add(0, csvExport);
job.Senders.Add(1, xmlExport);
job.Senders.Add(2, jsonExport);
//job.Senders.Add(3, influx);
var settings = new JsonSerializerSettings()
{
TypeNameHandling = TypeNameHandling.Objects,
Formatting = Formatting.Indented,
Error = HandleDeserializationError
//ConstructorHandling= ConstructorHandling.AllowNonPublicDefaultConstructor
};
//var serialized = JsonConvert.SerializeObject(job, settings);
//var deserialized = JsonConvert.DeserializeObject(File.ReadAllText("c.txt"), settings);
////File.WriteAllText("a.txt", serialized);
//File.WriteAllText("b.txt",JsonConvert.SerializeObject(deserialized as IJob, settings));
//return;
job.Execute().Wait();
return;
Process.Start("notepad.exe", "a.json");
//var connection = new SqliteConnection();
//connection.ConnectionString = "DataSource=:memory:";
//connection.Open();
//Console.WriteLine("Hello World!");
//var options = new DbContextOptionsBuilder<ApiContext>()
// //.UseInMemoryDatabase(databaseName: "Add_writes_to_database")
// .UseSqlite(connection)
// //.UseSqlite("DataSource=:memory:")
// .Options;
//using (var context = new ApiContext(options))
//{
// context.Database.EnsureCreated();
//}
//var apiContext = new ApiContext(options);
//apiContext.Posts.Add(new Post()
//{
// Id = 1,
// UserId = 1,
// Content = "Post1"
//});
//apiContext.SaveChanges();
//var db = apiContext.Database;
//var cmd = connection.CreateCommand();
//cmd.CommandText = "select count(*) from Posts";
//var i=cmd.ExecuteScalar();
//var c = ClaimsPrincipal.Current;
//if (c == null)
//{
//}
//var n = Thread.CurrentThread.Name;
//Console.WriteLine("ASD");
}
