Z-Archive » Maybank Projects » M2U UPASS Project

/*

 * Copyright (c) 2011 Penril Datability (M) Sdn Bhd All rights reserved.

 *

 * This software is copyrighted. Under the copyright laws, this software

 * may not be copied, in whole or in part, without prior written consent

 * of Penril Datability (M) Sdn Bhd or its assignees. This software is

 * provided under the terms of a license between Penril Datability (M)

 * Sdn Bhd and the recipient, and its use is subject to the terms of that

 * license.

 */

package net.penril.upass;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import junit.framework.TestCase;

import my.com.upass.db.DBOperations;

import org.apache.commons.io.IOUtils;

import org.apache.log4j.Logger;

//import my.com.upass.SelfTestV2;

/*

 * <pre>

 * PROGRAMMER: Hadi Ahmadi	

 * CHANGE-NO:

 * TASK-NO:

 * DATE CREATED: Mar 6, 2012

 * TAG AS:

 * REASON(S):

 * MODIFICATION:

 * </pre>

 */

/**

 * An integration test (IT) case for Agrobank UPass Web Services.

 */

public class UPassIT extends TestCase {

	private final static Logger logger = Logger.getLogger(UPassIT.class);

	// private static final PrintStream DEFAULT_OUTPUT = System.out;

	// private static final InputStream DEFAULT_INPUT = System.in;

	//

	// private final TestableOutputStream testableOutput;

	// private final PipedInputStream pipedInput;

	// private final PrintStream inputMockup;

	//

	// //

	//

	// public UPassIT() throws IOException {

	// testableOutput = new TestableOutputStream(DEFAULT_OUTPUT);

	// PipedOutputStream pipedOutput = new PipedOutputStream();

	// pipedInput = new PipedInputStream(pipedOutput);

	// inputMockup = new InputMockUp(pipedOutput);

	// }

	@Override

	protected void setUp() throws Exception {

		super.setUp();

		// System.setOut(testableOutput);

		// System.setIn(pipedInput);

	}

	@Override

	protected void tearDown() throws Exception {

		// System.setOut(DEFAULT_OUTPUT);

		// System.setIn(DEFAULT_INPUT);

		super.tearDown();

	}

	public void testInitDb() throws Exception {

		Connection conn = new DBOperations().getConnection();

		boolean oldAutoCommit = true;

		try {

			oldAutoCommit = conn.getAutoCommit();

			conn.setAutoCommit(false);

			Statement stmt = conn.createStatement();

			InputStream iStream = getClass().getClassLoader().getResourceAsStream(//

					//"db-scripts/agro-ci-db.upass.script.w-data.sql");

					"db-scripts/m2u-upass-ci-oracle.sql");

			String[] sqlStmts = IOUtils.toString(iStream).split(";\\s*\n");

			//String[] sqlStmts = IOUtils.toString(iStream).split("\\s*GO\\s*\n");

			for (String sqlStmt : sqlStmts) {

				if(sqlStmt.contains("DROP")){

					try {

						stmt.execute(sqlStmt);

					} catch (Exception e) {

						continue;

					}

				}else{

					stmt.execute(sqlStmt);

				}

			}

			ResultSet rs = stmt.executeQuery("select count(U_USER_ID) from TB_AM_USER");

			int userCount = -1;

			if (rs.next())

				userCount = rs.getInt(1);

			assertEquals(584, userCount);

			conn.commit();

		} catch (Exception e) {

			e.printStackTrace();

			if (conn != null)

				conn.rollback();

			fail(e.toString());

		} finally {

			if (conn != null) {

				conn.setAutoCommit(oldAutoCommit);

				conn.close();

			}

		}

	}

	// public void testSelfTestV2() throws IOException {

	// Thread testThread = new Thread("SelfTestV2 Dedicated Thread") {

	// @Override

	// public void run() {

	// SelfTestV2.main(null);

	// }

	// };

	// testThread.setDaemon(true);

	// testThread.start();

	//

	// String outStr = waitForPrompt("%");

	// String actualPrompt = outStr.substring(outStr.lastIndexOf('%'));

	// String expectedPrompt = "% Enter Option? | \"99\"-exit | \"e\"-ChkErr | \"s\"-SetSessID | \"m\"-Menu [01] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println("84");

	// outStr = waitForPrompt(":");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('\n') + 1);

	// expectedPrompt = "Enter User ID : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println("test-user-0");

	// outStr = waitForPrompt(":");

	// // assertTrue(outStr.contains("RC=6 RT=ERR_USERALIAS_NOT_FOUND"));

	// assertTrue(outStr.contains("RC=0 RT=ERR_SUCCESS SerailNo=1497524840"));

	//

	// outStr = waitForPrompt("%");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('%'));

	// expectedPrompt = "% Enter Option? | \"99\"-exit | \"e\"-ChkErr | \"s\"-SetSessID | \"m\"-Menu [84] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println("74");

	// outStr = waitForPrompt(":");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('\n') + 1);

	// expectedPrompt = "Enter User ID [test-user-0] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println();

	// outStr = waitForPrompt(":");

	// // assertTrue(outStr.contains("RC=6 RT=ERR_USERALIAS_NOT_FOUND"));

	// assertTrue(outStr.contains("RC=0 RT=ERR_SUCCESS"));

	//

	// outStr = waitForPrompt("%");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('%'));

	// expectedPrompt = "% Enter Option? | \"99\"-exit | \"e\"-ChkErr | \"s\"-SetSessID | \"m\"-Menu [74] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println("17");

	// outStr = waitForPrompt(":");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('\n') + 1);

	// expectedPrompt = "Enter User ID [test-user-0] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println();

	// outStr = waitForPrompt(":");

	// // assertTrue(outStr.contains("RC=6 RT=ERR_USERALIAS_NOT_FOUND"));

	// assertTrue(outStr.contains("test-user-0 RC=0 RT=ERR_SUCCESS Type=2 Desc=[Test User]" //

	// + "\n State=0 UseCount=0" //

	// + "\n DateCreated"));

	//

	// outStr = waitForPrompt("%");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('%'));

	// expectedPrompt = "% Enter Option? | \"99\"-exit | \"e\"-ChkErr | \"s\"-SetSessID | \"m\"-Menu [17] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println("64");

	// outStr = waitForPrompt(":");

	// actualPrompt = outStr.substring(outStr.lastIndexOf('\n') + 1);

	// expectedPrompt = "Enter User ID [test-user-0] : ";

	// assertEquals(expectedPrompt, actualPrompt);

	//

	// testableOutput.readableStream.reset();

	// inputMockup.println();

	// outStr = waitForPrompt(":");

	// // assertTrue(outStr.contains("RC=6 RT=ERR_USERALIAS_NOT_FOUND"));

	// assertTrue(outStr.contains("test-user-0 RC=0 RT=ERR_SUCCESS State=0 ExpiryStatus=0 "

	// + "UseCount=0 ErrorCount=0"));

	// }

	//

	// private String waitForPrompt(String promptIndicator) throws IOException {

	// String outStr;

	// do {

	// try {

	// Thread.sleep(1000);

	//

	// } catch (InterruptedException e) {

	// e.printStackTrace();

	// }

	// testableOutput.readableStream.flush();

	// outStr = testableOutput.readableStream.toString();

	//

	// } while (!outStr.contains(promptIndicator));

	//

	// return outStr;

	// }

	//

	// private final class TestableOutputStream extends PrintStream {

	//

	// private final ByteArrayOutputStream readableStream;

	//

	// private TestableOutputStream(OutputStream out) {

	// this(out, new ByteArrayOutputStream(1000));

	// }

	//

	// private TestableOutputStream(OutputStream out, ByteArrayOutputStream readableStream) {

	// super(out);

	// this.readableStream = readableStream;

	// }

	//

	// @Override

	// public void write(byte[] b, int off, int len) {

	// readableStream.write(b, off, len);

	// super.write(b, off, len);

	// }

	// }

	//

	// private final class InputMockUp extends PrintStream {

	//

	// private InputMockUp(OutputStream out) {

	// super(out);

	// }

	//

	// @Override

	// public void write(byte[] b, int off, int len) {

	// DEFAULT_OUTPUT.write(b, off, len);

	// super.write(b, off, len);

	// }

	// }

}