Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData

154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
   }

   public static ISQLDatabaseMetaData getEasyMockSybase12SQLMetaData()
         throws SQLException
   {
      ISQLDatabaseMetaData md = getSybaseSQLMetaData();
      String version =
         "Adaptive Server Enterprise/12.5.4/EBF 13194 " +
         "EC ESD/P/Linux Intel/Linux 2.4.21-20.ELsmp i686/" +
         "ase120/2179/32-bit/FBO/Mon Feb  6 04:14:19 2006";
      expect(md.getDatabaseProductVersion()).andReturn(version).anyTimes();
      expect(md.supportsSchemasInTableDefinitions()).andStubReturn(true);
      replay(md);
      return md;
   }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
      replay(md);
      return md;
   }

   private static ISQLDatabaseMetaData getSybaseSQLMetaData() throws SQLException {
      ISQLDatabaseMetaData md = createMock(ISQLDatabaseMetaData.class);
      expect(md.getDatabaseProductName()).andReturn("Adaptive Server Enterprise")
                                         .anyTimes();
      expect(md.supportsSchemasInDataManipulation()).andReturn(true).anyTimes();
      expect(md.supportsCatalogsInDataManipulation()).andReturn(true)
                                                     .anyTimes();
      expect(md.getCatalogSeparator()).andReturn(".").anyTimes();
      expect(md.getIdentifierQuoteString()).andReturn("\"").anyTimes();
      expect(md.getURL()).andReturn("jdbc:sybase:Tds:192.168.1.135:4115/dbcopydest")
                         .anyTimes();
      return md;     
   }
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
public class ColumnDiffDialogTestUI {

    public static void main(String[] args) throws Exception {
        ApplicationArguments.initialize(new String[] {});
       
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData("oracle", "jdbc:oracle");
        ColumnDifference diff = new ColumnDifference();
        TableColumnInfo column1 = FwTestUtil.getBigintColumnInfo(md, true);
        TableColumnInfo column2 = FwTestUtil.getVarcharColumnInfo(md, true, 100);
        diff.setColumns(column1, column2);
        diff.execute();
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
       return createTableScriptString(new IDatabaseObjectInfo[] { dbObj });
   }

   public String createTableScriptString(IDatabaseObjectInfo[] dbObjs) {
        StringBuilder result = new StringBuilder(1000);
        ISQLDatabaseMetaData md = _session.getMetaData();
        try {
            boolean isJdbcOdbc = md.getURL().startsWith("jdbc:odbc:");
            if (isJdbcOdbc) {
                _session.showErrorMessage(i18n.JDBCODBC_MESSAGE);
                s_log.error(i18n.JDBCODBC_MESSAGE);
            }
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
219
     *            unexpected sql exception
     */
    private boolean isColumnNameUnique(String columnName) throws SQLException
    {
      boolean result = true;
      ISQLDatabaseMetaData md = _session.getMetaData();
      TableColumnInfo[] columnInfos = md.getColumnInfo((ITableInfo) _info[0]);
      for (TableColumnInfo columnInfo : columnInfos)
      {
        String existingColumnName = columnInfo.getColumnName();
        if (columnName.equalsIgnoreCase(existingColumnName))
        {
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
  @Override
  protected String[] generateSQLStatements() throws Exception
  {
    ArrayList<String> results = new ArrayList<String>();

    ISQLDatabaseMetaData md = _session.getMetaData();

    String catalog = _info[0].getCatalogName();
    String schema = _info[0].getSchemaName();

    String lookupTableName = _customDialog.getLookupTableName();
    String lookupPrimaryKey = _customDialog.getLookupPrimaryKey();

    TableColumnInfo sourceColumn = null;
    for (TableColumnInfo info : md.getColumnInfo((ITableInfo) _info[0]))
    {
      if (info.getColumnName().equals(_customDialog.getSourceColumn()))
      {
        sourceColumn = info;
        break;
View Full Code Here
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
    return result;
  }

  private void showCustomDialog() throws SQLException
  {
    ISQLDatabaseMetaData md = _session.getMetaData();
    ITableInfo selectedTable = (ITableInfo) _info[0];
    TableColumnInfo[] tableColumnInfos = md.getColumnInfo(selectedTable);
    ForeignKeyInfo[] exportedKeys = md.getExportedKeysInfo(selectedTable);
    ForeignKeyInfo[] importedKeys = md.getImportedKeysInfo(selectedTable);

    _customDialog =
      new AddLookupTableDialog(selectedTable.getSimpleName(), getColumnNames(tableColumnInfos,
        exportedKeys,
        importedKeys));
View Full Code Here
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
    {
      catalog = fixCase(session, catalogName);
      schema = fixCase(session, schemaName);
      object = fixCase(session, objectName);
    }
    ISQLDatabaseMetaData md = session.getMetaData();
    boolean useSchema = true;
    boolean useCatalog = true;
    try
    {
      useCatalog = md.supportsCatalogsInTableDefinitions();
    } catch (SQLException e)
    {
      log.info("Encountered unexpected exception while attempting to "
            + "determine if catalogs are used in table definitions");
    }
    try
    {
      useSchema = md.supportsSchemasInTableDefinitions();
    } catch (SQLException e)
    {
      log.info("Encountered unexpected exception while attempting to "
            + "determine if schemas are used in table definitions");
    }
View Full Code Here
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
  public static String getCatSep(ISession session)
  {
    String catsep = ".";
    try
    {
      ISQLDatabaseMetaData md = session.getMetaData();
      catsep = md.getCatalogSeparator();
    } catch (SQLException e)
    {
      log.error("getCatSep: Unexpected Exception - " + e.getMessage(), e);
    }
    return catsep;
View Full Code Here
141
142
143
144
145
146
147
148
149
        return rs;
    }
   
    private void testBigintColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getBigintColumnInfo(md, true);
        testColType(md, toDb, column);
    }   
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData

  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.plugin.AbstractSessionPluginTest
  • net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
  • net.sourceforge.squirrel_sql.fw.dialects.DialectExternalTest
  • net.sourceforge.squirrel_sql.fw.dialects.DialectUtilsTest
  • net.sourceforge.squirrel_sql.fw.FwTestUtil
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.dbcopy.ColTypeMapperTest
  • net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor
    • 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.