private static OpenDBResult GetMysqlConnection(DesignServerEntity serverEntity)
{
OpenDBResult openDBResult = new OpenDBResult();
try
{
var connString = $"Server={serverEntity.MysqlServerIp};Port={serverEntity.MysqlServerPort};Database={serverEntity.MysqlDBName}; User={serverEntity.MysqlUsername};Password={serverEntity.MysqlPassword};Charset=utf8;Connection Timeout=3";
MySqlConnection connection = new MySqlConnection(connString);
connection.Open();
openDBResult.Connection = connection;
return(openDBResult);
}
catch (MySqlException ex)
{
if (ex.Number == 1042)
{
openDBResult.Status = ex.Number;
openDBResult.Message = "数据库连接失败";
}
else
{
openDBResult.Status = 500;
openDBResult.Message = ex.ToString();
}
}
return(openDBResult);
}
public static OpenDBResult GetConnection(DesignServerEntity serverEntity)
{
OpenDBResult openDBResult = new OpenDBResult();
switch (serverEntity.ServerType)
{
case ServerTypeConstant.Mysql:
{
openDBResult = GetMysqlConnection(serverEntity);
}
break;
case ServerTypeConstant.Sqlite:
{
openDBResult = GetSqliteConnection(serverEntity);
}
break;
default:
{
openDBResult.Status = 404;
openDBResult.Message = "不支持的数据库";
}
break;
}
return(openDBResult);
}
private static OpenDBResult GetSqliteConnection(DesignServerEntity serverEntity)
{
OpenDBResult openDBResult = new OpenDBResult();
var connString = $"Data Source={serverEntity.SqliteLocalPath};Version=3;FailIfMissing=true;Read Only=true";
SQLiteConnection connection = new SQLiteConnection(connString);
connection.Open();
openDBResult.Connection = connection;
return(openDBResult);
}
private static ServerVo ToVo(DesignServerEntity entity)
{
ServerVo server = new ServerVo();
server.Id = entity.Id;
server.ServerName = entity.ServerName;
server.ServerType = entity.ServerType;
server.MysqlServerIp = entity.MysqlServerIp;
server.MysqlServerPort = entity.MysqlServerPort;
server.MysqlUsername = entity.MysqlUsername;
server.MysqlPassword = entity.MysqlPassword;
server.MysqlDBName = entity.MysqlDBName;
server.SqliteLocalPath = entity.SqliteLocalPath;
server.Description = entity.Description;
server.DataStatus = entity.DataStatus;
server.CreateTime = entity.CreateTime;
server.LastUpdateTime = entity.LastUpdateTime;
return(server);
}
