public PyDataType GetBillTypes(CallInformation call)
{
this.CacheStorage.Load(
"billMgr",
"GetBillTypes",
"SELECT billTypeID, billTypeName, description FROM billTypes",
CacheStorage.CacheObjectType.Rowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("billMgr", "GetBillTypes");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetWarFactions(CallInformation call)
{
this.CacheStorage.Load(
"facWarMgr",
"GetWarFactions",
"SELECT factionID, militiaCorporationID FROM chrFactions WHERE militiaCorporationID IS NOT NULL",
CacheStorage.CacheObjectType.IntIntDict
);
PyDataType cacheHint = this.CacheStorage.GetHint("facWarMgr", "GetWarFactions");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetNPCNPCStandings(CallInformation call)
{
this.CacheStorage.Load(
"standing2",
"GetNPCNPCStandings",
"SELECT fromID, toID, standing FROM npcStandings",
CacheStorage.CacheObjectType.Rowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("standing2", "GetNPCNPCStandings");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetCertificateClasses(CallInformation call)
{
this.CacheStorage.Load(
"certificateMgr",
"GetCertificateClasses",
"SELECT classID, className, description, 0 AS dataID FROM crtClasses",
CacheStorage.CacheObjectType.IndexRowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("certificateMgr", "GetCertificateClasses");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetAllShipCertificateRecommendations(CallInformation call)
{
this.CacheStorage.Load(
"certificateMgr",
"GetAllShipCertificateRecommendations",
"SELECT shipTypeID, certificateID, recommendationLevel, recommendationID FROM crtRecommendations",
CacheStorage.CacheObjectType.Rowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("certificateMgr", "GetAllShipCertificateRecommendations");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetEntryTypes(CallInformation call)
{
this.CacheStorage.Load(
"account",
"GetEntryTypes",
"SELECT refTypeID AS entryTypeID, refTypeText AS entryTypeName, description FROM market_refTypes",
CacheStorage.CacheObjectType.Rowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("account", "GetEntryTypes");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetSolarSystemPseudoSecurities(CallInformation call)
{
this.CacheStorage.Load(
"map",
"GetSolarSystemPseudoSecurities",
"SELECT solarSystemID, security FROM mapSolarSystems",
CacheStorage.CacheObjectType.Rowset
);
PyDataType cacheHint = this.CacheStorage.GetHint("map", "GetSolarSystemPseudoSecurities");
return(PyCacheMethodCallResult.FromCacheHint(cacheHint));
}
public PyDataType GetMarketGroups(CallInformation call)
{
// check if the cache already exits
if (this.CacheStorage.Exists("marketProxy", "GetMarketGroups") == false)
{
this.CacheStorage.StoreCall(
"marketProxy",
"GetMarketGroups",
this.DB.GetMarketGroups(),
DateTime.UtcNow.ToFileTimeUtc()
);
}
return(PyCacheMethodCallResult.FromCacheHint(
this.CacheStorage.GetHint("marketProxy", "GetMarketGroups")
));
}
public PyDataType GetFacWarSystems(CallInformation call)
{
/*
* The data is an integer dict (indicating solar system) with these as entries:
* ["occupierID"] = Faction ID - I guess faction ID that controls the system
* ["factionID"] = Faction ID - I guess original faction ID that controled the system?
*/
if (this.CacheStorage.Exists("facWarMgr", "GetFacWarSystems") == false)
{
this.CacheStorage.StoreCall(
"facWarMgr",
"GetFacWarSystems",
new PyDictionary(),
DateTime.UtcNow.ToFileTimeUtc()
);
}
return(PyCacheMethodCallResult.FromCacheHint(
this.CacheStorage.GetHint("facWarMgr", "GetFacWarSystems")
));
}
