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);
}
