public int BatchInsertIncidentCollections(MatchCollection collections, ConfigInitializer.IncidentTableEntity incidentTable, out HashSet<string> duplicateHash, bool SKIP)
{
duplicateHash = new HashSet<string>();
if (SKIP) return 0;
var queryText = incidentTable.ToString();
var incident = new DataNormalizer.DataEntity.Incident(incidentTable);
int successCount = 0;
//var queryText = $"INSERT into {this.tableInfo.tableName} {this.tableInfo.queryItemPattern} VALUES {this.tableInfo.queryValuePattern}";
using (var transaction = this._connection.BeginTransaction())
{
foreach (Match match in collections)
{
var cmd = new SqlCommand(queryText, this._connection, transaction);
incident.registerSqlCommand(match, ref cmd);
try
{
cmd.ExecuteNonQuery();
Console.WriteLine($"Insert: {match.Groups[1].Value}");
successCount += 1;
}
catch
{
var incidentString = match.Groups[1].Value;
duplicateHash.Add(incidentString);
Console.WriteLine($"Duplicate Incident: {incidentString}");
}
}
transaction.Commit();
}
return successCount;
}
private void InitializeApplicationConfig()
{
ConfigInitializer.DirectoryName = "El Rosario SIGI";
if (!ConfigInitializer.ExistConfig())
{
ConfigInitializer.CreateConfig();
}
}
private static void InitializeConfigs(AzureSession session, string profilePath)
{
var fallbackList = new List <string>()
{
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile), ".Azure", "PSConfig.json"),
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), ".Azure", "PSConfig.json")
};
ConfigInitializer configInitializer = new ConfigInitializer(fallbackList);
configInitializer.MigrateConfigs(profilePath);
configInitializer.InitializeForAzureSession(session);
}
protected void uxOK_Click(object sender, EventArgs e)
{
if (uxProviders.SelectedValue == "sql")
{
ConfigInitializer.InitializeSql(uxConnectionStrings.SelectedValue);
}
else
{
ConfigInitializer.InitializeAccess(uxAccessFileName.Text);
}
Response.Redirect(JcoHttpHandler.HandlerPath + "?a=conf&p=2");
//MultiView1.ActiveViewIndex = 1;
}
public void BatchInsertDialogCollections(ConfigInitializer.ChatlogTableEntity chatlogTable, MatchCollection chatlogCollections, int IncidentId, bool SKIP)
{
if (SKIP) return;
Console.WriteLine(" [Sub-Chatlog] Inserting...");
var queryText = chatlogTable.ToHeader();
var chatlog = new DataNormalizer.DataEntity.ChatLog(chatlogTable);
using (var transaction = this._connection.BeginTransaction())
{
int TOTAL_DIALOG_NUM = chatlogCollections.Count;
int finished = 0;
int BATCH_COUNT = 0;
int LENGTH = chatlogCollections.Count;
for (int i = 0; i < LENGTH; i++)
{
var match = chatlogCollections[i];
if (BATCH_COUNT != 0)
{
// add head value with ","
queryText += ",";
}
queryText += chatlog.getParameterString(match, IncidentId);
BATCH_COUNT += 1;
// reach BATCH SIZE || last match
if (BATCH_COUNT >= 100 || i == LENGTH - 1)
{
// execute command and reset cmd text
_executeCMD(queryText, this._connection, transaction);
queryText = chatlogTable.ToHeader();
BATCH_COUNT = 0;
finished += 100;
}
}
//chatlog.clearState();
transaction.Commit();
Console.WriteLine($" [Sub-Chatlog] Insert : Done! IncidentID = {IncidentId}, LENGTH={LENGTH}");
}
}
public void NoFileExtension()
{
string configFile = Files.cr_noEnding;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = CombineWithDefaultLogFolder("StreamRedirection");
string expectedStreamFile = CombineWithDefaultLogFolder("Log");
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsFalse(ci.Errors.HasErrors);
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void GoodCustomValues()
{
string configFile = Files.cr_fine;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = CombineWithDefaultLogFolder("./b.txt");
string expectedStreamFile = CombineWithDefaultLogFolder("./a.txt");
LogLevel expectedLogLevel = LogLevel.Trace;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Full;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsFalse(ci.Errors.HasErrors);
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
}
public void MissingFields()
{
string configFile = Files.cr_missingFields;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsFalse(ci.Errors.HasErrors, "has error mismatch");
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void WrongLogPathType()
{
string configFile = Files.cr_wrongLogPathType;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = CombineWithDefaultLogFolder("../2");
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsFalse(ci.Errors.HasErrors);
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void SameFiles()
{
string configFile = Files.cr_sameFiles;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsTrue(ci.Errors.HasErrors);
Assert.IsTrue(ci.Errors.ErrorMessages.Contains("same files"));
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void ExceedingLogLevelInArgs()
{
string configFile = Files.cr_default;
var ci = new ConfigInitializer(new string[] { "/loglevel:55" }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsTrue(ci.Errors.HasErrors, "Error Mismatch");
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void MissingCfGFile()
{
string configFile = Files.cr_default;
var ci = new ConfigInitializer(new string[] { "/log:./Logs/a.txt", "/stream:./Logs/b.txt", "/loglevel:0" }, configFile);
ci.SetUp();
string expectedLogFile = CombineWithDefaultLogFolder("a.txt");
string expectedStreamFile = CombineWithDefaultLogFolder("b.txt");
LogLevel expectedLogLevel = LogLevel.Trace;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsFalse(ci.Errors.HasErrors, "Error Mismatch");
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void NoCfgFile()
{
string configFile = CombinePath("/", "abasdfasfdsa.json");
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsTrue(ci.Errors.HasErrors, "Error Mismatch");
Assert.IsTrue(ci.Errors.ErrorMessages.Contains("not be located"), "Errormsg not contained");
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void ExceedingLogLevel()
{
string configFile = Files.cr_wrongLogLevel;
var ci = new ConfigInitializer(new string[] { }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsTrue(ci.Errors.HasErrors, "error expectation mismatch");
Assert.IsTrue(ci.Errors.ErrorMessages.Contains("Loglevel must be between"));
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
public void IllegalArgument()
{
string configFile = Files.cr_default;
var ci = new ConfigInitializer(new string[] { "/abc:ab" }, configFile);
ci.SetUp();
string expectedLogFile = defaultLog;
string expectedStreamFile = defaultStream;
LogLevel expectedLogLevel = LogLevel.Error;
TextDocumentSyncKind expectedSyncKind = TextDocumentSyncKind.Incremental;
Console.WriteLine(LanguageServerConfig.ToString());
Assert.IsTrue(ci.Errors.HasErrors, "Error Mismatch");
Assert.IsTrue(ci.Errors.ErrorMessages.Contains("Unknown switch"));
Assert.AreEqual(expectedLogFile, LanguageServerConfig.LogFile);
Assert.AreEqual(expectedStreamFile, LanguageServerConfig.RedirectedStreamFile);
Assert.AreEqual(expectedSyncKind, LanguageServerConfig.SyncKind);
Assert.AreEqual(expectedLogLevel, LanguageServerConfig.LogLevel);
}
private Engine()
{
// Read config file
_configuration = ConfigInitializer.InitConfig();
_connectionString = _configuration.GetConnectionString("Default");
_context = new ToDoContext();
_context.Database.EnsureCreated();
_userRepository = new UserRepository(_context);
//ToDoListRepository toDoListRepository = new ToDoListRepository(_connectionStringEdit);
_userService = new UserService(_userRepository);
//_toDoListService = new ToDoListService(toDoListRepository);
_reader = new ConsoleReader();
_writer = new ConsoleWriter();
_userController = new UserController(_userService, _writer, _reader);
//_toDoListController = new ToDoListController(_toDoListService,_userService, _writer, _reader);
_menu = new Menu(_writer, _reader, _userController);
}
/// <summary>
/// Initializes and returns an <see cref="IConfigManager"/> with the specified configs registered with initial state.
/// </summary>
/// <param name="configFileWriter">An action to set up the config file before config manager initializes.</param>
/// <param name="envVarWriter">An action to set up the environments before config manager initializes.</param>
/// <param name="config">Definitions of configs to be registered to the config manager.</param>
/// <returns>A config manager with initial state, ready to use.</returns>
internal IConfigManager GetConfigManager(InitSettings settings, params ConfigDefinition[] config)
{
var dataStore = settings?.DataStore ?? new MockDataStore();
var configPath = settings?.Path ?? Path.GetRandomFileName();
var environmentVariableProvider = settings?.EnvironmentVariableProvider ?? new MockEnvironmentVariableProvider();
ConfigInitializer ci = new ConfigInitializer(new List <string>()
{
configPath
})
{
DataStore = dataStore,
EnvironmentVariableProvider = environmentVariableProvider
};
IConfigManager icm = ci.GetConfigManager();
foreach (var configDefinition in config)
{
icm.RegisterConfig(configDefinition);
}
icm.BuildConfig();
return(icm);
}
private Engine()
{
// Read config file
_configuration = ConfigInitializer.InitConfig();
_connectionStringCreate = _configuration.GetConnectionString("Create");
_connectionStringEdit = _configuration.GetConnectionString("Edit");
InitializeDb(_connectionStringCreate, _connectionStringEdit);
UserRepository userRepositiry = new UserRepository(_connectionStringEdit);
ToDoListRepository toDoListRepository = new ToDoListRepository(_connectionStringEdit);
_userService = new UserService(userRepositiry);
_toDoListService = new ToDoListService(toDoListRepository);
_reader = new ConsoleReader();
_writer = new ConsoleWriter();
_userController = new UserController(_userService, _writer, _reader);
_toDoListController = new ToDoListController(_toDoListService, _userService, _writer, _reader);
_menu = new Menu(_writer, _reader, _userController, _toDoListController);
}
/// <summary>
/// Initializes and returns an <see cref="IConfigManager"/> with the specified configs registered with initial state.
/// </summary>
/// <param name="configFileWriter">An action to set up the config file before config manager initializes.</param>
/// <param name="envVarWriter">An action to set up the environments before config manager initializes.</param>
/// <param name="config">Definitions of configs to be registered to the config manager.</param>
/// <returns>A config manager with initial state, ready to use.</returns>
protected IConfigManager GetConfigManagerWithInitState(Action <MockDataStore, string> configFileWriter, Action <MockEnvironmentVariableProvider> envVarWriter, params ConfigDefinition[] config)
{
if (configFileWriter == null)
{
configFileWriter = _noopFileWriter;
}
if (envVarWriter == null)
{
envVarWriter = _noopEnvVarWriter;
}
string configPath = Path.GetRandomFileName();
var mockDataStore = new MockDataStore();
configFileWriter(mockDataStore, configPath);
var environmentVariables = new MockEnvironmentVariableProvider();
envVarWriter(environmentVariables);
ConfigInitializer ci = new ConfigInitializer(new List <string>()
{
configPath
})
{
DataStore = mockDataStore,
EnvironmentVariableProvider = environmentVariables
};
IConfigManager icm = ci.GetConfigManager();
foreach (var configDefinition in config)
{
icm.RegisterConfig(configDefinition);
}
icm.BuildConfig();
return(icm);
}
public Incident(ConfigInitializer.IncidentTableEntity tableEntity) { this.tableInfo = tableEntity; }
public ChatLog(ConfigInitializer.ChatlogTableEntity tableEntity)
{
this.tableInfo = tableEntity;
}
public void InsertIncidentLevel(ConfigInitializer.LevelTableEntity levelTable, MatchCollection collections, int incidentId)
{
string qText = levelTable.ToString();
var cmd = new SqlCommand(qText, this._connection);
for (int i = 0; i < 5; i++)
{
string tag = collections[i].Groups[1].Value;
cmd.Parameters.AddWithValue($"@{i + 1}", tag);
}
cmd.Parameters.AddWithValue($"@6", incidentId);
try
{
cmd.ExecuteNonQuery();
Console.WriteLine($" @InsertIncidentLevel : insert {incidentId}");
}
catch
{
Console.WriteLine("Error happend at @InsertIncidentLevel");
}
}