public override void OnStart()
{
branchesLeftToRun = new List <int>(ChildCount());
utilityQueryIterator = new TreeQuery(Tree.Height - LevelOrder);
timer.AutoRestart = true;
timer.OnTimeout += Evaluate;
}
public async Task <RelationTreeResponse> ResolveTreeAsync(IList <Relation> relations)
{
var treeQuery = new TreeQuery()
{
};
foreach (var item in relations)
{
treeQuery.Relations.Add(item);
}
var response = await _client.ResolveTreeAsync(treeQuery);
return(Task.FromResult(response).Result);
}
public Task <RelationTreeResponse> ResolveTree(IList <Relation> relations, Filter filter = null)
{
var treeQuery = new TreeQuery()
{
};
foreach (var item in relations)
{
treeQuery.Relations.Add(item);
}
if (filter != null)
{
treeQuery.Filters = filter;
}
var response = _client.ResolveTree(treeQuery);
return(Task.FromResult(response));
}
//private void SendSelectedObject(PlugEvent sender)
//{
// //Personnes personne = (Personnes)PersonListBox.SelectedItem;
// XmlDocument doc = new XmlDocument();
// XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
// doc.AppendChild(docNode);
// XmlNode rootNode = doc.CreateElement("ToadDotNet");
// doc.AppendChild(rootNode);
// XmlNode actionNode = doc.CreateElement("action");
// string tagType = treeViewOracleSchema.SelectedNode.Tag.ToString().Replace(" ", "");
// actionNode.InnerText = "get" + tagType.ToLower();
// rootNode.AppendChild(actionNode);
// XmlNode productNode = doc.CreateElement(tagType.Replace(" ", ""));
// XmlAttribute productAttribute = doc.CreateAttribute("id");
// switch (tagType)
// {
// case "packagebodys":
// case "packagespecs":
// productAttribute.Value = treeViewOracleSchema.SelectedNode.Parent.Text;
// break;
// case "packagebody":
// case "packagespec":
// productAttribute.Value = treeViewOracleSchema.SelectedNode.Parent.Parent.Text;
// break;
// default:
// productAttribute.Value = treeViewOracleSchema.SelectedNode.Text;
// break;
// }
// productNode.Attributes.Append(productAttribute);
// actionNode.AppendChild(productNode);
// //Console.WriteLine(string.Format("tagtype = {0} - producAttribute = {1}", tagType, productAttribute.Value));
// if (sender != null)
// sender.Send(doc.OuterXml);
//}
private void GetTreeChildDetail(TreeNode SelectedNode)
{
string tagType = ((DbObjectItem)SelectedNode.Tag).Type;
if (SelectedNode.Nodes.Count == 0)
{
createIndexToolStripMenuItem.Enabled = false;
dropIndexToolStripMenuItem.Enabled = false;
if (!connexion.IsOpen && !String.IsNullOrEmpty(connexion.OracleConnexion.UserId) && !String.IsNullOrEmpty(connexion.OracleConnexion.Password) &&
!String.IsNullOrEmpty(connexion.OracleConnexion.DataSource))
connexion.Open(connexion.OracleConnexion.UserId, connexion.OracleConnexion.Password,
connexion.OracleConnexion.DataSource);
string SQL = "";
switch (tagType.Trim().ToLower())
{
case "view":
case "table":
case "fk":
case "referenced":
//bool bConnexion = false;
if (connexion.IsOpen)
{
string tablename = SelectedNode.Text;
if (tagType.Trim().ToLower() == "fk" || tagType.Trim().ToLower() == "referenced")
{
tagType = "table";
int DotPos = tablename.IndexOf('.');
tablename = tablename.Substring(0, DotPos);
}
DbObjectItem DbOi = new DbObjectItem("Fields", "fields");
TreeNode FieldsNode = new TreeNode(DbOi.Name);
FieldsNode.Tag = DbOi;
FieldsNode.SelectedImageIndex = 8;
FieldsNode.ImageIndex = 8;
SelectedNode.Nodes.Add(FieldsNode);
TreeQuery FieldsNodeQry = new TreeQuery(FieldsNode, connexion);
FieldsNodeQry.Start(string.Format("SELECT cname, 'VALID' FROM col where tname = '{0}' ORDER BY COLNO", tablename));
if (tagType.Trim().ToLower() == "table")
{
DbObjectItem DbOIIndex = new DbObjectItem("Indexes", "indexes");
TreeNode IndexesNode = new TreeNode(DbOIIndex.Name);
IndexesNode.Tag = DbOIIndex;
IndexesNode.SelectedImageIndex = 13;
IndexesNode.ImageIndex = 13;
SelectedNode.Nodes.Add(IndexesNode);
TreeQuery IndexesNodeQry = new TreeQuery(IndexesNode, connexion);
SQL = "SELECT distinct index_name , 'VALID' " +
" FROM USER_IND_COLUMNS " +
" WHERE TABLE_NAME = '{0}' " +
" order by index_name";
IndexesNodeQry.Start(string.Format(SQL, tablename));
// Get all table that referred this one
SQL = "SELECT o.NAME||'.'||uc.COLUMN_NAME, 'VALID', oc.NAME constraint_name " +
" FROM SYS.con$ oc, " +
" SYS.con$ rc, " +
" SYS.user$ ou, " +
" SYS.user$ ru, " +
" SYS.obj$ o, " +
" SYS.cdef$ c, " +
" SYS.cdef$ rcdef, " +
" SYS.obj$ rcobj, " +
" user_cons_columns uc " +
" WHERE oc.owner# = ou.user# " +
" AND oc.con# = c.con# " +
" AND c.obj# = o.obj# " +
" AND c.rcon# = rc.con# " +
" AND rc.owner# = ru.user# " +
" AND c.type# = 4 " +
" AND rcdef.con# = rc.con# " +
" AND rcobj.obj# = rcdef.obj# " +
" AND rcdef.type# IN (2, 3) " +
" AND ru.NAME = USER " +
" and uc.constraint_name = oc.NAME AND table_name = o.NAME " +
" AND rcobj.NAME = '{0}' " +
"ORDER BY 1 ";
DbObjectItem DbOIRef = new DbObjectItem("Referenced by", "Referenceds");
TreeNode RefNode = new TreeNode(DbOIRef.Name);
RefNode.Tag = DbOIRef;
RefNode.SelectedImageIndex = 14;
RefNode.ImageIndex = 14;
SelectedNode.Nodes.Add(RefNode);
TreeQuery RefNodeQry = new TreeQuery(RefNode, connexion);
RefNodeQry.Start(string.Format(SQL, tablename));
}
SelectedNode.Expand();
}
break;
case "field":
if (connexion.IsOpen)
{
DbObjectItem DbOi = new DbObjectItem("FKs", "fks");
TreeNode FieldsNode = new TreeNode(DbOi.Name);
FieldsNode.Tag = DbOi;
FieldsNode.SelectedImageIndex = 9;
FieldsNode.ImageIndex = 9;
TreeQuery FKsNodeQry = new TreeQuery(FieldsNode, connexion);
SQL = "SELECT r.table_name||'.'||a.COLUMN_NAME cname, 'VALID' " +
"FROM user_constraints t, user_constraints r, user_cons_columns b, user_cons_columns a " +
"WHERE t.r_constraint_name = r.constraint_name " +
"and a.CONSTRAINT_NAME = r.CONSTRAINT_NAME " +
"and b.CONSTRAINT_NAME = t.CONSTRAINT_NAME " +
"AND t.r_owner = r.owner " +
"AND t.constraint_type='R' " +
"AND t.table_name = '{0}' " +
"and b.COLUMN_NAME = '{1}' ";
//FKsNodeQry.Start(string.Format(SQL, SelectedNode.Parent.Parent.Text, SelectedNode.Text));
string tablename = SelectedNode.Parent.Parent.Text;
if (tablename.Contains("."))
{
int DotPos = tablename.IndexOf('.');
tablename = tablename.Substring(0, DotPos);
}
FKsNodeQry.Display(string.Format(SQL, tablename, SelectedNode.Text));
if (FieldsNode.Nodes.Count > 0)
SelectedNode.Nodes.Add(FieldsNode);
DbObjectItem DbOiIndex = new DbObjectItem("Indexes", "indexes");
TreeNode IndexesNode = new TreeNode(DbOiIndex.Name);
IndexesNode.Tag = DbOiIndex;
IndexesNode.SelectedImageIndex = 9;
IndexesNode.ImageIndex = 9;
TreeQuery IndexesNodeQry = new TreeQuery(IndexesNode, connexion);
string sql = "SELECT distinct index_name , 'VALID' " +
" FROM USER_IND_COLUMNS " +
" WHERE TABLE_NAME = '{0}' " +
" and column_name = '{1}' " +
" order by index_name ";
//FKsNodeQry.Start(string.Format(SQL, SelectedNode.Parent.Parent.Text, SelectedNode.Text));
IndexesNodeQry.Display(string.Format(sql, tablename, SelectedNode.Text));
if (IndexesNode.Nodes.Count > 0)
{
SelectedNode.Nodes.Add(IndexesNode);
}
SelectedNode.Expand();
}
break;
case "index":
DbObjectItem DbOiIndexCol = new DbObjectItem("Columns", "fields");
TreeNode IndexesColNode = new TreeNode(DbOiIndexCol.Name);
IndexesColNode.Tag = DbOiIndexCol;
IndexesColNode.SelectedImageIndex = 9;
IndexesColNode.ImageIndex = 9;
TreeQuery IndexesColNodeQry = new TreeQuery(IndexesColNode, connexion);
SQL = "SELECT distinct table_name||'.'||column_name , 'VALID', COLUMN_POSITION " +
" FROM USER_IND_COLUMNS " +
" WHERE index_name = '{0}' " +
" order by COLUMN_POSITION ";
//FKsNodeQry.Start(string.Format(SQL, SelectedNode.Parent.Parent.Text, SelectedNode.Text));
IndexesColNodeQry.Display(string.Format(SQL, SelectedNode.Text));
if (IndexesColNode.Nodes.Count > 0)
SelectedNode.Nodes.Add(IndexesColNode);
SelectedNode.Expand();
break;
case "indexe":
DbObjectItem DbOiIndexColumn = new DbObjectItem("Columns", "fields");
TreeNode IndexesColumnNode = new TreeNode(DbOiIndexColumn.Name);
IndexesColumnNode.Tag = DbOiIndexColumn;
IndexesColumnNode.SelectedImageIndex = 9;
IndexesColumnNode.ImageIndex = 9;
TreeQuery IndexesColumnNodeQry = new TreeQuery(IndexesColumnNode, connexion);
SQL = "SELECT distinct column_name , 'VALID', COLUMN_POSITION " +
" FROM USER_IND_COLUMNS " +
" WHERE index_name = '{0}' " +
" order by COLUMN_POSITION ";
//FKsNodeQry.Start(string.Format(SQL, SelectedNode.Parent.Parent.Text, SelectedNode.Text));
IndexesColumnNodeQry.Display(string.Format(SQL, SelectedNode.Text));
if (IndexesColumnNode.Nodes.Count > 0)
SelectedNode.Nodes.Add(IndexesColumnNode);
SelectedNode.Expand();
break;
case "package":
if (connexion.IsOpen)
{
DbObjectItem DbOi = new DbObjectItem("Package Spec", "packagespecs");
TreeNode PackagesNode = new TreeNode(DbOi.Name);
PackagesNode.Tag = DbOi;
SelectedNode.Nodes.Add(PackagesNode);
// Get all procedure and functions
TreeQuery PFNodeQry = new TreeQuery(PackagesNode, connexion);
SQL = "Select distinct " +
" object_name, 'VALID' /*, position, data_type, overload, argument_name, " +
" data_level, data_length, data_precision, data_scale, default_value, " +
" in_out, object_id, sequence */" +
"from all_arguments " +
"where object_id = (select object_id " +
" from sys.user_objects " +
" where object_name ='{0}' " +
" and object_type in ('PACKAGE')) " +
"order by Object_Name --, Overload, Sequence ";
PFNodeQry.Display(string.Format(SQL, SelectedNode.Text));
DbObjectItem DbOiPackageBody = new DbObjectItem("Package body", "packagebodys");
TreeNode PackagesBodyNode = new TreeNode(DbOiPackageBody.Name);
PackagesBodyNode.Tag = DbOiPackageBody;
SelectedNode.Nodes.Add(PackagesBodyNode);
// Get all procedure and functions
TreeQuery PFBNodeQry = new TreeQuery(PackagesBodyNode, connexion);
PFBNodeQry.Display(string.Format(SQL, SelectedNode.Text));
SelectedNode.Expand();
}
break;
case "function":
case "procedure":
if (connexion.IsOpen)
{
DbObjectItem DbOi = new DbObjectItem("Parameters", "parameters");
TreeNode ParametersNode = new TreeNode(DbOi.Name);
ParametersNode.Tag = DbOi;
SelectedNode.Nodes.Add(ParametersNode);
// Get all procedure and functions
TreeQuery ParamNodeQry = new TreeQuery(ParametersNode, connexion);
SQL = "Select lower(argument_name||': '||in_out||' '||data_type) param, 'VALID' " +
"from all_arguments " +
"where object_id = (select object_id " +
" from sys.user_objects " +
" where object_name ='{0}' " +
" and object_type in ('PROCEDURE', 'FUNCTION')) " +
"order by Sequence ";
ParamNodeQry.Display(
string.Format(SQL, SelectedNode.Text));
//if (PackagesNode.Nodes.Count > 0)
// SelectedNode.Nodes.Add(PackagesNode);
SelectedNode.Expand();
}
break;
case "packagespec":
case "packagebody":
case "proc_func":
if (connexion.IsOpen)
{
DbObjectItem DbOi = new DbObjectItem("Parameters", "Parameters");
TreeNode ParametersNode = new TreeNode(DbOi.Name);
ParametersNode.Tag = DbOi;
SelectedNode.Nodes.Add(ParametersNode);
// Get all procedure and functions
TreeQuery ParamNodeQry = new TreeQuery(ParametersNode, connexion);
SQL = "Select lower(argument_name||': '||in_out||' '||data_type) param, 'VALID' " +
"from all_arguments " +
"where object_id = (select object_id " +
" from sys.user_objects " +
" where object_name ='{0}' " +
" and object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION')) " +
" and object_name = '{1}' " +
"order by Sequence ";
ParamNodeQry.Display(
string.Format(SQL, SelectedNode.Parent.Parent.Text,
SelectedNode.Text));
//if (PackagesNode.Nodes.Count > 0)
// SelectedNode.Nodes.Add(PackagesNode);
SelectedNode.Expand();
}
break;
default:
break;
}
}
switch (tagType.Trim().ToLower())
{
case "field":
if (SelectedNode.Nodes.Count > 0)
{
createIndexToolStripMenuItem.Enabled = false;
dropIndexToolStripMenuItem.Enabled = true;
}
else
{
createIndexToolStripMenuItem.Enabled = true;
dropIndexToolStripMenuItem.Enabled = false;
}
break;
case "index":
createIndexToolStripMenuItem.Enabled = true;
dropIndexToolStripMenuItem.Enabled = true;
break;
case "indexe":
createIndexToolStripMenuItem.Enabled = false;
dropIndexToolStripMenuItem.Enabled = true;
break;
default:
createIndexToolStripMenuItem.Enabled = false;
dropIndexToolStripMenuItem.Enabled = false;
break;
}
}
private void GetObj(DbObjectItem DbOI, TreeNode tNode)
{
TreeNode TablesNode = new TreeNode(DbOI.Name);
TablesNode.Tag = DbOI; // obj_label.ToLower();
switch (DbOI.Type.ToUpper())
{
case "DATASOURCES":
TablesNode.ImageIndex = 1;
TablesNode.SelectedImageIndex = 1;
break;
case "TABLES":
TablesNode.ImageIndex = 2;
TablesNode.SelectedImageIndex = 2;
break;
case "VIEWS":
TablesNode.ImageIndex = 2;
TablesNode.SelectedImageIndex = 2;
break;
case "FUNCTIONS":
TablesNode.ImageIndex = 3;
TablesNode.SelectedImageIndex = 3;
break;
case "PROCEDURES":
TablesNode.ImageIndex = 4;
TablesNode.SelectedImageIndex = 4;
break;
case "PACKAGES":
TablesNode.ImageIndex = 5;
TablesNode.SelectedImageIndex = 5;
break;
case "TRIGGERS":
TablesNode.ImageIndex = 6;
TablesNode.SelectedImageIndex = 6;
break;
case "SEQUENCES":
TablesNode.ImageIndex = 7;
TablesNode.SelectedImageIndex = 7;
break;
case "INDEXES":
TablesNode.ImageIndex = 13;
TablesNode.SelectedImageIndex = 13;
DbOI.Type = "INDEXE";
break;
default:
TablesNode.ImageIndex = 0;
TablesNode.SelectedImageIndex = 0;
break;
}
tNode.Nodes.Add(TablesNode);
TreeQuery uLib = new TreeQuery(TablesNode, connexion);
uLib.Start(string.Format("select object_name, status from obj where object_type = '{0}'", DbOI.Type.Substring(0, DbOI.Type.Length - 1).ToUpper()));
}
