Examples of SequenceProperties

Examples of net.sf.hajdbc.SequenceProperties

61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getAlterSequenceSQL()
   */
  @Override
  public void getAlterSequenceSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDDLName()).thenReturn("sequence");
    when(sequence.getIncrement()).thenReturn(1);
   
    String result = this.dialect.getSequenceSupport().getAlterSequenceSQL(sequence, 1000L);

    assertEquals("SET GENERATOR sequence TO 1000", result);
  }
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

81
82
83
84
85
86
87
88
89
90
91
92
   */
  @Override
  public void getSequences() throws SQLException
  {
    SequencePropertiesFactory factory = mock(SequencePropertiesFactory.class);
    SequenceProperties sequence1 = mock(SequenceProperties.class);
    SequenceProperties sequence2 = mock(SequenceProperties.class);
    DatabaseMetaData metaData = mock(DatabaseMetaData.class);
    Connection connection = mock(Connection.class);
    Statement statement = mock(Statement.class);
    ResultSet resultSet = mock(ResultSet.class);
   
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

115
116
117
118
119
120
121
122
123
124
125
126
127
128
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getNextSequenceValueSQL()
   */
  @Override
  public void getNextSequenceValueSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDMLName()).thenReturn("sequence");
   
    String result = this.dialect.getSequenceSupport().getNextSequenceValueSQL(sequence);
   
    assertEquals("SELECT GEN_ID(sequence, 1) FROM RDB$DATABASE", result);
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

56
57
58
59
60
61
62
63
64
65
66
67
68
69
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getNextSequenceValueSQL()
   */
  @Override
  public void getNextSequenceValueSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDMLName()).thenReturn("sequence");
   
    String result = this.dialect.getSequenceSupport().getNextSequenceValueSQL(sequence);
   
    assertEquals("VALUES NEXT VALUE FOR sequence", result);
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

94
95
96
97
98
99
100
101
102
103
104
105
   */
  @Override
  public void getSequences() throws SQLException
  {
    SequencePropertiesFactory factory = mock(SequencePropertiesFactory.class);
    SequenceProperties sequence1 = mock(SequenceProperties.class);
    SequenceProperties sequence2 = mock(SequenceProperties.class);
    DatabaseMetaData metaData = mock(DatabaseMetaData.class);
    Connection connection = mock(Connection.class);
    Statement statement = mock(Statement.class);
    ResultSet resultSet = mock(ResultSet.class);
   
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

130
131
132
133
134
135
136
137
138
139
140
141
142
143
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getNextSequenceValueSQL()
   */
  @Override
  public void getNextSequenceValueSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDMLName()).thenReturn("sequence");
   
    String result = this.dialect.getSequenceSupport().getNextSequenceValueSQL(sequence);
   
    assertEquals("CALL NEXT VALUE FOR sequence", result);
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

66
67
68
69
70
71
72
73
74
75
76
77
   */
  @Override
  public void getSequences() throws SQLException
  {
    SequencePropertiesFactory factory = mock(SequencePropertiesFactory.class);
    SequenceProperties sequence1 = mock(SequenceProperties.class);
    SequenceProperties sequence2 = mock(SequenceProperties.class);
    DatabaseMetaData metaData = mock(DatabaseMetaData.class);
    Connection connection = mock(Connection.class);
    Statement statement = mock(Statement.class);
    ResultSet resultSet = mock(ResultSet.class);
   
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

96
97
98
99
100
101
102
103
104
105
106
107
   */
  @Override
  public void getSequences() throws SQLException
  {
    SequencePropertiesFactory factory = mock(SequencePropertiesFactory.class);
    SequenceProperties sequence1 = mock(SequenceProperties.class);
    SequenceProperties sequence2 = mock(SequenceProperties.class);
    DatabaseMetaData metaData = mock(DatabaseMetaData.class);
    Connection connection = mock(Connection.class);
    Statement statement = mock(Statement.class);
    ResultSet resultSet = mock(ResultSet.class);
   
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

169
170
171
172
173
174
175
176
177
178
179
180
181
182
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getNextSequenceValueSQL()
   */
  @Override
  public void getNextSequenceValueSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDMLName()).thenReturn("sequence");
   
    String result = this.dialect.getSequenceSupport().getNextSequenceValueSQL(sequence);

    assertEquals("SELECT sequence.NEXTVAL FROM DUAL", result);
View Full Code Here

Examples of net.sf.hajdbc.SequenceProperties

68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getAlterSequenceSQL()
   */
  @Override
  public void getAlterSequenceSQL() throws SQLException
  {
    SequenceProperties sequence = mock(SequenceProperties.class);
    QualifiedName name = mock(QualifiedName.class);
   
    when(sequence.getName()).thenReturn(name);
    when(name.getDDLName()).thenReturn("sequence");
    when(sequence.getIncrement()).thenReturn(1);
   
    String result = this.dialect.getSequenceSupport().getAlterSequenceSQL(sequence, 1000L);
   
    assertEquals("ALTER SEQUENCE sequence INCREMENT BY (1000 - (SELECT sequence.NEXTVAL FROM DUAL)); SELECT sequence.NEXTVAL FROM DUAL; ALTER SEQUENCE sequence INCREMENT BY 1", result);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.