queryLiveRoomStock 接口

package com.tougu.apitest.LiveRoom;


import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;


import org.json.JSONException;
import org.json.JSONObject;
import org.testng.annotations.Test;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.AfterClass;


import com.al.api.net.HttpFactory;
import com.al.api.test.base.APIBase;
import com.al.common.config.JDBCDriver;
import com.al.core.annotation.DataFactory;
import com.al.core.dataprovider.ProviderFactory;
import com.al.core.nassert.NAssert;
import com.al.core.report.NReporter;
import com.al.db.DbUtils;
import com.google.common.collect.Maps;
import com.pazq.apitest.common.LoginCommonMethods;





@DataFactory(dataPathKey="LiveRoom")
public class QueryLiveRoomStock extends APIBase{


  @BeforeClass
  public void beforeClass() {
  }


  @Test(dataProvider = "ExcelRowsDP", dataProviderClass = ProviderFactory.class)
  @DataFactory(dataName = "normal", author = "张瑞", category = "直播间自选股接口")
  public void queryLiveRoomStock(Map<String,String> caseData) {
 
 String tokenId="";
 String appName="";
 if(caseData.get("tokenId").equals("null")&&!caseData.get("description").contains("不传tokenId")){
 //用户先通过统一登录获取对应的tokenId
 Map<String, String> data = Maps.newHashMap();
 data.put("account", conf.get("account"));
 data.put("pwd", conf.get("pwd"));
 data.put("servername", "login");
 data.put("appName", conf.get("appName"));
 data.put("appChannel",conf.get("appChannel"));
 data.put("kbChannel", conf.get("kbChannel"));
 
 tokenId=LoginCommonMethods.loginByAccount(conf.get("loginCommonUrl"), data);
 }else{
 tokenId=caseData.get("tokenId");
 }
 
 if(caseData.get("appName").equals("null")){
 appName=conf.get("appName");
 }else{
 appName=caseData.get("appName");
 }
 
 //构造请求体
 Map<String,String> data1= Maps.newHashMap();
 data1.put("appName", appName);
 data1.put("tokenId", tokenId);
 data1.put("idLiveRoom", caseData.get("idLiveRoom"));
 data1.put("objectsPerPage", caseData.get("objectsPerPage"));
 data1.put("pageNumber", caseData.get("pageNumber"));
 
//发送请求
 HttpFactory hf = HttpFactory.newInstance();
 hf.post(conf.get("LiveRoomCommonUrl")+conf.get("queryLiveRoomStock"), data1);
 
//校验返回信息
 checkPoint(hf,caseData);
 
  }
  
  public void checkPoint(HttpFactory hf,Map<String, String> caseData) {
String liveRoomId=caseData.get("idLiveRoom");
JSONObject jo = new JSONObject(hf.getResponse());
if(hf.getStatus()==200){

if(jo.getString("responseCode").equals("0")){
 NAssert.assertEquals(hf.getStatus(), 200, "验证请求状态码");
 int listSize=Integer.valueOf(caseData.get("objectsPerPage"));
//  NAssert.assertEquals(getJsonString(jo,"responseCode"), caseData.get("responseCode"), "校验responseCode");
 NAssert.assertEquals(jo.getString("responseCode"), caseData.get("responseCode"), "校验responseCode");
 Connection conuserdb = DbUtils.getConnection(JDBCDriver.ORACLE, conf.get("livedburl"), conf.get("livedbuser"), conf.get("livedbpsw"));
 int listSize1=jo.getJSONArray("list").length();
 //对返回list校验
 if(listSize1>0){
 NAssert.assertEquals(listSize1,listSize,"校验每页展示条数");
 for(int i=0;i<listSize1;i++){
 String stockId=jo.getJSONArray("list").getJSONObject(i).getString("idStock");
  
 NReporter.info("查询数据库信息");
 String sql1="select count(*) as count from omm_mop_liveroom_stock m where m.live_room_id='"+liveRoomId+"' and m.status=02 and m.date_release is not null order by m.date_release desc";
 NReporter.info("执行SQL语句：" + sql1);
 ResultSet rs2 = DbUtils.getResultSet(conuserdb, sql1);
 try {
 while(rs2.next()){
 int j=Integer.valueOf(rs2.getString("count"));
NAssert.assertEquals(jo.getInt("totalSize"),j );
 }

 }catch(SQLException e){
e.printStackTrace();
 }finally{
 try {
rs2.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
 }
String sql="select m.id_stock as id_stock,m.stock_code as stock_code,m.stock_name as stock_name,m.market_type as market_type from omm_mop_liveroom_stock m where m.live_room_id='"+liveRoomId+"' and m.id_stock='"+stockId+"' and m.date_release is not null order by m.date_release desc";
 NReporter.info("执行SQL语句：" + sql);
 ResultSet rs1 = DbUtils.getResultSet(conuserdb, sql);
 try {
while(rs1.next()){
NAssert.assertEquals(jo.getJSONArray("list").getJSONObject(i).getString("stockCode"), rs1.getString("STOCK_CODE")); 
NAssert.assertEquals(jo.getJSONArray("list").getJSONObject(i).getString("stockName"), rs1.getString("STOCK_NAME"));
NAssert.assertEquals(jo.getJSONArray("list").getJSONObject(i).getString("marketType"), rs1.getString("MARKET_TYPE"));
 }
 }catch(JSONException | SQLException e){
 e.printStackTrace();
 }finally{
 try {
rs1.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
 }
 }
 DbUtils.closeConnection(conuserdb);
}
}else{
NAssert.assertEquals(jo.getString("responseCode"), caseData.get("responseCode"), "校验responseCode");
NAssert.assertEquals(jo.getString("responseMsg"), caseData.get("responseMsg"), "校验responseMsg");
}
 
 } else{
 NAssert.assertEquals(hf.getStatus(), 400, "验证请求状态码");
 }
}
  
  @AfterClass
  public void afterClass() {
  }


}