Package org.apache.ddlutils.model

Examples of org.apache.ddlutils.model.Column

1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
    {
        ListOrderedMap columns = new ListOrderedMap();

        for (int idx = 0; idx < sourceTable.getColumnCount(); idx++)
        {
            Column sourceColumn = sourceTable.getColumn(idx);
            Column targetColumn = targetTable.findColumn(sourceColumn.getName(),
                                                         getPlatform().isDelimitedIdentifierModeOn());


            if (targetColumn != null)
            {
View Full Code Here
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
        buffer.append(getDelimitedIdentifier(getTableName(table)));
        buffer.append(" (");

        for (int idx = 0; idx < table.getColumnCount(); idx++)
        {
            Column column = table.getColumn(idx);

            if (columnValues.containsKey(column.getName()))
            {
                if (addComma)
                {
                    buffer.append(", ");
                }
                buffer.append(getDelimitedIdentifier(column.getName()));
                addComma = true;
            }
        }
        buffer.append(") VALUES (");
        if (genPlaceholders)
        {
            addComma = false;
            for (int idx = 0; idx < columnValues.size(); idx++)
            {
                if (addComma)
                {
                    buffer.append(", ");
                }
                buffer.append("?");
                addComma = true;
            }
        }
        else
        {
            addComma = false;
            for (int idx = 0; idx < table.getColumnCount(); idx++)
            {
                Column column = table.getColumn(idx);

                if (columnValues.containsKey(column.getName()))
                {
                    if (addComma)
                    {
                        buffer.append(", ");
                    }
                    buffer.append(getValueAsString(column, columnValues.get(column.getName())));
                    addComma = true;
                }
            }
        }
        buffer.append(")");
View Full Code Here
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
        buffer.append(getDelimitedIdentifier(getTableName(table)));
        buffer.append(" SET ");

        for (int idx = 0; idx < table.getColumnCount(); idx++)
        {
            Column column = table.getColumn(idx);

            if (!column.isPrimaryKey() && columnValues.containsKey(column.getName()))
            {
                if (addSep)
                {
                    buffer.append(", ");
                }
                buffer.append(getDelimitedIdentifier(column.getName()));
                buffer.append(" = ");
                if (genPlaceholders)
                {
                    buffer.append("?");
                }
                else
                {
                    buffer.append(getValueAsString(column, columnValues.get(column.getName())));
                }
                addSep = true;
            }
        }
        buffer.append(" WHERE ");
        addSep = false;
        for (int idx = 0; idx < table.getColumnCount(); idx++)
        {
            Column column = table.getColumn(idx);

            if (column.isPrimaryKey() && columnValues.containsKey(column.getName()))
            {
                if (addSep)
                {
                    buffer.append(" AND ");
                }
                buffer.append(getDelimitedIdentifier(column.getName()));
                buffer.append(" = ");
                if (genPlaceholders)
                {
                    buffer.append("?");
                }
                else
                {
                    buffer.append(getValueAsString(column, columnValues.get(column.getName())));
                }
                addSep = true;
            }
        }
        return buffer.toString();
View Full Code Here
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
        {
            buffer.append(" WHERE ");
            for (Iterator it = pkValues.entrySet().iterator(); it.hasNext();)
            {
                Map.Entry entry  = (Map.Entry)it.next();
                Column    column = table.findColumn((String)entry.getKey());
   
                if (addSep)
                {
                    buffer.append(" AND ");
                }
View Full Code Here
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
                print(" (");
   
                for (int idx = 0; idx < index.getColumnCount(); idx++)
                {
                    IndexColumn idxColumn = index.getColumn(idx);
                    Column      col       = table.findColumn(idxColumn.getName());
   
                    if (col == null)
                    {
                        // would get null pointer on next line anyway, so throw exception
                        throw new ModelException("Invalid column '" + idxColumn.getName() + "' on index " + index.getName() + " for table " + table.getName());
View Full Code Here
2414
2415
2416
2417
2418
2419
2420
2421
2422
2423
2424
        print(" (");

        for (int idx = 0; idx < index.getColumnCount(); idx++)
        {
            IndexColumn idxColumn = index.getColumn(idx);
            Column      col       = table.findColumn(idxColumn.getName());

            if (col == null)
            {
                // would get null pointer on next line anyway, so throw exception
                throw new ModelException("Invalid column '" + idxColumn.getName() + "' on index " + index.getName() + " for table " + table.getName());
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
                String path  = "data/"+table.getName();
   
                addRule(path, new DynaSqlCreateRule(_model, table, _sink));
                for (int columnIdx = 0; columnIdx < table.getColumnCount(); columnIdx++)
                {
                    Column           column    = (Column)table.getColumn(columnIdx);
                    SqlTypeConverter converter = _converterConf.getRegisteredConverter(table, column);
   
                    addRule(path, new SetColumnPropertyRule(column, converter, isCaseSensitive()));
                    addRule(path + "/" + column.getName(), new SetColumnPropertyFromSubElementRule(column, converter));
                }
            }
            _needsConfiguration = false;
        }
        super.configure();
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
  /**
     * {@inheritDoc}
     */
    protected Column readColumn(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
    {
    Column column = super.readColumn(metaData, values);

    if (column.getDefaultValue() != null)
    {
      // SapDb pads the default value with spaces
      column.setDefaultValue(column.getDefaultValue().trim());
      // SapDb uses the default value for the auto-increment specification
      if (column.getDefaultValue().startsWith("DEFAULT SERIAL"))
      {
        column.setAutoIncrement(true);
        column.setDefaultValue(null);
      }
    }
    if (column.getTypeCode() == Types.DECIMAL)
    {
      // We also perform back-mapping to BIGINT
      if ((column.getSizeAsInt() == 38) && (column.getScale() == 0))
      {
        column.setTypeCode(Types.BIGINT);
      }
    }
    return column;
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
    /**
     * {@inheritDoc}
     */
    protected Column readColumn(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
    {
        Column column = super.readColumn(metaData, values);

        if (column.getDefaultValue() != null)
        {
            // SapDb pads the default value with spaces
            column.setDefaultValue(column.getDefaultValue().trim());
            // SapDb uses the default value for the auto-increment specification
            if (column.getDefaultValue().startsWith("DEFAULT SERIAL"))
            {
                column.setAutoIncrement(true);
                column.setDefaultValue(null);
            }
        }
        if (column.getTypeCode() == Types.DECIMAL)
        {
            // For some reason, the size will be reported with 2 byte more, e.g. 17 instead of 15
            // So we have to adjust the size here
            if (column.getSizeAsInt() > 2)
            {
                column.setSizeAndScale(column.getSizeAsInt() - 2, column.getScale());
            }
            // We also perform back-mapping to BIGINT
            if ((column.getSizeAsInt() == 38) && (column.getScale() == 0))
            {
                column.setTypeCode(Types.BIGINT);
            }
        }
        return column;
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
  /**
   * {@inheritDoc}
   */
    protected Column readColumn(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
    {
    Column column = super.readColumn(metaData, values);

    if (column.getDefaultValue() != null)
    {
      if (column.getTypeCode() == Types.TIME)
      {
        PatternMatcher matcher = new Perl5Matcher();

        // Db2 returns "HH24.MI.SS"
        if (matcher.matches(column.getDefaultValue(), _db2TimePattern))
        {
          StringBuffer newDefault = new StringBuffer();

          newDefault.append("'");
          // the hour
          newDefault.append(matcher.getMatch().group(1));
          newDefault.append(":");
          // the minute
          newDefault.append(matcher.getMatch().group(2));
          newDefault.append(":");
          // the second
          newDefault.append(matcher.getMatch().group(3));
          newDefault.append("'");

          column.setDefaultValue(newDefault.toString());
        }
      }
      else if (column.getTypeCode() == Types.TIMESTAMP)
      {
        PatternMatcher matcher = new Perl5Matcher();

        // Db2 returns "YYYY-MM-DD-HH24.MI.SS.FF"
        if (matcher.matches(column.getDefaultValue(), _db2TimestampPattern))
        {
          StringBuffer newDefault = new StringBuffer();

          newDefault.append("'");
          // group 1 is the date which has the correct format
          newDefault.append(matcher.getMatch().group(1));
          newDefault.append(" ");
          // the hour
          newDefault.append(matcher.getMatch().group(2));
          newDefault.append(":");
          // the minute
          newDefault.append(matcher.getMatch().group(3));
          newDefault.append(":");
          // the second
          newDefault.append(matcher.getMatch().group(4));
          // optionally, the fraction
          if ((matcher.getMatch().groups() > 4) && (matcher.getMatch().group(4) != null))
          {
            newDefault.append(matcher.getMatch().group(5));
          }
          newDefault.append("'");

          column.setDefaultValue(newDefault.toString());
        }
      }
            else if (TypeMap.isTextType(column.getTypeCode()))
            {
                column.setDefaultValue(unescape(column.getDefaultValue(), "'", "''"));
            }
    }
    return column;
  }
View Full Code Here
TOP

Related Classes of org.apache.ddlutils.model.Column

  • atg.tools.dynunit.adapter.gsa.GSARepositorySchemaGenerator
  • com.alibaba.otter.node.etl.extract.extractor.FreedomExtractor
  • com.alibaba.otter.node.etl.transform.transformer.RowDataTransformer
  • com.alibaba.otter.shared.common.utils.meta.DdlUtils
  • net.sf.minuteProject.configuration.bean.enrichment.Entity
  • net.sf.minuteProject.configuration.bean.model.data.impl.DDLUtils.ForeignKeyDDLUtils
  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.ddlutils.alteration.AddColumnChange
  • org.apache.ddlutils.alteration.AddPrimaryKeyChange
    • 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.