public void RepairDatabase()
{
bool local = (ConnectionString.Contains("localhost") || ConnectionString.Contains("127.0.0.1"));
if (local == false)
{
throw new Exception("MongoDB数据库不在本地，无法启动自动数据库修复");
}
if (LocalDBLocation == null)
{
throw new Exception("数据库连接失败，请检查数据库配置，或手动设定MongoDB数据库的安装路径以方便自动修复");
}
var mydir = new DirectoryInfo(LocalDBLocation);
FileInfo file = mydir.GetFiles().FirstOrDefault(d => d.Name == "mongod.lock");
if (file == null)
{
throw new Exception("修复失败，您是否没有安装MongoDB数据库");
}
try
{
File.Delete(file.FullName);
string str = CMDHelper.Execute("net start MongoDB");
}
catch (Exception ex)
{
}
}
static AppFixture()
{
_configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.AddEnvironmentVariables()
.Build();
var startup = new Startup(_configuration, new HostEnvironment());
var services = new ServiceCollection();
startup.ConfigureServices(services);
var builder = new AutofacServiceProviderFactory().CreateBuilder(services);
startup.ConfigureContainer(builder);
builder.RegisterType <NullDispatcher>().As <IDomainEventDispatcher>(); // replace with null dispatcher
var container = builder.Build();
_scopeFactory = container.Resolve <IServiceScopeFactory>();
_checkpoint = new Checkpoint
{
DbAdapter = DbAdapter.Postgres,
TablesToIgnore = new[]
{
"unit_of_measure_lib",
"migration_history"
}
};
ConnectionString = _configuration.GetConnectionString("Postgres");
Debug.Assert(ConnectionString.Contains("_test"));
}
public void RepairDatabase()
{
var local = (ConnectionString.Contains("localhost") || ConnectionString.Contains("127.0.0.1"));
if (local == false)
{
throw new Exception(GlobalHelper.Get("key_74"));
}
if (LocalDBLocation == null)
{
throw new Exception(GlobalHelper.Get("mongo_connect_error"));
}
var mydir = new DirectoryInfo(LocalDBLocation);
var file = mydir.GetFiles().FirstOrDefault(d => d.Name == "mongod.lock");
if (file == null)
{
throw new Exception(GlobalHelper.Get("key_76"));
}
try
{
File.Delete(file.FullName);
var str = CMDHelper.Execute("net start MongoDB");
}
catch (Exception ex)
{
}
}
/**
* Check if current DatafeedResult contains "Keyword"
* @params: keyword: Search keyword
* @return: True: if it contains, False: if it doesn't contain
* */
public bool Find(string keyword)
{
if ((DatafeedID.Contains(keyword) && CheckStatus.Check_DatafeedID) ||
(Guid.Contains(keyword) && CheckStatus.Check_Guid) ||
(DatafeedName.Contains(keyword) && CheckStatus.Check_DatafeedName) ||
(SecurityUsername.Contains(keyword) && CheckStatus.Check_SecurityUsername) ||
(SecurityPassword.Contains(keyword) && CheckStatus.Check_SecurityPassword) ||
(TransportUsername.Contains(keyword) && CheckStatus.Check_TransportUsername) ||
(TransportPassword.Contains(keyword) && CheckStatus.Check_TransportPassword) ||
(TransportURL.Contains(keyword) && CheckStatus.Check_TransportURL) ||
(TransportInstance.Contains(keyword) && CheckStatus.Check_TransportInstance) ||
(SecurityDomain.Contains(keyword) && CheckStatus.Check_SecurityDomain) ||
(TransportDomain.Contains(keyword) && CheckStatus.Check_TransportDomain) ||
(ProxyOption.Contains(keyword) && CheckStatus.Check_ProxyOption) ||
(ProxyName.Contains(keyword) && CheckStatus.Check_ProxyName) ||
(ProxyPort.Contains(keyword) && CheckStatus.Check_ProxyPort) ||
(ProxyDomain.Contains(keyword) && CheckStatus.Check_ProxyDomain) ||
(ProxyUserName.Contains(keyword) && CheckStatus.Check_ProxyUserName) ||
(ProxyPassword.Contains(keyword) && CheckStatus.Check_ProxyPassword) ||
(TransportPath.Contains(keyword) && CheckStatus.Check_TransportPath) ||
(ConnectionString.Contains(keyword) && CheckStatus.Check_ConnectionString) ||
(SQLQueryUsername.Contains(keyword) && CheckStatus.Check_SQLQueryUsername) ||
(SQLQueryPassword.Contains(keyword) && CheckStatus.Check_SQLQueryPassword)
)
{
return(true);
}
return(false);
}
public static int CommandTimeout()
{
int timeout = 60;
if (ConnectionString.Contains("timeout="))
{
try
{
string[] valores = ConnectionString.Split(';');
foreach (string item in valores)
{
try
{
string[] par = item.Split('=');
if (par[0].ToLower() == "timeout")
{
timeout = int.Parse(par[1]);
break;
}
}
catch { }
}
}
catch { }
}
return(timeout);
}
public static IDatabase CreateDatabase()
{
type = DatabaseType.Default;
if (ConnectionString.Contains("OraOLEDB.Oracle.1"))
{
type = DatabaseType.Oracle;
}
else if (ConnectionString.Contains("IBMDADB2.DB2CLIENT9"))
{
type = DatabaseType.DB2;
}
//SQLNCLI11
else if (ConnectionString.Contains("SQLNCLI") || ConnectionString.Contains("SQLOLEDB"))
{
type = DatabaseType.MSSqlServer;
}
else if (ConnectionString.Contains("server") || ConnectionString.Contains("port"))
{
type = DatabaseType.MySql;
}
else
{
type = DatabaseType.SqlLite;
}
return(CreateDatabase(type));
}
private string ExtractShemaFromConnectionString()
{
string result = "";
if (!string.IsNullOrEmpty(ConnectionString) && ConnectionString.Contains(DB2LUWIDs.SCHEMA))
{
string searchStr = DB2LUWIDs.SCHEMA + "=";
int startIndex = ConnectionString.IndexOf(searchStr) + searchStr.Length;
int endIndex = ConnectionString.IndexOf(";", startIndex);
if (endIndex == -1)
{
endIndex = ConnectionString.IndexOf("<", startIndex);
}
if (endIndex == -1)
{
endIndex = ConnectionString.IndexOf(" ", startIndex);
}
if (startIndex > 0 && endIndex > 0 && endIndex > startIndex)
{
result = ConnectionString.Substring(startIndex, endIndex - startIndex);
}
}
return(result);
}
public void Validate()
{
if (!System.IO.Directory.Exists(Directory))
{
throw new ArgumentException("Directory not found", nameof(Directory));
}
if (!string.IsNullOrWhiteSpace(ConnectionString))
{
ExportType |= ExportType.SQL;
// append file import conn string setting
if (!ConnectionString.Contains("AllowLoadLocalInfile", StringComparison.OrdinalIgnoreCase))
{
ConnectionString += "AllowLoadLocalInfile=true;";
}
}
if (!string.IsNullOrWhiteSpace(OutputDirectory))
{
ExportType |= ExportType.CSV;
}
if (ExportType == 0)
{
throw new ArgumentException("Either ConnectionString or FileName must be set");
}
}
protected override void ConfigureConnectionString()
{
base.ConfigureConnectionString();
if (!ConnectionString.Contains("Password="******"Integrated Security=SSPI;";
}
}
public override void Open()
{
// No Op, unless credentials are bad
if (ConnectionString.Contains("invalidUsername"))
{
throw new Exception("Invalid credentials provided");
}
}
public AccessAce()
{
ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionKey].ConnectionString;
if (!ConnectionString.Contains(":"))
{
ConnectionString = AppDomain.CurrentDomain.BaseDirectory + ConnectionString;
}
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
throw new Exception("Antiforgery check failed.");
}
var initResult = Init();
if (initResult != null)
{
return(initResult);
}
InitEntitySelectOptions();
try
{
ValidationException valEx = new ValidationException();
if (string.IsNullOrWhiteSpace(ConnectionString))
{
valEx.AddError("ConnectionString", "Original database connection string is required.");
ShowResults = false;
throw valEx;
}
var conString = ConnectionString;
if (!ConnectionString.Contains(";"))
{
NpgsqlConnectionStringBuilder builder = new NpgsqlConnectionStringBuilder(ErpSettings.ConnectionString);
builder.Database = ConnectionString;
conString = builder.ToString();
}
var cgService = new CodeGenService();
var result = cgService.EvaluateMetaChanges(conString, IncludeRecordsEntityIdList, IncludeEntityMeta, IncludeEntityRelations, IncludeUserRoles, IncludeApplications);
Code = result.Code;
Changes = result.Changes;
ShowResults = true;
}
catch (ValidationException valEx)
{
Validation.Message = valEx.Message;
Validation.Errors.AddRange(valEx.Errors);
ShowResults = false;
}
catch (Exception ex)
{
Validation.Message = ex.Message;
Validation.AddError("", ex.Message);
ShowResults = false;
}
BeforeRender();
return(Page());
}
public ConnectionFactory(Environment environment, string customConnectionString = null)
{
this.Environment = environment;
this.ConnectionString = customConnectionString ?? ConfigurationReader.GetConnectionString(environment);
if (ConnectionString.Contains(guid_placeholder))
{
this.guid = Guid.NewGuid().ToString();
this.ConnectionString = this.ConnectionString.Replace(guid_placeholder, this.guid);
}
this.initialized = false;
}
public override IDbConnection CreateConnection()
{
if (ConnectionString.Contains(":memory:"))
{
if (_connection == null)
{
return(_connection = new SqliteInMemoryDbConnection(base.CreateConnection()));
}
return(_connection);
}
return(base.CreateConnection());
}
public virtual bool OpenConnection()
{
try
{
if (_Connection == null)
{
if (ConnectionString.Contains("="))
{
_Connection = dbProvider.CreateConnection();
_Connection.ConnectionString = ConnectionString;
}
else
{
var connInfo = ConnectionStringInfo.GetConnectionStringInfo(ConnectionString);
if (connInfo == null)
{
SetError("InvalidConnectionString");
if (ThrowExceptions)
{
throw new ApplicationException(ErrorMessage);
}
return(false);
}
dbProvider = connInfo.Provider;
ConnectionString = connInfo.ConnectionString;
_Connection = dbProvider.CreateConnection();
_Connection.ConnectionString = ConnectionString;
}
}
if (_Connection.State != ConnectionState.Open)
{
_Connection.Open();
}
}
catch (DbException ex)
{
SetError(string.Format("ConnectionOpeningFailure", ex.Message));
return(false);
}
catch (Exception ex)
{
SetError(string.Format("ConnectionOpeningFailure", ex.GetBaseException().Message));
return(false);
}
return(true);
}
/// <summary>
/// Handle design time access to the configuration settings - used for the
/// DbDesignTimeResourceProvider - when loaded we re-read the settings
/// </summary>
/// <param name="serviceHost"></param>
public bool ReadDesignTimeConfiguration(IServiceProvider serviceProvider)
{
IWebApplication webApp = serviceProvider.GetService(typeof(IWebApplication)) as IWebApplication;
// Can't get an application instance - can only exit
if (webApp == null)
{
return(false);
}
object TSection = webApp.OpenWebConfiguration(true).GetSection("DbResourceProvider");
if (TSection == null)
{
return(false);
}
var section = TSection as DbResourceProviderSection;
ReadSectionValues(section);
// If the connection string doesn't contain = then it's
// a ConnectionString key from .config. This is handled in
// in the propertyGet of the resource configration, but it uses
// ConfigurationManager which is not available at design time
// So we have to duplicate the code here using the WebConfiguration.
if (!ConnectionString.Contains("="))
{
try
{
string conn = webApp.OpenWebConfiguration(true).ConnectionStrings.ConnectionStrings[ConnectionString].ConnectionString;
ConnectionString = conn;
}
catch { }
}
return(true);
}
/// <summary>
/// Opens a Sql Connection based on the connection string.
/// Called internally but externally accessible. Sets the internal
/// _Connection property.
/// </summary>
/// <returns></returns>
public override bool OpenConnection()
{
try
{
if (_Connection == null)
{
if (ConnectionString.Contains("="))
{
_Connection = dbProvider.CreateConnection();
_Connection.ConnectionString = ConnectionString;
}
else
{
// Assume it's a connection string value
_Connection = dbProvider.CreateConnection();
_Connection.ConnectionString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString;
}
}
if (_Connection.State != ConnectionState.Open)
{
_Connection.Open();
}
}
catch (DbException ex)
{
SetError(ex.Message, ex.ErrorCode);
return(false);
}
catch (Exception ex)
{
SetError(ex.GetBaseException().Message);
return(false);
}
return(true);
}
/**
* Replace DatafeedResult with keyword.
* @params: keyword: Search Keyword, replaceText: Text for Replace
* @return: Replace keyword count
* */
public int Replace(string keyword, string replaceText)
{
int replaceCount = 0;
if (DatafeedID.Contains(keyword) && CheckStatus.Check_DatafeedID)
{
DatafeedID = DatafeedID.Replace(keyword, replaceText);
replaceCount += 1;
}
if (Guid.Contains(keyword) && CheckStatus.Check_Guid)
{
Guid = Guid.Replace(keyword, replaceText);
replaceCount += 1;
}
if (DatafeedName.Contains(keyword) && CheckStatus.Check_DatafeedName)
{
DatafeedName = DatafeedName.Replace(keyword, replaceText);
replaceCount += 1;
}
if (SecurityUsername.Contains(keyword) && CheckStatus.Check_SecurityUsername)
{
SecurityUsername = SecurityUsername.Replace(keyword, replaceText);
replaceCount += 1;
}
if (SecurityPassword.Contains(keyword) && CheckStatus.Check_SecurityPassword)
{
SecurityPassword = SecurityPassword.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportUsername.Contains(keyword) && CheckStatus.Check_TransportUsername)
{
TransportUsername = TransportUsername.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportPassword.Contains(keyword) && CheckStatus.Check_TransportPassword)
{
TransportPassword = TransportPassword.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportURL.Contains(keyword) && CheckStatus.Check_TransportURL)
{
TransportURL = TransportURL.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportInstance.Contains(keyword) && CheckStatus.Check_TransportInstance)
{
TransportInstance = TransportInstance.Replace(keyword, replaceText);
replaceCount += 1;
}
if (SecurityDomain.Contains(keyword) && CheckStatus.Check_SecurityDomain)
{
SecurityDomain = SecurityDomain.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportDomain.Contains(keyword) && CheckStatus.Check_TransportDomain)
{
TransportDomain = TransportDomain.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyOption.Contains(keyword) && CheckStatus.Check_ProxyOption)
{
ProxyOption = ProxyOption.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyName.Contains(keyword) && CheckStatus.Check_ProxyName)
{
ProxyName = ProxyName.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyPort.Contains(keyword) && CheckStatus.Check_ProxyPort)
{
ProxyPort = ProxyPort.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyDomain.Contains(keyword) && CheckStatus.Check_ProxyDomain)
{
ProxyDomain = ProxyDomain.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyUserName.Contains(keyword) && CheckStatus.Check_ProxyUserName)
{
ProxyUserName = ProxyUserName.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ProxyPassword.Contains(keyword) && CheckStatus.Check_ProxyPassword)
{
ProxyPassword = ProxyPassword.Replace(keyword, replaceText);
replaceCount += 1;
}
if (TransportPath.Contains(keyword) && CheckStatus.Check_TransportPath)
{
TransportPath = TransportPath.Replace(keyword, replaceText);
replaceCount += 1;
}
if (ConnectionString.Contains(keyword) && CheckStatus.Check_ConnectionString)
{
ConnectionString = ConnectionString.Replace(keyword, replaceText);
replaceCount += 1;
}
if (SQLQueryUsername.Contains(keyword) && CheckStatus.Check_SQLQueryUsername)
{
SQLQueryUsername = SQLQueryUsername.Replace(keyword, replaceText);
replaceCount += 1;
}
if (SQLQueryPassword.Contains(keyword) && CheckStatus.Check_SQLQueryPassword)
{
SQLQueryPassword = SQLQueryPassword.Replace(keyword, replaceText);
replaceCount += 1;
}
return(replaceCount);
}
private bool CheckParameters()
{
bool isCorrect = true;
if (ConnectionString.Contains('='))
{
;
//we only very roufly checking correctnes of connection string.
//We will make sure if it is correct during connection to database.
}
else
{
errorDesctiption += "connection string: \"" + ConnectionString + "\" is not proper" + Environment.NewLine;
errorDesctiption += "Issue Code: E005" + Environment.NewLine;
isCorrect = false;
}
if (Directory.Exists(OutDirectory) && hasWriteAccessToFolder(OutDirectory))
{
}
else
{
errorDesctiption += "output directory: " + OutDirectory + " is not proper, ";
errorDesctiption += "patch does not exist or access is not allowed" + Environment.NewLine;
errorDesctiption += "Issue Code: E006" + Environment.NewLine;
isCorrect = false;
}
if (TimeOut >= 0 && TimeOut < 86400)
{
}
else
{
errorDesctiption += "TimeOut value: " + TimeOut + " is not proper, ";
errorDesctiption += "it should be value between 0 and 86400, 0 means that timeout is not changed" + Environment.NewLine;
errorDesctiption += "(taken from connection string or database configuration)" + Environment.NewLine;
errorDesctiption += "Issue Code: E007b" + Environment.NewLine;
isCorrect = false;
}
if (DropboxDelay >= 0 && DropboxDelay < 3600)
{
}
else
{
errorDesctiption += "timeout value: " + DropboxDelay + " is not proper, ";
errorDesctiption += "it should be value between 0 and 3600, 0 means that there is no delay" + Environment.NewLine;;
errorDesctiption += "Issue Code: E008b" + Environment.NewLine;
isCorrect = false;
}
if (AddDate.ToUpper() == "YES" || AddDate.ToUpper() == "NO")
{
}
else
{
errorDesctiption += "AddDate value: " + AddDate + " is not proper, ";
errorDesctiption += "it should be YES or NO" + Environment.NewLine;;
errorDesctiption += "Issue Code: E009" + Environment.NewLine;
isCorrect = false;
}
if (hasWriteAccessToFile(BussinessLogFile) == true)
{
}
else
{
errorDesctiption += "Business Log File: " + BussinessLogFile + " is not avaible to write, ";
errorDesctiption += "you have to put file that is available to write for KKrReporter";
errorDesctiption += Environment.NewLine;;
errorDesctiption += "Issue Code: E010a" + Environment.NewLine;
isCorrect = false;
}
if (hasWriteAccessToFile(ExceptionLogFile) == true)
{
}
else
{
errorDesctiption += "Exception Log File: " + ExceptionLogFile + " is not avaible to write, ";
errorDesctiption += "you have to put file that is available to write for KKrReporter";
errorDesctiption += Environment.NewLine;;
errorDesctiption += "Issue Code: E010b" + Environment.NewLine;
isCorrect = false;
}
if (isCorrect)
{
return(true);
}
else
{
return(false);
}
}
