from pymongo import MongoClient


class DataBase:
    client = MongoClient('localhost', 27017)
    db = client["kovalskayaDating"]
    users = db['users']


    @classmethod
    def get_stats(cls) -> str:
        message = cls._get_message()
        return message

    @classmethod
    def _get_message(cls) -> str:
	
        general_count = cls.users.find().count()
        man_count = cls.users.find({'gender':'man'}).count()
        woman_count = cls.users.find({'gender':'woman'}).count()
        men = cls.users.find({'gender':'man'})
	
	#moscow_count = cls.users.find({'city':'Москва'}).collation({locale:"ru", strength:1}).count()

        pairs = 0
        for man in men:
            p = man.get('pairs')
            pairs += len(p) if p else 0
        message = f"Всего пользователей: {general_count}\n"\
                  f"Мужчин: {man_count}\n"\
                  f"Женщин: {woman_count}\n"\
                  f"Пар: {pairs}\n"\
		  f"Из Москвы: 10\n"\
		  f"Из Санкт-Петербурга:"
        return message