From yesterday im trying to add/remove user from group, im new to mongodb and nodebb js.
Im using python as backend.
So i just checked how adding user to group is done in NodeBB.
https://github.com/NodeBB/NodeBB/blob/master/src/groups/join.js#L41
const promises = [
db.sortedSetsAdd(groupsToJoin.map(groupName => 'group:' + groupName + ':members'), Date.now(), uid),
db.incrObjectField(groupsToJoin.map(groupName => 'group:' + groupName), 'memberCount'),
];
if (isAdmin) {
promises.push(db.setsAdd(groupsToJoin.map(groupName => 'group:' + groupName + ':owners'), uid));
}
https://github.com/NodeBB/NodeBB/blob/b61a4da50c192924426ed3620cea91f51952901f/src/database/mongo/sorted/add.js#L50
module.sortedSetsAdd = async function (keys, scores, value) {
...
var bulk = module.client.collection('objects').initializeUnorderedBulkOp();
for (var i = 0; i < keys.length; i += 1) {
console.info("KEYS[i]: " + keys[i] + " value: " + value + " SCORE:" + scores);
bulk.find({ _key: keys[i], value: value }).upsert().updateOne({ $set: { score: parseFloat(isArrayOfScores ? scores[i] : scores) } });
}
await bulk.execute();
Just addded console.info that showed these keys when i was adding users from ACP:
KEYS[i]: group:group_A:members value: 2 SCORE:1596909662460
KEYS[i]: events:time value: 28 SCORE:1596909662470
KEYS[i]: events:time:group-add-member value: 28 SCORE:1596909662470
group_A is a group that i want to add user to, user id is 2.
and this is my python code:
import pymongo
import urllib.parse
username = urllib.parse.quote_plus('nodebb')
password = urllib.parse.quote_plus('passwd"')
database = 'nodebb'
client = pymongo.MongoClient('mongodb://{0}:{1}@%2Fhome%2Fuser%2Fdb%2Fmongodb-27017.sock/{2}'.format(username, password, database))
db = client['nodebb']
collection = db['nodebb']
query={"_key":"group:group_A:members","value": "2"}
values={"$set": {"score": float(1596909662470)}}
x = collection.update(query, values)
for y in x:
print(y)
query={"_key":"events:time","value": "28"}
values={"$set": {"score": float(1596909662470)}}
x = collection.update(query, values)
for y in x:
print(y)
query={"_key":"events:time:group-add-member","value": "28"}
values={"$set": {"score": float(1596909662470)}}
x = collection.update(query, values)
for y in x:
print(y)
python output:
n
nModified
ok
updatedExisting
n
nModified
ok
updatedExisting
n
nModified
ok
updatedExisting
I just cant get it, i think the _key might be wrong.
it must be something with nginx im testing it again.
or i miss something in config?