databaseView           package:RGtkViewers           R Documentation

_G_U_I _f_o_r _d_i_s_p_l_a_y_i_n_g _d_a_t_a_b_a_s_e, _t_a_b_l_e_s _a_n_d _s_c_h_e_m_a

_D_e_s_c_r_i_p_t_i_o_n:

     This provides a GUI for browsing the structure of a database
     server. Specifically, it creates a 'GtkTree' object which shows
     the hierarchical content of the server, i.e.   databases, tables
     within databases, fields within tables as an expandable and
     interactive tree. One can customize the behavior of the tree  by
     providing one or more callbacks for the different nodes.

_U_s_a_g_e:

     databaseView(con, callbacks = NULL, databases = getDatabases(con)[, 1], lazy = FALSE)

_A_r_g_u_m_e_n_t_s:

     con: the RSDBI connection object to the server

callbacks: a list of callbacks which are to be registered with the the
          tree items at successive levels of the tree. The first
          function in the list is used for database name items. The
          second element is used for tables within those databases. And
          the final element is used for fields within those tables. Any
          of them can be 'NULL'.

databases: a character vector giving the names of the databases to
          show. This defaults to all of the databases in the server.
          One can specify a subset of the entire list for efficiency
          and focus.

    lazy: a logical value, which if TRUE specifies that the sub-nodes
          should not be created until they are expanded. Otherwise
          ('FALSE'), the entire contents of the tree are queried from
          the database before it is displayed. This trades off delays
          in initialization when querying the entire hierarcy of the
          database server for more uniform delays when examining the
          tree.

_V_a_l_u_e:

     The top-level Gtk GUI window displaying the class hierarchy. This
     is an object of class   'GtkWindow'.

_A_u_t_h_o_r(_s):

     Duncan Temple Lang <duncan@research.bell-labs.com>

_R_e_f_e_r_e_n_c_e_s:

     <URL: http://www.omegahat.org/RGtk>, <URL:
     http://www.omegahat.org/RSDBI>

_S_e_e _A_l_s_o:

     'createDatabaseTree' 'createDatabaseTree' 'databaseLazyTreeView'

_E_x_a_m_p_l_e_s:

     ## Not run: 
      library(RMySQL)
      m <- dbManager("MySQL")
      con <- dbConnect(m)
      databaseView()
     ## End(Not run)

