static string SimpleJobDllLoadTypes()
{
string dir = Environment.CurrentDirectory;
IReceive folderWithDll = new ReceiverFolderHierarchical("#static:Directory.GetCurrentDirectory()#", "*.dll");
var filterFiles = new FilterForFilesHierarchical();
var recContentFile = new ReceiverFromDllRelational();
var loadDllromFiles = new TransformerApplyReceiver(recContentFile, "DllFileName", "FullName");
var fileRazor = Path.Combine(dir, "relationalGeneric.cshtml");
string filename = "#static:Directory.GetCurrentDirectory()#\\relationalDLL.html";
ISend senderHTML = new SyncSenderMultiple(
new Sender_Text(filename, "<html><body>")
{
FileMode = FileMode.Create
},
new Sender_HTMLRazor("Views/" + Path.GetFileName(fileRazor), filename),
//new Sender_HTMLRelationViz("Name", filename),
new Sender_Text(filename, "</body></html>")
)
;
var job = new SimpleJob();
job.Receivers.Add(0, folderWithDll);
job.FiltersAndTransformers.Add(0, filterFiles);
job.FiltersAndTransformers.Add(1, loadDllromFiles);
job.Senders.Add(0, senderHTML);
return(job.SerializeMe());
}
public async Task TestFilterHierarchicalFiles()
{
#region arrange
var dir = AppContext.BaseDirectory;
dir = UtilsIO.DeleteCreateFolder(Path.Combine(dir, "TestFilterHierarchicalFiles"));
string filename = Path.Combine(dir, "a.html");
if (File.Exists(filename))
{
File.Delete(filename);
}
string fileNameToWrite = Guid.NewGuid().ToString("N") + ".txt";
string fullNameFile = Path.Combine(dir, fileNameToWrite);
File.WriteAllText(fullNameFile, "andrei ignat");
#endregion
#region act
IReceive r = new ReceiverFolderHierarchical(dir, "*.txt");
await r.LoadData();
var fi = new FilterForFilesHierarchical();
fi.valuesRead = r.valuesRead;
await fi.Run();
#endregion
#region assert
foreach (var item in fi.valuesTransformed)
{
item.Values.ShouldContainKeyAndValue("RowType", "file");
}
#endregion
}
public async Task TestTransformerApplyReceiverFiles()
{
#region arrange
var dir = AppContext.BaseDirectory;
dir = UtilsIO.DeleteCreateFolder(Path.Combine(dir, "TestTransformerApplyReceiverFiles"));
string filename = Path.Combine(dir, "a.html");
if (File.Exists(filename))
{
File.Delete(filename);
}
string fileNameToWrite = Guid.NewGuid().ToString("N") + ".txt";
string fullNameFile = Path.Combine(dir, fileNameToWrite);
File.WriteAllText(fullNameFile, "andrei ignat" + Environment.NewLine + "aaa");
var readFile = new ReceiverFileFromStorageLines(fullNameFile, Encoding.UTF8);
readFile.ReadAllFirstTime = false;
#endregion
#region act
IReceive r = new ReceiverFolderHierarchical(dir, "*.txt");
await r.LoadData();
var fi = new FilterForFilesHierarchical();
fi.valuesRead = r.valuesRead;
await fi.Run();
var transformerApplyReceiver = new TransformerApplyReceiver(readFile, "FileToRead", "FullName");
transformerApplyReceiver.valuesRead = fi.valuesTransformed;
await transformerApplyReceiver.Run();
#endregion
#region assert
transformerApplyReceiver.valuesTransformed.ShouldNotBeNull();
transformerApplyReceiver.valuesTransformed.Length.ShouldBe(2, "2 lines above");
#endregion
}
static async Task ExecuteSlnAnalysis()
{
string root = "@static:Path.GetPathRoot(#static:Directory.GetCurrentDirectory()#)@";
var si = new SimpleJob();
var recFolder = new ReceiverFolderHierarchical(root, "*tank*.sln;*StankinsSimpleJobNET*.exe");
si.Receivers.Add(0, recFolder);
IFilter fi = new FilterForFilesHierarchical();
si.FiltersAndTransformers.Add(0, fi);
si.UnSerialize(si.SerializeMe());
await si.Execute();
fi = si.FiltersAndTransformers[0] as IFilter;
var exe = fi.valuesTransformed.FirstOrDefault(it => it.Values["FullName"].ToString().EndsWith(".exe"));
if (exe == null)
{
Console.WriteLine("please build StankinsSimpleJobNET");
return;
}
string exePath = exe.Values["FullName"].ToString();
string exeDir = Path.GetDirectoryName(exePath);
//cleanup
foreach (var item in Directory.GetFiles(exeDir, "*.json"))
{
File.Delete(item);
}
//File.Copy("SolutionExport.txt", Path.Combine(exeDir, "SolutionExport.txt"));
var slns = fi.valuesTransformed.Select(it => it.Values["FullName"]?.ToString()).Where(it => (it ?? "").Contains(".sln")).ToArray();
foreach (var sln in slns)
{
Console.WriteLine($"interpret:{sln}");
var psi = new ProcessStartInfo(exePath, "execute SolutionExport.txt");
psi.WorkingDirectory = exeDir;
psi.Environment["solutionPath"] = sln;
var p = Process.Start(psi);
if (p.WaitForExit(60 * 1000))
{
var newJob = new SimpleJobConditionalTransformers();
var json = Path.Combine(exeDir, Path.GetFileNameWithoutExtension(sln) + ".json");
var rec = new ReceiverJSONFileInt(json, Encoding.UTF8);
newJob.Receivers.Add(0, rec);
string fileName = Path.Combine(AppContext.BaseDirectory, Path.GetFileNameWithoutExtension(sln) + ".html");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
Console.WriteLine($"exporting to {fileName}");
string fileRazor = "solution.cshtml";
var sender = new SyncSenderMultiple(
new Sender_Text(fileName, "<html><body>"),
new Sender_HTMLRazor("Views/" + Path.GetFileName(fileRazor), fileName)
);
newJob.AddSender(sender);
var filter = new FilterExcludeRelation("referencedIn", "assemblyReferenced");
var senderViz = new SyncSenderMultiple(
new Sender_HTMLRelationViz("Name", fileName),
new Sender_Text(fileName, "</body></html>")
);
newJob.Add(filter, senderViz);
await newJob.Execute();
}
}
}
static string PBXJob()
{
var dir = AppContext.BaseDirectory;
var dirPBX = Path.Combine(dir, "PBX");
var serialize = new SerializeDataOnFile("a.txt");
IReceive r = new ReceiverFolderHierarchical(dirPBX, "*.log");
IFilter filterFiles = new FilterForFilesHierarchical();
#region filter for remove dates serialize
var filterDateTime = new FilterComparableGreat(typeof(DateTime), DateTime.MinValue, "LastWriteTimeUtc");
IFilter filterDateTimeSerializable = new FilterComparableFromSerializable(filterDateTime, serialize);
#endregion
IFilter removeFilesMaxWritten = new FilterRemovePropertyMaxMinDateTime("LastWriteTimeUtc", GroupingFunctions.Max);
ITransform transformLines = new TransformerFileToLines()
{
TrimEmptyLines = true
};
var trDateRegex = new TransformRowRegex(@"^Date:\ (?<datePBX>.{23}).*?$", "text");
var trKeyValueRegex = new TransformRowRegex(@"(^|\r|\n|\r\n)(?<tkey>(\$?[a-zA-Z0-9_[\]/ ]+))='?(?<tvalue>([a-zA-Z0-9_ ]+))'?(\r|\r\n|$)", "text");
var trToDate = new TransformerFieldStringToDate("datePBX", "NewDatePBX", "yyyy/MM/dd HH:mm:ss.fff");
var trAddDate = new TransformAddFieldDown("NewDatePBX");
var trAddKey = new TransformAddNewField("tkey");
var trAddValue = new TransformAddNewField("tvalue");
var trSimpleFields = new TransformRowRemainsProperties("NewDatePBX", "lineNr", "text", "FullName", "LastWriteTimeUtc", "tkey", "tvalue");
var data = new DBTableDataConnection <SqlConnection>(new SerializeDataInMemory());
data.ConnectionString = "#file:SqlServerConnectionString#";
data.Fields = new string[] { "NewDatePBX", "lineNr", "text", "FullName", "tkey", "tvalue" };
data.TableName = "PBXData";
var bulk = new SenderSqlServerBulkCopy(data);
var md = new MediaTransformMaxMin <DateTime>();
md.GroupFunction = GroupingFunctions.Max;
md.FieldName = "LastWriteTimeUtc";
var serializeMaxDate = new SenderMediaSerialize <DateTime>(serialize, "LastWriteTimeUtc", md);
var si = new SimpleJob();
si.Receivers.Add(0, r);
int iFilterNr = 0;
si.FiltersAndTransformers.Add(iFilterNr++, filterFiles);
si.FiltersAndTransformers.Add(iFilterNr++, filterDateTimeSerializable);
si.FiltersAndTransformers.Add(iFilterNr++, removeFilesMaxWritten);
si.FiltersAndTransformers.Add(iFilterNr++, transformLines);
si.FiltersAndTransformers.Add(iFilterNr++, trDateRegex);
si.FiltersAndTransformers.Add(iFilterNr++, trKeyValueRegex);
si.FiltersAndTransformers.Add(iFilterNr++, trToDate);
si.FiltersAndTransformers.Add(iFilterNr++, trAddDate);
si.FiltersAndTransformers.Add(iFilterNr++, trAddKey);
si.FiltersAndTransformers.Add(iFilterNr++, trAddValue);
si.FiltersAndTransformers.Add(iFilterNr++, trSimpleFields);
//TODO: add transformer to add a field down for all fields
//TODO: add transformer regex for splitting Key=Value
//TODO: add field to separate Conn(1)Type(Any)User(InternalTask) CDL Request:RSVI(Get)
si.Senders.Add(0, bulk);
si.Senders.Add(1, serializeMaxDate);
return(si.SerializeMe());
}
static string JobDllBlockly()
{
string dir = Environment.CurrentDirectory;
IReceive folderWithDll = new ReceiverFolderHierarchical("#static:Directory.GetCurrentDirectory()#", "*.dll");
var filterFiles = new FilterForFilesHierarchical();
var recContentFile = new ReceiverFromDllRelational();
var loadDllFromFiles = new TransformerApplyReceiver(recContentFile, "DllFileName", "FullName");
//retain just types
var filterTypes = new FilterRetainRelationalName(FilterType.Equal, "Types");
//load types that are not generic or abstract
//var justTypes = new FilterComparableEqual(typeof(string), "Types", "NameRelation");
var notAbstract = new FilterComparableEqual(typeof(bool), false, "IsAbstract");
var notGeneric = new FilterComparableEqual(typeof(bool), false, "IsGeneric");
var notInterface = new FilterComparableEqual(typeof(bool), false, "IsInterface");
//var noInterface = new FilterExcludeRelation("Interfaces");
//var rel2plain = new TransformerRelationalToPlain();
var haveProps = new FilterComparableGreat(typeof(int), 0, "PropertiesNr");
//var justRelations = new FilterRetainItemsWithKey("NameRelation", FilterType.Equal);
var fileRazor = Path.Combine(dir, "blockly.cshtml");
string filename = "#static:Directory.GetCurrentDirectory()#\\blockly.html";
ISend senderHTML = new SyncSenderMultiple(
new Sender_Text(filename, "<html><body>")
{
FileMode = FileMode.Create
},
new Sender_HTMLRazor("Views/" + Path.GetFileName(fileRazor), filename),
//new Sender_HTMLRelationViz("Name", filename),
new Sender_Text(filename, "</body></html>")
)
;
var senderRow = new SenderByRowToFile("Name", "txt", "Block Definition", "txt");
var clear = new TransformClearValues();
var trReceiveHtml = new ReceiverHTMLTable(@"blockly.html", Encoding.UTF8);
var decodeHtml = new TransformerHtmlDecode();
//var addJS = new TransformModifyField("Name", "{0}.js");
var senderBlockTag = new SenderByRowToFile("Name", "_def.txt", "Block definition", "txt");
var senderBlockDefinitionJs = new SenderByRowToFile("Name", "_block.js", "Block JS", "js");
var senderBlockCodeJs = new SenderByRowToFile("Name", "_code.js", "Block CodeGenerator", "js");
var job = new SimpleJobConditionalTransformers();
job
.AddReceiver(folderWithDll)
.AddFilter(filterFiles)
.AddTransformer(loadDllFromFiles)
.AddFilter(filterTypes)
.AddFilter(notAbstract)
.AddFilter(notGeneric)
.AddFilter(notInterface)
.AddFilter(haveProps)
//.AddTransformer(noInterface)
//.AddTransformer(rel2plain)
.AddSender(senderHTML)
.AddTransformer(clear)
.Add(clear, trReceiveHtml)
.Add(trReceiveHtml, decodeHtml)
.Add(decodeHtml, senderBlockTag)
.Add(decodeHtml, senderBlockDefinitionJs)
.Add(decodeHtml, senderBlockCodeJs)
;
return(job.SerializeMe());
}
public async Task TestPBXData()
{
#region arrange
string connectionString = GetSqlServerConnectionString();
using (var conn = new SqlConnection(connectionString))
{
await conn.OpenAsync();
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"
IF OBJECT_ID('dbo.PBXData', 'U') IS NOT NULL
DROP TABLE dbo.PBXData;";
await cmd.ExecuteNonQueryAsync();
cmd.CommandText = @"CREATE TABLE [PBXData](
[NewDatePBX] [datetime] NOT NULL,
[lineNr] [int] NOT NULL,
[text] [nvarchar](500) NOT NULL,
[FullName] [nvarchar](500) NOT NULL
)";
await cmd.ExecuteNonQueryAsync();
}
await Task.Delay(2000);
var dir = AppContext.BaseDirectory;
var dirPBX = Path.Combine(dir, "PBX");
File.AppendAllText(Path.Combine(dirPBX, "PBXRemove.log"), "aaaa");
#endregion
#region act
var serialize = new SerializeDataOnFile("a.txt");
IReceive r = new ReceiverFolderHierarchical(dirPBX, "*.log");
IFilter filterFiles = new FilterForFilesHierarchical();
#region filter for remove dates serialize
var filterDateTime = new FilterComparableGreat(typeof(DateTime), DateTime.MinValue, "LastWriteTimeUtc");
IFilter filterDateTimeSerializable = new FilterComparableFromSerializable(filterDateTime, serialize);
#endregion
IFilter removeFilesMaxWritten = new FilterRemovePropertyMaxMinDateTime("LastWriteTimeUtc", GroupingFunctions.Max);
ITransform transformLines = new TransformerFileToLines()
{
TrimEmptyLines = true
};
var trDateRegex = new TransformRowRegex(@"^Date:\ (?<datePBX>.{23}).*?$", "text");
var trToDate = new TransformerFieldStringToDate("datePBX", "NewDatePBX", "yyyy/MM/dd HH:mm:ss.fff");
var trAddDate = new TransformAddFieldDown("NewDatePBX");
var trSimpleFields = new TransformRowRemainsProperties("NewDatePBX", "lineNr", "text", "FullName", "LastWriteTimeUtc");
var data = new DBTableDataConnection <SqlConnection>(new SerializeDataInMemory());
data.ConnectionString = GetSqlServerConnectionString();
data.Fields = new string[] { "NewDatePBX", "lineNr", "text", "FullName" };
data.TableName = "PBXData";
var bulk = new SenderSqlServerBulkCopy(data);
var md = new MediaTransformMaxMin <DateTime>();
md.GroupFunction = GroupingFunctions.Max;
md.FieldName = "LastWriteTimeUtc";
var serializeMaxDate = new SenderMediaSerialize <DateTime>(serialize, "LastWriteTimeUtc", md);
var si = new SimpleJob();
si.Receivers.Add(0, r);
int iFilterNr = 0;
si.FiltersAndTransformers.Add(iFilterNr++, filterFiles);
si.FiltersAndTransformers.Add(iFilterNr++, filterDateTimeSerializable);
si.FiltersAndTransformers.Add(iFilterNr++, removeFilesMaxWritten);
si.FiltersAndTransformers.Add(iFilterNr++, transformLines);
si.FiltersAndTransformers.Add(iFilterNr++, trDateRegex);
si.FiltersAndTransformers.Add(iFilterNr++, trToDate);
si.FiltersAndTransformers.Add(iFilterNr++, trAddDate);
si.FiltersAndTransformers.Add(iFilterNr++, trSimpleFields);
//TODO: add transformer to add a field down for all fields
//TODO: add transformer regex for splitting Key=Value
//TODO: add field to separate Conn(1)Type(Any)User(InternalTask) CDL Request:RSVI(Get)
si.Senders.Add(0, bulk);
si.Senders.Add(1, serializeMaxDate);
await si.Execute();
#endregion
#region assert
filterFiles.valuesTransformed.Length.ShouldBe(3, "three files after first filter");
removeFilesMaxWritten.valuesTransformed.Length.ShouldBe(2, "last one file written dismissed");
transformLines.valuesTransformed.Length.ShouldBe(77251);
var d = transformLines.valuesTransformed.Select(it => it.Values["FullName"]).Distinct().ToArray();
d.Length.ShouldBe(2, "two files after reading contents");
//transformGroupingFiles.valuesTransformed.Length.ShouldBe(2);
//trDateRegex.valuesTransformed.Count(it => it.Values.ContainsKey("datePBX")).ShouldBeGreaterThan(0,"datePBX");
//trToDate.valuesTransformed.Count(it => it.Values.ContainsKey("NewDatePBX")).ShouldBeGreaterThan(0,"NewDatePBX");
foreach (var item in trAddDate.valuesTransformed)
{
item.Values.ShouldContainKey("NewDatePBX");
}
foreach (var item in trSimpleFields.valuesTransformed)
{
item.Values.Keys.Count.ShouldBe(5);
}
using (var con = new SqlConnection(connectionString))
{
await con.OpenAsync();
using (var cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select count(*) from PBXData";
var val = await cmd.ExecuteScalarAsync();
val.ShouldBe(77251);
}
}
md.Result.Year.ShouldBe(DateTime.Now.Year);
#endregion
#region arange to read again
r = new ReceiverFolderHierarchical(dirPBX, "*.log");
filterFiles = new FilterForFilesHierarchical();
#region filter for remove dates serialize
filterDateTime = new FilterComparableGreat(typeof(DateTime), DateTime.MinValue, "LastWriteTimeUtc");
filterDateTimeSerializable = new FilterComparableFromSerializable(filterDateTime, serialize);
#endregion
#endregion
#region act
si = new SimpleJob();
si.Receivers.Add(0, r);
iFilterNr = 0;
si.FiltersAndTransformers.Add(iFilterNr++, filterFiles);
si.FiltersAndTransformers.Add(iFilterNr++, filterDateTimeSerializable);
await si.Execute();
#endregion
#region assert
filterDateTime.valuesTransformed?.Length.ShouldBe(1, "next time 1 file read - the added one");
#endregion
}
}
