package com.tougu.apitest.LiveRoom;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Map;
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.Configuration;
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.alibaba.fastjson.JSON;
import com.google.common.collect.Maps;
import com.pazq.apitest.common.LoginCommonMethods;
@DataFactory(dataPathKey = "LiveRoom")
public class QueryMyInvestmentAdvisory extends APIBase{
@BeforeClass
public void beforeClass() {
}
@Test(dataProvider = "ExcelRowsDP", dataProviderClass = ProviderFactory.class)
@DataFactory(dataName = "normal", author = "DD", category = "查询我的投顾信息")
public void queryMyInvestmentAdvisory(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");
}
// //构造请求体
// JSONObject js=new JSONObject();
// js.put("appName", conf.get("appName"));
// js.put("tokenId", tokenId);
//
// // 发送请求
// HttpFactory hf = HttpFactory.newInstance();
// hf.post(conf.get("LiveRoomCommonUrl")+conf.get("queryMyInvestMentAdvisory"), js.toString());
caseData.put("appName", appName);
caseData.put("tokenId", tokenId);
HttpFactory hf = HttpFactory.newInstance();
hf.get(conf.get("LiveRoomCommonUrl")+conf.get("queryMyInvestMentAdvisory"),caseData,"appName","tokenId");
//校验返回信息
checkPoint(hf, caseData);
}
public void checkPoint(HttpFactory hf,Map<String, String> caseData) {
String liveRoomId="";
JSONObject jo = new JSONObject(hf.getResponse());
if(hf.getStatus()==200){
NAssert.assertEquals(hf.getStatus(), 200, "验证请求状态码");
NAssert.assertEquals(jo.getString("responseCode"), caseData.get("responseCode"), "校验responseCode");
// NAssert.assertEquals(getJsonString(jo,"responseCode"), caseData.get("responseCode"), "校验responseCode");
if(jo.getString("responseCode").equals("0")){
Connection conuserdb = DbUtils.getConnection(JDBCDriver.ORACLE, conf.get("livedburl"), conf.get("livedbuser"), conf.get("livedbpsw"));
//对返回List的校验
int length=(jo.getJSONObject("result").getJSONArray("list")).length();
for(int i=0;i<length;i++){
liveRoomId=(jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i).getString("idLiveRoom");
NReporter.info(liveRoomId);
NReporter.info("查询数据库信息");
String sql="select oml.id_liveroom as idLiveRoom,oml.LIVE_ROOM_TYPE as liveRoomType, oml.room_vip_type as roomVipType,oml.adviser_manager as adviserManager, decode(nvl(oml.IS_MORE_INVESTMENT,'1'),'1',(select u.adviser_manager_cover from omm_mop_user_role u where u.is_liveroom='01'and u.user_um=oml.adviser_manager_um),'0',oml.image_url) as imageUrl,"+
"(select count(sf.id_follow) from sis_live_follow_adviser sf "+
"inner join omm_mop_unionid mu on mu.union_id=sf.follow_adviser_uid "+
"where mu.user_um=oml.adviser_manager_um and sf.follow_status='01') as numFans from omm_mop_liveroom_info oml where oml.status='00' and oml.is_effective='01' and oml.id_liveroom='"+liveRoomId+"' and oml.adviser_manager_um in (select distinct mu.user_um from sis_live_follow_adviser sf "+
"inner join omm_mop_unionid mu on mu.union_id=sf.follow_adviser_uid where sf.follow_status='01')";
NReporter.info("执行SQL语句:" + sql);
ResultSet rs = DbUtils.getResultSet(conuserdb, sql);
try{
while(rs.next()){
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"adviserManager"), rs.getString("ADVISERMANAGER"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"roomVipType"), rs.getString("ROOMVIPTYPE"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"numFans"), rs.getString("NUMFANS"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"imageUrl"), rs.getString("IMAGEURL"));
}
}catch(SQLException e){
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.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"), "校验responseCode");
}
}
private String getJsonString(JSONObject jo,String key){
if(jo.get(key) instanceof String){
return jo.getString(key);
}else{
return null;
}
}
@AfterClass
public void afterClass() {
}
}
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Map;
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.Configuration;
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.alibaba.fastjson.JSON;
import com.google.common.collect.Maps;
import com.pazq.apitest.common.LoginCommonMethods;
@DataFactory(dataPathKey = "LiveRoom")
public class QueryMyInvestmentAdvisory extends APIBase{
@BeforeClass
public void beforeClass() {
}
@Test(dataProvider = "ExcelRowsDP", dataProviderClass = ProviderFactory.class)
@DataFactory(dataName = "normal", author = "DD", category = "查询我的投顾信息")
public void queryMyInvestmentAdvisory(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");
}
// //构造请求体
// JSONObject js=new JSONObject();
// js.put("appName", conf.get("appName"));
// js.put("tokenId", tokenId);
//
// // 发送请求
// HttpFactory hf = HttpFactory.newInstance();
// hf.post(conf.get("LiveRoomCommonUrl")+conf.get("queryMyInvestMentAdvisory"), js.toString());
caseData.put("appName", appName);
caseData.put("tokenId", tokenId);
HttpFactory hf = HttpFactory.newInstance();
hf.get(conf.get("LiveRoomCommonUrl")+conf.get("queryMyInvestMentAdvisory"),caseData,"appName","tokenId");
//校验返回信息
checkPoint(hf, caseData);
}
public void checkPoint(HttpFactory hf,Map<String, String> caseData) {
String liveRoomId="";
JSONObject jo = new JSONObject(hf.getResponse());
if(hf.getStatus()==200){
NAssert.assertEquals(hf.getStatus(), 200, "验证请求状态码");
NAssert.assertEquals(jo.getString("responseCode"), caseData.get("responseCode"), "校验responseCode");
// NAssert.assertEquals(getJsonString(jo,"responseCode"), caseData.get("responseCode"), "校验responseCode");
if(jo.getString("responseCode").equals("0")){
Connection conuserdb = DbUtils.getConnection(JDBCDriver.ORACLE, conf.get("livedburl"), conf.get("livedbuser"), conf.get("livedbpsw"));
//对返回List的校验
int length=(jo.getJSONObject("result").getJSONArray("list")).length();
for(int i=0;i<length;i++){
liveRoomId=(jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i).getString("idLiveRoom");
NReporter.info(liveRoomId);
NReporter.info("查询数据库信息");
String sql="select oml.id_liveroom as idLiveRoom,oml.LIVE_ROOM_TYPE as liveRoomType, oml.room_vip_type as roomVipType,oml.adviser_manager as adviserManager, decode(nvl(oml.IS_MORE_INVESTMENT,'1'),'1',(select u.adviser_manager_cover from omm_mop_user_role u where u.is_liveroom='01'and u.user_um=oml.adviser_manager_um),'0',oml.image_url) as imageUrl,"+
"(select count(sf.id_follow) from sis_live_follow_adviser sf "+
"inner join omm_mop_unionid mu on mu.union_id=sf.follow_adviser_uid "+
"where mu.user_um=oml.adviser_manager_um and sf.follow_status='01') as numFans from omm_mop_liveroom_info oml where oml.status='00' and oml.is_effective='01' and oml.id_liveroom='"+liveRoomId+"' and oml.adviser_manager_um in (select distinct mu.user_um from sis_live_follow_adviser sf "+
"inner join omm_mop_unionid mu on mu.union_id=sf.follow_adviser_uid where sf.follow_status='01')";
NReporter.info("执行SQL语句:" + sql);
ResultSet rs = DbUtils.getResultSet(conuserdb, sql);
try{
while(rs.next()){
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"adviserManager"), rs.getString("ADVISERMANAGER"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"roomVipType"), rs.getString("ROOMVIPTYPE"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"numFans"), rs.getString("NUMFANS"));
NAssert.assertEquals(getJsonString((jo.getJSONObject("result").getJSONArray("list")).getJSONObject(i),"imageUrl"), rs.getString("IMAGEURL"));
}
}catch(SQLException e){
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.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"), "校验responseCode");
}
}
private String getJsonString(JSONObject jo,String key){
if(jo.get(key) instanceof String){
return jo.getString(key);
}else{
return null;
}
}
@AfterClass
public void afterClass() {
}
}