public static string prepareCloudQuery(string vCloudName, string vCurrSql) { if (vCurrSql == null | vCloudName == null | vCurrSql == "" | vCloudName == "") { return(""); } CloudProperties vCurrCloud = in2sqlSvcCloud.vCloudList.Find(item => item.CloudName == vCloudName); if (vCurrCloud.CloudName == null) { return(""); } vCurrSql = In2SqlVBAEngineCloud.setSqlLimit(vCurrCloud.CloudType, vCurrSql); if (vCurrCloud.CloudType.Contains("CloudCH")) { vCurrSql = vCurrSql.Replace("FORMAT CSVWithNames", "") + " FORMAT CSVWithNames"; } In2SqlSvcTool.addSqlLog(vCloudName, vCurrSql); return(prepareCloudQuery_int(vCurrCloud.Url, vCurrSql, vCurrCloud.Login, vCurrCloud.Password)); }
public static IEnumerable <ObjectsAndProperties> getObjectProperties(string vCurrCloudName, string vObjName) { CloudProperties vCurrCloud = vCloudList.Find(item => item.CloudName == vCurrCloudName); string vSqlURL; vSqlURL = prepareCloudQuery(vCurrCloudName, in2SqlLibrary.getCloudColumns(vCurrCloud.CloudType)); var vTb1 = vObjName.Split('.'); vSqlURL = vSqlURL.Replace("%TNAME%", vTb1[1]); vSqlURL = vSqlURL.Replace("%TOWNER%", vTb1[0]); ObjectsAndProperties vObject = new ObjectsAndProperties(); vObject.ObjName = vCurrCloudName + '.' + vObjName; vObject.objColumns = new List <string>(); List <String> vObjects = new List <String>(); vObjects.AddRange(In2SqlSvcTool.HttpGetArray(vSqlURL)); int i = 0; foreach (var vCurrObj in vObjects) { i += 1; if (i < 2) { continue; } vObject.objColumns.Add(vCurrObj.ToString().Replace('"', ' ').Trim()); } yield return(vObject); }
public static IEnumerable <CloudObjects> getCloudViewList(string vCurrCloudName) { CloudProperties vCurrCloud = vCloudList.Find(item => item.CloudName == vCurrCloudName); string vSqlURL; vSqlURL = prepareCloudQuery(vCurrCloudName, in2SqlLibrary.getCloudSqlView(vCurrCloud.CloudType)); return(getCloudObjectList(vSqlURL)); }
public static void getCloudTablesAndViews(TreeNodeMouseClickEventArgs e) { e.Node.Nodes.Clear(); string vCurrCloudName = e.Node.Text; CloudProperties vCurrCloud = in2sqlSvcCloud.vCloudList.Find(item => item.CloudName == vCurrCloudName); try { if ((in2sqlSvcCloud.checkCloudState(vCurrCloudName) < 0)) { return; } e.Node.ImageIndex = 2; e.Node.SelectedImageIndex = 2; e.Node.Tag = vCurrCloud.CloudType + '#'; TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3); vNodeTableFolder.Tag = vCurrCloud.CloudName + "_tf"; e.Node.Nodes.Add(vNodeTableFolder); initCloudObjects(ref vCurrCloud); foreach (var vCurrTable in vCurrCloud.Tables) { TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4); vNodeTable.Tag = vCurrCloud.CloudName + "|" + vCurrTable.Name + "|$TABLE_CLD$"; vNodeTableFolder.Nodes.Add(vNodeTable); TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99); vNodeColumnTbl.Tag = vCurrCloud.CloudName + "." + vCurrTable.Name; vNodeTable.Nodes.Add(vNodeColumnTbl); } TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5); vNodeViewFolder.Tag = vCurrCloud.CloudName + "_vf"; e.Node.Nodes.Add(vNodeViewFolder); foreach (var vCurrView in vCurrCloud.Views) { TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6); vNodeView.Tag = vCurrCloud.CloudName + "." + vNodeView.Name + "|$VIEW_CLD$"; vNodeViewFolder.Nodes.Add(vNodeView); TreeNode vNodeColumnVw = new TreeNode(" ".ToString(), 99, 99); vNodeColumnVw.Tag = vCurrCloud.CloudName + "." + vNodeView.Name; vNodeView.Nodes.Add(vNodeColumnVw); } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick 1 "); } }
public static int checkCloudState(string vCurrCloudName) { CloudProperties vCurrCloud = vCloudList.Find(item => item.CloudName == vCurrCloudName); string vSqlURL = prepareCloudQuery(vCurrCloudName, in2SqlLibrary.getCloudSqlCheck(vCurrCloud.CloudType)); vSqlURL = In2SqlSvcTool.HttpGet(vSqlURL); if (vSqlURL.Length < 2) { return(-1); } return(1); }
public static IEnumerable <CloudProperties> getCloudList() { RegistryKey vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql"); string vCurrName = ""; string vPrevName = ""; if (vCurrRegKey != null) { CloudProperties vCloudProperties = new CloudProperties(); foreach (string name in vCurrRegKey.GetValueNames()) { if (name.Contains("Cloud")) { string[] vNameDetails = name.Split('.'); if (vNameDetails.Count() < 2) { MessageBox.Show("Error in reading registry getCloudList "); yield return(new CloudProperties()); break; } vCurrName = vNameDetails[1]; if (!vCurrName.Equals(vPrevName)) { if (vPrevName.Length > 2) { yield return(vCloudProperties); } vCloudProperties = new CloudProperties(); } vPrevName = vCurrName; vCloudProperties.CloudName = vCurrName; vCloudProperties.CloudType = vNameDetails[0]; string vCurrRegValue = in2SqlRegistry.getLocalRegValue(vCurrRegKey, name); if (name.Contains("Url")) { vCloudProperties.Url = vCurrRegValue; } if (name.Contains("Password")) { vCloudProperties.Password = vCurrRegValue; } if (name.Contains("Login")) { vCloudProperties.Login = vCurrRegValue; } if (vCloudProperties.Url != null) { if (vCloudProperties.Password != null) { if (vCloudProperties.Login.Length > 0) { vPrevName = ""; yield return(vCloudProperties); } } } } else { if (vPrevName.Length > 2) { vPrevName = ""; } } } } }
public static string getCloudType(string vCurrCloudName) { CloudProperties vCurrCloud = vCloudList.Find(item => item.CloudName == vCurrCloudName); return(vCurrCloud.CloudType); }