/*
* Copyright 2001-2008 Geert Bevin <gbevin[remove] at uwyn dot com>
* Licensed under the Apache License, Version 2.0 (the "License")
* $Id: TestSequenceValueMckoi.java 3918 2008-04-14 17:35:35Z gbevin $
*/
package com.uwyn.rife.database.queries;
import com.uwyn.rife.database.exceptions.SequenceNameRequiredException;
import com.uwyn.rife.database.exceptions.SequenceOperationRequiredException;
import com.uwyn.rife.database.exceptions.UnsupportedSqlFeatureException;
public class TestSequenceValueMckoi extends TestSequenceValue
{
public TestSequenceValueMckoi(String name)
{
super(name);
}
public void testInstantiationMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
assertNotNull(query);
try
{
query.getSql();
fail();
}
catch (SequenceNameRequiredException e)
{
assertEquals(e.getQueryName(), "SequenceValue");
}
}
public void testInvalidMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
try
{
query.getSql();
fail();
}
catch (SequenceNameRequiredException e)
{
assertEquals(e.getQueryName(), "SequenceValue");
}
query.name("sequencename");
try
{
query.getSql();
fail();
}
catch (SequenceOperationRequiredException e)
{
assertEquals(e.getQueryName(), "SequenceValue");
}
query.clear();
query.next();
try
{
query.getSql();
fail();
}
catch (SequenceNameRequiredException e)
{
assertEquals(e.getQueryName(), "SequenceValue");
}
query.clear();
}
public void testClearMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
query
.name("sequencename")
.next();
assertNotNull(query.getSql());
query
.clear();
try
{
query.getSql();
fail();
}
catch (SequenceNameRequiredException e)
{
assertEquals(e.getQueryName(), "SequenceValue");
}
}
public void testNextMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
query
.name("sequencename")
.next();
assertEquals(query.getSql(), "SELECT nextval('sequencename')");
assertTrue(execute(mMckoi, query) >= 0);
}
public void testCurrentMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
query
.name("sequencename")
.current();
try
{
query.getSql();
fail();
}
catch (UnsupportedSqlFeatureException e)
{
assertTrue(true);
}
}
public void testCloneMckoi()
{
SequenceValue query = new SequenceValue(mMckoi);
query
.name("sequencename")
.next();
SequenceValue query_clone = query.clone();
assertEquals(query.getSql(), query_clone.getSql());
assertTrue(query != query_clone);
assertTrue(execute(mMckoi, query_clone) >= 0);
}
}