Package net.sf.hajdbc

Examples of net.sf.hajdbc.UniqueConstraint

773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
  {
    ResultSet resultSet = metaData.getPrimaryKeys(getCatalog(metaData), table.getSchema(), table.getName());
   
    try
    {
      UniqueConstraint constraint = null;

      while (resultSet.next())
      {
        if (constraint == null)
        {
          constraint = factory.createUniqueConstraint(resultSet.getString("PK_NAME"), table);
        }
       
        constraint.getColumnList().add(resultSet.getString("COLUMN_NAME"));
      }
     
      return constraint;
    }
    finally
View Full Code Here
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
      {
        if (resultSet.getShort("TYPE") == DatabaseMetaData.tableIndexHashed)
        {
          String name = resultSet.getString("INDEX_NAME");
         
          UniqueConstraint key = keyMap.get(name);
         
          if (key == null)
          {
            key = factory.createUniqueConstraint(name, table);
           
            // Don't include the primary key
            if (key.equals(primaryKey)) continue;
           
            keyMap.put(name, key);
          }
         
          key.getColumnList().add(resultSet.getString("COLUMN_NAME"));
        }
      }
      return keyMap.values();
    }
    finally
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
  @Override
  public <Z, D extends Database<Z>> void synchronize(SynchronizationContext<Z, D> context, TableProperties table) throws SQLException
  {
    String tableName = table.getName().getDMLName();
   
    UniqueConstraint primaryKey = table.getPrimaryKey();
   
    if (primaryKey == null)
    {
      throw new SQLException(Messages.PRIMARY_KEY_REQUIRED.getMessage(this.getClass().getName(), tableName));
    }
   
    List<String> primaryKeyColumns = primaryKey.getColumnList();
   
    Collection<String> columns = table.getColumns();
   
    List<String> nonPrimaryKeyColumns = new ArrayList<String>(columns.size());
    List<String> versionColumns = new ArrayList<String>(columns.size());
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
   */
  @Override
  public void getCreateUniqueConstraintSQL() throws SQLException
  {
    QualifiedName table = mock(QualifiedName.class);
    UniqueConstraint constraint = mock(UniqueConstraint.class);
   
    when(table.getDDLName()).thenReturn("table");
    when(constraint.getName()).thenReturn("name");
    when(constraint.getTable()).thenReturn(table);
    when(constraint.getColumnList()).thenReturn(Arrays.asList("column1", "column2"));
   
    String result = this.dialect.getCreateUniqueConstraintSQL(constraint);
   
    assertEquals("ALTER TABLE table ADD UNIQUE name (column1, column2)", result);
  }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
   */
  @Override
  public void getDropUniqueConstraintSQL() throws SQLException
  {
    QualifiedName table = mock(QualifiedName.class);
    UniqueConstraint constraint = mock(UniqueConstraint.class);
   
    when(table.getDDLName()).thenReturn("table");
    when(constraint.getName()).thenReturn("name");
    when(constraint.getTable()).thenReturn(table);
    when(constraint.getColumnList()).thenReturn(Arrays.asList("column1", "column2"));
   
    String result = this.dialect.getDropUniqueConstraintSQL(constraint);
   
    assertEquals("ALTER TABLE table DROP INDEX name", result);
  }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
  @Test
  public void getCreateUniqueConstraintSQL() throws SQLException
  {
    QualifiedName table = mock(QualifiedName.class);
    UniqueConstraint constraint = mock(UniqueConstraint.class);
   
    when(table.getDDLName()).thenReturn("table");
    when(constraint.getName()).thenReturn("name");
    when(constraint.getTable()).thenReturn(table);
    when(constraint.getColumnList()).thenReturn(Arrays.asList("column1", "column2"));
   
    String result = this.dialect.getCreateUniqueConstraintSQL(constraint);
   
    assertEquals("ALTER TABLE table ADD CONSTRAINT name UNIQUE (column1, column2)", result);
  }
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
  @Test
  public void getDropUniqueConstraintSQL() throws SQLException
  {
    QualifiedName table = mock(QualifiedName.class);
    UniqueConstraint constraint = mock(UniqueConstraint.class);
   
    when(table.getDDLName()).thenReturn("table");
    when(constraint.getName()).thenReturn("name");
    when(constraint.getTable()).thenReturn(table);
    when(constraint.getColumnList()).thenReturn(Arrays.asList("column1", "column2"));
   
    String result = this.dialect.getDropUniqueConstraintSQL(constraint);
   
    assertEquals("ALTER TABLE table DROP CONSTRAINT name", result);
  }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
   * @see net.sf.hajdbc.TableProperties#getPrimaryKey()
   */
  @Override
  public UniqueConstraint getPrimaryKey() throws SQLException
  {
    UniqueConstraint primaryKey = this.primaryKeyRef.get();
   
    if (primaryKey == null)
    {
      primaryKey = this.dialect.getPrimaryKey(this.metaDataProvider.getDatabaseMetaData(), this.getName(), this.uniqueConstraintFactory);
     
View Full Code Here
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
  {
    ResultSet resultSet = metaData.getPrimaryKeys(getCatalog(metaData), table.getSchema(), table.getName());
   
    try
    {
      UniqueConstraint constraint = null;

      while (resultSet.next())
      {
        if (constraint == null)
        {
          constraint = factory.createUniqueConstraint(resultSet.getString("PK_NAME"), table);
        }
       
        constraint.getColumnList().add(resultSet.getString("COLUMN_NAME"));
      }
     
      return constraint;
    }
    finally
View Full Code Here
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
      {
        if (resultSet.getShort("TYPE") == DatabaseMetaData.tableIndexHashed)
        {
          String name = resultSet.getString("INDEX_NAME");
         
          UniqueConstraint key = keyMap.get(name);
         
          if (key == null)
          {
            key = factory.createUniqueConstraint(name, table);
           
            // Don't include the primary key
            if (key.equals(primaryKey)) continue;
           
            keyMap.put(name, key);
          }
         
          key.getColumnList().add(resultSet.getString("COLUMN_NAME"));
        }
      }
      return keyMap.values();
    }
    finally
View Full Code Here
TOP

Related Classes of net.sf.hajdbc.UniqueConstraint

  • net.sf.hajdbc.cache.lazy.LazyTableProperties
  • net.sf.hajdbc.dialect.MySQLDialectTest
  • net.sf.hajdbc.dialect.StandardDialect
  • net.sf.hajdbc.dialect.StandardDialectTest
  • net.sf.hajdbc.sync.DifferentialSynchronizationStrategy
    • 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.