/*
 * Copyright 2005 the original author or authors.
 * 
 * Licensed 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 WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */ 

package org.wamblee.usermgt.hibernate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import org.wamblee.general.BeanKernel;
import org.wamblee.test.TestTransactionCallback;
import org.wamblee.usermgt.GroupSet;
import org.wamblee.usermgt.InMemoryGroupSetTest;
import org.wamblee.usermgt.UsermgtHibernateMappingFiles;
import org.wamblee.usermgt.UsermgtSpringConfigFiles;

/**
 * Tests for {@link org.wamblee.usermgt.hibernate.HibernateGroupSet} 
 */
public class HibernateGroupSetTest extends InMemoryGroupSetTest {
    
    private static final String GROUP_TABLE = "GROUPS"; 
    
    private static final String GROUP_QUERY = "select * from " + GROUP_TABLE + " where name = ?";
    
    public HibernateGroupSetTest() { 
        super(UsermgtSpringConfigFiles.class, UsermgtHibernateMappingFiles.class);
    }

    /* (non-Javadoc)
     * @see org.wamblee.usermgt.InMemoryGroupSetTest#checkGroupCount(int)
     */
    @Override
    protected void checkGroupCount(int aSize) throws SQLException {
        super.flush(); 
        super.checkGroupCount(aSize);
        assertEquals(aSize, getTableSize(GROUP_TABLE));
    }
    
    /* (non-Javadoc)
     * @see org.wamblee.usermgt.InMemoryGroupSetTest#checkGroupExists(java.lang.String)
     */
    @Override
    protected void checkGroupExists(final String aGroup) throws SQLException {
        flush();
        Map<String,Integer> result = 
        executeTransaction(new TestTransactionCallback()  { 
            /* (non-Javadoc)
             * @see org.wamblee.test.TestTransactionCallback#execute()
             */
            @Override
            public Map execute() throws Exception {
                ResultSet result = executeQuery(GROUP_QUERY, aGroup);
                Map<String,Integer> res = new HashMap<String,Integer>(); 
                res.put("result", countResultSet(result));
                return res; 
            }
        }); 
      
        int count = result.get("result");
        assertEquals(1, count);
    }
    
    /* (non-Javadoc)
     * @see org.wamblee.usermgt.InMemoryGroupSetTest#checkGroupNotExists(java.lang.String)
     */
    @Override
    protected void checkGroupNotExists(String aGroup) throws SQLException {
       flush(); 
       ResultSet result = executeQuery(GROUP_QUERY, aGroup); 
       assertEquals(0, countResultSet(result));
    }
    
    /* (non-Javadoc)
     * @see org.wamblee.usermgt.InMemoryGroupSetTest#createGroupSet()
     */
    @Override
    protected GroupSet createGroupSet() {
        return BeanKernel.getBeanFactory().find(GroupSet.class); 
    }
    
}