src/main/java/org/vanilladb/bench/server/procedure/tpce/TradeOrderProc.java
private void frame1() {
		// SELECT acct_name = ca_name, broker_id = ca_b_id, 
		// cust_id = ca_c_id, tax_status = ca_tax_st FROM
		// customer_account WHERE ca_id = acct_id
		String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account"
				+ " WHERE ca_id = " + paramHelper.getAcctId();
		Scan s = executeQuery(sql);
		acctName = (String) s.getVal("ca_name").asJavaVal();
		brokerId = (Long) s.getVal("ca_b_id").asJavaVal();
		custId = (Long) s.getVal("ca_c_id").asJavaVal();
		taxStatus = (Integer) s.getVal("ca_tax_st").asJavaVal();
		
		// TODO: Add this
		// num_found = row_count
		
		// SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, 
		// cust_tier = c_tier, tax_id = c_tax_id FROM
		// customer WHERE c_id = cust_id
		sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer"
				+ " WHERE c_id = " + custId;
		s = executeQuery(sql);
		custFName = (String) s.getVal("c_f_name").asJavaVal();
		custLName = (String) s.getVal("c_l_name").asJavaVal();
		custTier = (Integer) s.getVal("c_tier").asJavaVal();
		taxId = (String) s.getVal("c_tax_id").asJavaVal();
		
		// SELECT broker_name = b_name FROM broker WHERE b_id = broker_id
		sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId;
		s = executeQuery(sql);
		brokerName = (String) s.getVal("b_name").asJavaVal();
	}
private void frame1() {
		// SELECT acct_name = ca_name, broker_id = ca_b_id, 
		// cust_id = ca_c_id, tax_status = ca_tax_st FROM
		// customer_account WHERE ca_id = acct_id
		String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account"
				+ " WHERE ca_id = " + paramHelper.getAcctId();
		Scan s = executeQuery(sql);
		acctName = (String) s.getVal("ca_name").asJavaVal();
		brokerId = (Long) s.getVal("ca_b_id").asJavaVal();
		custId = (Long) s.getVal("ca_c_id").asJavaVal();
		taxStatus = (Integer) s.getVal("ca_tax_st").asJavaVal();
		
		// TODO: Add this
		// num_found = row_count
		
		// SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, 
		// cust_tier = c_tier, tax_id = c_tax_id FROM
		// customer WHERE c_id = cust_id
		sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer"
				+ " WHERE c_id = " + custId;
		s = executeQuery(sql);
		custFName = (String) s.getVal("c_f_name").asJavaVal();
		custLName = (String) s.getVal("c_l_name").asJavaVal();
		custTier = (Integer) s.getVal("c_tier").asJavaVal();
		taxId = (String) s.getVal("c_tax_id").asJavaVal();
		
		// SELECT broker_name = b_name FROM broker WHERE b_id = broker_id
		sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId;
		s = executeQuery(sql);
		brokerName = (String) s.getVal("b_name").asJavaVal();
	}
private void frame1 ( ) { // SELECT acct_name = ca_name, broker_id = ca_b_id, 
 // cust_id = ca_c_id, tax_status = ca_tax_st FROM
 // customer_account WHERE ca_id = acct_id
 String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account" + " WHERE ca_id = " + paramHelper . getAcctId ( ) ; Scan s = executeQuery ( sql ) ; acctName = ( String ) s . getVal ( "ca_name" ) . asJavaVal ( ) ; brokerId = ( Long ) s . getVal ( "ca_b_id" ) . asJavaVal ( ) ; custId = ( Long ) s . getVal ( "ca_c_id" ) . asJavaVal ( ) ; taxStatus = ( Integer ) s . getVal ( "ca_tax_st" ) . asJavaVal ( ) ; // TODO: Add this
 // num_found = row_count
 // SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, 
 // cust_tier = c_tier, tax_id = c_tax_id FROM
 // customer WHERE c_id = cust_id
 sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer" + " WHERE c_id = " + custId ; s = executeQuery ( sql ) ; custFName = ( String ) s . getVal ( "c_f_name" ) . asJavaVal ( ) ; custLName = ( String ) s . getVal ( "c_l_name" ) . asJavaVal ( ) ; custTier = ( Integer ) s . getVal ( "c_tier" ) . asJavaVal ( ) ; taxId = ( String ) s . getVal ( "c_tax_id" ) . asJavaVal ( ) ; // SELECT broker_name = b_name FROM broker WHERE b_id = broker_id
 sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId ; s = executeQuery ( sql ) ; brokerName = ( String ) s . getVal ( "b_name" ) . asJavaVal ( ) ; }
Get customer, customer account, and broker information
Get customer customer account and broker information