EVEDBUtils.cpp File Reference

#include "eve-common.h"
#include "database/EVEDBUtils.h"
#include "packets/General.h"
#include "python/classes/PyDatabase.h"
#include "python/PyVisitor.h"
#include "python/PyRep.h"

Include dependency graph for EVEDBUtils.cpp:

Go to the source code of this file.

Functions
PyRep *	DBColumnToPyRep (const DBResultRow &row, uint32 index)
PyObject *	DBResultToRowset (DBQueryResult &result)
PyTuple *	DBResultToTupleSet (DBQueryResult &result)
PyObject *	DBResultToIndexRowset (DBQueryResult &result, const char *key)
PyObject *	DBResultToIndexRowset (DBQueryResult &result, uint32 key_index)
PyObject *	DBRowToKeyVal (DBResultRow &row)
PyObject *	DBRowToRow (DBResultRow &row, const char *type)
PyTuple *	DBResultToRowList (DBQueryResult &result, const char *type)
PyDict *	DBResultToIntRowDict (DBQueryResult &result, uint32 key_index, const char *type)
PyDict *	DBResultToIntIntDict (DBQueryResult &result)
void	FillPackedRow (const DBResultRow &row, PyPackedRow *into)
PyPackedRow *	CreatePackedRow (const DBResultRow &row, DBRowDescriptor *header)
PyList *	DBResultToPackedRowList (DBQueryResult &result)
PyTuple *	DBResultToPackedRowListTuple (DBQueryResult &result)
PyDict *	DBResultToPackedRowDict (DBQueryResult &result, const char *key)
PyDict *	DBResultToPackedRowDict (DBQueryResult &result, uint32 key_index)
PyObjectEx *	DBResultToCRowset (DBQueryResult &result)
PyObjectEx *	DBResultToCIndexedRowset (DBQueryResult &result, const char *key)
PyObjectEx *	DBResultToCIndexedRowset (DBQueryResult &result, uint32 key_index)
PyPackedRow *	DBRowToPackedRow (DBResultRow &row)
void	DBResultToIntIntDict (DBQueryResult &result, std::map< int32, int32 > &into)
void	DBResultToUIntUIntDict (DBQueryResult &result, std::map< uint32, uint32 > &into)
void	DBResultToIntIntlistDict (DBQueryResult &result, std::map< int32, PyRep * > &into)

Function Documentation

PyPackedRow* CreatePackedRow	(	const DBResultRow &	row,
		DBRowDescriptor *	header
	)

Definition at line 299 of file EVEDBUtils.cpp.

References FillPackedRow().

Referenced by DBResultToPackedRowDict(), DBResultToPackedRowList(), DBResultToPackedRowListTuple(), and DBRowToPackedRow().

{
    PyPackedRow* res = new PyPackedRow( header );
    FillPackedRow( row, res );
    return res;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep* DBColumnToPyRep	(	const DBResultRow &	row,
		uint32	index
	)

Definition at line 36 of file EVEDBUtils.cpp.

References DBResultRow::ColumnLength(), DBResultRow::ColumnType(), DBTYPE_BOOL, DBTYPE_BYTES, DBTYPE_I1, DBTYPE_I2, DBTYPE_I4, DBTYPE_I8, DBTYPE_R4, DBTYPE_R8, DBTYPE_STR, DBTYPE_UI1, DBTYPE_UI2, DBTYPE_UI4, DBTYPE_UI8, DBTYPE_WSTR, DBResultRow::GetBool(), DBResultRow::GetDouble(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBResultRow::GetText(), DBResultRow::IsNull(), PyStatic, and sLog.

Referenced by DBResultToCIndexedRowset(), DBResultToIndexRowset(), DBResultToPackedRowDict(), DBResultToRowset(), DBResultToTupleSet(), DBRowToKeyVal(), DBRowToRow(), FillPackedRow(), and LiveUpdateDB::GenerateUpdates().

{
    /* check for valid column */
    if (row.IsNull(index))
        return PyStatic.NewNone();      // this doesnt work right.  client still sees this as 0 instead of None

    switch(row.ColumnType(index)) {
        case DBTYPE_I1:
        case DBTYPE_UI1:
        case DBTYPE_I2:
        case DBTYPE_UI2:
        case DBTYPE_I4:
        case DBTYPE_UI4:
            return new PyInt( row.GetInt( index ) );

        case DBTYPE_I8:
        case DBTYPE_UI8:
            return new PyLong( row.GetInt64( index ) );

        case DBTYPE_R8:
        case DBTYPE_R4:
            return new PyFloat( row.GetDouble( index ) );

        case DBTYPE_BOOL:
            return new PyBool( row.GetBool(index) );

        case DBTYPE_STR:
            return new PyString( row.GetText( index ), row.ColumnLength( index ) );

        case DBTYPE_WSTR:
            return new PyWString( row.GetText( index ), row.ColumnLength( index ) );

        case DBTYPE_BYTES: {
            const uint8* data = (const uint8*)row.GetText( index );
            const uint32 len = row.ColumnLength( index );
            return new PyBuffer( data, data + len );
        }

        default: {
            sLog.Error( "DBColumnToPyRep", "invalid column type: %u", row.ColumnType(index) );
            return PyStatic.NewNone();
        }
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObjectEx* DBResultToCIndexedRowset	(	DBQueryResult &	result,
		const char *	key
	)

Definition at line 419 of file EVEDBUtils.cpp.

References DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBResultToCIndexedRowset(), and sLog.

Referenced by DBResultToCIndexedRowset(), AllianceDB::GetApplications(), CorporationDB::GetApplications(), AllianceDB::GetContacts(), CorporationDB::GetContacts(), AllianceDB::GetLabels(), CorporationDB::GetLabels(), CharacterDB::GetLabels(), AllianceDB::GetMyApplications(), ManagerDB::GetOperands(), and CorporationDB::GetVotes().

{
    uint32 cc = result.ColumnCount();
    uint32 key_index(0);

    for(key_index = 0; key_index < cc; key_index++)
        if(strcmp(key, result.ColumnName(key_index)) == 0)
            break;

    if(key_index == cc)
    {
        sLog.Error("EVEDBUtils", "DBResultToCIndexedRowset | Failed to find key column '%s' in result for CIndexRowset", key);
        return NULL;
    }

    return DBResultToCIndexedRowset(result, key_index);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObjectEx* DBResultToCIndexedRowset	(	DBQueryResult &	result,
		uint32	key_index
	)

Todo:

Mem leak. header never freed

Definition at line 437 of file EVEDBUtils.cpp.

References DBColumnToPyRep(), FillPackedRow(), DBQueryResult::GetRow(), and CIndexedRowSet::NewRow().

                                                                              {
    DBRowDescriptor *header = new DBRowDescriptor( result );
    CIndexedRowSet *rowset = new CIndexedRowSet( &header );

    DBResultRow row;
    while( result.GetRow( row ) )
    {
        PyPackedRow* into = rowset->NewRow( DBColumnToPyRep(row, key_index) );
        FillPackedRow( row, into );
    }

    //PyDecRef( header );
    return rowset;
}

Here is the call graph for this function:

PyObjectEx* DBResultToCRowset

(

DBQueryResult &

result

)

Todo:

Mem leak. header never freed

Definition at line 402 of file EVEDBUtils.cpp.

References FillPackedRow(), DBQueryResult::GetRow(), and CRowSet::NewRow().

Referenced by FactoryDB::AssemblyLinesGet(), FactoryDB::AssemblyLinesSelectAlliance(), FactoryDB::AssemblyLinesSelectCorporation(), FactoryDB::AssemblyLinesSelectPersonal(), FactoryDB::AssemblyLinesSelectPrivate(), FactoryDB::AssemblyLinesSelectPublic(), ObjCacheDB::Generate_a_accessories(), ObjCacheDB::Generate_a_backgrounds(), ObjCacheDB::Generate_a_beards(), ObjCacheDB::Generate_a_costumes(), ObjCacheDB::Generate_a_decos(), ObjCacheDB::Generate_a_eyebrows(), ObjCacheDB::Generate_a_eyes(), ObjCacheDB::Generate_a_hairs(), ObjCacheDB::Generate_a_lights(), ObjCacheDB::Generate_a_lipsticks(), ObjCacheDB::Generate_a_makeups(), ObjCacheDB::Generate_a_skins(), ObjCacheDB::Generate_AllianceShortnames(), ObjCacheDB::Generate_BillTypes(), ObjCacheDB::Generate_bl_accessories(), ObjCacheDB::Generate_bl_backgrounds(), ObjCacheDB::Generate_bl_beards(), ObjCacheDB::Generate_bl_costumes(), ObjCacheDB::Generate_bl_decos(), ObjCacheDB::Generate_bl_eyebrows(), ObjCacheDB::Generate_bl_eyes(), ObjCacheDB::Generate_bl_hairs(), ObjCacheDB::Generate_bl_lights(), ObjCacheDB::Generate_bl_lipsticks(), ObjCacheDB::Generate_bl_makeups(), ObjCacheDB::Generate_bl_skins(), ObjCacheDB::Generate_BloodlineNames(), ObjCacheDB::Generate_c_chrAncestries(), ObjCacheDB::Generate_c_chrAttributes(), ObjCacheDB::Generate_c_chrBloodlines(), ObjCacheDB::Generate_c_chrRaces(), ObjCacheDB::Generate_c_chrSchools(), ObjCacheDB::Generate_cacheLocations(), ObjCacheDB::Generate_cacheOwners(), ObjCacheDB::Generate_certificateRelationships(), ObjCacheDB::Generate_certificates(), ObjCacheDB::Generate_CharNewExtraCareers(), ObjCacheDB::Generate_CharNewExtraCareerSkills(), ObjCacheDB::Generate_CharNewExtraRaceSkills(), ObjCacheDB::Generate_CharNewExtraSpecialities(), ObjCacheDB::Generate_CharNewExtraSpecialitySkills(), ObjCacheDB::Generate_dgmAttribs(), ObjCacheDB::Generate_dgmEffects(), ObjCacheDB::Generate_dgmExpressions(), ObjCacheDB::Generate_dgmTypeAttribs(), ObjCacheDB::Generate_dgmTypeEffects(), ObjCacheDB::Generate_eveBulkDataUnits(), ObjCacheDB::Generate_eveGraphics(), ObjCacheDB::Generate_eveStaticLocations(), ObjCacheDB::Generate_eveStaticOwners(), ObjCacheDB::Generate_Icons(), ObjCacheDB::Generate_invBlueprintTypes(), ObjCacheDB::Generate_invCategories(), ObjCacheDB::Generate_invContrabandTypes(), ObjCacheDB::Generate_invGroups(), ObjCacheDB::Generate_invMetaGroups(), ObjCacheDB::Generate_invMetaTypes(), ObjCacheDB::Generate_invShipTypes(), ObjCacheDB::Generate_Invtypematerials(), ObjCacheDB::Generate_invTypeReactions(), ObjCacheDB::Generate_invTypes(), ObjCacheDB::Generate_Locationscenes(), ObjCacheDB::Generate_locationWormholeClasses(), ObjCacheDB::Generate_mapCelestialDescriptions(), ObjCacheDB::Generate_OverviewDefaultGroups(), ObjCacheDB::Generate_OverviewDefaults(), ObjCacheDB::Generate_Ownericons(), ObjCacheDB::Generate_PaperdollColorNames(), ObjCacheDB::Generate_PaperdollColorRestrictions(), ObjCacheDB::Generate_PaperdollColors(), ObjCacheDB::Generate_PaperdollModifierLocations(), ObjCacheDB::Generate_PaperdollResources(), ObjCacheDB::Generate_PaperdollSculptingLocations(), ObjCacheDB::Generate_ramActivities(), ObjCacheDB::Generate_ramALTypeCategory(), ObjCacheDB::Generate_ramALTypeGroup(), ObjCacheDB::Generate_ramALTypes(), ObjCacheDB::Generate_ramCompletedStatuses(), ObjCacheDB::Generate_ramTypeRequirements(), ObjCacheDB::Generate_Schematics(), ObjCacheDB::Generate_Schematicspinmap(), ObjCacheDB::Generate_Schematicstypemap(), ObjCacheDB::Generate_Sounds(), ObjCacheDB::Generate_tickerNames(), CorporationDB::GetAdGroupData(), CorporationDB::GetAdRegistryData(), CorporationDB::GetAdTypeData(), CorporationDB::GetAdvert(), ManagerDB::GetAgents(), CorporationDB::GetAllCorpMedals(), CorporationDB::GetAssetInventory(), CorporationDB::GetAssetInventoryForLocation(), AllianceDB::GetBulletins(), CorporationDB::GetBulletins(), ConfigDB::GetCelestialStatistic(), CharacterDB::GetCharacterList(), StandingDB::GetCharNPCStandings(), CharacterDB::GetCharPublicInfo3(), CharacterDB::GetCharSelectInfo(), StandingDB::GetCharStandings(), PosMgrDB::GetCorpControlTowers(), CorporationDB::GetCorpMedalData(), CorporationDB::GetCorpRoleGroups(), CorporationDB::GetCorpRoles(), StandingDB::GetCorpStandings(), BulkDB::GetDogmaAttribs(), BulkDB::GetDogmaEffects(), BulkDB::GetDogmaTypeAttribs(), BulkDB::GetDogmaTypeEffects(), ConfigDB::GetDynamicCelestials(), BulkDB::GetExpressions(), StandingDB::GetFactionStandings(), CorporationDB::GetItemEvents(), AccountDB::GetJournal(), CharacterDB::GetKillOrLoss(), CorporationDB::GetKillsAndLosses(), MailDB::GetMailStatus(), ConfigDB::GetMapObjects(), CorporationDB::GetMedalDetails(), CorporationDB::GetMedalsReceived(), CorporationDB::GetMedalsReceivedDetails(), CorporationDB::GetMemberTrackingInfo(), CorporationDB::GetMemberTrackingInfoSimple(), CorporationDB::GetMktInfo(), CorporationDB::GetMyApplications(), CharacterDB::GetMyCorpMates(), StandingDB::GetMyStandings(), MailDB::GetNewMail(), MarketMgr::GetNewPriceHistory(), StationDB::GetOffices(), MarketMgr::GetOldPriceHistory(), BulkDB::GetOperands(), MarketDB::GetOrders(), CharacterDB::GetOwnerNote(), CharacterDB::GetOwnerNoteLabels(), PaperDollDB::GetPaperDollAvatarColors(), PaperDollDB::GetPaperDollAvatarModifiers(), PaperDollDB::GetPaperDollAvatarSculpts(), PaperDollDB::GetPaperDollPortraitData(), PlanetDB::GetPlanetsForChar(), CorporationDB::GetRecipientsOfMedal(), CorporationDB::GetRoleHistroy(), CorporationDB::GetSanctionedItems(), PosMgrDB::GetSiloCapacityForType(), CharacterDB::List(), CharacterDB::ListStationBlueprintItems(), CharacterDB::ListStationItems(), CharacterDB::ListStations(), and StaticDataMgr::SetBPMatlType().

{
    DBRowDescriptor *header = new DBRowDescriptor( result );
    CRowSet *rowset = new CRowSet( &header );

    DBResultRow row;
    while( result.GetRow( row ) )
    {
        PyPackedRow* into = rowset->NewRow();
        FillPackedRow( row, into );
    }

    //PyDecRef( header );
    return rowset;
}

Here is the call graph for this function:

PyObject* DBResultToIndexRowset	(	DBQueryResult &	result,
		const char *	key
	)

Definition at line 144 of file EVEDBUtils.cpp.

References DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBResultToIndexRowset(), and sLog.

Referenced by DBResultToIndexRowset(), CertificateMgrDB::GetCertificateCategories(), CharacterDB::GetContacts(), AllianceDB::GetMembers(), MarketDB::GetRegionBest(), CorporationDB::GetShares(), MarketDB::GetStationAsks(), MarketDB::GetSystemAsks(), ConfigDB::GetUnits(), and CorporationDB::GetVoteOptions().

                                                                        {
    uint32 cc = result.ColumnCount();
    uint32 key_index(0);

    for(key_index = 0; key_index < cc; ++key_index)
        if(strcmp(key, result.ColumnName(key_index)) == 0)
            break;

    if(key_index == cc)
    {
        sLog.Error("EVEDBUtils", "DBResultToIndexRowset | Failed to find key column '%s' in result for IndexRowset", key);
        return nullptr;
    }

    return DBResultToIndexRowset(result, key_index);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject* DBResultToIndexRowset	(	DBQueryResult &	result,
		uint32	key_index
	)

Definition at line 161 of file EVEDBUtils.cpp.

References args, DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBColumnToPyRep(), DBQueryResult::GetRow(), items, key(), PyList::SetItem(), PyDict::SetItem(), PyList::SetItemString(), and PyDict::SetItemString().

                                                                         {
    uint32 cc = result.ColumnCount();

    //start building the IndexRowset
    PyDict *args = new PyDict();

    if(cc == 0 || cc < key_index)
        return new PyObject( "util.IndexRowset", args );

    //list off the column names:
    PyList *header = new PyList(cc);
    args->SetItemString("header", header);
    for(uint32 i(0); i < cc; ++i)
        header->SetItemString(i, result.ColumnName(i));

    //RowClass:
    args->SetItemString("RowClass", new PyToken("util.Row"));
    //idName:
    args->SetItemString("idName", new PyString( result.ColumnName(key_index) ));

    //items:
    PyDict *items = new PyDict();
    //add a line entry for each result row:
    uint32 i(0);
    DBResultRow row;
    while(result.GetRow(row)) {
        PyRep *key = DBColumnToPyRep(row, key_index);
        PyList *line = new PyList(cc);
        for(i = 0; i < cc; ++i)
            line->SetItem(i, DBColumnToPyRep(row, i));

        items->SetItem(key, line);
    }

    args->SetItemString("items", items);
    return new PyObject( "util.IndexRowset", args );
}

Here is the call graph for this function:

PyDict* DBResultToIntIntDict

(

DBQueryResult &

result

)

Definition at line 273 of file EVEDBUtils.cpp.

References DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::IsNull(), PyStatic, and PyDict::SetItem().

Referenced by FactionWarMgrDB::GetWarFactions(), and SearchDB::Query().

                                                    {
    PyDict *res = new PyDict();
    //add a line entry for each result row:
    DBResultRow row;
    while(result.GetRow(row)) {
        if (row.IsNull(0))
            continue;   //no working with NULL keys...
        int32 k = row.GetInt(0);
        if (k == 0)
            continue;   //likely a non-integer key
        if (row.IsNull(1))
            res->SetItem( new PyInt(k), PyStatic.NewNone() );
        else
            res->SetItem( new PyInt(k), new PyInt(row.GetInt(1)) );
    }

    return res;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void DBResultToIntIntDict	(	DBQueryResult &	result,
		std::map< int32, int32 > &	into
	)

these functions aren't used.

Definition at line 463 of file EVEDBUtils.cpp.

References DBResultRow::GetInt(), DBQueryResult::GetRow(), and DBResultRow::IsNull().

                                                                             {
    //add a line entry for each result row:
    DBResultRow row;
    while(result.GetRow(row)) {
        if (row.IsNull(0))
            continue;   //no working with NULL keys...
            int32 k = row.GetInt(0);
        int32 v(0);
        if (row.IsNull(1))
            v = 0;      //we can deal with assuming NULL == 0
            else
                v = row.GetInt(1);
            into[k] = v;
    }
}

Here is the call graph for this function:

void DBResultToIntIntlistDict	(	DBQueryResult &	result,
		std::map< int32, PyRep * > &	into
	)

Definition at line 495 of file EVEDBUtils.cpp.

References PyList::AddItemInt(), DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), and PyDecRef.

Referenced by ManagerDB::LoadFactionConstellations(), ManagerDB::LoadFactionRaces(), ManagerDB::LoadFactionRegions(), and ManagerDB::LoadFactionSolarSystems().

                                                                                     {
    /* this builds a map from the int in result[0], to a list of each result[1]
     * which is has the same result[0]. This function assumes the result is
     * ORDER BY result[0]
     */
    uint32 last_key = 0xFFFFFFFF;

    PyList *l = NULL;

    DBResultRow row;
    while( result.GetRow( row ) )
    {
        uint32 k = row.GetUInt(0);
        if (k != last_key )
        {
            //watch for overwrite, no guarantee we are dealing with a key.
            std::map<int32, PyRep *>::iterator res = into.find(k);
            if (res != into.end() )
                //log an error or warning?
                PyDecRef( res->second );

            into[k] = l = new PyList();
            last_key = k;
        }

        l->AddItemInt( row.GetInt( 1 ) );
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyDict* DBResultToIntRowDict	(	DBQueryResult &	result,
		uint32	key_index,
		const char *	type
	)

Definition at line 257 of file EVEDBUtils.cpp.

References DBRowToRow(), DBResultRow::GetInt(), DBQueryResult::GetRow(), and PyDict::SetItem().

Referenced by CertificateMgrDB::GetCertificateClasses(), and ManagerDB::LoadNPCCorpInfo().

                                                                                        {
    PyDict *res = new PyDict();
    //add a line entry for each result row:
    DBResultRow row;
    while (result.GetRow(row)) {
        //this could be more efficient by not building the column list each time, but cloning it instead.
        PyObject *r = DBRowToRow(row, type);
        int32 k = row.GetInt(key_index);
        if (k == 0)
            continue;   //likely a non-integer key
        res->SetItem(new PyInt(k), r);
    }

    return res;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyDict* DBResultToPackedRowDict	(	DBQueryResult &	result,
		const char *	key
	)

Definition at line 340 of file EVEDBUtils.cpp.

References DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBResultToPackedRowDict(), and sLog.

Referenced by DBResultToPackedRowDict(), and CorporationDB::GetVoteItems().

{
    uint32 cc = result.ColumnCount();
    uint32 key_index(0);

    for (key_index = 0; key_index < cc; ++key_index)
        if (strcmp(key, result.ColumnName(key_index)) == 0)
            break;

    if(key_index == cc)
    {
        sLog.Error("EVEDBUtils", "DBResultToPackedRowDict | Failed to find key column '%s' in result for CIndexRowset", key);
        return NULL;
    }

    return DBResultToPackedRowDict(result, key_index);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyDict* DBResultToPackedRowDict	(	DBQueryResult &	result,
		uint32	key_index
	)

Definition at line 358 of file EVEDBUtils.cpp.

References CreatePackedRow(), DBColumnToPyRep(), DBQueryResult::GetRow(), PyDecRef, PyIncRef, and PyDict::SetItem().

{
    DBRowDescriptor *header = new DBRowDescriptor( result );

    PyDict *res = new PyDict();

    DBResultRow row;
    while( result.GetRow(row) ) {
        res->SetItem( DBColumnToPyRep(row, key_index), CreatePackedRow( row, header ) );
        PyIncRef( header );
    }

    PyDecRef( header );
    return res;
}

Here is the call graph for this function:

PyList* DBResultToPackedRowList

(

DBQueryResult &

result

)

Definition at line 306 of file EVEDBUtils.cpp.

References CreatePackedRow(), DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), PyDecRef, PyIncRef, and PyList::SetItem().

Referenced by ObjCacheDB::Generate_chrAttributes(), ObjCacheDB::Generate_chrBloodlines(), ObjCacheDB::Generate_chrRaces(), ObjCacheDB::Generate_eveUnits(), and ObjCacheDB::Generate_invFlags().

{
    DBRowDescriptor *header = new DBRowDescriptor( result );
    PyList * list = new PyList( result.GetRowCount() );

    uint32 i(0);
    DBResultRow row;
    while( result.GetRow(row) ) {
        list->SetItem( i++, CreatePackedRow( row, header ) );
        PyIncRef( header );
    }

    PyDecRef( header );
    return list;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyTuple* DBResultToPackedRowListTuple

(

DBQueryResult &

result

)

Definition at line 322 of file EVEDBUtils.cpp.

References CreatePackedRow(), DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), PyIncRef, PyTuple::SetItem(), and PyList::SetItem().

{
    DBRowDescriptor * header = new DBRowDescriptor( result );
    PyList * list = new PyList( result.GetRowCount() );

    DBResultRow row;
    uint32 i(0);
    while( result.GetRow(row) ) {
        list->SetItem( i++, CreatePackedRow( row, header ) );
        PyIncRef( header );
    }

    PyTuple* res = new PyTuple(2);
        res->SetItem( 0, header );
        res->SetItem( 1, list );
    return res;
}

Here is the call graph for this function:

PyTuple* DBResultToRowList	(	DBQueryResult &	result,
		const char *	type
	)

Definition at line 231 of file EVEDBUtils.cpp.

References DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBRowToRow(), DBQueryResult::GetRow(), PyList::items, PyTuple::SetItem(), and PyList::SetItemString().

Referenced by ConfigDB::GetMultiCorpTickerNamesEx(), ConfigDB::GetMultiGraphicsEx(), and ConfigDB::GetMultiInvTypesEx().

                                                                    {
    uint32 cc = result.ColumnCount();
    if(cc == 0)
        return(new PyTuple(0));

    PyList *cols = new PyList(cc);
    //list off the column names:
    for(uint32 r(0); r < cc; ++r)
        cols->SetItemString(r, result.ColumnName(r));

    PyTuple *res = new PyTuple(2);
    res->SetItem( 0, cols );

    //add a line entry for each result row:
    DBResultRow row;
    PyList *reslist = new PyList();
    while(result.GetRow(row)) {
        //this could be more efficient by not building the column list each time, but cloning it instead.
        PyObject *o = DBRowToRow(row, type);
        reslist->items.push_back(o);
    }
    res->SetItem( 1, reslist );

    return res;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject* DBResultToRowset

(

DBQueryResult &

result

)

Definition at line 81 of file EVEDBUtils.cpp.

References PyList::AddItem(), args, DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBColumnToPyRep(), DBQueryResult::GetRow(), PyList::SetItem(), PyList::SetItemString(), and PyDict::SetItemString().

Referenced by TutorialDB::GetAllCriterias(), AllianceDB::GetAllianceMembers(), CertificateMgrDB::GetAllShipCertificateRecommendations(), TutorialDB::GetAllTutorials(), ManagerDB::GetBillTypes(), CharacterDB::GetBounty(), TutorialDB::GetCategories(), CorporationDB::GetCorporationBills(), MapDB::GetDynamicData(), AllianceDB::GetEmploymentRecord(), CorporationDB::GetEmploymentRecord(), ManagerDB::GetEntryTypes(), CorporationDB::GetEveOwners(), ShipDB::GetInsuranceByOwnerID(), FactoryDB::GetJobs2(), ManagerDB::GetKeyMap(), LSCDB::GetMailHeaders(), ConfigDB::GetMap(), ConfigDB::GetMapConnections(), ConfigDB::GetMapLandmarks(), ConfigDB::GetMapOffices(), FactoryDB::GetMaterialCompositionOfItemType(), CorporationDB::GetMedalStatuses(), PlanetDB::GetMyLaunchesDetails(), CorporationDB::GetMyShares(), ManagerDB::GetNPCDivisions(), MarketDB::GetOrdersForOwner(), TutorialDB::GetPageCriterias(), TutorialDB::GetPages(), MapDB::GetPseudoSecurities(), AllianceDB::GetRankedAlliances(), CharacterDB::GetSkillHistory(), MapDB::GetSolSystemVisits(), StandingDB::GetStandingTransactions(), MapDB::GetStationExtraInfo(), MapDB::GetStationOpServices(), CorporationDB::GetStations(), MapDB::GetStationServiceInfo(), ConfigDB::GetStationSolarSystemsByOwner(), ConfigDB::GetTextsForGroup(), CharacterDB::GetTopBounties(), MarketDB::GetTransactions(), TutorialDB::GetTutorial(), TutorialDB::GetTutorialCriterias(), TutorialDB::GetTutorialsAndConnections(), SystemDB::ListFactions(), SystemDB::ListJumps(), ConfigDB::ListLanguages(), CorporationDB::ListStationCorps(), CorporationDB::ListStationOwners(), ServiceDB::LookupChars(), ServiceDB::LookupCorporations(), ServiceDB::LookupCorporationTickers(), ServiceDB::LookupFactions(), ServiceDB::LookupKnownLocationsByGroup(), ServiceDB::LookupOwners(), ServiceDB::LookupStations(), and StandingDB::PrimeCharStandings().

{
    uint32 cc = result.ColumnCount();

    PyDict *args = new PyDict();

    /* check if we have a empty query result and return a empty RowSet */
    if (cc == 0 )
        return new PyObject( "util.Rowset" , args );

    //list off the column names:
    PyList *header = new PyList( cc );
    for(uint32 r(0); r < cc; ++r)
        header->SetItemString( r, result.ColumnName(r));
    args->SetItemString("header", header);

    //RowClass:
    args->SetItemString("RowClass", new PyToken("util.Row"));

    //lines:
    PyList *rowlist = new PyList();
    //add a line entry for each result row:
    uint32 r(0);
    DBResultRow row;
    while(result.GetRow(row)) {
        PyList *linedata = new PyList( cc );
        for (r = 0; r < cc; ++r)
            linedata->SetItem( r, DBColumnToPyRep(row, r) );
        rowlist->AddItem(linedata);
    }
    args->SetItemString("lines", rowlist);

    return new PyObject( "util.Rowset" , args );
}

Here is the call graph for this function:

PyTuple* DBResultToTupleSet

(

DBQueryResult &

result

)

Definition at line 116 of file EVEDBUtils.cpp.

References DBQueryResult::ColumnCount(), DBQueryResult::ColumnName(), DBColumnToPyRep(), DBQueryResult::GetRow(), PyTuple::items, PyList::items, PyList::SetItem(), and PyList::SetItemString().

Referenced by ConfigDB::GetMultiAllianceShortNamesEx(), ConfigDB::GetMultiLocationsEx(), ConfigDB::GetMultiOwnersEx(), and ConfigDB::GetMultiStationEx().

                                                   {
    uint32 cc = result.ColumnCount();
    if(cc == 0)
        return new PyTuple(0);

    PyTuple *res = new PyTuple(2);

    //list off the column names:
    PyList *cols = new PyList(cc);
    for(uint32 r(0); r < cc; ++r)
        cols->SetItemString(r, result.ColumnName(r));
    res->items[0] = cols;

    //add a line entry for each result row:
    uint32 r(0);
    DBResultRow row;
    PyList *reslist = new PyList();
    while(result.GetRow(row)) {
        PyList *linedata = new PyList(cc);
        for(r = 0; r < cc; ++r)
            linedata->SetItem(r, DBColumnToPyRep(row, r));
        reslist->items.push_back(linedata);
    }
    res->items[1] = reslist;

    return res;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void DBResultToUIntUIntDict	(	DBQueryResult &	result,
		std::map< uint32, uint32 > &	into
	)

Definition at line 479 of file EVEDBUtils.cpp.

References DBQueryResult::GetRow(), DBResultRow::GetUInt(), and DBResultRow::IsNull().

Referenced by ManagerDB::LoadCorpFactions(), ManagerDB::LoadFactionStationCounts(), and ManagerDB::LoadFactionSystemCounts().

                                                                                 {
    //add a line entry for each result row:
    DBResultRow row;
    while(result.GetRow(row)) {
        if(row.IsNull(0))
            continue;   //no working with NULL keys...
            uint32 k = row.GetUInt(0);
        uint32 v(0);
        if(row.IsNull(1))
            v = 0;      //we can deal with assuming NULL == 0
            else
                v = row.GetUInt(1);
            into[k] = v;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject* DBRowToKeyVal

(

DBResultRow &

row

)

Definition at line 199 of file EVEDBUtils.cpp.

References args, DBResultRow::ColumnCount(), DBResultRow::ColumnName(), DBColumnToPyRep(), and PyDict::SetItemString().

Referenced by CharacterDB::GetCharPublicInfo(), CorporationDB::GetCorpInfo(), and CharacterDB::GetInfoWindowDataForChar().

                                          {
    PyDict *args = new PyDict();
    uint32 cc = row.ColumnCount();
    for( uint32 r(0); r < cc; ++r )
        args->SetItemString( row.ColumnName(r), DBColumnToPyRep(row, r));

    return new PyObject( "util.KeyVal", args );
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyPackedRow* DBRowToPackedRow

(

DBResultRow &

row

)

Definition at line 453 of file EVEDBUtils.cpp.

References CreatePackedRow().

Referenced by AllianceDB::GetAlliance(), CharacterDB::GetCharPrivateInfo(), CorporationDB::GetCorporations(), CorporationDB::GetMember(), MarketDB::GetOrderRow(), and SystemDB::GetSolarSystem().

{
    DBRowDescriptor *header = new DBRowDescriptor( row );

    return CreatePackedRow( row, header );
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject* DBRowToRow	(	DBResultRow &	row,
		const char *	type
	)

Definition at line 208 of file EVEDBUtils.cpp.

References args, DBResultRow::ColumnCount(), DBResultRow::ColumnName(), DBColumnToPyRep(), PyList::SetItem(), PyList::SetItemString(), and PyDict::SetItemString().

Referenced by DBResultToIntRowDict(), DBResultToRowList(), CorporationDB::GetCorporation(), ShipDB::GetInsuranceByShipID(), PaperDollDB::GetPaperDollAvatar(), and StationDB::GetStationOfficeIDs().

{
    PyDict *args = new PyDict();

    //list off the column names:
    uint32 cc = row.ColumnCount();
    PyList *header = new PyList(cc);
    for(uint32 r(0); r < cc; ++r)
        header->SetItemString(r, row.ColumnName(r));

    args->SetItemString("header", header);

    //lines:
    PyList *rowlist = new PyList(cc);
    //add a line entry for the row:
    for(uint32 r(0); r < cc; ++r)
        rowlist->SetItem(r, DBColumnToPyRep(row, r));

    args->SetItemString("line", rowlist);

    return new PyObject( type, args );
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FillPackedRow	(	const DBResultRow &	row,
		PyPackedRow *	into
	)

Definition at line 292 of file EVEDBUtils.cpp.

References DBResultRow::ColumnCount(), DBColumnToPyRep(), and PyPackedRow::SetField().

Referenced by CreatePackedRow(), DBResultToCIndexedRowset(), and DBResultToCRowset().

{
    uint32 cc = row.ColumnCount();
    for( uint32 i(0); i < cc; ++i )
        into->SetField( i, DBColumnToPyRep( row, i ) );
}

Here is the call graph for this function:

Here is the caller graph for this function: