public CTest_SelectQry()
: base("Platform", "", "")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cSelWhere);
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cSelRead);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cSelRead);
}
public CQryWritePlatforms()
: base("Platform", "", "")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cUpdWhere | QryFlag.cDelWhere);
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cUpdWrite | QryFlag.cInsWrite);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cUpdWrite | QryFlag.cInsWrite);
}
public CTest_AdvancedLikeQry()
: base("Platform", "(& LIKE '%?%')", "")
{
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cSelRead);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cSelRead);
}
public CTest_AdvancedGreaterThanQry()
: base("Platform", "(& > ?)", "ORDER BY PlatformID DESC")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cSelRead);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cSelRead);
}
public CTest_InsertQry()
: base("Platform", "", "")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cInsWrite);
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cInsWrite);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cInsWrite);
}
public CQryReadPlatforms()
: base(
"Platform " +
"LEFT JOIN Game G on PlatformID = G.PlatformFK",
"", " GROUP BY PlatformID")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cSelWhere);
m_sqlRow["Name"] = new CSqlFieldString("Name", QryFlag.cSelRead);
m_sqlRow["GameCount"] = new CSqlFieldString("COUNT(G.GameID) as GameCount", QryFlag.cSelRead);
}
public CQryGame() : base("Game", "", "")
{
m_sqlRow["GameID"] = new CSqlFieldInteger("GameID", QryFlag.cSelRead | QryFlag.cWhere);
m_sqlRow["PlatformFK"] = new CSqlFieldInteger("PlatformFK", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cWhere);
m_sqlRow["Identifier"] = new CSqlFieldString("Identifier", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["Title"] = new CSqlFieldString("Title", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Alias"] = new CSqlFieldString("Alias", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Launch"] = new CSqlFieldString("Launch", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["Uninstall"] = new CSqlFieldString("Uninstall", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["IsInstalled"] = new CSqlFieldBoolean("IsInstalled", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["IsFavourite"] = new CSqlFieldBoolean("IsFavourite", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["IsNew"] = new CSqlFieldBoolean("IsNew", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["IsHidden"] = new CSqlFieldBoolean("IsHidden", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Frequency"] = new CSqlFieldDouble("Frequency", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["Rating"] = new CSqlFieldInteger("Rating", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["NumRuns"] = new CSqlFieldInteger("NumRuns", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["LastRun"] = new CSqlFieldString("LastRun", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["Icon"] = new CSqlFieldString("Icon", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["Tags"] = new CSqlFieldString("Tags", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cInsWrite | QryFlag.cSelRead);
m_sqlRow["IsMultiPlatform"] = new CSqlFieldBoolean("IsMultiPlatform", QryFlag.cInsWrite | QryFlag.cSelRead | QryFlag.cSelWhere);
}
public CTest_UpdateQry()
: base("Platform", "", "")
{
m_sqlRow["PlatformID"] = new CSqlFieldInteger("PlatformID", QryFlag.cUpdWhere);
m_sqlRow["Description"] = new CSqlFieldString("Description", QryFlag.cUpdWrite);
}
public CQryGameFuzzySearch() : base("Game", "(& = ?) AND (& LIKE '%?%')", "")
{
m_sqlRow["PlatformFK"] = new CSqlFieldInteger("PlatformFK", QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["Title"] = new CSqlFieldString("Title", QryFlag.cSelRead | QryFlag.cSelWhere);
m_sqlRow["GameID"] = new CSqlFieldInteger("GameID", QryFlag.cSelRead);
}