public ProcedureNode(
SchemaNode schemaNode,
PackageNode packageNode,
string name)
{
this.schemaNode = schemaNode;
this.packageNode = packageNode;
this.name = name;
}
public TableNode(
SchemaNode schema,
string name,
bool showFullName)
{
this.schema = schema;
this.name = name;
this.showFullName = showFullName;
}
public TableNode(
SchemaNode schema,
string name,
bool showFullName)
{
_schema = schema;
_name = name;
_showFullName = showFullName;
}
public ProcedureNode(
SchemaNode schemaNode,
PackageNode packageNode,
string name)
{
_schemaNode = schemaNode;
_packageNode = packageNode;
_name = name;
}
IEnumerable <ITreeNode> ITreeNode.GetChildren(bool refresh)
{
var commandText = $@"select s.TABLE_OWNER,
s.TABLE_NAME
from SYS.ALL_SYNONYMS s
where s.OWNER = '{_schema.Name}'
and s.SYNONYM_NAME = '{_name}'";
var executor = _schema.SchemasNode.Connection.CreateCommandExecutor();
var dataTable = executor.ExecuteDataTable(new ExecuteReaderRequest(commandText));
var dataRow = dataTable.Rows[0];
var schemaName = (string)dataRow["TABLE_OWNER"];
var schemaNode = new SchemaNode(_schema.SchemasNode, schemaName);
var tableNode = new TableNode(schemaNode, (string)dataRow["TABLE_NAME"], true);
return(new ITreeNode[] { tableNode });
}
public IEnumerable <ITreeNode> GetChildren(bool refresh)
{
var commandText = "select username from all_users order by username";
var executor = Connection.CreateCommandExecutor();
var dataTable = executor.ExecuteDataTable(new ExecuteReaderRequest(commandText));
var count = dataTable.Rows.Count;
var treeNodes = new ITreeNode[count];
for (var i = 0; i < count; i++)
{
var name = (string)dataTable.Rows[i][0];
treeNodes[i] = new SchemaNode(this, name);
}
return(treeNodes);
}
public FunctionCollectionNode(SchemaNode schemaNode)
{
_schemaNode = schemaNode;
}
public SynonymNode(SchemaNode schema, string name)
{
_schema = schema;
_name = name;
}
public ViewCollectionNode(SchemaNode schemaNode)
{
_schemaNode = schemaNode;
}
public SynonymCollectionNode(SchemaNode schema)
{
_schema = schema;
}
public TableCollectionNode(SchemaNode schema)
{
this.schema = schema;
}
public ProcedureCollectionNode(SchemaNode schemaNode) => _schemaNode = schemaNode;
public SequenceNode(SchemaNode schemaNode, string name)
{
_schemaNode = schemaNode;
_name = name;
}
public SequenceCollectionNode(SchemaNode schemaNode)
{
this.schemaNode = schemaNode;
}
public SequenceNode(SchemaNode schemaNode, string name)
{
this.schemaNode = schemaNode;
this.name = name;
}
public PackageCollectionNode(SchemaNode schema) => this.schema = schema;
public FunctionNode(SchemaNode schemaNode, PackageNode packageNode, string name)
{
_schemaNode = schemaNode;
_packageNode = packageNode;
_name = name;
}
public PackageNode(SchemaNode schema, string name)
{
_schemaNode = schema;
_name = name;
}