// *************************************************************** // Function: GWLPDatabase // *************************************************************** #include "GWLPDatabase.h" #include "GWLPLog.h" #ifdef WIN32 #define WIN32_LEAN_AND_MEAN #include #endif GWLPDatabase::GWLPDatabase() { //Initialize our log file this->mQLog.SetFileHeader("GWLP Query Logger", "1.0"); this->mQLog.Open("Logs/Queries.txt", LOG_ALL); this->mQLog.SetSpecialDefaults(CATEGORY_OPT, SECTION_OPT, SECTION_OPT_OK, SECTION_OPT_FAIL); this->mQLog.SetLevelDefaults(DEBUG_TEXT, WARNING_TEXT, NOTICE_TEXT, ERROR_TEXT, ALWAYS_TEXT); this->mFreeReferenceId=2; this->mQueriesAdded=0; this->mQueriesProcessed=0; } void GWLPDatabase::Init() { } GWLPDatabase::~GWLPDatabase() { PrepareForShutdown(); mQLog.WriteCategory("Shutdown Initiated"); mQLog.notice("Queries Processed: %u/%u", this->mQueriesProcessed, this->mQueriesAdded); for (unsigned int i=0; i::iterator itr; for (itr=mPipes[i].threads.begin(); itr!=mPipes[i].threads.end(); itr++) { if ((*itr)->pErrorMessage!=NULL) { delete [] (*itr)->pErrorMessage; } if ((*itr)->pQuery!=NULL) { delete [] (*itr)->pQuery; } if ((*itr)->pResult!=NULL) { mysql_free_result((*itr)->pResult); } if ((*itr)->pThreadHandle!=NULL) { CloseHandle((*itr)->pThreadHandle); } delete (*itr); } mPipes[i].threads.clear(); } mPipes.clear(); mysql_library_end(); //Clean up the query queue list::iterator itr; for (itr=mQueue.begin(); itr!=mQueue.end(); itr++) { delete [] itr->pQuery; } mQueue.clear(); //Clean up the results hash_map::iterator itr2; for (itr2=mResults.begin(); itr2!=mResults.end(); itr2++) { if ((itr2)->second.pResult!=NULL) { mysql_free_result((itr2)->second.pResult); (itr2)->second.pResult=NULL; } } mResults.clear(); mQLog.warning("Shutdown."); mQLog.Close(); } //************************************ // Name: ResultsWaiting // // Are any results waiting to be processed? // // Parameters: // // Return: // unsigned long - Number of results waiting to be processed. //************************************ unsigned long GWLPDatabase::ResultsWaiting() { if (mResults.size()>0) { return (unsigned long)mResults.size(); } else { return 0; } } //************************************ // Name: AddQuery // // Add a query to be processed. // // Parameters: // pQuery - Query string // queryLength - Length of query // returnStatus - Will return a result with the status if true // showStatus - Will show the status of the query if it fails if true. // // Return: // - Query reference number //************************************ unsigned long GWLPDatabase::AddQuery(char* pQuery, long queryLength, bool returnStatus, bool showStatus) { QUERY q; //Decide what rule set this query follows //Check for no return result or result if (pQuery[0]=='S' || pQuery[1]=='s') { //if result //check length if (queryLength>=LENGTH_OF_LONG_QUERY && mPipes.size()>=4) { q.boundRule=LONG_RESULT; } else { q.boundRule=SHORT_RESULT; } } else { //if no result if (queryLength>=LENGTH_OF_LONG_QUERY && mPipes.size()>=3) { q.boundRule=LONG_NO_RESULT; } else { q.boundRule=SHORT_NO_RESULT; } } char* pQCopy=new char[queryLength+1]; memcpy(pQCopy, pQuery, queryLength+1); //Scan the query for control tags if (strstr(pQCopy, "@NOSTATUS")!=NULL) { char* noStatusLocation=strstr(pQCopy, "@NOSTATUS"); *noStatusLocation=0; queryLength-=9; q.showStatus=false; } q.pQuery=pQCopy; q.queryLength=queryLength+1; q.referenceId=this->mFreeReferenceId; q.deleteMe=false; q.returnStatus=returnStatus; this->mFreeReferenceId++; if (this->mFreeReferenceId>4, 000, 000, 000) { this->mFreeReferenceId=1; } mQueue.push_back(q); this->mQueriesAdded++; if (this->mQueriesAdded>4000000000){this->mQueriesAdded=0;} return q.referenceId; } //************************************ // Name: PrepareForShutdown // // Prepares the database class for shutdown. It will execute all remaining queries until returning. // // Parameters: // // Return: // //************************************ void GWLPDatabase::PrepareForShutdown() { while (true) { bool all_clear=true; for (unsigned int i=0; i0) { all_clear=false; } } if (!all_clear) { Update(); } else { break; } } } //************************************ // Name: Query // // Adds a query to be processed. // // Parameters: // pString - Query string // length - Query length // // Return: // - Query reference id //************************************ unsigned long GWLPDatabase::Query(char* pString, long length) { return AddQuery(pString, length, false, true); } unsigned long GWLPDatabase::Query(char* pString, long length, bool returnStatus) { return AddQuery(pString, length, returnStatus, true); } //************************************ // Name: StealMySQLResult // // Gets the mysql result for the specified query. // // Parameters: // reference - Reference number for query // // Return: // NOT NULL - MYSQL_RESULT* // NULL - No query exists or it hasn't been executed. //************************************ MYSQL_RES* GWLPDatabase::StealMySQLResult(unsigned long reference) { return mResults[reference].pResult; } //************************************ // Name: StealResult // // Gets the QUERY_RESULT for the specified query. // // Parameters: // reference - Query reference id // // Return: // NOT NULL - returns QUERY_RESULT // NULL - Query doesn't exist or has not been executed. //************************************ QUERY_RESULT* GWLPDatabase::StealResult(unsigned long reference) { hash_map::iterator itr=mResults.find(reference); if (itr!=mResults.end()) { return &itr->second; } return NULL; } //************************************ // Name: FreeResult // // Frees memory allocated for the query result. // // Parameters: // reference - Query reference id // // Return: // - true //************************************ bool GWLPDatabase::FreeResult(unsigned long reference) { QUERY_RESULT *pResult=&mResults[reference]; if (pResult->pResult!=NULL){mysql_free_result(pResult->pResult);} mResults.erase(reference); return true; } //************************************ // Name: EstablishConnections // // Establishes connections to the specified database server. // // Parameters: // pHost - Host name to connect to. // pUsername - Database user name. // pPassword - Password for the database user name. // pDatabaseName - Name of the database to use. // port - Port the database server is listening on. // numConnections - Number of connections to establish. // // Return: // true - Connections successful // false - Connection failed //************************************ bool GWLPDatabase::EstablishConnections(char* pHost, char* pUsername, char* pPassword, char* pDatabaseName, long port, short numConnections) { if (numConnections<=0) { return false; } if (numConnections>20) { numConnections=20; } //Connect to the database X amount of times for (int i=0; i