/// <summary>
///
/// </summary>
/// <param name="sshIp">ssh主机ip</param>
/// <param name="sshPort">ssh主机端口</param>
/// <param name="username">ssh主机用户名</param>
/// <param name="password">ssh主机密码</param>
/// <param name="lanIp">本地或者远程主机ip</param>
/// <param name="lanPort">本地或者远程主机端口</param>
/// <returns></returns>
public static SshClient GetSshClient(EsConnectionInfo connInfo)
{
SshClient client;
//input.localPort = 8001;//todo：需要去获取本机未用端口
try
{
PasswordConnectionInfo connectionInfo = new PasswordConnectionInfo(connInfo.sshIp, connInfo.sshPort, connInfo.username, connInfo.password);
connectionInfo.Timeout = TimeSpan.FromSeconds(30);
client = new SshClient(connectionInfo);
//client.ErrorOccurred += Client_ErrorOccurred;
client.Connect();
if (!client.IsConnected)
{
throw new Exception("SSH connect failed");
}
var portFwdL = new ForwardedPortLocal(connInfo.localIp, (uint)connInfo.localPort, connInfo.esIp, (uint)connInfo.esPort); //映射到本地端口
client.AddForwardedPort(portFwdL);
portFwdL.Start();
if (!client.IsConnected)
{
throw new Exception("Port forwarding failed");
}
}
catch (Exception ex)
{
throw ex;
}
return(client);
}
/// <summary>
/// 删除索引
/// </summary>
/// <param name="url"></param>
/// <param name="indexName"></param>
/// <returns></returns>
public static async Task <bool> DeleteIndex(EsConnectionInfo connInfo, String indexName)
{
try
{
string result = await HttpUtil.DeleteURL(connInfo.GetLastUrl() + "/" + indexName, connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(false);
}
JObject jObj = JObject.Parse(result);
if (jObj != null)
{
if (jObj.Root["acknowledged"] != null)
{
return(true);
}
}
return(false);
}
catch
{
return(false);
}
}
/// <summary>
/// 获取索引Mapping
/// </summary>
/// <param name="url"></param>
/// <param name="indexName"></param>
/// <returns></returns>
public static async Task <JObject> GetIndexMapping(EsConnectionInfo connInfo, String indexName)
{
try
{
string result = await HttpUtil.GetURL(connInfo.GetLastUrl() + "/" + indexName, connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(null);
}
JObject jObj = JObject.Parse(result);
if (jObj != null)
{
if (jObj.Root[indexName] != null && jObj.Root[indexName]["mappings"] != null)
{
return(jObj);
}
}
return(null);
}
catch
{
return(null);
}
}
public static async Task <string> RunJson(EsConnectionInfo connInfo, String method, String command, String json = "")
{
string url = connInfo.GetLastUrl() + "/" + command;
switch (method.ToLower())
{
case "get":
if (string.IsNullOrEmpty(json) == false)
{
return(await HttpUtil.PostURL(url, connInfo.esUsername, connInfo.esPassword, json));
}
return(await HttpUtil.GetURL(url, connInfo.esUsername, connInfo.esPassword));
break;
case "put":
return(await HttpUtil.PutURL(url, json, connInfo.esUsername, connInfo.esPassword));
break;
case "post":
return(await HttpUtil.PostURL(url, json, connInfo.esUsername, connInfo.esPassword));
break;
case "delete":
return(await HttpUtil.DeleteURL(url, connInfo.esUsername, connInfo.esPassword));
break;
}
return("");
}
/// <summary>
/// 获取所有索引模板
/// </summary>
/// <param name="connInfo"></param>
/// <returns></returns>
public static async Task <List <EsTemplate> > GetTemplate(EsConnectionInfo connInfo)
{
try
{
string result = await HttpUtil.GetURL(connInfo.GetLastUrl() + "/_template", connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(null);
}
JObject jObj = JObject.Parse(result);
var jtokens = jObj.Children();
List <EsTemplate> list = new List <EsTemplate>();
foreach (JToken jt in jtokens)
{
JToken jt1 = jt.First.SelectToken("index_patterns");
string tempName = (jt as JProperty).Name;
string indexName = jt1.First.Value <string>();
if (indexName.StartsWith(".") == false)
{
list.Add(new EsTemplate()
{
Name = tempName, IndexName = indexName, Mapping = jt.First.SelectToken("mappings")
});
}
}
return(list);
}
catch
{
return(null);
}
}
/// <summary>
/// 删除模板
/// </summary>
/// <param name="connInfo"></param>
/// <param name="templateName"></param>
public static async Task <FuncResult> DeleteTemplate(EsConnectionInfo connInfo, string templateName)
{
FuncResult funcResult = new FuncResult();
try
{
//DELETE _template/update-mapping-webindex.json?pretty
string result = await HttpUtil.DeleteURL(connInfo.GetLastUrl() + "/_template/" + templateName + "?pretty", connInfo.esUsername, connInfo.esPassword);
JObject jObj = JObject.Parse(result);
if (jObj != null)
{
if (jObj.Root["acknowledged"] != null)
{
funcResult.Success = true;
return(funcResult);
}
}
}
catch (Exception ex)
{
funcResult.Message = ex.Message;
}
return(funcResult);
}
/// <summary>
/// 把连接信息保存到File
/// </summary>
/// <param name="input"></param>
public static async void SaveEsFile(EsConnectionInfo input)
{
StorageFolder storageFolder = ApplicationData.Current.LocalFolder;
StorageFile esFile = await storageFolder.CreateFileAsync(input.connectionName, CreationCollisionOption.ReplaceExisting);
await FileIO.WriteTextAsync(esFile, EsFileEncoding(input));
}
/// <summary>
/// 获取索引数据
/// </summary>
/// <param name="url"></param>
/// <param name="indexName">索引名称</param>
/// <param name="json"></param>
/// <param name="pageIndex">开始位置</param>
/// <param name="pageCount">每页数量</param>
/// <returns></returns>
public static async Task <PerPageData> GetIndexData(EsConnectionInfo connInfo, String indexName, int pageIndex = 0, int pageSize = 20, string strJson = "")
{
PerPageData pData;
try
{
string strDefault = string.IsNullOrEmpty(strJson) ? "\"bool\":{\"must\":{\"match_all\": { }}}" : strJson;
String json = "{\"query\": {" + strDefault + "},\"from\": " + (pageIndex * pageSize).ToString() + ", \"size\": " + pageSize.ToString() + "}";
string result = await HttpUtil.PostURL(connInfo.GetLastUrl() + "/" + indexName + "/_search", json, connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(null);
}
JObject jObj = JObject.Parse(result);
if (jObj != null)
{
if (jObj.Root["hits"] != null && jObj.Root["hits"]["total"] != null)
{
int total = int.Parse(jObj.Root["hits"]["total"].ToString());
pData = new PerPageData(pageIndex, total, pageSize);
pData.json = json;
pData.pageData = jObj;
return(pData);
}
}
return(null);
}
catch
{
return(null);
}
}
/// <summary>
/// 删除EsFile
/// </summary>
/// <param name="input"></param>
public static void DelEsFile(EsConnectionInfo input)
{
StorageFolder storageFolder = ApplicationData.Current.LocalFolder;
string filePath = storageFolder.Path + "//" + input.connectionName;
if (File.Exists(filePath))
{
File.Delete(filePath);
}
}
private static string EsFileEncoding(EsConnectionInfo input)
{
try
{
return(JsonConvert.SerializeObject(input));
}
catch
{
return(null);
}
}
/// <summary>
/// 获取索引列表
/// </summary>
/// <param name="connInfo"></param>
/// <returns></returns>
public static async Task <List <EsIndex> > GetIndexList(EsConnectionInfo connInfo, bool isShowSysIndex = false)
{
string json = await HttpUtil.GetURL(connInfo.GetLastUrl() + "/_cat/indices", connInfo.esUsername, connInfo.esPassword);
try
{
String[] strlines = json.Split(Environment.NewLine.ToCharArray());
List <EsIndex> listIndex = new List <EsIndex>();
foreach (string str in strlines)
{
if (str == "")
{
continue;
}
string[] arr = str.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
if (arr.Length == 10)
{
if (arr[2].StartsWith(".") == false || isShowSysIndex)
{
listIndex.Add(new EsIndex()
{
Color = arr[0],
isOpen = arr[1],
Name = arr[2],
Id = arr[3],
ShardsCount = arr[4],
DocumentCount = arr[6],
DataSpace = arr[8]
});
}
}
else if (arr.Length == 3)
{
listIndex.Add(new EsIndex()
{
isOpen = arr[0],
Name = arr[1],
Id = arr[2]
});
}
}
return(listIndex);
}
catch
{
return(null);
}
}
/// <summary>
/// 不使用SSH连接测试
/// </summary>
/// <param name="connInfo"></param>
/// <returns></returns>
public static bool ConnectionTest(EsConnectionInfo connInfo)
{
try
{
string version = EsService.GetEsVersion(connInfo);
if (string.IsNullOrEmpty(version) == false)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
/// <summary>
/// 获取ES版本
/// </summary>
/// <param name="connInfo"></param>
/// <returns></returns>
public static String GetEsVersion(EsConnectionInfo connInfo)
{
string json = HttpUtil.GetURL_SYNC(connInfo.GetLastUrl(), connInfo.esUsername, connInfo.esPassword);
try
{
JObject jobj = JObject.Parse(json);
if (jobj != null && jobj.Root["version"] != null && jobj.Root["version"]["number"] != null)
{
return(jobj.Root["version"]["number"].ToString());
}
}
catch
{
}
return(null);
}
/// <summary>
/// 获取索引列表
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public static async Task <FuncResult> CreateIndex(EsConnectionInfo connInfo, String indexName, String json)
{
try
{
string result = await HttpUtil.PutURL(connInfo.GetLastUrl() + "/" + indexName, json, connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(new FuncResult()
{
Success = false, Message = "put error"
});
}
JObject jobj = JObject.Parse(result);
if (jobj != null)
{
if (jobj.Root["acknowledged"] != null)
{
return(new FuncResult()
{
Success = true
});
}
else if (jobj.Root["error"] != null && jobj.Root["error"]["reason"] != null)
{
return(new FuncResult()
{
Success = false, Message = jobj.Root["error"]["reason"].ToString()
});
}
}
return(new FuncResult()
{
Success = false, Message = "error"
});
}
catch
{
return(new FuncResult()
{
Success = false, Message = "create index error!"
});
}
}
/// <summary>
/// 从文件读取所有可用的连接信息
/// </summary>
/// <returns></returns>
public static List <EsConnectionInfo> GetEsFiles()
{
List <EsConnectionInfo> list = new List <EsConnectionInfo>();
StorageFolder storageFolder = ApplicationData.Current.LocalFolder;
string[] files = Directory.GetFiles(storageFolder.Path);
foreach (string file in files)
{
try
{
string strInput = File.ReadAllText(file);
EsConnectionInfo input = EsFileDecoding(strInput);
if (input != null)
{
list.Add(input);
}
}
catch
{
continue;
}
}
return(list);
}
/// <summary>
/// 获取插件
/// </summary>
/// <param name="connInfo"></param>
/// <returns></returns>
public static async Task <string> GetPlugin(EsConnectionInfo connInfo)
{
//_cat/plugins
return(await HttpUtil.GetURL(connInfo.GetLastUrl() + "/_cat/plugins", connInfo.esUsername, connInfo.esPassword));
}
/// <summary>
/// 从json中得到
/// </summary>
/// <param name="jsonObj"></param>
/// <returns></returns>
public static async Task <List <string> > GetFieldsByJson(EsConnectionInfo connInfo, string indexName)
{
List <string> list = new List <string>();
try
{
string result = await HttpUtil.GetURL(connInfo.GetLastUrl() + "/" + indexName + "/_mapping/field/*", connInfo.esUsername, connInfo.esPassword);
if (string.IsNullOrEmpty(result))
{
return(list);
}
JObject jObj = JObject.Parse(result);
if (jObj != null && jObj.Root["error"] == null)
{
var tokens = jObj.First.First.First.First;
foreach (JToken tokenType in tokens) //可能有多个type
{
foreach (JProperty propertyField in (tokenType.First as JObject).Properties())
{
if (propertyField.Name.StartsWith("_") == false)
{
list.Add(propertyField.Name);
}
}
}
}
list.Sort();
return(list);
}
catch
{
return(list);
}
//await HttpUtil.GetURL(url, connInfo.esUsername, connInfo.esPassword);
//var tokens = jsonObj.SelectTokens(indexName + ".mappings").Children();
//foreach (JToken jtoken in tokens)
//{
// string typeName = ((JProperty)jtoken).Name;
// JToken jk = ((JProperty)jtoken).Value;
// var tokenFields = jk.SelectTokens("properties").Children();
// foreach (JToken jtoken1 in tokenFields)
// {
// //string typeName1 = ((JProperty)jtoken1).Name;
// list.Add(jtoken1.Path.Replace(indexName + ".mappings.", "").Replace(".properties.", "."));
// }
// //JObject jObj = jtoken as JObject;
// //foreach (JProperty jpro in jObj.Properties())
// //{
// // if (jpro.Value is JValue)
// // {
// // //string aa = jpro.Path + jpro.Name;
// // //if (jpro.Path.Contains(".properties."))
// // {
// // list.Add(jpro.Path);
// // }
// // }
// // else if (jpro.Value is JObject)
// // {
// // //if (jpro.Path.Contains(".properties."))
// // {
// // list.Add(jpro.Path);
// // }
// // GetFieldsByJson((JObject)jpro.Value, indexName, list);
// // }
// //}
//}
//foreach (JProperty jpro in jsonObj.Properties())
//{
// if (jpro.Value is JValue)
// {
// //string aa = jpro.Path + jpro.Name;
// if (jpro.Path.Contains(".properties."))
// {
// list.Add(jpro.Path.Replace(indexName + ".mappings.", "").Replace(".properties.", "."));
// }
// }
// else if (jpro.Value is JObject)
// {
// //if (jpro.Path.Contains(".properties."))
// //{
// // list.Add(jpro.Path.Replace(indexName + ".mappings.", "").Replace(".properties.", "."));
// //}
// //else
// //{
// // GetFieldsByJson((JObject)jpro.Value, indexName, list);
// //}
// GetFieldsByJson((JObject)jpro.Value, indexName, list);
// //ISet<String> set = new SortedSet<String>();
// }
//}
}
