SimpleTransactionTest.java

/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIESOR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
package org.apache.aries.tx.control.itests;

import static org.junit.Assert.assertEquals;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Arrays;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.ops4j.pax.exam.junit.PaxExam;
import org.ops4j.pax.exam.spi.reactors.ExamReactorStrategy;
import org.ops4j.pax.exam.spi.reactors.PerClass;

@RunWith(PaxExam.class)
@ExamReactorStrategy(PerClass.class)
public class SimpleTransactionTest extends AbstractTransactionTest {

	@Test
	public void testTx() {
		txControl.required(() -> connection.createStatement()
				.execute("Insert into TEST_TABLE values ( 'Hello World!' )"));

		assertEquals("Hello World!", txControl.notSupported(() -> {
			ResultSet rs = connection.createStatement()
					.executeQuery("Select * from TEST_TABLE");
			rs.next();
			return rs.getString(1);
		}));
	}

	@Test
	public void testRollback() {
		txControl.required(() -> {
			connection.createStatement().execute(
					"Insert into TEST_TABLE values ( 'Hello World!' )");
			txControl.setRollbackOnly();
			return null;
		});

		assertEquals(Integer.valueOf(0), txControl.notSupported(() -> {
			ResultSet rs = connection.createStatement()
					.executeQuery("Select count(*) from TEST_TABLE");
			rs.next();
			return rs.getInt(1);
		}));
	}

	@Test
	public void testNestedTx() {
		txControl.required(() -> {
			connection.createStatement()
				.execute("Insert into TEST_TABLE values ( 'Hello World!' )");
			
			txControl.requiresNew(() -> connection.createStatement()
					.execute("Insert into TEST_TABLE values ( 'Hello Nested World!' )"));
			
			return null;
		});
		
		String[] results = txControl.notSupported(() -> {
				Statement s = connection.createStatement();
				
				ResultSet rs = s.executeQuery("Select count(*) from TEST_TABLE");
				rs.next();
				int count = rs.getInt(1);
				
				rs = s.executeQuery("Select message from TEST_TABLE ORDER BY message");
				
				String[] result = new String[2];
				rs.next();
				result[0] = "" + count + ": " + rs.getString(1);
				rs.next();
				result[1] = "" + count + ": " + rs.getString(1);
				return result;
			});
		
		System.out.println(Arrays.toString(results));
		
		assertEquals("2: Hello Nested World!", results[0]);
		assertEquals("2: Hello World!", results[1]);
	}
	
	@Test
	public void testNestedTxOuterRollback() {
		txControl.required(() -> {
				// This will not end up in the database
				connection.createStatement()
					.execute("Insert into TEST_TABLE values ( 'Hello World!' )");
				
				// This should only apply to the current transaction level
				txControl.setRollbackOnly();
			
				// This nested transaction will commit
				txControl.requiresNew(() -> connection.createStatement()
						.execute("Insert into TEST_TABLE values ( 'Hello Nested World!' )"));
			
				return null;
			});
		
		assertEquals("1: Hello Nested World!", txControl.notSupported(() -> {
				Statement s = connection.createStatement();
				
				ResultSet rs = s.executeQuery("Select count(*) from TEST_TABLE");
				rs.next();
				int count = rs.getInt(1);
				
				rs = s.executeQuery("Select message from TEST_TABLE ORDER BY message");
				
				rs.next();
				return "" + count + ": " + rs.getString(1);
			}));
	}

	@Test
	public void testNestedTxInnerRollback() {
		txControl.required(() -> {
			// This will end up in the database
			connection.createStatement()
				.execute("Insert into TEST_TABLE values ( 'Hello World!' )");
			
						
			// This nested transaction not commit
			txControl.requiresNew(() -> {
					connection.createStatement()
						.execute("Insert into TEST_TABLE values ( 'Hello Nested World!' )");
					txControl.setRollbackOnly();
					return null;
				});
			
			return null;
		});
		
		assertEquals("1: Hello World!", txControl.notSupported(() -> {
				Statement s = connection.createStatement();
				
				ResultSet rs = s.executeQuery("Select count(*) from TEST_TABLE");
				rs.next();
				int count = rs.getInt(1);
				
				rs = s.executeQuery("Select message from TEST_TABLE ORDER BY message");
				
				rs.next();
				return "" + count + ": " + rs.getString(1);
			}));
	}
	
	@Test
	public void testRequiredInheritsTx() {
		txControl.required(() -> {
			Object key = txControl.getCurrentContext().getTransactionKey();
			
			connection.createStatement()
				.execute("Insert into TEST_TABLE values ( 'Hello World!' )");
			
			return txControl.required(() -> {
					assertEquals(key , txControl.getCurrentContext().getTransactionKey());
					return connection.createStatement()
							.execute("Insert into TEST_TABLE values ( 'Hello Nested World!' )");
				});
		});
		
		String[] results = txControl.notSupported(() -> {
				Statement s = connection.createStatement();
				
				ResultSet rs = s.executeQuery("Select count(*) from TEST_TABLE");
				rs.next();
				int count = rs.getInt(1);
				
				rs = s.executeQuery("Select message from TEST_TABLE ORDER BY message");
				
				String[] result = new String[2];
				rs.next();
				result[0] = "" + count + ": " + rs.getString(1);
				rs.next();
				result[1] = "" + count + ": " + rs.getString(1);
				return result;
			});
		
		System.out.println(Arrays.toString(results));
		
		assertEquals("2: Hello Nested World!", results[0]);
		assertEquals("2: Hello World!", results[1]);
	}

	@Test
	public void testSuspendedTx() {
		txControl.required(() -> {        
			
			connection.createStatement()
				.execute("Insert into TEST_TABLE values ( 'Hello World!' )");
			
			assertEquals(Integer.valueOf(0), txControl.notSupported(() -> {
				ResultSet rs = connection.createStatement()
						.executeQuery("Select count(*) from TEST_TABLE");
				rs.next();
				return rs.getInt(1);
			}));                
			
			return null;            
			
		});   
	}
}