FacilityEntityTest

package com.citi.risk.credit.facility.entity;

import java.math.BigDecimal;
import java.util.Date;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.Before;
import org.junit.Test;
import java.util.*;
import org.junit.runner.RunWith;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.SessionFactoryUtils;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.citi.risk.credit.facility.FacilityServiceBasicTest;
import com.citi.risk.credit.facility.entity.cdm.*;
//import com.citi.risk.credit.facility.service.FacilityServiceTestOne;
//import com.citi.risk.credit.facility.util.exception.ApplicationException;
//import com.citi.risk.credit.facility.util.exception.SystemRuntimeException;

public class FacilityEntityTest extends FacilityServiceBasicTest{

// private static Log //logger = LogFactory.getLog(FacilityServiceTestOne.class);

SessionFactory sessionFactory = null;

// @Test
public void testAloAllocation() throws Exception {
//logger.info("...");

sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);
//add
AloAllocation aloAllocation_add=new AloAllocation();
session.save(aloAllocation_add);

//delete
Query query = session.createQuery("from AloAllocation c");
AloAllocation aloAllocation_d = (AloAllocation) query.list().get(0);
session.delete(aloAllocation_d);

//update
query = session.createQuery("from AloAllocation c");
AloAllocation aloAllocation_u = (AloAllocation) query.list().get(1);
aloAllocation_u.setCreatedBy("sjblue");
session.saveOrUpdate(aloAllocation_u);

//logger.info("...");

}

// @Test
public void testAloAmount() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
AloAmount aloAmount_add=new AloAmount();
AloAmount aloAmount_add2=new AloAmount();
//
Query query = session.createQuery("from AloAllocation c");

AloAllocation aloAllocation_add=new AloAllocation();
AloAllocation aloAllocation_add2=new AloAllocation();

aloAllocation_add = (AloAllocation) query.list().get(0);
aloAllocation_add2= (AloAllocation) query.list().get(1);

aloAmount_add.setAloAllocation(aloAllocation_add);
aloAmount_add2.setAloAllocation(aloAllocation_add2);

aloAllocation_add.getAloAmounts().add(aloAmount_add);
aloAllocation_add2.getAloAmounts().add(aloAmount_add2);

session.saveOrUpdate(aloAllocation_add);
session.saveOrUpdate(aloAllocation_add2);

//delete
// query = session.createQuery("from AloAllocation c");
AloAllocation aloAllocation_d=new AloAllocation();
aloAllocation_d = (AloAllocation) query.list().get(0);

AloAmount aloAmount_d = (AloAmount) aloAllocation_d.getAloAmounts().toArray()[0];
aloAllocation_d.getAloAmounts().clear();
session.saveOrUpdate(aloAllocation_d);

//update
// Query query = session.createQuery("from AloAllocation c where c.aloId=40");
AloAllocation aloAllocation_u = new AloAllocation();
aloAllocation_u=(AloAllocation) query.list().get(1);
AloAmount aloAmount_u=new AloAmount();
aloAmount_u = (AloAmount)aloAllocation_u.getAloAmounts().toArray()[0];
aloAmount_u.setCreatedBy("sjblue");
session.saveOrUpdate(aloAllocation_u);

//logger.info("...");
}

// @Test
public void testAloAudit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
AloAudit aloAudit_add=new AloAudit();
AloAudit aloAudit_add2=new AloAudit();

Query query = session.createQuery("from AloAllocation c");
AloAllocation aloAllocation_add = (AloAllocation) query.list().get(0);
AloAllocation aloAllocation_add2 = (AloAllocation) query.list().get(1);

aloAudit_add.setAloAllocation(aloAllocation_add);
aloAllocation_add.getAloAudits().add(aloAudit_add);

aloAudit_add2.setAloAllocation(aloAllocation_add2);
aloAllocation_add2.getAloAudits().add(aloAudit_add2);

session.saveOrUpdate(aloAllocation_add);
session.saveOrUpdate(aloAllocation_add2);

//delete
// Query query = session.createQuery("from AloAllocation c where c.aloId=11");
AloAllocation aloAllocation_d = (AloAllocation) query.list().get(0);
AloAudit aloAudit_d = (AloAudit) aloAllocation_d.getAloAudits().toArray()[0];
aloAllocation_d.getAloAudits().clear();
session.saveOrUpdate(aloAllocation_d);

//update
// Query query = session.createQuery("from AloAllocation c where c.aloId=11");
AloAllocation aloAllocation_u = (AloAllocation) query.list().get(1);
AloAudit aloAudit_u=new AloAudit();
aloAudit_u = (AloAudit)aloAllocation_u.getAloAudits().toArray()[0];
aloAudit_u.setCreatedBy("sjblue");
session.saveOrUpdate(aloAllocation_u);

//logger.info("...");
}

// @Test
public void testAloTenor() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);
//add

Query query = session.createQuery("from AloAllocation c");
AloAllocation aloAllocation_add = (AloAllocation) query.list().get(0);

AloAmount aloAmount_add=new AloAmount();
aloAmount_add.setAloTenors(new HashSet<AloTenor>());

AloAmount aloAmount_add2=new AloAmount();
aloAmount_add2.setAloTenors(new HashSet<AloTenor>());

aloAmount_add.setAloAllocation(aloAllocation_add);
aloAllocation_add.getAloAmounts().add(aloAmount_add);

aloAmount_add2.setAloAllocation(aloAllocation_add);
aloAllocation_add.getAloAmounts().add(aloAmount_add2);

AloTenor AloTenor_add=new AloTenor();
AloTenor AloTenor_add2=new AloTenor();

AloTenor_add.setAloAmount(aloAmount_add);
AloTenor_add2.setAloAmount(aloAmount_add2);

aloAmount_add.getAloTenors().add(AloTenor_add);
aloAmount_add2.getAloTenors().add(AloTenor_add2);
session.saveOrUpdate(aloAllocation_add);

//delete
// Query query = session.createQuery("from AloAllocation c where c.aloId=40");
AloAllocation aloAllocation_d=new AloAllocation();
aloAllocation_d=(AloAllocation) query.list().get(0);

AloAmount aloAmount_d = new AloAmount();
aloAmount_d=(AloAmount) aloAllocation_d.getAloAmounts().toArray()[0];

AloTenor aloTenor_d = new AloTenor();
aloTenor_d = (AloTenor) aloAmount_d.getAloTenors().toArray()[0];
aloAmount_d.getAloTenors().clear();
session.saveOrUpdate(aloAllocation_d);


//update
// Query query = session.createQuery("from AloAllocation c where c.aloId=40");
AloAllocation aloAllocation_u=new AloAllocation();
aloAllocation_u=(AloAllocation) query.list().get(0);

AloAmount aloAmount_u = new AloAmount();
aloAmount_u=(AloAmount) aloAllocation_u.getAloAmounts().toArray()[1];

AloTenor aloTenor_u = new AloTenor();
aloTenor_u = (AloTenor) aloAmount_u.getAloTenors().toArray()[0];
aloTenor_u.setCreatedBy("sjblue");
session.saveOrUpdate(aloAllocation_u);

//logger.info("...");
}

// @Test
public void testColAudit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
ColAudit colAudit_add=new ColAudit();
ColAudit colAudit_add2=new ColAudit();

Query query = session.createQuery("from ColCollateral c");

ColCollateral colCollateral = new ColCollateral();
colCollateral = (ColCollateral) query.list().get(0);

colAudit_add.setColCollateral(colCollateral);
colAudit_add2.setColCollateral(colCollateral);

colCollateral.getColAudits().add(colAudit_add);
colCollateral.getColAudits().add(colAudit_add2);

session.saveOrUpdate(colCollateral);

//delete
// Query query = session.createQuery("from ColCollateral c where c.colId=2");
ColCollateral colCollateral_d = new ColCollateral();
colCollateral_d = (ColCollateral) query.list().get(0);
ColAudit colAudit_d=new ColAudit();
colAudit_d = (ColAudit) colCollateral_d.getColAudits().toArray()[0];
colCollateral_d.getColAudits().clear();
session.saveOrUpdate(colCollateral_d);

//update
// Query query = session.createQuery("from ColCollateral c where c.colId=2");
ColCollateral colCollateral_u = new ColCollateral();
colCollateral_u = (ColCollateral) query.list().get(0);
ColAudit colAudit_u=new ColAudit();
colAudit_u = (ColAudit) colCollateral_u.getColAudits().toArray()[1];

colAudit_u.setCreatedBy("sjblue");
session.saveOrUpdate(colCollateral_u);

//logger.info("...");
}

// @Test
public void testColCollateral() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
ColCollateral colCollateral_add=new ColCollateral();
ColCollateral colCollateral_add2=new ColCollateral();
session.saveOrUpdate(colCollateral_add);
session.saveOrUpdate(colCollateral_add2);

//delete
Query query = session.createQuery("from ColCollateral c");
ColCollateral colCollateral_d=new ColCollateral();
colCollateral_d = (ColCollateral) query.list().get(0);
session.delete(colCollateral_d);

// //update
// Query query = session.createQuery("from ColCollateral c where c.colId=2");
ColCollateral colCollateral_u=new ColCollateral();
colCollateral_u = (ColCollateral) query.list().get(1);
colCollateral_u.setCreatedBy("sjblue");
session.saveOrUpdate(colCollateral_u);
//logger.info("...");
}

// @Test
public void testFacAmount() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
Query query = session.createQuery("from FacFacility c where c.facId=2");
FacFacility facFacility_add=new FacFacility();
facFacility_add = (FacFacility) query.list().get(0);

FacAmount facAmount_add=new FacAmount();
FacAmount facAmount_add2=new FacAmount();

facAmount_add.setFacFacility(facFacility_add);
facAmount_add2.setFacFacility(facFacility_add);

facFacility_add.getFacAmounts().add(facAmount_add);
facFacility_add.getFacAmounts().add(facAmount_add2);

session.saveOrUpdate(facFacility_add);

//delete
// Query query = session.createQuery("from FacFacility c where c.facId=2");
FacFacility facFacility_d=new FacFacility();
facFacility_d = (FacFacility) query.list().get(0);
FacAmount facAmount_d=new FacAmount();
facAmount_d = (FacAmount) facFacility_d.getFacAmounts().toArray()[0];
facFacility_d.getFacAmounts().clear();
session.saveOrUpdate(facFacility_d);

// //update
// Query query = session.createQuery("from FacFacility c where c.facId=2");
FacFacility facFacility_u=new FacFacility();
facFacility_u = (FacFacility) query.list().get(0);
FacAmount facAmount_u=new FacAmount();
facAmount_u = (FacAmount) facFacility_u.getFacAmounts().toArray()[1];

facAmount_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_u);
//logger.info("...");
}


// @Test
public void testFacPurchaseReceivable() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacPurchaseReceivable facPurchaseReceivable_add=new FacPurchaseReceivable();
FacPurchaseReceivable facPurchaseReceivable_add2=new FacPurchaseReceivable();

facPurchaseReceivable_add.setFacFacility(facFacility_add);
facPurchaseReceivable_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacPurchaseReceivable(facPurchaseReceivable_add);
facFacility_add2.setFacPurchaseReceivable(facPurchaseReceivable_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.setFacPurchaseReceivable(null);
session.saveOrUpdate(facFacility_add);

//update
FacPurchaseReceivable facPurchaseReceivable_u=new FacPurchaseReceivable();
facPurchaseReceivable_u = (FacPurchaseReceivable) facFacility_add2.getFacPurchaseReceivable();

facPurchaseReceivable_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
//logger.info("...");
}

// @Test
public void testFacFacility() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
// Query query = session.createQuery("from FacFacility c where c.facId=47");
// FacFacility facFacility_d=new FacFacility();
// facFacility_d = (FacFacility) query.uniqueResult();
session.delete(facFacility_add);

//update
// Query query = session.createQuery("from FacFacility c where c.facId=51");
// FacFacility facFacility_u=new FacFacility();
// facFacility_u = (FacFacility) query.uniqueResult();
facFacility_add2.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
//
//logger.info("...");
}

@Test
public void testFacApprovingUnit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

// //add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacApprovingUnit facApprovingUnit_add=new FacApprovingUnit("ljhjay1",facFacility_add);
FacApprovingUnit facApprovingUnit_add2=new FacApprovingUnit("ljhjay2",facFacility_add2);

facFacility_add.setFacApprovingUnits(new HashSet<FacApprovingUnit>());
facFacility_add2.setFacApprovingUnits(new HashSet<FacApprovingUnit>());

facApprovingUnit_add.setFacFacility(facFacility_add);
facApprovingUnit_add2.setFacFacility(facFacility_add2);

facFacility_add.getFacApprovingUnits().add(facApprovingUnit_add);
facFacility_add2.getFacApprovingUnits().add(facApprovingUnit_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacApprovingUnit facApprovingUnit_d=new FacApprovingUnit();
facApprovingUnit_d = (FacApprovingUnit) facFacility_add.getFacApprovingUnits().toArray()[0];
facFacility_add.getFacApprovingUnits().clear();
session.saveOrUpdate(facFacility_add);

//update
FacApprovingUnit facApprovingUnit_u=new FacApprovingUnit();
facApprovingUnit_u = (FacApprovingUnit) facFacility_add2.getFacApprovingUnits().toArray()[0];
facApprovingUnit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
//logger.info("...");
}

// @Test
public void testFacAudit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacAudit facAudit_add=new FacAudit();
FacAudit facAudit_add2=new FacAudit();

facAudit_add.setFacFacility(facFacility_add);
facAudit_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacAudits(new HashSet<FacAudit>());
facFacility_add2.setFacAudits(new HashSet<FacAudit>());

facFacility_add.getFacAudits().add(facAudit_add);
facFacility_add2.getFacAudits().add(facAudit_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacAudit facAudit_d=new FacAudit();
facAudit_d = (FacAudit) facFacility_add.getFacAudits().toArray()[0];
facFacility_add.getFacAudits().clear();
session.saveOrUpdate(facFacility_add);

//update
FacAudit facAudit_u=new FacAudit();
facAudit_u = (FacAudit) facFacility_add2.getFacAudits().toArray()[0];

facAudit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);

//logger.info("...");
}
// @Test
public void testFacAvailableCurrency() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacAvailableCurrency facAvailableCurrency_add=new FacAvailableCurrency("ljhjay1",facFacility_add);
FacAvailableCurrency facAvailableCurrency_add2=new FacAvailableCurrency("ljhjay2",facFacility_add2);

facAvailableCurrency_add.setFacFacility(facFacility_add);
facAvailableCurrency_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacAvailableCurrencies(new HashSet<FacAvailableCurrency>());
facFacility_add2.setFacAvailableCurrencies(new HashSet<FacAvailableCurrency>());

facFacility_add.getFacAvailableCurrencies().add(facAvailableCurrency_add);
facFacility_add2.getFacAvailableCurrencies().add(facAvailableCurrency_add2);
session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacAvailableCurrency facAvailableCurrency_d=new FacAvailableCurrency();
facAvailableCurrency_d = (FacAvailableCurrency) facFacility_add.getFacAvailableCurrencies().toArray()[0];
facFacility_add.getFacAvailableCurrencies().clear();
session.saveOrUpdate(facFacility_add);

//update
FacAvailableCurrency facAvailableCurrency_u=new FacAvailableCurrency();
facAvailableCurrency_u = (FacAvailableCurrency) facFacility_add2.getFacAvailableCurrencies().toArray()[0];

facAvailableCurrency_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);

//logger.info("...");
}

// @Test
public void testFacBookingUnit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacBookingUnit facBookingUnit_add=new FacBookingUnit("ljhjay1",facFacility_add);
FacBookingUnit facBookingUnit_add2=new FacBookingUnit("ljhjay2",facFacility_add2);

facFacility_add.setFacBookingUnits(new HashSet<FacBookingUnit>());
facFacility_add2.setFacBookingUnits(new HashSet<FacBookingUnit>());

facFacility_add.getFacBookingUnits().add(facBookingUnit_add);
facFacility_add2.getFacBookingUnits().add(facBookingUnit_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacBookingUnit facBookingUnit_d=new FacBookingUnit();
facBookingUnit_d = (FacBookingUnit) facFacility_add.getFacBookingUnits().toArray()[0];
facFacility_add.getFacBookingUnits().clear();
session.saveOrUpdate(facFacility_add);

//update
FacBookingUnit facBookingUnit_u=new FacBookingUnit();
facBookingUnit_u = (FacBookingUnit) facFacility_add2.getFacBookingUnits().toArray()[0];

facBookingUnit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);

//logger.info("...");
}

@Test
public void testFacClassified() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacClassified facClassified_add=new FacClassified();
FacClassified facClassified_add2=new FacClassified();

facClassified_add.setFacFacility(facFacility_add);
facClassified_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacClassifieds(new HashSet<FacClassified>());
facFacility_add2.setFacClassifieds(new HashSet<FacClassified>());

facFacility_add.getFacClassifieds().add(facClassified_add);
facFacility_add2.getFacClassifieds().add(facClassified_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacClassified facClassified_d=new FacClassified();
facClassified_d = (FacClassified) facFacility_add.getFacClassifieds().toArray()[0];
facFacility_add.getFacClassifieds().clear();
session.saveOrUpdate(facFacility_add);

//update
FacClassified facClassified_u=new FacClassified();
facClassified_u = (FacClassified) facFacility_add2.getFacClassifieds().toArray()[0];

facClassified_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
//logger.info("...");
}

// @Test
public void testFacCollateral() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
// FacFacility facFacility_add2=new FacFacility();

ColCollateral colCollateral_add=new ColCollateral();
// ColCollateral colCollateral_add2=new ColCollateral();

FacCollateral facCollateral_add=new FacCollateral(facFacility_add,colCollateral_add);
// FacCollateral facCollateral_add2=new FacCollateral(facFacility_add2,colCollateral_add2);


colCollateral_add.setFacCollaterals(new HashSet<FacCollateral>());
// colCollateral_add2.setFacCollaterals(new HashSet<FacCollateral>());

colCollateral_add.getFacCollaterals().add(facCollateral_add);
// colCollateral_add2.getFacCollaterals().add(facCollateral_add2);

facFacility_add.setFacCollaterals(new HashSet<FacCollateral>());
// facFacility_add2.setFacCollaterals(new HashSet<FacCollateral>());

facFacility_add.getFacCollaterals().add(facCollateral_add);
// facFacility_add2.getFacCollaterals().add(facCollateral_add2);

session.saveOrUpdate(facCollateral_add);
// session.saveOrUpdate(facFacility_add);

// session.saveOrUpdate(facFacility_add2);
// session.saveOrUpdate(colCollateral_add);
// session.saveOrUpdate(colCollateral_add2);
//delete
// Query query = session.createQuery("from FacFacility c where c.facId=2");
// FacFacility facFacility_d=new FacFacility();
// facFacility_d = (FacFacility) query.uniqueResult();
// FacCollateral facCollateral_d=new FacCollateral();
// facCollateral_d = (FacCollateral) facFacility_add.getFacCollaterals().toArray()[0];
// facFacility_add.getFacCollaterals().remove(facCollateral_d);
// session.saveOrUpdate(facFacility_add);


//update
// Query query = session.createQuery("from FacFacility c where c.facId=3");
// FacFacility facFacility_u=new FacFacility();
// facFacility_u = (FacFacility) query.uniqueResult();
// FacCollateral facCollateral_u=new FacCollateral();
// facCollateral_u = (FacCollateral) facFacility_u.getFacCollaterals().toArray()[0];
//
// facCollateral_u.setCreatedBy("sfasdnow");
// session.saveOrUpdate(facFacility_u);
//logger.info("...");
}
@Test
public void testFacConfidential() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
// Query query = session.createQuery("from FacFacility c where c.facId=2");
// Query query2 = session.createQuery("from FacFacility c where c.facId=3");
//
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

// facFacility_add = (FacFacility) query.uniqueResult();
// facFacility_add2 = (FacFacility) query2.uniqueResult();

FacConfidential FacConfidential_add=new FacConfidential();
FacConfidential FacConfidential_add2=new FacConfidential();


FacConfidential_add.setFacFacility(facFacility_add);
FacConfidential_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacConfidential(FacConfidential_add);
facFacility_add2.setFacConfidential(FacConfidential_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
// query = session.createQuery("from FacFacility c where c.facId=25");
// FacFacility facFacility_d=new FacFacility();
// facFacility_d = (FacFacility) query.uniqueResult();
facFacility_add.setFacConfidential(null);
session.saveOrUpdate(facFacility_add);


//update
// query = session.createQuery("from FacFacility c where c.facId=2");
// FacFacility facFacility_u=new FacFacility();
// facFacility_u = (FacFacility) query.uniqueResult();
FacConfidential facConfidential_u=new FacConfidential();
facConfidential_u = (FacConfidential) facFacility_add2.getFacConfidential();

facConfidential_u.setCreatedBy("sjblue");
session.saveOrUpdate(FacConfidential_add2);
//logger.info("...");
}
@Test
public void testFacCrossBorder() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
// Query query = session.createQuery("from FacFacility c where c.facId=25");
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacCrossBorder facCrossBorder_add=new FacCrossBorder("a2","t2",facFacility_add);
FacCrossBorder facCrossBorder_add2=new FacCrossBorder("a3","t3",facFacility_add2);

facFacility_add.setFacCrossBorders(new HashSet<FacCrossBorder>());
facFacility_add2.setFacCrossBorders(new HashSet<FacCrossBorder>());

facFacility_add.getFacCrossBorders().add(facCrossBorder_add);
facFacility_add2.getFacCrossBorders().add(facCrossBorder_add2);

session.saveOrUpdate(facFacility_add);
session.flush();
session.saveOrUpdate(facFacility_add2);
System.out.println("facFacility_add.getFacCrossBorders().size():"+facFacility_add.getFacCrossBorders().size());
//delete
// Query query = session.createQuery("from FacFacility c where c.facId=25");
// FacFacility facFacility_d=new FacFacility();
// facFacility_d = (FacFacility) query.uniqueResult();
// FacFacility facFacility_d=new FacFacility();
// facFacility_d.setFacCrossBorders(new HashSet<FacCrossBorder>());


// for(int i=0;i<facFacility_add.getFacCrossBorders().size();i++){
// facFacility_d.getFacCrossBorders().add((FacCrossBorder) facFacility_add.getFacCrossBorders().toArray()[i]);
// }

FacCrossBorder facCrossBorder_d = (FacCrossBorder) facFacility_add.getFacCrossBorders().toArray()[0];
System.out.println("size___:"+facFacility_add.getFacCrossBorders().size());
facFacility_add.getFacCrossBorders().clear();
// System.out.println("facCrossBorder_d___:"+facCrossBorder_d.getFacFacility().getFacId());
System.out.println("facFacility_add.getFacCrossBorders().size():"+facFacility_add.getFacCrossBorders().size());
session.saveOrUpdate(facFacility_add);


//update
// Query query = session.createQuery("from FacFacility c where c.facId=3");
// FacFacility facFacility_u=new FacFacility();
// facFacility_u = (FacFacility) query.uniqueResult();
FacCrossBorder facCrossBorder_u=new FacCrossBorder();
facCrossBorder_u = (FacCrossBorder) facFacility_add2.getFacCrossBorders().toArray()[0];
facCrossBorder_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);

//logger.info("...");
}
@Test
public void testFacCustomerAggregation() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacCustomerAggregation facCustomerAggregation_add=new FacCustomerAggregation("ljh1",facFacility_add);
FacCustomerAggregation facCustomerAggregation_add2=new FacCustomerAggregation("ljh2",facFacility_add2);

facFacility_add.setFacCustomerAggregations(new HashSet<FacCustomerAggregation>());
facFacility_add2.setFacCustomerAggregations(new HashSet<FacCustomerAggregation>());

facFacility_add.getFacCustomerAggregations().add(facCustomerAggregation_add);
facFacility_add2.getFacCustomerAggregations().add(facCustomerAggregation_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
FacCustomerAggregation facCustomerAggregation_d=new FacCustomerAggregation();
facCustomerAggregation_d = (FacCustomerAggregation) facFacility_add.getFacCustomerAggregations().toArray()[0];
facFacility_add.getFacCustomerAggregations().clear();
session.saveOrUpdate(facFacility_add);

//update
// Query query = session.createQuery("from FacFacility c where c.facId=3");
// FacFacility facFacility_u=new FacFacility();
// facFacility_u = (FacFacility) query.uniqueResult();
FacCustomerAggregation facCustomerAggregation_u=new FacCustomerAggregation();
facCustomerAggregation_u = (FacCustomerAggregation) facFacility_add2.getFacCustomerAggregations().toArray()[0];
facCustomerAggregation_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add2);
session.delete(facFacility_add);
//logger.info("...");
}

@Test
public void testFacExtendingUnit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacExtendingUnit facExtendingUnit_add=new FacExtendingUnit("l1",facFacility_add);
FacExtendingUnit facExtendingUnit_add2=new FacExtendingUnit("l2",facFacility_add2);

facFacility_add.setFacExtendingUnits(new HashSet<FacExtendingUnit>());
facFacility_add2.setFacExtendingUnits(new HashSet<FacExtendingUnit>());

facFacility_add.getFacExtendingUnits().add(facExtendingUnit_add);
facFacility_add2.getFacExtendingUnits().add(facExtendingUnit_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);
//delete
// FacExtendingUnit facExtendingUnit_d=new FacExtendingUnit();
// facExtendingUnit_d = (FacExtendingUnit) facFacility_add.getFacExtendingUnits().toArray()[0];
facFacility_add.getFacExtendingUnits().clear();
session.saveOrUpdate(facFacility_add);


//update
FacExtendingUnit facExtendingUnit_u=new FacExtendingUnit();
facExtendingUnit_u = (FacExtendingUnit) facFacility_add2.getFacExtendingUnits().toArray()[0];
facExtendingUnit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

@Test
public void testFacExtraordinaryRisk() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacExtraordinaryRisk facExtraordinaryRisk_add=new FacExtraordinaryRisk();
FacExtraordinaryRisk facExtraordinaryRisk_add2=new FacExtraordinaryRisk();

facExtraordinaryRisk_add.setFacFacility(facFacility_add);
facExtraordinaryRisk_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacExtraordinaryRisks(new HashSet<FacExtraordinaryRisk>());
facFacility_add2.setFacExtraordinaryRisks(new HashSet<FacExtraordinaryRisk>());

facFacility_add.getFacExtraordinaryRisks().add(facExtraordinaryRisk_add);
facFacility_add2.getFacExtraordinaryRisks().add(facExtraordinaryRisk_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);
//delete
facFacility_add.getFacExtraordinaryRisks().clear();
session.saveOrUpdate(facFacility_add);

//update

FacExtraordinaryRisk facExtraordinaryRisk_u=new FacExtraordinaryRisk();
facExtraordinaryRisk_u = (FacExtraordinaryRisk) facFacility_add2.getFacExtraordinaryRisks().toArray()[0];

facExtraordinaryRisk_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);

//logger.info("...");
}

@Test
public void testFacLine() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacLine facLine_add=new FacLine();
FacLine facLine_add2=new FacLine();

facLine_add.setFacFacility(facFacility_add);
facLine_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacLines(new HashSet<FacLine>());
facFacility_add2.setFacLines(new HashSet<FacLine>());

facFacility_add.getFacLines().add(facLine_add);
facFacility_add2.getFacLines().add(facLine_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacLines().clear();
session.saveOrUpdate(facFacility_add);

//update
FacLine facLine_u=new FacLine();
facLine_u = (FacLine) facFacility_add2.getFacLines().toArray()[0];

facLine_u.setCreatedBy("snasdfaow");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

@Test
public void testFacMandatoryDocument() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacMandatoryDocument facMandatoryDocument_add=new FacMandatoryDocument();
FacMandatoryDocument facMandatoryDocument_add2=new FacMandatoryDocument();

facMandatoryDocument_add.setFacFacility(facFacility_add);
facMandatoryDocument_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacMandatoryDocuments(new HashSet<FacMandatoryDocument>());
facFacility_add2.setFacMandatoryDocuments(new HashSet<FacMandatoryDocument>());

facFacility_add.getFacMandatoryDocuments().add(facMandatoryDocument_add);
facFacility_add2.getFacMandatoryDocuments().add(facMandatoryDocument_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);


//delete

facFacility_add.getFacMandatoryDocuments().clear();
session.saveOrUpdate(facFacility_add);


//update
FacMandatoryDocument facMandatoryDocument_u=new FacMandatoryDocument();
facMandatoryDocument_u = (FacMandatoryDocument) facFacility_add2.getFacMandatoryDocuments().toArray()[0];

facMandatoryDocument_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

//@Test
public void testFacOasys() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add

FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacOasys facOasys_add=new FacOasys();
FacOasys facOasys_add2=new FacOasys();

facOasys_add.setGfcid("123456789");
facOasys_add.setLegalUnitCd("ljhjay");
facOasys_add.setFacFacility(facFacility_add);

facOasys_add2.setGfcid("987654321");
facOasys_add2.setLegalUnitCd("sjblue");
facOasys_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacOasyses(new HashSet<FacOasys>());
facFacility_add2.setFacOasyses(new HashSet<FacOasys>());

facFacility_add.getFacOasyses().add(facOasys_add);
facFacility_add2.getFacOasyses().add(facOasys_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacOasyses().clear();
session.saveOrUpdate(facFacility_add);

//update
FacOasys facOasys_u=new FacOasys();
facOasys_u = (FacOasys) facFacility_add2.getFacOasyses().toArray()[0];

facOasys_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

@Test
public void testFacProduct() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacProduct facProduct_add=new FacProduct();
FacProduct facProduct_add2=new FacProduct();

facProduct_add.setFacFacility(facFacility_add);
facProduct_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacProducts(new HashSet<FacProduct>());
facFacility_add2.setFacProducts(new HashSet<FacProduct>());


facFacility_add.getFacProducts().add(facProduct_add);
facFacility_add2.getFacProducts().add(facProduct_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacProducts().clear();
session.saveOrUpdate(facFacility_add);

//update
FacProduct facProduct_u=new FacProduct();
facProduct_u = (FacProduct) facFacility_add2.getFacProducts().toArray()[0];

facProduct_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);

//logger.info("...");
}

//@Test
public void testFacSublimit() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

facSublimit_add.setFacFacility(facFacility_add);
facSublimit_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacSublimits(new HashSet<FacSublimit>());
facFacility_add2.setFacSublimits(new HashSet<FacSublimit>());


facFacility_add.getFacSublimits().add(facSublimit_add);
facFacility_add2.getFacSublimits().add(facSublimit_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacSublimits().clear();
session.saveOrUpdate(facFacility_add);

//update
FacSublimit facSublimit_u=new FacSublimit();
facSublimit_u = (FacSublimit) facSublimit_add2.getFacSublimits().toArray()[0];

facSublimit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}

//@Test
public void testFacProductHierarchy() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacProductHierarchy facProductHierarchy_add=new FacProductHierarchy();
FacProductHierarchy facProductHierarchy_add2=new FacProductHierarchy();

facProductHierarchy_add.setFacFacility(facFacility_add);
facProductHierarchy_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacProductHierarchies(new HashSet<FacProductHierarchy>());
facFacility_add2.setFacProductHierarchies(new HashSet<FacProductHierarchy>());

facFacility_add.getFacProductHierarchies().add(facProductHierarchy_add);
facFacility_add2.getFacProductHierarchies().add(facProductHierarchy_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacProductHierarchies().clear();
session.saveOrUpdate(facFacility_add);

//update
FacProductHierarchy facProductHierarchy_u=new FacProductHierarchy();
facProductHierarchy_u = (FacProductHierarchy) facFacility_add2.getFacProductHierarchies().toArray()[0];

facProductHierarchy_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

@Test
public void testFacSlAmount() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add

FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlAmount facSlAmount_add=new FacSlAmount();
FacSlAmount facSlAmount_add2=new FacSlAmount();

facSlAmount_add.setFacSublimit(facSublimit_add);
facSlAmount_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.setFacSlAmounts(new HashSet<FacSlAmount>());
facSublimit_add2.setFacSlAmounts(new HashSet<FacSlAmount>());

facSublimit_add.getFacSlAmounts().add(facSlAmount_add);
facSublimit_add2.getFacSlAmounts().add(facSlAmount_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlAmounts().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlAmount facSlAmount_u=new FacSlAmount();
facSlAmount_u = (FacSlAmount) facSublimit_add2.getFacSlAmounts().toArray()[0];

facSlAmount_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);
//logger.info("...");
}

//@Test
public void testFacSlAvailableCurrency() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlAvailableCurrency facSlAvailableCurrency_add=new FacSlAvailableCurrency("RMB",facSublimit_add);
FacSlAvailableCurrency facSlAvailableCurrency_add2=new FacSlAvailableCurrency("USD",facSublimit_add2);

facSublimit_add.getFacSlAvailableCurrencies(new HashSet<FacSlAvailableCurrency>());
facSublimit_add2.getFacSlAvailableCurrencies(new HashSet<FacSlAvailableCurrency>());

facSublimit_add.getFacSlAvailableCurrencies().add(facSlAvailableCurrency_add);
facSublimit_add2.getFacSlAvailableCurrencies().add(facSlAvailableCurrency_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlAvailableCurrencies().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlAvailableCurrency facSlAvailableCurrency_u=new FacSlAvailableCurrency();
facSlAvailableCurrency_u = (FacSlAvailableCurrency) facSublimit_add2.getFacSlAvailableCurrencies().toArray()[0];

facSlAvailableCurrency_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);
//logger.info("...");

}

//@Test
public void testFacSlBookingUnitId() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlBookingUnit facSlBookingUnit_add=new FacSlBookingUnit("snow",facSublimit_add);
FacSlBookingUnit facSlBookingUnit_add2=new FacSlBookingUnit("snow",facSublimit_add2);

facSublimit_add.setFacSlBookingUnits(new HashSet<FacSlBookingUnit>());
facSublimit_add2.setFacSlBookingUnits(new HashSet<FacSlBookingUnit>());

facSublimit_add.getFacSlBookingUnits().add(facSlBookingUnit_add);
facSublimit_add2.getFacSlBookingUnits().add(facSlBookingUnit_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlBookingUnits().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlBookingUnit facSlBookingUnit_u=new FacSlBookingUnit();
facSlBookingUnit_u = (FacSlBookingUnit) facSublimit_add2.getFacSlBookingUnits().toArray()[0];

facSlBookingUnit_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}

//@Test
public void testFacSlLine() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlLine facSlLine_add=new FacSlLine();
FacSlLine facSlLine_add2=new FacSlLine();

facSlLine_add.setFacSublimit(facSublimit_add);
facSlLine_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.setFacSlLines(new HashSet<FacSlLine>());
facSublimit_add2.setFacSlLines(new HashSet<FacSlLine>());

facSublimit_add.getFacSlLines().add(facSlLine_add);
facSublimit_add2.getFacSlLines().add(facSlLine_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlLines().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlLine facSlLine_u=new FacSlLine();
facSlLine_u = (FacSlLine) facSublimit_add2.getFacSlLines().toArray()[0];

facSlLine_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}

//@Test
public void testFacSlProduct() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();


FacSlProduct facSlProduct_add=new FacSlProduct();
FacSlProduct facSlProduct_add2=new FacSlProduct();

facSlProduct_add.setFacSublimit(facSublimit_add);
facSlProduct_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.getFacSlProducts(new HashSet<FacSlProduct>());
facSublimit_add2.getFacSlProducts(new HashSet<FacSlProduct>());

facSublimit_add.getFacSlProducts().add(facSlProduct_add);
facSublimit_add2.getFacSlProducts().add(facSlProduct_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlProducts().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlProduct facSlProduct_u=new FacSlProduct();
facSlProduct_u = (FacSlProduct) facSublimit_add2.getFacSlProducts().toArray()[0];

facSlProduct_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}
//@Test
public void testFacSlProductHierarchy() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlProductHierarchy facSlProductHierarchy_add=new FacSlProductHierarchy();
FacSlProductHierarchy facSlProductHierarchy_add2=new FacSlProductHierarchy();

facSlProductHierarchy_add.setFacSublimit(facSublimit_add);
facSlProductHierarchy_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.setFacSlProductHierarchies(new HashSet<FacSlProductHierarchy>());
facSublimit_add2.setFacSlProductHierarchies(new HashSet<FacSlProductHierarchy>());

facSublimit_add.getFacSlProductHierarchies().add(facSlProductHierarchy_add);
facSublimit_add2.getFacSlProductHierarchies().add(facSlProductHierarchy_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlProductHierarchies().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlProductHierarchy facSlProductHierarchy_u=new FacSlProductHierarchy();
facSlProductHierarchy_u = (FacSlProductHierarchy) facSublimit_add2.getFacSlProductHierarchies().toArray()[0];

facSlProductHierarchy_u.setCreatedBy("snow");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}

//@Test
public void testFacSlSpecialTran() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlSpecialTran facSlSpecialTran_add=new FacSlSpecialTran();
FacSlSpecialTran facSlSpecialTran_add2=new FacSlSpecialTran();

facSlSpecialTran_add.setFacSublimit(facSublimit_add);
facSlSpecialTran_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.setFacSlSpecialTrans(new HashSet<FacSlSpecialTran>());
facSublimit_add2.setFacSlSpecialTrans(new HashSet<FacSlSpecialTran>());

facSublimit_add.getFacSlSpecialTrans().add(facSlSpecialTran_add);
facSublimit_add2.getFacSlSpecialTrans().add(facSlSpecialTran_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlSpecialTrans().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlSpecialTran facSlSpecialTran_u=new FacSlSpecialTran();
facSlSpecialTran_u = (FacSlSpecialTran) facSublimit_add2.getFacSlSpecialTrans().toArray()[0];

facSlSpecialTran_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);
//logger.info("...");
}
//@Test
public void testFacSlStif() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();
FacSublimit facSublimit_add2=new FacSublimit();

FacSlStif FacSlStif_add=new FacSlStif();
FacSlStif FacSlStif_add2=new FacSlStif();

FacSlStif_add.setFacSublimit(facSublimit_add);
FacSlStif_add2.setFacSublimit(facSublimit_add2);

facSublimit_add.setFacSlStifs(new HashSet<FacSlStif>());
facSublimit_add2.setFacSlStifs(new HashSet<FacSlStif>());

facSublimit_add.getFacSlStifs().add(FacSlStif_add);
facSublimit_add2.getFacSlStifs().add(FacSlStif_add2);

session.saveOrUpdate(facSublimit_add);
session.saveOrUpdate(facSublimit_add2);

//delete
facSublimit_add.getFacSlStifs().clear();
session.saveOrUpdate(facSublimit_add);

//update
FacSlStif facSlStif_u=new FacSlStif();
facSlStif_u = (FacSlStif) facSublimit_add2.getFacSlStifs().toArray()[0];

facSlStif_u.setCreatedBy("sjblue");
session.saveOrUpdate(facSublimit_add2);
session.delete(facSublimit_add);
session.delete(facSublimit_add2);

//logger.info("...");
}

//@Test
public void testFacSlTenor() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacSublimit facSublimit_add=new FacSublimit();

FacSlAmount facSlAmount_add=new FacSlAmount();
FacSlAmount facSlAmount_add2=new FacSlAmount();

facSlAmount_add.setFacSublimit(facSublimit_add);
facSlAmount_add2.setFacSublimit(facSublimit_add);

facSublimit_add.setFacSlAmounts(new HashSet<FacSlAmount>());

facSublimit_add.getFacSlAmounts().add(facSlAmount_add);
facSublimit_add.getFacSlAmounts().add(facSlAmount_add2);

FacSlTenor facSlTenor_add=new FacSlTenor();
FacSlTenor facSlTenor_add2=new FacSlTenor();

facSlTenor_add.setFacSlAmount(facSlAmount_add);
facSlTenor_add2.setFacSlAmount(facSlAmount_add2);

facSlAmount_add.getFacSlTenors(new HashSet<FacSlTenor>());
facSlAmount_add2.getFacSlTenors(new HashSet<FacSlTenor>);

facSlAmount_add.getFacSlTenors().add(facSlTenor_add);
facSlAmount_add2.getFacSlTenors().add(facSlTenor_add2);

session.saveOrUpdate(facSublimit_add);

//delete
// Query query = session.createQuery("from FacSublimit c where c.sublimitId=2");
// FacSublimit facSublimit_d=new FacSublimit();
// facSublimit_d = (FacSublimit) query.uniqueResult();
// FacSlAmount facSlAmount_d=(FacSlAmount)facSublimit_d.getFacSlAmounts().toArray()[0];
// FacSlTenor facSlTenor_d=new FacSlTenor();
// facSlTenor_d = (FacSlTenor) facSlAmount_d.getFacSlTenors().toArray()[0];
facSlAmount_add.getFacSlTenors().clear;
session.saveOrUpdate(facSublimit_add);

//update
FacSlTenor facSlTenor_u=new FacSlTenor();
facSlTenor_u = (FacSlTenor) facSlAmount_add2.getFacSlTenors().toArray()[0];

facSlTenor_u.setCreatedBy("sjblue");

session.saveOrUpdate(facSublimit_add);
session.delete(facSlAmount_add);
session.delete(facSlAmount_add2);
session.delete(facSublimit_add);

//logger.info("...");
}

//@Test
public void testFacLoanInfo() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacLoanInfo facLoanInfo_add=new FacLoanInfo();
FacLoanInfo facLoanInfo_add2=new FacLoanInfo();

facLoanInfo_add.setFacFacility(facFacility_add);
facLoanInfo_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacLoanInfo(new FacLoanInfo());
facFacility_add2.setFacLoanInfo(new FacLoanInfo());

facFacility_add.setFacLoanInfo(facLoanInfo_add);
facFacility_add2.setFacLoanInfo(facLoanInfo_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.setFacLoanInfo(null);
session.saveOrUpdate(facFacility_add);

//update
FacLoanInfo facLoanInfo_u=new FacLoanInfo();
facLoanInfo_u = (FacLoanInfo) facFacility_add2.getFacLoanInfo();

facLoanInfo_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}
//@Test
public void testFacSncClass() throws Exception {
//logger.info("...");
sessionFactory = (SessionFactory) context.getBean("rapidSessionFactory");
Session session = SessionFactoryUtils.getSession(sessionFactory, true);

//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacLoanInfo facLoanInfo_add=new FacLoanInfo();
FacLoanInfo facLoanInfo_add2=new FacLoanInfo();

facLoanInfo_add.setFacFacility(facFacility_add);
facLoanInfo_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacLoanInfo(new FacLoanInfo());
facFacility_add2.setFacLoanInfo(new FacLoanInfo());

facFacility_add.setFacLoanInfo(facLoanInfo_add);
facFacility_add2.setFacLoanInfo(facLoanInfo_add2);

FacSncClass facSncClasst_add=new FacSncClass();
FacSncClass facSncClasst_add2=new FacSncClass();

facSncClasst_add.setFacLoanInfo(facLoanInfo_add);
facSncClasst_add2.setFacLoanInfo(facLoanInfo_add2);

facLoanInfo_add.setFacSncClasses(new HashSet<FacSncClass>());
facLoanInfo_add2.setFacSncClasses(new HashSet<FacSncClass>());

facLoanInfo_add.getFacSncClasses().add(facSncClasst_add);
facLoanInfo_add2.getFacSncClasses().add(facSncClasst_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facLoanInfo_add.getFacSncClasses().clear();
session.saveOrUpdate(facFacility_add);

//update
FacSncClass facSncClasst_u=new FacSncClass();
facSncClasst_u=(FacSncClass) facLoanInfo_add2.getFacSncClasses().toArray()[0];
facSncClasst_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add2);

//logger.info("...");
}

//@Test
public void testFacSpecialTran() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacSpecialTran facSpecialTran_add=new FacSpecialTran();
FacSpecialTran facSpecialTran_add2=new FacSpecialTran();

facSpecialTran_add.setFacFacility(facFacility_add);
facSpecialTran_add2.setFacFacility(facFacility_add2);

facFacility_add.getFacSpecialTrans(new HashSet<FacSpecialTran>());
facFacility_add2.getFacSpecialTrans(new HashSet<FacSpecialTran>());

facFacility_add.getFacSpecialTrans().add(facSpecialTran_add);
facFacility_add2.getFacSpecialTrans().add(facSpecialTran_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacSpecialTrans().clear();
session.saveOrUpdate(facFacility_add);

//update
FacSpecialTran facSpecialTran_u=new FacSpecialTran();
facSpecialTran_u = (FacSpecialTran) facFacility_add2.getFacSpecialTrans().toArray()[0];

facSpecialTran_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);

//logger.info("...");

}

//@Test
public void testFacStif() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add

FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacStif facStif_add=new FacStif();
FacStif facStif_add2=new FacStif();

facStif_add.setFacFacility(facFacility_add);
facStif_add2.setFacFacility(facFacility_add2);

facFacility_add.getFacStifs(new HashSet<FacStif>());
facFacility_add2.getFacStifs(new HashSet<FacStif>());

facFacility_add.getFacStifs().add(facStif_add);
facFacility_add2.getFacStifs().add(facStif_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacStifs().clear();
session.saveOrUpdate(facFacility_add);

//update
FacStif facStif_u=new FacStif();
facStif_u = (FacStif) facFacility_add2.getFacStifs().toArray()[0];

facStif_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
//logger.info("...");
}

//@Test
public void testFacSupport() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacSupport facSupport_add=new FacSupport();
FacSupport facSupport_add2=new FacSupport();

facSupport_add.setProviderGfcid("l1");
facSupport_add2.setProviderGfcid("l2");

facSupport_add.setFacFacility(facFacility_add);
facSupport_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacSupports(new HashSet<FacSupport>());
facFacility_add2.setFacSupports(new HashSet<FacSupport>());

facFacility_add.getFacSupports().add(facSupport_add);
facFacility_add2.getFacSupports().add(facSupport_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.getFacSupports().clear();
session.saveOrUpdate(facFacility_add);

//update
FacSupport facSupport_u=new FacSupport();
facSupport_u = (FacSupport) facFacility_add2.getFacSupports().toArray()[0];

facSupport_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);

//logger.info("...");
}

//@Test
public void testFacTenor() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add
FacFacility facFacility_add=new FacFacility();

FacAmount facAmount_add=new FacAmount();
FacAmount facAmount_add2=new FacAmount();

facAmount_add.setFacFacility(facFacility_add);
facAmount_add2.setFacFacility(facFacility_add);

facFacility_add.setFacAmounts(new HashSet<FacAmount>());

facFacility_add.getFacAmounts().add(facAmount_add);
facFacility_add.getFacAmounts().add(facAmount_add2);

FacTenor facTenor_add=new FacTenor();
FacTenor facTenor_add2=new FacTenor();

facTenor_add.setFacAmount(facAmount_add);
facTenor_add2.setFacAmount(facAmount_add2);

facAmount_add.getFacTenors(new HashSet<FacTenor>());
facAmount_add2.getFacTenors(new HashSet<FacTenor>());

facAmount_add.getFacTenors().add(facTenor_add);
facAmount_add2.getFacTenors().add(facTenor_add2);

session.saveOrUpdate(facFacility_add);
//delete
facAmount_add.getFacTenors().clear();
session.saveOrUpdate(facFacility_add);


//update
FacTenor facTenor_u=new FacTenor();
facTenor_u=(FacTenor) facAmount_add2.getFacTenors().toArray()[0];

facTenor_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add);
session.delete(facFacility_add);
//logger.info("...");
}
//@Test
public void testFacTerminationReason() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacEarlyTermination facEarlyTermination_add=new FacEarlyTermination();
FacEarlyTermination facEarlyTermination_add2=new FacEarlyTermination();

facEarlyTermination_add.setFacFacility(facFacility_add);
facEarlyTermination_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacEarlyTermination(new FacEarlyTermination());
facFacility_add2.setFacEarlyTermination(new FacEarlyTermination());

facFacility_add.setFacEarlyTermination(facEarlyTermination_add);
facFacility_add2.setFacEarlyTermination(facEarlyTermination_add2);

FacTerminationReason facTerminationReason_add =new FacTerminationReason();
FacTerminationReason facTerminationReason_add2 =new FacTerminationReason();

facTerminationReason_add.setFacEarlyTermination(facEarlyTermination_add);
facTerminationReason_add2.setFacEarlyTermination(facEarlyTermination_add2);

facEarlyTermination_add.setFacTerminationReasons(new HashSet<FacTerminationReason>());
facEarlyTermination_add2.setFacTerminationReasons(new HashSet<FacTerminationReason>());

facEarlyTermination_add.getFacTerminationReasons().add(facTerminationReason_add);
facEarlyTermination_add2.getFacTerminationReasons().add(facTerminationReason_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facEarlyTermination_add.getFacTerminationReasons().clear();
session.saveOrUpdate(facFacility_add);
//update
FacTerminationReason facTerminationReason_u =new FacTerminationReason();
facTerminationReason_u=(FacTerminationReason) facEarlyTermination_add2.getFacTerminationReasons().toArray()[0];
facTerminationReason_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);

//logger.info("...");
}

//@Test
public void testFacEarlyTermination() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add
FacFacility facFacility_add=new FacFacility();
FacFacility facFacility_add2=new FacFacility();

FacEarlyTermination facEarlyTermination_add=new FacEarlyTermination();
FacEarlyTermination facEarlyTermination_add2=new FacEarlyTermination();

facEarlyTermination_add.setFacFacility(facFacility_add);
facEarlyTermination_add2.setFacFacility(facFacility_add2);

facFacility_add.setFacEarlyTermination(new FacEarlyTermination());
facFacility_add2.setFacEarlyTermination(new FacEarlyTermination());

facFacility_add.setFacEarlyTermination(facEarlyTermination_add);
facFacility_add2.setFacEarlyTermination(facEarlyTermination_add2);

session.saveOrUpdate(facFacility_add);
session.saveOrUpdate(facFacility_add2);

//delete
facFacility_add.setFacEarlyTermination(null);
session.saveOrUpdate(facFacility_add);

//update
FacEarlyTermination facEarlyTermination_u=new FacEarlyTermination();
facEarlyTermination_u=facFacility_add2.getFacEarlyTermination();
facEarlyTermination_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add2);
session.delete(facFacility_add);
session.delete(facFacility_add2);
// //logger.info("...");
}

//@Test
public void testFacUnitAmount() throws Exception {
//logger.info("...");
Session session = sessionFactory.openSession();
//add

FacFacility facFacility_add=new FacFacility();

FacApprovingUnit facApprovingUnit_add=new FacApprovingUnit("ljhjay1",facFacility_add);
FacApprovingUnit facApprovingUnit_add2=new FacApprovingUnit("ljhjay2",facFacility_add2);

facFacility_add.setFacApprovingUnits(new HashSet<FacApprovingUnit>());

facApprovingUnit_add.setFacFacility(facFacility_add);
facApprovingUnit_add2.setFacFacility(facFacility_add);

facFacility_add.getFacApprovingUnits().add(facApprovingUnit_add);
facFacility_add.getFacApprovingUnits().add(facApprovingUnit_add2)

FacUnitAmount facUnitAmount_add=new FacUnitAmount();
FacUnitAmount facUnitAmount_add2=new FacUnitAmount();

facUnitAmount_add.setFacApprovingUnit(facApprovingUnit_add);
facUnitAmount_add2.setFacApprovingUnit(facApprovingUnit_add2);

facApprovingUnit_add.setFacUnitAmounts(new HashSet<FacUnitAmount>());
facApprovingUnit_add2.setFacUnitAmounts(new HashSet<FacUnitAmount>());

facApprovingUnit_add.getFacUnitAmounts().add(facUnitAmount_add);
facApprovingUnit_add2.getFacUnitAmounts().add(facUnitAmount_add2);

session.saveOrUpdate(facFacility_add);

//delete
facApprovingUnit_add.getFacUnitAmounts().clear();
session.saveOrUpdate(facFacility_add);


//update
FacUnitAmount facUnitAmount_u=new FacUnitAmount();
facUnitAmount_u=(FacUnitAmount) facApprovingUnit_add2.getFacUnitAmounts().toArray()[0];

facUnitAmount_u.setCreatedBy("sjblue");
session.saveOrUpdate(facFacility_add);
session.delete(facFacility_add);
//logger.info("...");
}

}