com.gemstone.gemfire.cache.query.data.SecurityMaster Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of gemfire-junit Show documentation
Show all versions of gemfire-junit Show documentation
SnappyData store based off Pivotal GemFireXD
/*
* Copyright (c) 2010-2015 Pivotal Software, Inc. All rights reserved.
*
* 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. See accompanying
* LICENSE file.
*/
package com.gemstone.gemfire.cache.query.data;
import java.sql.*;
import java.io.*;
/*
* author: Prafulla Chaudhari
*/
public class SecurityMaster implements Serializable{
public String cusip; //VARCHAR(9)
public String cusip_prohibited;// VARCHAR(1)
public String security_number;// VARCHAR(7)
public String security_type;// VARCHAR(1)
public String sbs_product_code;// VARCHAR(10)
public String sbs_product_group;//_CODE VARCHAR(20)
public String is_callable;// VARCHAR(1)
public Timestamp dated_date;// TIMESTAMP
public Timestamp maturity_date;// TIMESTAMP
public Timestamp coupon_date;// TIMESTAMP
public double coupon_rate;// DOUBLE
public Timestamp issue_date;// TIMESTAMP
public double issuer_price;// DOUBLE
public String moody_rating;// VARCHAR(10)
public String snp_rating;// VARCHAR(10)
public String security_description;// VARCHAR(200)
public String state_code;// VARCHAR(2)
public String country_code;// VARCHAR(3)
public Timestamp first_settlement_date;// TIMESTAMP
public Timestamp next_settlement_date; // TIMESTAMP
public Timestamp first_coupon_date;// TIMESTAMP
public Timestamp next_last_coupon_date; // TIMESTAMP
public Timestamp last_coupon_date; // TIMESTAMP
public String call_type;// VARCHAR(10)
public Timestamp pre_refunded_date; // TIMESTAMP
public double pre_refunded_price;// DOUBLE
public String put_type;// VARCHAR(5)
public String coupon_frequency;// VARCHAR(15)
public String sinking_fund_type;// VARCHAR(5)
public String escrow_type;// VARCHAR(5)
public String pre_refund_type;// VARCHAR(5)
public String insurance_type;// VARCHAR(5)
public String insurer_name;// VARCHAR(60)
public String exchange;// VARCHAR(4)
public String is_escrow;// VARCHAR(1)
public String is_prerefunded;// VARCHAR(1)
public String is_insured;// VARCHAR(1)
public String is_taxable;// VARCHAR(1)
public String is_subj_amt;// VARCHAR(1)
public String is_exmt_amt;// VARCHAR(1)
public String is_bank_qualified;// VARCHAR(1)
public String is_general_oblig;// VARCHAR(1)
public String is_revenue;// VARCHAR(1)
public String legal_defeasance_status;// VARCHAR(1)
public String alternative_minimum_tax_status;// VARCHAR(1)
public String tax_indicator;// VARCHAR(1)
public String bank_qualified_status;// VARCHAR(1)
public String taxable_status;// VARCHAR(1)
public String advalorem_tax_status;// VARCHAR(1)
public String source;// VARCHAR(8)
public String accrual_daycount_code;// VARCHAR(22)
public String is_endof_monthpayment;// VARCHAR(10)
public String symbol;// VARCHAR(9)
public String short_description;// VARCHAR(48)
public String moody_watch;// VARCHAR(10)
public String snp_watch;// VARCHAR(10)
public double article_counter;// DOUBLE
public String coupon_type;// VARCHAR(10)
public Timestamp update_date;// TIMESTAMP
public String is_perpetual;// VARCHAR(1)
public String tba_cusip;// VARCHAR(7)
public String coupon_class;// VARCHAR(10)
public int amortization_term;// INTEGER
public String mbs_class_code;// VARCHAR(1)
public String mbscc_eligibility_flag;// VARCHAR(1)
public String additional_sec_desc;// VARCHAR(256)
public String hand_figure_ind;// VARCHAR(1)
public String trading_flat_ind;// VARCHAR(1)
public String monetary_default_ind;// VARCHAR(1)
public String investment_grade;// VARCHAR(1)
////////constructor of class SecurityMaster
protected String [] tempArr;
protected int i=0;
protected String tempStr;
protected int tempInt;
protected double tempDouble;
public SecurityMaster(String inputStr){
tempArr = inputStr.split(",");
cusip = tempArr[i++].replaceAll("\"", " ").trim(); //VARCHAR(9)
cusip_prohibited = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
security_number = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(7)
security_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
sbs_product_code = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
sbs_product_group = tempArr[i++].replaceAll("\"", " ").trim();//_CODE VARCHAR(20)
is_callable = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
dated_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
maturity_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
coupon_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
coupon_rate = (Double.valueOf(tempStr.replaceAll("\"", " ").trim())).doubleValue();// DOUBLE
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
issue_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
issuer_price = (Double.valueOf(tempStr.replaceAll("\"", " ").trim())).doubleValue();// DOUBLE
}
moody_rating = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
snp_rating = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
tempStr = tempArr[i++];
tempStr = tempStr.replaceFirst("\"", " ").trim();
if(tempStr.lastIndexOf("\"") == -1){
tempStr = tempStr+tempArr[i++];
}
security_description = tempStr.replaceAll("\"", " ").trim();// VARCHAR(200)
state_code = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(2)
country_code = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(3)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
first_settlement_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
next_settlement_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
first_coupon_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
next_last_coupon_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
last_coupon_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
call_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
pre_refunded_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
pre_refunded_price = (Double.valueOf(tempStr.replaceAll("\"", " ").trim())).doubleValue();// DOUBLE
}
put_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(5)
coupon_frequency = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(15)
sinking_fund_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(5)
escrow_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(5)
pre_refund_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(5)
insurance_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(5)
insurer_name = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(60)
exchange = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(4)
is_escrow = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_prerefunded = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_insured = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_taxable = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_subj_amt = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_exmt_amt = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_bank_qualified = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_general_oblig = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
is_revenue = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
legal_defeasance_status = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
alternative_minimum_tax_status = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
tax_indicator = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
bank_qualified_status = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
taxable_status = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
advalorem_tax_status = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
source = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(8)
accrual_daycount_code = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(22)
is_endof_monthpayment = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
symbol = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(9)
short_description = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(48)
moody_watch = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
snp_watch = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
article_counter = (Double.valueOf(tempStr.replaceAll("\"", " ").trim())).doubleValue();// DOUBLE
}
coupon_type = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
update_date = Timestamp.valueOf(tempStr.replaceAll("\"", " ").trim());// TIMESTAMP
}
is_perpetual = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
tba_cusip = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(7)
coupon_class = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(10)
tempStr = tempArr[i++];
if(!tempStr.equalsIgnoreCase("NULL")){
amortization_term = (Integer.valueOf(tempStr.replaceAll("\"", " ").trim())).intValue();// INTEGER
}
mbs_class_code = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
mbscc_eligibility_flag = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
additional_sec_desc = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(256)
hand_figure_ind = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
trading_flat_ind = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
monetary_default_ind = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
investment_grade = tempArr[i++].replaceAll("\"", " ").trim();// VARCHAR(1)
}//end of SecurityMaster constructor
}//end of class