/** * Set title of this frame. Ensure that the title label matches the frame title. * * @param title New title text. */ public void setTitle(String title) { if(null != _titleLbl) { // this method is called from the super class's constructor // therfore _titleLbl is null for that call. _titleLbl.setText(title + ": " + _objectInfo.getSimpleName()); } }
private String[] getSimpleNames(IDatabaseObjectInfo[] dbInfo) { ArrayList<String> simpleNames = new ArrayList<String>(); for (IDatabaseObjectInfo info : dbInfo) { if (!simpleNames.contains(info.getSimpleName())) simpleNames.add(info.getSimpleName()); } return simpleNames.toArray(new String[] {}); }
protected String getSQL() { final String catalog = getDatabaseObjectInfo().getSimpleName(); return "show open tables from " + catalog; } }
public static String getSchemaNameFromDbObject(IDatabaseObjectInfo dbObject) { String destSchema; if (dbObject.getDatabaseObjectType().equals(DatabaseObjectType.SCHEMA)) { destSchema = dbObject.getSimpleName(); } else { destSchema = dbObject.getSchemaName(); } return destSchema; }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; } }
public String getSimpleName() { if (null != _objectTreeNode) { return _objectTreeNode.getDatabaseObjectInfo().getSimpleName(); } else { return _tableInfo.getSimpleName(); } }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; } }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; } }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; }
protected PreparedStatement createStatement() throws SQLException { //System.out.println(SQL); ISession session = getSession(); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); pstmt.setString(1, doi.getSimpleName()); pstmt.setString(2, doi.getSchemaName()); pstmt.setString(3, doi.getSimpleName()); //I dont know how to get the user and db_name //pstmt.setString(4, "gpadmin"); //pstmt.setString(5, "db_name"); return pstmt; }
/** * This method simply returns a String array containing the schema name and the selected object's simple * name, in that order. If the SQL returned from getSqlStatement must specify a different order, or for * example uses that catalog of the object, instead of or in addition to schema, then this method must be * overridden to return the necessary bind variable values, in the order required by the SQL statement. * * @return a String array of bind variable values */ protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getSchemaName(), doi.getSimpleName() }; }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, * net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo) */ public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) throws SQLException { if (s_log.isDebugEnabled()) { s_log.debug("Binding schema name " + dbo.getSchemaName() + " as first bind value"); s_log.debug("Binding table name " + dbo.getSimpleName() + " as second bind value"); } pstmt.setString(1, dbo.getSchemaName()); pstmt.setString(2, dbo.getSimpleName()); }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo) */ public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) throws SQLException { if (s_log.isDebugEnabled()) { s_log.debug("Binding table name "+dbo.getSchemaName()+ " as first bind value"); } pstmt.setString(1, dbo.getSimpleName()); }
protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt; } }
protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt; } }
protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); if (s_log.isDebugEnabled()) { s_log.debug("Trigger details SQL: "+SQL); s_log.debug("Trigger name: "+doi.getSimpleName()); } PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); pstmt.setString(1, doi.getSimpleName()); return pstmt; } }
protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(BIGVIEW_SQL); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt; } }
/** * Expands the specified tree node. * * @param node the tree node to expand */ public void expandNode(ObjectTreeNode node) { IDatabaseObjectInfo info = node.getDatabaseObjectInfo(); TreePath path = getTreePath(info.getCatalogName(), info.getSchemaName(), new FilterMatcher(info.getSimpleName(), null)); _tree.fireTreeExpanded(path); }
/** * Expands the specified tree node. * * @param node the tree node to expand */ public void expandNode(ObjectTreeNode node) { IDatabaseObjectInfo info = node.getDatabaseObjectInfo(); TreePath path = getTreePath(info.getCatalogName(), info.getSchemaName(), new FilterMatcher(info.getSimpleName(), null)); _tree.fireTreeExpanded(path); }