Examples of net.sf.hajdbc.SequenceSupport.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

    assertEquals("sequence", support.parseSequence("SELECT sequence.currval, * FROM table"));
    assertEquals("sequence", support.parseSequence("SELECT sequence.nextval"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (sequence.nextval, 0)"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (sequence.currval, 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = sequence.nextval"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = sequence.nextval"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
  }
  
  /**
   * {@inheritDoc}

View Full Code Here

    assertEquals("sequence", support.parseSequence("SELECT sequence.nextval"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (sequence.nextval, 0)"));
    assertEquals("sequence", support.parseSequence("INSERT INTO table VALUES (sequence.currval, 0)"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = sequence.nextval"));
    assertEquals("sequence", support.parseSequence("UPDATE table SET id = sequence.nextval"));
    assertNull(support.parseSequence("SELECT NEXT VALUE FOR sequence"));
  }
  
  /**
   * {@inheritDoc}
   * @see net.sf.hajdbc.dialect.StandardDialectTest#getNextSequenceValueSQL()

View Full Code Here

  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("test", support.parseSequence("VALUES NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXTVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (PREVVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = PREVVAL FOR test"));
    assertNull(support.parseSequence("SELECT * FROM test"));
  }


  /**

View Full Code Here

    SequenceSupport support = this.dialect.getSequenceSupport();
    assertEquals("test", support.parseSequence("VALUES NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXTVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (PREVVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = PREVVAL FOR test"));
    assertNull(support.parseSequence("SELECT * FROM test"));
  }


  /**
   * {@inheritDoc}

View Full Code Here

    assertEquals("test", support.parseSequence("VALUES NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXTVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("INSERT INTO table VALUES (PREVVAL FOR test, 0)"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = NEXTVAL FOR test"));
    assertEquals("test", support.parseSequence("UPDATE table SET id = PREVVAL FOR test"));
    assertNull(support.parseSequence("SELECT * FROM test"));
  }


  /**
   * {@inheritDoc}
   * @see net.sf.hajdbc.dialect.StandardDialectTest#evaluateCurrentDate()

View Full Code Here

  {
    SequenceSupport support = this.dialect.getSequenceSupport();
    
    if (support != null)
    {
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test"));
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
      assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
      assertEquals("test", support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
      assertNull(support.parseSequence("SELECT * FROM table"));
    }

View Full Code Here

    SequenceSupport support = this.dialect.getSequenceSupport();
    
    if (support != null)
    {
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test"));
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
      assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
      assertEquals("test", support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
      assertNull(support.parseSequence("SELECT * FROM table"));
    }
  }

View Full Code Here

    
    if (support != null)
    {
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test"));
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
      assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
      assertEquals("test", support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
      assertNull(support.parseSequence("SELECT * FROM table"));
    }
  }

View Full Code Here

    if (support != null)
    {
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test"));
      assertEquals("test", support.parseSequence("SELECT NEXT VALUE FOR test, * FROM table"));
      assertEquals("test", support.parseSequence("INSERT INTO table VALUES (NEXT VALUE FOR test)"));
      assertEquals("test", support.parseSequence("UPDATE table SET id = NEXT VALUE FOR test"));
      assertNull(support.parseSequence("SELECT * FROM table"));
    }
  }


  @Test

View Full Code Here

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


  @Test
  public void getDefaultSchemas() throws SQLException

View Full Code Here

0 1 2 3 4 5 6 7 8

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.