List of parseSequence() Examples

Examples of parseSequence()

net.sf.hajdbc.SequenceSupport.parseSequence()
Parses a sequence name from the specified SQL statement. @param sql a SQL statement @return the name of a sequence, or null if this SQL statement does not reference a sequence or this dialect does not support sequences @throws SQLException @since 2.0

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1) FROM RDB$DATABASE"));
    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1), * FROM table"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (GEN_ID(sequence, 1), 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1) FROM RDB$DATABASE"));
    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1), * FROM table"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (GEN_ID(sequence, 1), 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1) FROM RDB$DATABASE"));
    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1), * FROM table"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (GEN_ID(sequence, 1), 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

    assertEquals("sequence", support.parseSequence("SELECT GEN_ID(sequence, 1), * FROM table"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (GEN_ID(sequence, 1), 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (GEN_ID(sequence, 1), 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

    assertEquals("sequence", support.parseSequence("UPDATE table SET id = GEN_ID(sequence, 1)"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
    assertNull(support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
    assertNull(support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

   */
  @Override
  public void parseSequence() throws SQLException
  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL ( 'sequence' ), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL ( 'sequence' ), * FROM table"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
    assertNull(support.parseSequence("SELECT * FROM table"));

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

  @Override
  public void parseSequence() throws SQLException
  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL ( 'sequence' ), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL ( 'sequence' ), * FROM table"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

  public void parseSequence() throws SQLException
  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL ( 'sequence' ), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL ( 'sequence' ), * FROM table"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

Examples of net.sf.hajdbc.SequenceSupport.parseSequence()

  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT NEXTVAL ( 'sequence' ), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL('sequence'), * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT CURRVAL ( 'sequence' ), * FROM table"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
    assertNull(support.parseSequence("SELECT * FROM table"));
  }
}

View Full Code Here

0 1 2 3 4 5

TOP

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.