Exemplo n.º 1
0
        //========================================================================================
        // Discover()
        //		If an inheritor allows discoveries (HasDiscovery == true), then the inheritor
        //		should override this method to propulate its Nodes collections.
        //========================================================================================

        public virtual void Discover()
        {
            Nodes.Clear();

            switch (this.type = type)
            {
            case SchemataType.Column:               DiscoverColumns();                      break;

            case SchemataType.Function:             DiscoverFunctions();            break;

            case SchemataType.Index:                DiscoverIndexes();                      break;

            case SchemataType.Package:              DiscoverPackages();                     break;

            case SchemataType.PackageBody:  DiscoverPackageBodies();        break;

            case SchemataType.Procedure:    DiscoverProcedures();           break;

            case SchemataType.Sequence:             DiscoverSequences();            break;

            case SchemataType.SystemTable:  DiscoverTables();                       break;

            case SchemataType.UserTable:    DiscoverTables();                       break;

            case SchemataType.View:                 DiscoverViews();                        break;
            }
        }
Exemplo n.º 2
0
        protected override void DoDiscoverWork(object sender, DoWorkEventArgs e)
        {
            string sql =
                @"select object_name, object_id, created, last_ddl_time, status
  from all_objects
 where owner = '" + schemaName + @"'
   and object_type = 'TYPE'
 order by 1";

            Logger.WriteLine(sql);

            using (var cmd = new OracleCommand(sql, dbase.OraConnection))
            {
                try
                {
                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            if (Logger.IsEnabled)
                            {
                                Logger.WriteLine(schemaName + "." + reader.GetString(0));
                            }

                            var table = new SchemataType(
                                dbase,
                                srvnode,
                                reader.GetString(Colnum.ObjectName));

                            if (reader.GetString(Colnum.Status) == "INVALID")
                            {
                                table.ForeColor = System.Drawing.Color.Red;
                            }

                            table.AddProperty("Name", reader.GetString(Colnum.ObjectName));
                            table.AddProperty("Object ID", ((int)reader.GetDecimal(Colnum.ObjectID)).ToString());
                            table.AddProperty("Created", reader.GetDateTime(Colnum.Created).ToString());
                            table.AddProperty("Last DDL Time", reader.GetDateTime(Colnum.LastDDLTime).ToString());
                            table.AddProperty("Status", reader.GetString(Colnum.Status));

                            discoveries.Add(table);
                        }

                        reader.Close();
                    }
                }
                catch (Exception exc)
                {
                    River.Orqa.Dialogs.ExceptionDialog.ShowException(exc);
                }
            }
        }
Exemplo n.º 3
0
        //========================================================================================
        // Constructor
        //		Public type constructor.  The default base constructor will be called
        //		implicitly, which, in turn, will call our Configure factory method.
        //========================================================================================

        public SchemataFolder(MainForm form, ConnectionInfo cinfo, SchemataType type)
        {
            this.Form = form;

            switch (this.type = type)
            {
            case SchemataType.Column:
                Text = "Columns";
                break;

            case SchemataType.Function:
                Text         = "Functions";
                restrictions = new string[] { null, schemaName, null, null };
                break;

            case SchemataType.Index:
                Text = "Indexes";
                break;

            case SchemataType.Package:
                Text         = "Packages";
                restrictions = new Object[] { null, schemaName, null, null };
                break;

            case SchemataType.PackageBody:
                Text         = "Package Bodies";
                restrictions = new Object[] { null, schemaName, null, null };
                break;

            case SchemataType.Procedure:
                Text = "Procedures";
                short ptype = 2;
                restrictions = new Object[] { null, schemaName, null, ptype };
                break;

            case SchemataType.Sequence:
                Text         = "Sequences";
                restrictions = new Object[] { null, schemaName, null, null };
                break;

            case SchemataType.SystemTable:
                Text         = "System Tables";
                restrictions = new Object[] { null, schemaName, null, "SYSTEM TABLE" };
                break;

            case SchemataType.UserTable:
                Text         = "User Tables";
                restrictions = new Object[] { null, schemaName, null, "TABLE" };
                break;

            case SchemataType.View:
                Text         = "Views";
                restrictions = new Object[] { null, schemaName, null };
                break;
            }

            ImageIndex         = 2;
            SelectedImageIndex = 2;

            canRefresh   = true;
            hasDiscovery = true;

            Nodes.Add(new TreeNode());
        }