Package net.sourceforge.squirrel_sql.client.session

Examples of net.sourceforge.squirrel_sql.client.session.ISession

1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
  {
    if (prov == null)
    {
      return;
    }
    ISession sourceSession = prov.getCopySourceSession();
    ISession destSession = prov.getCopyDestSession();
    if (sourceSession == null || destSession == null)
    {
      return;
    }
    ISQLConnection sourceCon = sourceSession.getSQLConnection();
    ISQLConnection con = destSession.getSQLConnection();
    TableColumnInfo[] colInfoArr = null;
    try
    {
      colInfoArr = sourceCon.getSQLMetaData().getColumnInfo(ti);
    } catch (SQLException e)
    {
      // ignore any SQLExceptions. This would only if we could not get
      // column info from the SQL database meta data.
      return;
    }
    for (int colIdx = 0; colIdx < colInfoArr.length; colIdx++)
    {
      TableColumnInfo colInfo = colInfoArr[colIdx];
      IDatabaseObjectInfo selectedDestObj = prov.getDestSelectedDatabaseObject();
      String schema = selectedDestObj.getSimpleName();
      String catalog = selectedDestObj.getCatalogName();
      String tableName = getQualifiedObjectName(
         destSession, catalog, schema, TEST_TABLE_NAME, DialectFactory.DEST_TYPE);

      StringBuilder sql = new StringBuilder("CREATE TABLE ");
      sql.append(tableName);
      sql.append(" ( ");
      sql.append(colInfo.getColumnName());
      sql.append(" CHAR(10) )");
      boolean cascade = DialectFactory.isFrontBase(destSession.getMetaData());
      try
      {
        dropTable(TEST_TABLE_NAME, schema, catalog, destSession, cascade, DialectFactory.DEST_TYPE);
        DBUtil.executeUpdate(con, sql.toString(), false);
      } catch (SQLException e)
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
220
    private void testColType(ISQLDatabaseMetaData md,
                             String toDb,
                             TableColumnInfo column)
        throws Exception
    {
        ISession sourceSession = AppTestUtil.getEasyMockSession(md);
        ISession destSession = AppTestUtil.getEasyMockSession(toDb);
       
       
        String type = ColTypeMapper.mapColType(sourceSession,
                                               destSession,
                                               column,
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
240
                             String toDb,
                             TableColumnInfo column,
                             ResultSet rs)
        throws Exception
    {
        ISession sourceSession = AppTestUtil.getEasyMockSession(md, rs);
        ISession destSession = AppTestUtil.getEasyMockSession(toDb);


        String type = ColTypeMapper.mapColType(sourceSession,
                                               destSession,
                                               column,
View Full Code Here
61
62
63
64
65
66
67
68
69
    /**
     * Open the script.
     * @param prov
     */
    private void initializeScript(SessionInfoProvider prov) {
        ISession source = prov.getCopySourceSession();
        ISession dest = prov.getCopyDestSession();
        ScriptWriter.open(source,dest);
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
    /* (non-Javadoc)
     * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
     */
    public void actionPerformed(ActionEvent evt) {
        ISession destSession = sessionInfoProv.getCopyDestSession();
        IObjectTreeAPI api =
            destSession.getObjectTreeAPIOfActiveSessionWindow();
        if (api == null) {
            return;
        }
        IDatabaseObjectInfo[] dbObjs = api.getSelectedDatabaseObjects();
        if (dbObjs.length > 1) {
            sessionInfoProv.setDestSelectedDatabaseObject(null);
            //i18n[PasteTableAction.error.multischemapaste=The paste
            //operation may only be applied to one schema at a time]
            String msg =
              s_stringMgr.getString("PasteTableAction.error.multischemapaste");
            app.showErrorDialog(msg);
                           
            return;
        } else {
          // When the user pastes on a TABLE label which is located under a
          // schema/catalog, build the schema DatabaseObjectInfo.
          if (DatabaseObjectType.TABLE_TYPE_DBO.equals(dbObjs[0].getDatabaseObjectType())) {
            IDatabaseObjectInfo tableLabelInfo = dbObjs[0];
            ISQLConnection destCon = destSession.getSQLConnection();
            SQLDatabaseMetaData md = null;
            if (destCon != null) {
              md = destCon.getSQLMetaData();
            }
            IDatabaseObjectInfo schema =
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
        ISQLDatabaseMetaData md = createNiceMock(ISQLDatabaseMetaData.class);
        expect(md.getCatalogSeparator()).andReturn(".");
        expect(md.supportsCatalogsInTableDefinitions()).andReturn(true);
        expect(md.supportsSchemasInTableDefinitions()).andReturn(true);
        replay(md);
        ISession session = createNiceMock(ISession.class);
        expect(session.getMetaData()).andReturn(md).anyTimes();
        replay(session);
        String catalog = "TestCatalog";
        String schema = "TestSchema";
        String table = "TestTable";
        // case shouldn't be changed in this test because the context is the
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
45
  @Before
  public void setUp() throws Exception
  {
    super.setUp();
   
    ISession session = EasyMock.createMock(ISession.class);
    ISQLDatabaseMetaData metaData = EasyMock.createMock(ISQLDatabaseMetaData.class);
    expect(session.getMetaData()).andStubReturn(metaData);
    expect(metaData.getDatabaseProductName()).andStubReturn("Oracle");
    expect(metaData.getDatabaseProductVersion()).andStubReturn("10g");
   
    classUnderTest = new SupportedRefactoringsTab(session);
    clazz = SupportedRefactoringsTab.class;
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
    }
   
    private int[] getTableCounts() {
        int[] result = null;
       
        ISession sourceSession = prov.getDiffSourceSession();
        IDatabaseObjectInfo[] dbObjs = prov.getSourceSelectedDatabaseObjects();
        if (dbObjs != null) {
            result = new int[dbObjs.length];
            for (int i = 0; i < dbObjs.length; i++) {
                if (false == dbObjs[i] instanceof ITableInfo) {
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
  /**
   * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
   */
  public void actionPerformed(ActionEvent evt)
  {
    ISession destSession = sessionInfoProv.getDiffDestSession();
    IObjectTreeAPI api = destSession.getObjectTreeAPIOfActiveSessionWindow();
    if (api == null) { return; }
    IDatabaseObjectInfo[] dbObjs = api.getSelectedDatabaseObjects();
    sessionInfoProv.setDestSelectedDatabaseObjects(dbObjs);

    if (sessionInfoProv.getDiffSourceSession() == null) { return; }
View Full Code Here
97
98
99
100
101
102
103
104
105
   *
   * @return true if they are different sessions; false otherwise.
   */
  private boolean sourceDestSchemasDiffer()
  {
    ISession sourceSession = sessionInfoProv.getDiffSourceSession();
    ISession destSession = sessionInfoProv.getDiffDestSession();
    return sourceSession != null && ! sourceSession.equals(destSession);
  }
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.client.session.ISession

  • net.sourceforge.squirrel_sql.client.action.ActionCollection
  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrameToolBar$MySessionListener
  • net.sourceforge.squirrel_sql.client.gui.session.SessionPanel
  • net.sourceforge.squirrel_sql.client.gui.session.SessionPanel$CatalogsComboListener
  • net.sourceforge.squirrel_sql.client.gui.WindowManager
  • net.sourceforge.squirrel_sql.client.gui.WindowManager$SessionListener
  • net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.