src/test/java/com/xtremelabs/robolectric/util/H2MapTest.java

package com.xtremelabs.robolectric.util;

import static com.xtremelabs.robolectric.util.SQLite.buildInsertString;
import static org.hamcrest.CoreMatchers.equalTo;
import static org.junit.Assert.assertThat;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;

import android.content.ContentValues;

import com.xtremelabs.robolectric.WithTestDefaultsRunner;
import com.xtremelabs.robolectric.util.SQLite.SQLStringAndBindings;

@RunWith(WithTestDefaultsRunner.class)
public class H2MapTest {

	H2Map map;
	@Before
    public void setUp() throws Exception {
      map = new H2Map();  
    }

    @Test
    public void testDriverClassName() {
        assertThat(map.getDriverClassName(), equalTo("org.h2.Driver"));
    }
    
    @Test
    public void testConnectionString() {
        assertThat(map.getConnectionString(), equalTo("jdbc:h2:mem:"));
    }
    
    @Test
    public void testScrubSQLReplacesAutoIncrement() throws SQLException {  	
    	assertThat(map.getScrubSQL("autoincrement"),equalTo("auto_increment"));
    }
    
    @Test
    public void testScrubSQLReplacesIntegerWithBigInt() throws SQLException {   	
    	assertThat(map.getScrubSQL("integer"),equalTo("bigint(19)"));
    }
    
    
    @Test
    public void testScrubSQLAcceptsIntegerPrimaryKey() throws SQLException {
    	map.getScrubSQL("INTEGER PRIMARY KEY AUTOINCREMENT");
    }
    
    @Test(expected=SQLException.class)
    public void testScrubSQLRejectsIntPrimaryKeyThrowsException() throws SQLException {
    	map.getScrubSQL("INT PRIMARY KEY AUTOINCREMENT");
    }
    
    @Test(expected=SQLException.class)
    public void testScrubSQLRejectsCharPrimaryKeyThrowsException2() throws SQLException {
    	map.getScrubSQL("CHAR PRIMARY KEY AUTOINCREMENT");
    }
    
    @Test
    public void testGetSelectLastInsertIdentity() throws SQLException {   	
    	assertThat(map.getSelectLastInsertIdentity(),equalTo("SELECT IDENTITY();"));
    }
    
    @Test
    public void testGetH2ResultSetIs_TYPE_SCROLL_INSENSITIVE() throws SQLException {   	
    	assertThat(map.getResultSetType(),equalTo(ResultSet.TYPE_SCROLL_INSENSITIVE));
    }
}