Category

Development Platform
Home > SourceCode/Document > Game Program > Game Server Simulator > View Code
S3PTestCardInfoDAO.cpp
Package: SwordOnline.rar　[view]
Upload User: dzyhzl
Upload Date: 2019-04-29
Package Size: 56270k
Code Size: 3k
Category:

Game Server Simulator

Development Platform:

C/C++

S3PTestCardInfoDAO.cpp：Code Content
  1. // S3PTestCardInfoDAO.cpp: implementation of the S3PTestCardInfoDAO class.
  2. //
  3. //////////////////////////////////////////////////////////////////////
  5. #include "S3PTestCardInfoDAO.h"
  7. #include "S3PDBConnection.h"
  8. #include "S3PRow.h"
  9. #include "S3PCardInfoDAO.h"
  10. #include "S3PDBConnector.h"
  11. //////////////////////////////////////////////////////////////////////
  12. // Construction/Destruction
  13. //////////////////////////////////////////////////////////////////////
  15. S3PTestCardInfoDAO::~S3PTestCardInfoDAO()
  16. {
  18. }
  20. void S3PTestCardInfoDAO::testAdd()
  21. {
  22. S3PDBConnection* pCardCon = // 连接角色数据库
  23. S3PDBConnector::Instance()->ApplyDBConnection( def_CARDDB );
  25. if (NULL != pCardCon)
  26. {
  27. S3PCardInfoDAO card(pCardCon);
  28. ColumnAndValue cav;
  30. cav["cCardCode"] = "001";
  31. cav["cCardPassWord"] = "1111";
  32. cav["iFlag"]="1";
  33. cav["iHoldSecond"]="1000";
  34. cav["iHoldMonth"]="6";
  36. S3PRow row(card.GetTableName(), &cav, pCardCon);
  37. if ( card.Add(&row) <= 0 )
  38. {
  39. assert(false);
  40. }
  42. pCardCon->Close();
  43. }
  44. }
  46. void S3PTestCardInfoDAO::testUpdate()
  47. {
  48. /* S3PDBConnection* pCardCon = // 连接角色数据库
  49. S3PDBConnector::Instance()->ApplyDBConnection( def_CARDDB );
  50. if (NULL != pCardCon)
  51. {
  52. S3PCardInfoDAO card(pCardCon);
  53. ColumnAndValue cav,cavWhere;
  54. cav["cCardPassWord"] = "101010";
  55. cavWhere["cCardCode"] = "001";
  56. S3PRow row(card.GetTableName(), &cav,pCardCon);
  57. S3PRow rowWhere(card.GetTableName(),&cavWhere,pCardCon);
  58. card.Update(&row,&rowWhere);
  59. S3PResult * res;
  60. std::string strQuery;
  61. strQuery = "select * from cardinfo where ccardcode like '001' ";
  62. card.GetCardInfoResult(strQuery,res);
  63. if ( res->rows() != 1)
  64. {
  65. assert(false);
  66. }
  67. else
  68. {
  69. ColumnAndValue cavPassWord;
  70. cavPassWord = ( * res )[0];
  71. if ( cavPassWord["ccardpassword"] != "101010" )
  72. {
  73. assert( false );
  74. }
  75. }
  77. pCardCon->Close();
  78. }*/
  79. }
  81. void S3PTestCardInfoDAO::testDelete()
  82. {
  83. S3PDBConnection* pCardCon = // 连接角色数据库
  84. S3PDBConnector::Instance()->ApplyDBConnection( def_CARDDB );
  86. if (NULL != pCardCon)
  87. {
  88. S3PCardInfoDAO card(pCardCon);
  89. ColumnAndValue cav;
  91. cav["cCardCode"] = "001";
  92. //cav["cCardPassWord"] = "1111";
  93. //cav["iFlag"]="1";
  94. //cav["iHoldSecond"]="1000";
  95. //cav["iHoldMonth"]="6";
  97. S3PRow row(card.GetTableName(), &cav, pCardCon);
  98. if ( card.Delete(& row) <= 0 )
  99. {
  100. assert(false);
  101. }
  103. pCardCon->Close();
  104. }
  105. }
  108. Test *S3PTestCardInfoDAO::suite ()
  109. {
  110. TestSuite *testSuite = new TestSuite ("Test CardInfo Table Manipulator");
  112. testSuite->addTest (new TestCaller <S3PTestCardInfoDAO> ("testCardInfoAdd", testAdd));
  113.     testSuite->addTest (new TestCaller <S3PTestCardInfoDAO> ("testCardInfoUpdate", testUpdate));
  114.     testSuite->addTest (new TestCaller <S3PTestCardInfoDAO> ("testCardInfoDelete", testDelete));
  115.     
  116. return testSuite;
  117. }
  119. void S3PTestCardInfoDAO::setUp()
  120. {
  121. }