Marie.o at 08:23, 14 January 2010

2010-01-14T08:23:36Z

←Older revision		Revision as of 08:23, 14 January 2010
Line 1:		Line 1:
			[[Category:Programmer's Guide]]
			{{NeedsToBeFixed}}
	==GAMEROM.h==		==GAMEROM.h==
	<pre>		<pre>
Line 239:		Line 241:
	}		}
	</pre>		</pre>

	~~[[Category:Programmer's Guide]]~~

Tschak909: Fix category.

2009-07-23T08:43:40Z

Fix category.

←Older revision		Revision as of 08:43, 23 July 2009
Line 240:		Line 240:
	</pre>		</pre>

	[[Category:~~Programmers~~ Guide]]		[[Category:Programmer's Guide]]

Tschak909: formatting fix.

2009-07-23T08:43:04Z

formatting fix.

←Older revision		Revision as of 08:43, 23 July 2009
Line 238:		Line 238:
	return "NOMATCH";		return "NOMATCH";
	}		}
			</pre>

	[[Category:Programmers Guide]]		[[Category:Programmers Guide]]

Tschak909: Initial Content.

2009-07-23T08:41:54Z

Initial Content.

New page

==GAMEROM.h==
<pre>
/****************************************/
/* GAMEROM - Class to return metadata */
/* For a given GAME ROM. */
/* */
/* @author <thom.cherryhomes@gmail.com> */
/****************************************/

#define GAME_RELEASE 0.122u7

#include <string>
#include <map>
#include <iostream>

/* sql2cpp classes */
#include "lmce_game/Database_lmce_game.h"
#include "lmce_game/Define_RomAttributeType.h"
#include "lmce_game/Define_Rom_RomAttribute.h"
#include "lmce_game/TableRow.h"
#include "lmce_game/Table_RomAttributeType.h"
#include "lmce_game/Table_Rom_RomAttribute.h"
#include "lmce_game/Define_RomAttribute.h"
#include "lmce_game/Define_Rom.h"
#include "lmce_game/Define_GameSystem.h"
#include "lmce_game/Table_RomAttribute.h"
#include "lmce_game/Table_Rom.h"
#include "lmce_game/Table_GameSystem.h"

#include "DCE/Logger.h"
#include "PlutoUtils/DBHelper.h"

using namespace std;

class GAMEROM
{

public:

map<string,string> mRomTitleList, mRomYearList, mRomManufacturerList, mRomList, mRomGenreList;
Database_lmce_game *m_pMyDatabase;

string getTitleForROM(string sROMName);
string getYearForROM(string sROMName);
string getManufacturerForROM(string sROMName);
string getGenreForROM(string sROMName);
void InitDatabase();

GAMEROM();
virtual ~GAMEROM();

};
</pre>
==GAMEROM.cpp==
<pre>
/****************************************/
/* GAMEROM - Class to return metadata */
/* For a given GAME ROM. */
/* */
/* @author <thom.cherryhomes@gmail.com> */
/****************************************/

#include "GAMEROM.h"

GAMEROM::GAMEROM()
{

}

GAMEROM::~GAMEROM()
{
}

void GAMEROM::InitDatabase()
{
LoggerWrapper::GetInstance()->Write(LV_STATUS,"GAMEROM::InitDatabase() start");
m_pMyDatabase = new Database_lmce_game(LoggerWrapper::GetInstance());
m_pMyDatabase->Connect("localhost","root","","lmce_game",3306);
LoggerWrapper::GetInstance()->Write(LV_STATUS,"GAMEROM::InitDatabase() successful.");
}

string GAMEROM::getTitleForROM(string sROMName)
{
Row_Rom *pRow_Rom;
Row_RomAttribute *pRow_RomAttribute;
vector<class Row_Rom *> v_Rom;
vector<class Row_Rom_RomAttribute *> v_Rom_RomAttributes;
string sRomName = sROMName + ".zip";
string s_WhereQuery = "WHERE Romname = '"+sRomName+"'";

if (!m_pMyDatabase->Rom_get()->GetRows(s_WhereQuery,&v_Rom))
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

if (v_Rom.size() == 0)
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

pRow_Rom = m_pMyDatabase->Rom_get()->GetRow(v_Rom[0]->PK_Rom_get());
pRow_Rom->Rom_RomAttribute_FK_Rom_getrows(&v_Rom_RomAttributes);

// Iterate through the resulting matching RomAttributes for a Rom
for (unsigned int i=0;i<v_Rom_RomAttributes.size();i++)
{
pRow_RomAttribute = m_pMyDatabase->RomAttribute_get()->GetRow(v_Rom_RomAttributes[i]->FK_RomAttribute_get());
if (pRow_RomAttribute-> FK_RomAttributeType_get() == ROMATTRIBUTETYPE_title_CONST)
{
return pRow_RomAttribute->Name_get();
}
}

// Nothing was found, return a message.
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not Find Title RomAttribute for ROMName: %s",sRomName.c_str());
return "NOMATCH";

}

string GAMEROM::getYearForROM(string sROMName)
{
Row_Rom *pRow_Rom;
Row_RomAttribute *pRow_RomAttribute;
vector<class Row_Rom *> v_Rom;
vector<class Row_Rom_RomAttribute *> v_Rom_RomAttributes;
string sRomName = sROMName + ".zip";
string s_WhereQuery = "WHERE Romname = '"+sRomName+"'";

if (!m_pMyDatabase->Rom_get()->GetRows(s_WhereQuery,&v_Rom))
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

if (v_Rom.size() == 0)
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

pRow_Rom = m_pMyDatabase->Rom_get()->GetRow(v_Rom[0]->PK_Rom_get());
pRow_Rom->Rom_RomAttribute_FK_Rom_getrows(&v_Rom_RomAttributes);

// Iterate through the resulting matching RomAttributes for a Rom
for (unsigned int i=0;i<v_Rom_RomAttributes.size();i++)
{
pRow_RomAttribute = m_pMyDatabase->RomAttribute_get()->GetRow(v_Rom_RomAttributes[i]->FK_RomAttribute_get());
if (pRow_RomAttribute-> FK_RomAttributeType_get() == ROMATTRIBUTETYPE_year_CONST)
{
return pRow_RomAttribute->Name_get();
}
}

// Nothing was found, return a message.
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not Find Year RomAttribute for ROMName: %s",sRomName.c_str());
return "NOMATCH";

}

string GAMEROM::getManufacturerForROM(string sROMName)
{
Row_Rom *pRow_Rom;
Row_RomAttribute *pRow_RomAttribute;
vector<class Row_Rom *> v_Rom;
vector<class Row_Rom_RomAttribute *> v_Rom_RomAttributes;
string sRomName = sROMName + ".zip";
string s_WhereQuery = "WHERE Romname = '"+sRomName+"'";

if (!m_pMyDatabase->Rom_get()->GetRows(s_WhereQuery,&v_Rom))
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

if (v_Rom.size() == 0)
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

pRow_Rom = m_pMyDatabase->Rom_get()->GetRow(v_Rom[0]->PK_Rom_get());
pRow_Rom->Rom_RomAttribute_FK_Rom_getrows(&v_Rom_RomAttributes);

// Iterate through the resulting matching RomAttributes for a Rom
for (unsigned int i=0;i<v_Rom_RomAttributes.size();i++)
{
pRow_RomAttribute = m_pMyDatabase->RomAttribute_get()->GetRow(v_Rom_RomAttributes[i]->FK_RomAttribute_get());
if (pRow_RomAttribute-> FK_RomAttributeType_get() == ROMATTRIBUTETYPE_manufacturer_CONST)
{
return pRow_RomAttribute->Name_get();
}
}

// Nothing was found, return a message.
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not Find Manufacturer RomAttribute for ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

string GAMEROM::getGenreForROM(string sROMName)
{
Row_Rom *pRow_Rom;
Row_RomAttribute *pRow_RomAttribute;
vector<class Row_Rom *> v_Rom;
vector<class Row_Rom_RomAttribute *> v_Rom_RomAttributes;
string sRomName = sROMName + ".zip";
string s_WhereQuery = "WHERE Romname = '"+sRomName+"'";

if (!m_pMyDatabase->Rom_get()->GetRows(s_WhereQuery,&v_Rom))
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

if (v_Rom.size() == 0)
{
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not get Rom matching ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

pRow_Rom = m_pMyDatabase->Rom_get()->GetRow(v_Rom[0]->PK_Rom_get());
pRow_Rom->Rom_RomAttribute_FK_Rom_getrows(&v_Rom_RomAttributes);

// Iterate through the resulting matching RomAttributes for a Rom
for (unsigned int i=0;i<v_Rom_RomAttributes.size();i++)
{
pRow_RomAttribute = m_pMyDatabase->RomAttribute_get()->GetRow(v_Rom_RomAttributes[i]->FK_RomAttribute_get());
if (pRow_RomAttribute-> FK_RomAttributeType_get() == ROMATTRIBUTETYPE_genre_CONST)
{
return pRow_RomAttribute->Name_get();
}
}

// Nothing was found, return a message.
LoggerWrapper::GetInstance()->Write(LV_CRITICAL,"Could not Find Genre RomAttribute for ROMName: %s",sRomName.c_str());
return "NOMATCH";
}

[[Category:Programmers Guide]]

Gamerom - Revision history

Marie.o at 08:23, 14 January 2010

Tschak909: Fix category.

Tschak909: formatting fix.

Tschak909: Initial Content.