Package net.sourceforge.squirrel_sql.fw.sql

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

369
370
371
372
373
374
375
376
377
378
379
380
            // get the nullability information and pass it into the ResultSet
            // Unfortunately, not all DBMSs provide the column number in object 17 as stated in the
            // SQL documentation, so we have to guess that the result set is in column order
            for (int i = 0; i < columnInfos.length; i++) {
                boolean isNullable = true;
                TableColumnInfo info = columnInfos[i];
                if (info.isNullAllowed() == DatabaseMetaData.columnNoNulls) {
                    isNullable = false;
                }
                if (i < colDefs.length) {
                    colDefs[i].setIsNullable(isNullable);
                }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
    try
    {
      final ISQLConnection conn = session.getSQLConnection();
        TableColumnInfo[] infos = conn.getSQLMetaData().getColumnInfo((ITableInfo)_objectInfo);
        for (int i = 0; i < infos.length; i++) {
           TableColumnInfo info = infos[i];
           columnNames.add(info.getColumnName());
        }
    }
    catch (SQLException ex)
    {
      session.getApplication().showErrorDialog(
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
  {
    ArrayList<String> result = new ArrayList<String>();
    String alterClause = DialectUtils.ALTER_COLUMN_CLAUSE;
    for (int i = 0; i < columns.length; i++)
    {
      TableColumnInfo info = columns[i];
      String notNullSQL = DialectUtils.getColumnNullableAlterSQL(info, false, this, alterClause, true, qualifier, prefs);
      result.add(notNullSQL);
    }
    result.add(DialectUtils.getAddPrimaryKeySQL(ti, pkName, columns, false, qualifier, prefs, this));
    return result.toArray(new String[result.size()]);
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
    addPKSQL.append(" ADD CONSTRAINT ");
    addPKSQL.append(pkName);
    addPKSQL.append(" PRIMARY KEY (");
    for (int i = 0; i < columns.length; i++)
    {
      TableColumnInfo info = columns[i];
      if (info.isNullable().equals("YES"))
      {
        String alterClause = DialectUtils.ALTER_COLUMN_CLAUSE;
        String notNullSql =
          DialectUtils.getColumnNullableAlterSQL(info, false, this, alterClause, true, qualifier, prefs);

        result.add(notNullSql);
      }
      addPKSQL.append(DialectUtils.shapeIdentifier(info.getColumnName(), prefs, this));
      if (i + 1 < columns.length)
      {
        addPKSQL.append(", ");
      }
    }
View Full Code Here
382
383
384
385
386
387
388
389
390
391
392
      int index = 0;
      for (String columnName : columnNames) {
         Integer columnDataType = dataTypes.get(index++);

         TableColumnInfo info = getEasyMockTableColumnInfo(catalogName,
                                                           schemaName,
                                                           tableName,
                                                           columnName,
                                                           columnDataType,
                                                           10,
View Full Code Here
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
   public static TableColumnInfo getEasyMockTableColumnInfo(String catalogName,
         String schemaName, String tableName, String columnName, int dataType,
         int columnSize, String defaultValue, String remarks,
         int decimalDigits, int octetLength, int radix, boolean nullable) {
      TableColumnInfo info = createMock(TableColumnInfo.class);
      expect(info.getCatalogName()).andReturn(catalogName).anyTimes();
      expect(info.getSchemaName()).andReturn(schemaName).anyTimes();
      expect(info.getTableName()).andReturn(tableName).anyTimes();
      expect(info.getColumnName()).andReturn(columnName).anyTimes();
      expect(info.getDataType()).andReturn(dataType).anyTimes();
      expect(info.getTypeName()).andReturn(JDBCTypeMapper.getJdbcTypeName(dataType))
                                .anyTimes();
      expect(info.getColumnSize()).andReturn(columnSize).anyTimes();
      expect(info.getDatabaseObjectType()).andReturn(DatabaseObjectType.COLUMN)
                                          .anyTimes();
      expect(info.getDefaultValue()).andReturn(defaultValue).anyTimes();
      expect(info.getRemarks()).andReturn(remarks).anyTimes();
      expect(info.getDecimalDigits()).andReturn(decimalDigits).anyTimes();
      expect(info.getOctetLength()).andReturn(octetLength).anyTimes();
      expect(info.getQualifiedName()).andReturn(schemaName + "." + tableName
            + "." + columnName).anyTimes();
      expect(info.getRadix()).andReturn(radix).anyTimes();
      if (nullable) {
         expect(info.isNullable()).andReturn("YES").anyTimes();
         expect(info.isNullAllowed()).andReturn(1).anyTimes();
      } else {
         expect(info.isNullable()).andReturn("NO").anyTimes();
         expect(info.isNullAllowed()).andReturn(0).anyTimes();
      }
      replay(info);
      return info;
   }
View Full Code Here
446
447
448
449
450
451
452
453
454
455
456
    *           the new column size
    * @return
    */
   public static TableColumnInfo setEasyMockTableColumnInfoSize(
         final TableColumnInfo info, final int newSize) {
      TableColumnInfo result = getEasyMockTableColumnInfo(info.getCatalogName(),
                                                          info.getSchemaName(),
                                                          info.getTableName(),
                                                          info.getColumnName(),
                                                          info.getDataType(),
                                                          newSize,
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
    *           the new column size
    * @return
    */
   public static TableColumnInfo setEasyMockTableColumnInfoNullable(
         final TableColumnInfo info, final boolean nullable) {
      TableColumnInfo result = getEasyMockTableColumnInfo(info.getCatalogName(),
                                                          info.getSchemaName(),
                                                          info.getTableName(),
                                                          info.getColumnName(),
                                                          info.getDataType(),
                                                          info.getColumnSize(),
View Full Code Here
503
504
505
506
507
508
509
510
511
512
513
    *           the new column data type
    * @return
    */
   public static TableColumnInfo setEasyMockTableColumnInfoType(
         final TableColumnInfo info, final int dataType) {
      TableColumnInfo result = getEasyMockTableColumnInfo(info.getCatalogName(),
                                                          info.getSchemaName(),
                                                          info.getTableName(),
                                                          info.getColumnName(),
                                                          dataType,
                                                          info.getColumnSize(),
View Full Code Here
580
581
582
583
584
585
586
587
588
589
590
      if (nullable) {
         isNullableInt = 1;
         isNullableStr = "yes";
      }
      TableColumnInfo info = new TableColumnInfo("TestCatalog",
                                                 "TestSchema",
                                                 "TestTable",
                                                 columnName,
                                                 type,
                                                 JDBCTypeMapper.getJdbcTypeName(type), // typeName
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.