easydb.and.bud.testing

CMD:budtestmulti(playerid, params[]){

    new time = GetTickCount();
    BUD::MultiSet( pi[playerid][userid], "siiiiiiiiiiiiii",
        "Email", pi[playerid][email],
        "Novac", pi[playerid][novac],
        "Level", Bit16_Get(Level, playerid),
        "Skin", Bit16_Get(Skin, playerid),
        "Drzava", Bit4_Get(Drzava, playerid),
        "Godine", Bit8_Get(Godine, playerid),
        "Spol", Bit4_Get(Spol, playerid),
        "Spawn", Bit4_Get(Spawn, playerid),
        "RentVozilo", Bit16_Get(RentVozilo, playerid),
        "Kuca1", GetPVarInt(playerid, "AH_Kuca1"),
        "Kuca2", GetPVarInt(playerid, "AH_Kuca2"),
        "Kuca2Omogucena", GetPVarInt(playerid, "AH_Kuca2Omogucena"),
        "KucaRent",  GetPVarInt(playerid, "AH_KucaRent"),
        "KucaSpawn", GetPVarInt(playerid, "AH_Spawn"),
        "Admin", Bit4_Get(Admin, playerid)
    );
    printf("Multiset: %d ms", GetTickCount()-time);
    //89 ms
    return 1;
}
CMD:budtestsingle(playerid, params[]){

    new time = GetTickCount();

    BUD::SetStringEntry( pi[playerid][userid], "Email", pi[playerid][email]);
    BUD::SetIntEntry( pi[playerid][userid], "Novac",  pi[playerid][novac] );
    BUD::SetIntEntry( pi[playerid][userid], "Level",  Bit16_Get(Level, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Skin", Bit16_Get(Skin, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Drzava", Bit4_Get(Drzava, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Godine", Bit8_Get(Godine, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Spol", Bit4_Get(Spol, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Spawn", Bit4_Get(Spawn, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "RentVozilo", Bit16_Get(RentVozilo, playerid) );
    BUD::SetIntEntry( pi[playerid][userid], "Kuca1", GetPVarInt(playerid, "AH_Kuca1") );
    BUD::SetIntEntry( pi[playerid][userid], "Kuca2", GetPVarInt(playerid, "AH_Kuca2") );
    BUD::SetIntEntry( pi[playerid][userid], "Kuca2Omogucena", GetPVarInt(playerid, "AH_Kuca2Omogucena") );
    BUD::SetIntEntry( pi[playerid][userid], "KucaRent", GetPVarInt(playerid, "AH_KucaRent") );
    BUD::SetIntEntry( pi[playerid][userid], "KucaSpawn", GetPVarInt(playerid, "AH_Spawn") );
    BUD::SetIntEntry( pi[playerid][userid], "Admin", Bit4_Get(Admin, playerid) );


    printf("Singletest: %d ms", GetTickCount()-time);
    //987 ms
    return 1;
}

CMD:testsingleeasy(playerid, params[]){

    new time = GetTickCount();
    new id = 0;
    DB::CreateRow(interijeri_Table, "id", id);
    new db_id = DB::RetrieveKey(interijeri_Table, "id", id);

    DB::SetIntEntry(interijeri_Table, db_id, "IzlazInt", IntInfo[id][iinterijer]);
    DB::SetIntEntry(interijeri_Table, db_id, "UlazInt", IntInfo[id][uinterijer]);
    DB::SetIntEntry(interijeri_Table, db_id, "UlazWorld", IntInfo[id][uworld]);
    DB::SetIntEntry(interijeri_Table, db_id, "Pickup", IntInfo[id][PickupID]);
    DB::SetIntEntry(interijeri_Table, db_id, "Mapicon", IntInfo[id][MapIconID]);

    DB::SetFloatEntry(interijeri_Table, db_id, "uX", IntInfo[id][uX]);
    DB::SetFloatEntry(interijeri_Table, db_id, "uY", IntInfo[id][uY]);
    DB::SetFloatEntry(interijeri_Table, db_id, "uZ", IntInfo[id][uZ]);
    DB::SetFloatEntry(interijeri_Table, db_id, "uA", IntInfo[id][uA]);

    DB::SetFloatEntry(interijeri_Table, db_id, "iX", IntInfo[id][iX]);
    DB::SetFloatEntry(interijeri_Table, db_id, "iY", IntInfo[id][iY]);
    DB::SetFloatEntry(interijeri_Table, db_id, "iZ", IntInfo[id][iZ]);
    DB::SetFloatEntry(interijeri_Table, db_id, "iA", IntInfo[id][iA]);

    DB::SetStringEntry(interijeri_Table, db_id, "Ime", IntInfo[id][intime]);
    printf("EasyTest: %d ms", GetTickCount()-time);
    //134 ms
    return 1;
}

CMD:testmultiset(playerid, params[]){

    new time = GetTickCount();
    new id = 0;
    new db_id = DB::RetrieveKey(interijeri_Table, "id", 0);

    DB::MultiSet(interijeri_Table, db_id, "iiiiiffffffffs",
        "IzlazInt", IntInfo[id][iinterijer],
        "UlazInt", IntInfo[id][uinterijer],
        "UlazWorld", IntInfo[id][uworld],
        "Pickup", IntInfo[id][PickupID],
        "Mapicon", IntInfo[id][MapIconID],
        "uX", IntInfo[id][uX],
        "uY", IntInfo[id][uY],
        "uZ", IntInfo[id][uZ],
        "uA", IntInfo[id][uA],
        "iX", IntInfo[id][iX],
        "iY", IntInfo[id][iY],
        "iZ", IntInfo[id][iZ],
        "iA", IntInfo[id][iA],
        "Ime", IntInfo[id][intime]
    );


    printf("MultiSet easy: %d ms", GetTickCount()-time);
    //1-2 ms
    return 1;
}
CMD:testmultiget(playerid, params[]) {

    new time = GetTickCount();
    new id = 0;
    new db_id = DB::RetrieveKey(interijeri_Table, "id", 0);

    DB::MultiGet( interijeri_Table, db_id, "iiiiiffffffffs[64]",
        "IzlazInt", IntInfo[id][iinterijer],
        "UlazInt", IntInfo[id][uinterijer],
        "UlazWorld", IntInfo[id][uworld],
        "Pickup", IntInfo[id][PickupID],
        "Mapicon", IntInfo[id][MapIconID],
        "uX", IntInfo[id][uX],
        "uY", IntInfo[id][uY],
        "uZ", IntInfo[id][uZ],
        "uA", IntInfo[id][uA],
        "iX", IntInfo[id][iX],
        "iY", IntInfo[id][iY],
        "iZ", IntInfo[id][iZ],
        "iA", IntInfo[id][iA],
        "Ime", IntInfo[id][intime]
    );

    printf("MultiGet easy: %d ms", GetTickCount()-time);
    //1-2 ms
    return 1;
}