Package net.sourceforge.squirrel_sql.fw.sql

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

37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
    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();

        ColumnDifference diff2 = new ColumnDifference();
        TableColumnInfo column3 = FwTestUtil.getVarcharColumnInfo(md, true, 200);
        TableColumnInfo column4 = FwTestUtil.getVarcharColumnInfo(md, true, 100);
        diff2.setColumns(column3, column4);
        diff2.execute();
       
        ColumnDifference diff3 = new ColumnDifference();
        TableColumnInfo column5 =
            FwTestUtil.getTableColumnInfo(md, "LongColumnNameThatIsUnreal", VARCHAR, 100, 0, false);
        diff3.setColumn1(column5);
        diff3.setCol2Exists(false);
       
        final ArrayList<ColumnDifference> diffs = new ArrayList<ColumnDifference>();
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
           
    public void setColumnList(TableColumnInfo[] columnInfos) {
        colInfos = columnInfos;
        ArrayList<String> tmp = new ArrayList<String>();
        for (int i = 0; i < colInfos.length; i++) {
            TableColumnInfo info = colInfos[i];
            tmp.add(info.getColumnName());
        }
        String[] cols = tmp.toArray(new String[tmp.size()]);
        if (columnList != null) {
            columnList.setListData(cols);
        } else {
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
197
        return result.toArray(new TableColumnInfo[result.size()]);
    }
   
    private TableColumnInfo getColInfoByName(String columnName) {
        for (int i = 0; i < colInfos.length; i++) {
            TableColumnInfo colInfo = colInfos[i];
            if (colInfo.getColumnName().equals(columnName)) {
                return colInfo;
            }
        }
        return null;
    }
View Full Code Here
373
374
375
376
377
378
379
380
381
382
383
                           "ColumnP","ColumnQ","ColumnR","ColumnS","ColumnT"};
       
        TableColumnInfo[] infos = new TableColumnInfo[data.length];
       
        for (int i = 0; i < infos.length; i++) {
            infos[i] = new TableColumnInfo("aCat",
                                          "aSchem",
                                          "aTab",
                                          data[i],
                                          java.sql.Types.CHAR,
                                          "character",
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
      }

         
      TableColumnInfo[] infos = md.getColumnInfo(_catalog, _schema, _tableName);
      for (int i = 0; i < infos.length; i++) {
         TableColumnInfo info = infos[i];
         String columnName = info.getColumnName();
         String columnType = info.getTypeName();
         int columnSize = info.getColumnSize();
         int decimalDigits = info.getDecimalDigits();
         boolean nullable = "YES".equalsIgnoreCase(info.isNullable());

         ColumnInfo colInfo = new ColumnInfo(columnName,
                                             columnType,
                                             columnSize,
                                             decimalDigits,
                                             nullable);
         colInfosBuf.add(colInfo);
        
      }
     
      _colInfos = colInfosBuf.toArray(new ColumnInfo[colInfosBuf.size()]);

      if(0 == _colInfos.length)
      {
         // Table was deleted from DB
         return false;
      }

      try {
          PrimaryKeyInfo[] pkinfos =
              md.getPrimaryKey(_catalog, _schema, _tableName);
          for (int i = 0; i < pkinfos.length; i++) {
             PrimaryKeyInfo info = pkinfos[i];
             for (int c = 0; c < _colInfos.length; c++)
             {
                if(_colInfos[c].getName().equals(info.getColumnName()))
                {
                   _colInfos[c].markPrimaryKey();
                }
             }
          }         
View Full Code Here
490
491
492
493
494
495
496
497
498
499
500
501
  {
    StringBuilder result = new StringBuilder();

    for (int i = 0; i < colInfoArr.length; i++)
    {
      TableColumnInfo colInfo = colInfoArr[i];
      String columnName = colInfo.getColumnName();
      result.append(columnName);
      if (i < colInfoArr.length - 1)
      {
        result.append(", ");
      }
View Full Code Here
512
513
514
515
516
517
518
519
   */
  public static String getColumnName(ISQLConnection sourceConn, ITableInfo ti, int column)
    throws SQLException
  {
    TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
    TableColumnInfo colInfo = infoArr[column];
    return colInfo.getColumnName();
  }
View Full Code Here
528
529
530
531
532
533
534
535
536
537
  {
    TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
    String[] result = new String[infoArr.length];
    for (int i = 0; i < result.length; i++)
    {
      TableColumnInfo colInfo = infoArr[i];
      result[i] = colInfo.getColumnName();
    }
    return result;
  }
View Full Code Here
728
729
730
731
732
733
734
735
   * @throws SQLException
   */
  public static int getColumnType(ISQLConnection con, ITableInfo ti, int column) throws SQLException
  {
    TableColumnInfo[] infoArr = con.getSQLMetaData().getColumnInfo(ti);
    TableColumnInfo colInfo = infoArr[column];
    return colInfo.getDataType();
  }
View Full Code Here
738
739
740
741
742
743
744
745
746
747
  {
    TableColumnInfo[] infoArr = con.getSQLMetaData().getColumnInfo(ti);
    int[] result = new int[infoArr.length];
    for (int i = 0; i < result.length; i++)
    {
      TableColumnInfo colInfo = infoArr[i];
      result[i] = colInfo.getDataType();
    }
    return result;
  }
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.