Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.96 KB | None | 0 0
  1.     mysqlpp::Query updateQuery = this->getQuery();
  2.     updateQuery << "INSERT INTO `database_backendsocket` ( `database` , `backend` ) VALUES ( ( SELECT DISTINCT `database`.`id` FROM `database` WHERE `database`.`inetaddress` = 'localhost' ) , ( SELECT DISTINCT `backend`.`id` FROM `backend` WHERE `backend`.`inetaddress` = " << mysqlpp::quote << serverGuardian->GetSockAddress() << " ) );";
  3.  
  4.     try {
  5.  
  6.  
  7.         if( ( updateQuery.execute() ).rows() == 1 ) {
  8.  
  9.             return "valid";
  10.  
  11.         }
  12.         else
  13.         {
  14.  
  15.             return "invalid";
  16.  
  17.         }
  18.  
  19.     }
  20.     catch( const mysqlpp::BadQuery &exception ) {
  21.  
  22.         this->addWarningToLog( std::string( exception.what() ) + " using query: " + updateQuery.str() );
  23.         return "invalid";
  24.  
  25.     }
  26.     catch( const mysqlpp::Exception &exception ) {
  27.  
  28.         this->addErrorToLog( std::string( exception.what() ) + " using query: " + updateQuery.str() );
  29.         return "invalid";
  30.        
  31.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement