[Appsunit-develop] [cvscommit] project/src/net/sourceforge/appsunit/environment DbSession.java, NONE, 1.1 AppsSession.java, NONE, 1.1

[Jan C. <jan...@us...>]

Update of /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment
In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv32319/src/net/sourceforge/appsunit/environment

Added Files:
	DbSession.java AppsSession.java 
Log Message:
Initial helper classes will provide the environment that allows to execute tests.

--- NEW FILE: AppsSession.java ---
/*
 * AppsSession.java
 *
 * $Id: AppsSession.java,v 1.1 2006/09/11 20:32:52 jancumps Exp $
 * $Revision: 1.1 $
 * $Date: 2006/09/11 20:32:52 $
 *
 * Created on 11 september 2006, 22:00
 *
 */

package net.sourceforge.appsunit.environment;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * Utility class creates an Apps session environment.
 */
public class AppsSession {
    
    /** Creates a new instance of AppsSession */
    public AppsSession() {
    }
    
    /**
     * Log on to the erp system with a given user and responsibility.
     * @param application The short name of the module we're logging on to.
     * @param connection Database connection.
     * @param user Apps user name to log on.
     * @param responsibility Apps responsibility to log on.
     * @throws java.lang.Exception Exceptions are not caught. They will be passed to the caller.
     * @TODO replace literal value insertion by parameter binding.
     */
    public static void logon(Connection connection, String user, String responsibility, String application) throws Exception {
        ResultSet rs = null;
        PreparedStatement stmt = null;
        
        String usr = null;
        stmt = connection.prepareStatement( 
                "select user_id " +
                "from fnd_user " +
                "where user_name = '" +
                user + "'");
        rs = stmt.executeQuery(); // execute
        if (rs.next()) {
            usr = rs.getString(1); // retrieve map_id
        }
        rs.close();
        TestCase.assertNotNull("user " + user + " not found", usr);
        
        // TODO: lookup responsibility
        String rsp = null;
        stmt = connection.prepareStatement( 
                "select responsibility_id " +
                "from fnd_responsibility " +
                "where responsibility_key = '" +
                responsibility + "'");
        rs = stmt.executeQuery(); // execute
        if (rs.next()) {
            rsp = rs.getString(1); // retrieve responsibility_id
        }
        rs.close();
        if (rsp == null ) {
            throw new Exception("Responsibility " + responsibility + " not found.");
        }
    
        String appl = null;
        stmt = parent.getConn().prepareStatement(
                "select application_id from fnd_application where application_short_name = '" +
                application + "'");
        rs = stmt.executeQuery(); // execute
        if (rs.next()) {
            appl = rs.getString(1); // retrieve application_id
        }
        rs.close();
        if (appl == null) {
            throw new Exception("Application " + application + " not found.");
        }
        
        // call the fnd_global api to log on to the apps
        CallableStatement cstmt = null;
        cstmt = connection.prepareCall(
            "{ call apps.fnd_global.apps_initialize(" +
                "user_id => " + usr +
                ", resp_id => " + rsp +
                ", resp_appl_id => " + appl +
                ", security_group_id => null)}");
        try {
            // the first call somethimes fails. That's why it's retried in the catch block;
            rs = cstmt.executeQuery(); // execute
            rs.close();
        } catch (Exception e) {
            rs = cstmt.executeQuery(); // execute
            rs.close();
        }
        
}

--- NEW FILE: DbSession.java ---
/*
 * DbSession.java
 *
 * $Id: DbSession.java,v 1.1 2006/09/11 20:32:52 jancumps Exp $
 * $Revision: 1.1 $
 * $Date: 2006/09/11 20:32:52 $
 *
 * Created on 11 september 2006, 21:59
 */

package net.sourceforge.appsunit.environment;

/**
 *
 * @author JCUMPS
 */
public class DbSession {
    
    /**
     * Creates a new instance of DbSession
     */
    public DbSession() {
    }
    
}