Package net.sourceforge.squirrel_sql.fw.sql

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

200
201
202
203
204
205
206
207
    }   
   
    private void testIntegerColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getIntegerColumnInfo(md, true);
        testColType(md, toDb, column);
    }
View Full Code Here
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
      Statement stmt = session.getSQLConnection().createStatement();
      int resultFound = 0;

      for (int c = 0; c < columnInfos.length; c++)
      {
        TableColumnInfo tableColumnInfo = columnInfos[c];
        String sql = null;

        if (isStringValueCheck(tableColumnInfo) || isIntegerValueCheck(tableColumnInfo)
          || isNumericValueCheck(tableColumnInfo) || isDateValueCheck(tableColumnInfo))
        {
          sql =
            "SELECT COUNT(*) FROM " + tableInfo.getSimpleName() + " "
              + getWhereCondition(tableColumnInfo.getColumnName(), oldValue);
        }

        if (sql != null)
        {
          try
          {
            resultFound = SmarttoolsHelper.checkColumnData(stmt, sql);
            if (resultFound > 0 || !chkDisplayOnlyTablesWithData.isSelected())
            {
              addTableEntry(stmt, tableInfo.getSimpleName(), tableColumnInfo.getColumnName(),
                SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo), resultFound);
            }
          }
          catch (SQLException e)
          {
            String text =
              INDENT + i18n.ERROR_ON_TABLE + " [" + tableInfo.getSimpleName() + "] "
                + i18n.GLOBAL_COLUMN + " [" + tableColumnInfo.getColumnName() + "] :"
                + e.getLocalizedMessage();
            addTableEntry(stmt, tableInfo.getSimpleName(), tableColumnInfo.getColumnName(),
              SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo), -1);
            log.error(text);
          }
        }
      }
View Full Code Here
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
      TableColumnInfo[] columnInfos = session.getMetaData().getColumnInfo(tableInfo);
      Statement stmt = session.getSQLConnection().createStatement();
      int resultFound = 0;

      for (int c = 0; c < columnInfos.length; c++) {
        TableColumnInfo tableColumnInfo = columnInfos[c];
        String sql = null;

        if (tableColumnInfo.isNullAllowed() == 0) {
          sql = "SELECT COUNT(*) FROM " + tableInfo.getSimpleName()
              + " WHERE " + tableColumnInfo.getColumnName()
              + " IS NULL";
        }

        if (sql != null) {
          try {
            resultFound = SmarttoolsHelper.checkColumnData(stmt, sql);
            if (resultFound > 0) {
              addTableEntry(tableInfo.getSimpleName(),
                  tableColumnInfo.getColumnName(),
                  SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo),
                  resultFound + "");
            }
          } catch (SQLException e) {
            String text = INDENT + i18n.ERROR_ON_TABLE + " ["
                + tableInfo.getSimpleName() + "] "
                + i18n.GLOBAL_COLUMN + " ["
                + tableColumnInfo.getColumnName() + "] :"
                + e.getLocalizedMessage();
            addTableEntry(tableInfo.getSimpleName(),
                tableColumnInfo.getColumnName(),
                SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo),
                i18n.ERROR_ON_TABLE);
            log.error(text);
          }
        }
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
288
289
290
    {
      for (String importerColumn : importerColumns )
      {
        if (null != importerColumn && !importerColumn.isEmpty())
        {
          final TableColumnInfo suggestedColumn = suggestColumn(importerColumn, ignorecase);
          if (suggestedColumn != null)
          {           
            final String suggestedColumnName = suggestedColumn.getColumnName();
            int row = columnMappingTableModel.findTableColumn(suggestedColumnName);
            columnMappingTableModel.setValueAt(importerColumn, row, ColumnMappingConstants.INDEX_IMPORTFILE_COLUMN);
          }
        }
      }     
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        Map<String, TableColumnInfo> t2ColMap = getColumnMap(t2cols);
       
        for (String columnName : columnNames) {
            ColumnDifference diff = new ColumnDifference();
            if (t1ColumnNames.contains(columnName)) {
                TableColumnInfo c1 = t1ColMap.get(columnName);
               
                if (t2ColumnNames.contains(columnName)) { // Column is in both table 1 and 2
                    TableColumnInfo c2 = t2ColMap.get(columnName);
                    diff.setColumns(c1, c2);
                } else {
                    // Column is in table 1, but not table 2
                    diff.setCol2Exists(false);
                    diff.setColumn1(c1);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
   
    private Map<String, TableColumnInfo> getColumnMap(TableColumnInfo[] tci) {
        HashMap<String, TableColumnInfo> result =
            new HashMap<String, TableColumnInfo>();
        for (int i = 0; i < tci.length; i++) {
            TableColumnInfo info = tci[i];
            result.put(info.getColumnName(), info);
        }       
        return result;
    }
View Full Code Here
104
105
106
107
108
109
110
111
112
113
    }
   
    private Set<String> getAllColumnNames(TableColumnInfo[] tci) {
        HashSet<String> result = new HashSet<String>();
        for (int i = 0; i < tci.length; i++) {
            TableColumnInfo info = tci[i];
            result.add(info.getColumnName());
        }
        return result;
    }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    IQueryTokenizer mockTokenizer = mockHelper.createMock(IQueryTokenizer.class);
    expect(mockTokenizer.getSQLStatementSeparator()).andStubReturn(";");
    expect(mockSession.getQueryTokenizer()).andStubReturn(mockTokenizer);
   
   
    TableColumnInfo mockTableColumnInfo = mockHelper.createMock(TableColumnInfo.class);
    expect(mockTableColumnInfo.getColumnName()).andStubReturn("testColumnName");
    expect(mockTableColumnInfo.getDefaultValue()).andStubReturn("");
    expect(mockTableColumnInfo.getColumnSize()).andStubReturn(10);
    expect(mockTableColumnInfo.getDataType()).andStubReturn(VARCHAR);
    expect(mockTableColumnInfo.getDecimalDigits()).andStubReturn(0);
    expect(mockTableColumnInfo.isNullable()).andStubReturn("YES");
    final ForeignKeyInfo[] fkInfos = new ForeignKeyInfo[0];
    expect(mockMetaData.getImportedKeysInfo(mockTableInfo)).andStubReturn(fkInfos);
    TableColumnInfo[] columnInfos = new TableColumnInfo[] { mockTableColumnInfo };
    expect(mockMetaData.getColumnInfo(mockTableInfo)).andStubReturn(columnInfos);
  }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
  @Override
  protected String[] generateSQLStatements()
  {
    String[] result = null;

    TableColumnInfo to = customDialog.getColumnInfo();
    String dbName = customDialog.getSelectedDBName();
    _dialect = DialectFactory.getDialect(dbName);

    DatabaseObjectQualifier qualifier =
      new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
        {
          if (s_log.isDebugEnabled())
          {
            s_log.debug("Schema: " + mc.getSchemaName());
          }
          TableColumnInfo columnInNewTable =
            new TableColumnInfo(  mc.getCatalogName(),
                          mc.getSchemaName(),
                          destinationTable,
                          mc.getColumnName(),
                          mc.getDataType(),
                          JDBCTypeMapper.getJdbcTypeName(mc.getDataType()),
View Full Code Here
TOP

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

  • net.sourceforge.squirrel_sql.client.gui.db.ColumnDetailDialog
  • net.sourceforge.squirrel_sql.client.gui.db.ColumnListDialog
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
  • net.sourceforge.squirrel_sql.client.session.properties.EditWhereColsSheet
  • net.sourceforge.squirrel_sql.fw.dialects.AbstractDialectExtTest
  • net.sourceforge.squirrel_sql.fw.dialects.DialectExternalTest
  • net.sourceforge.squirrel_sql.fw.dialects.H2DialectExt
  • net.sourceforge.squirrel_sql.fw.dialects.IngresDialectExt
  • net.sourceforge.squirrel_sql.fw.dialects.OracleDialectExt
  • net.sourceforge.squirrel_sql.fw.FwTestUtil
    • 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.