monitoring/scripts/users2csv.py

24 lines
702 B
Python
Executable File

#!/usr/bin/python3
import os
import sys
sys.path.insert(0, os.path.abspath(os.path.dirname(__file__) + '/' + '..'))
from pymongo import MongoClient
from bson.json_util import dumps as bson2json
from bson.objectid import ObjectId
import base64
import datetime
targetfile = "/data/fff/users.txt"
client = MongoClient(tz_aware=True, connect=False)
db = client.freifunk
users = db.users.find({}, {"nickname": 1, "password":1, "email": 1, "token": 1, "created": 1, "admin": 1})
with open(targetfile, "wb") as csv:
for u in users:
str = "%s;%s;%s;%s;%s;%s\n" % (u.get("nickname"),u.get("token"),u.get("email",""),u.get("created"),u.get("admin",0),u.get("password"))
csv.write(str.encode("UTF-8"))