def getAskableCurrentTags(request): if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) asked = objJson['asked'] user = User.objects.filter(username=objJson['login'])[0] profile = Profile.objects.filter(id_user=user)[0] listtags = ListTags.objects.filter(id_profile=profile) res = {} if len(listtags) > 0: for lt in listtags: tag = lt.id_tag category = tag.id_category theme = category.id_theme if (theme.theme in asked and category.category in asked[theme.theme] and tag.tag in asked[theme.theme][category.category]): continue if not theme.theme in res: res[theme.theme] = {} if not category.category in res[theme.theme]: res[theme.theme][category.category] = [] res[theme.theme][category.category].append(tag.tag) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getMyFriends(request): """ Récupère les amis d'un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.get(username=objJson['login']) profile = Profile.objects.get(id_user=user) res = [] friends = Friendship.objects.filter(profile1=profile) for friend in friends: p = Profile.objects.filter(pseudo=friend.profile2.pseudo) if p.exists(): p = p[0] res.append(ProfileDTO(p, p.pourcentage).toJson()) friends = Friendship.objects.filter(profile2=profile) for friend in friends: p = Profile.objects.filter(pseudo=friend.profile1.pseudo) if p.exists(): p = p[0] res.append(ProfileDTO(p, p.pourcentage).toJson()) return myDumpJson(res) else: return HttpResponse(content="Not a POST request", status=400)
def getAskableCurrentTags(request): if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) asked = objJson['asked'] user = User.objects.filter(username=objJson['login'])[0] profile = Profile.objects.filter(id_user=user)[0] listtags = ListTags.objects.filter(id_profile=profile) res = {} if len(listtags) > 0: for lt in listtags: tag = lt.id_tag category = tag.id_category theme = category.id_theme if (theme.theme in asked and category.category in asked[theme.theme] and tag.tag in asked[theme.theme][category.category]): continue if not theme.theme in res: res[theme.theme] = {} if not category.category in res[theme.theme]: res[theme.theme][category.category] = [] res[theme.theme][category.category].append(tag.tag) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getMyFriends(request): """ Récupère les amis d'un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.get(username=objJson['login']) profile = Profile.objects.get(id_user=user) res = [] friends = Friendship.objects.filter(profile1=profile) for friend in friends: p = Profile.objects.filter(pseudo=friend.profile2.pseudo) if p.exists(): p = p[0] res.append(ProfileDTO(p, p.pourcentage).toJson()) friends = Friendship.objects.filter(profile2=profile) for friend in friends: p = Profile.objects.filter(pseudo=friend.profile1.pseudo) if p.exists(): p = p[0] res.append(ProfileDTO(p, p.pourcentage).toJson()) return myDumpJson(res) else: return HttpResponse(content="Not a POST request", status=400)
def getHistoriqueCheckin(request, user): user = User.objects.filter(username=user)[0] checkins = Checkin.objects.filter(id_user=user) res = [] for c in checkins: hc = HistoriqueCheckinDTO(c) res.append(hc.toJson()) return myDumpJson(res)
def getHistoriqueCheckin(request, user): user = User.objects.filter(username=user)[0] checkins = Checkin.objects.filter(id_user=user) res = [] for c in checkins: hc = HistoriqueCheckinDTO(c) res.append(hc.toJson()) return myDumpJson(res)
def getPossibleChallengers(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] res = findValidCheckins(user, getLastCheckin(user)) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getPossibleChallengers(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] res = findValidCheckins(user, getLastCheckin(user)) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getGameQuestions(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] prof = Profile.objects.filter(id_user=user)[0] profchall = Profile.objects.filter(pseudo=objJson['pseudo-challenger'])[0] game = Game.objects.filter(profile1=prof, profile2=profchall) if len(game) == 0: game = Game.objects.filter(profile1=profchall, profile2=prof) if len(game) == 0: game = Game.objects.create_game(profile1=prof, profile2=profchall, startDate=datetime.now()) else: game = game[0] questions = Question.objects.filter(id_game=game) tab = [] for question in questions: if question.prof_ask == prof: lt = ListTags.objects.filter(id_profile=profchall, id_tag=question.id_tag) q = QuestionDTO(question, len(lt) == 1, True) else : lt = ListTags.objects.filter(id_profile=prof, id_tag=question.id_tag) q = QuestionDTO(question, len(lt) == 1, False) tab.append(q.toJson()) res = {} res['questions'] = tab res['turn'] = game.turn1 if game.profile1 == prof else game.turn2 res['startDate'] = game.startDate.strftime('%d/%m/%Y %H:%M:%S') if len(questions) > 0 : res['lastDate'] = questions[len(questions) - 1].askDate.strftime('%d/%m/%Y %H:%M:%S') else: res['lastDate'] = ' - ' f1 = Friendship.objects.filter(profile1=prof, profile2=profchall) f2 = Friendship.objects.filter(profile1=profchall, profile2=prof) res['friend'] = False res['canBeFriends'] = False if f1.exists() or f2.exists(): res['friend'] = True else: num = 0 challNum = 0 for q in res['questions']: if q['answer']: if q['profile'] == profchall: challNum += 1 if q['profile'] == prof: num += 1 res['canBeFriends'] = num >= 3 and challNum >= 3 return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def dispatchDataBase(request, username): """ Récupère toute la base de données """ if request.method == 'GET': user = User.objects.filter(username=username) profile = Profile.objects.filter(id_user=user[0]) res = getDataBase(profile[0]) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def dispatchDataBase(request, username): """ Récupère toute la base de données """ if request.method == 'GET': user = User.objects.filter(username=username) profile = Profile.objects.filter(id_user=user[0]) res = getDataBase(profile[0]) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getProfile(request): """ Récupère le profil d'un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login']) prof = Profile.objects.filter(id_user=user)[0] p = ProfileDTO(prof, prof.pourcentage) return myDumpJson(p.toJson()) else: return HttpResponse(content="Not a POST request", status=400)
def getAllThemes(request): """ Récupère tous les thèmes de l'application """ if request.method == 'GET': allThemes = Theme.objects.all() res = [] for theme in allThemes: res.append(theme.theme) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getProfile(request): """ Récupère le profil d'un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login']) prof = Profile.objects.filter(id_user=user)[0] p = ProfileDTO(prof, prof.pourcentage) return myDumpJson(p.toJson()) else: return HttpResponse(content="Not a POST request", status=400)
def getAllThemes(request): """ Récupère tous les thèmes de l'application """ if request.method == 'GET': allThemes = Theme.objects.all() res = [] for theme in allThemes: res.append(theme.theme) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getTagsLetter(request, theme, category): """ Récupère tous les tags d'une catégorie d'un thème, en fonction d'une recherche """ if request.method == 'POST': letter = request.POST.get('letter') name = request.POST.get('login') user = User.objects.filter(username=name) them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) cat = Category.objects.filter(id_theme=them, category=urllib.parse.unquote(category)) return myDumpJson(getTags(category=cat, profile=profile, letter=letter)) else: return HttpResponse(content="Not a good request", status=400)
def getAllTags(request, theme, category): """ Récupère tous les tags d'une catégorie d'un thème """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) name = objJson['login'] user = User.objects.filter(username=name) profile = Profile.objects.filter(id_user=user)[0] them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) cat = Category.objects.filter(id_theme=them, category=urllib.parse.unquote(category)) return myDumpJson(getTags(category=cat, profile=profile)) else: return HttpResponse(content="Not a good request", status=400)
def getCategories(request, theme): """ Récupère toutes les catégories d'un thème """ if request.method == 'GET': them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) allCategories = Category.objects.filter(id_theme=them) res = [] for cat in allCategories: c = CategoryDTO(cat) res.append(c.toJson()) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getAllTags(request, theme, category): """ Récupère tous les tags d'une catégorie d'un thème """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) name = objJson['login'] user = User.objects.filter(username=name) profile = Profile.objects.filter(id_user=user)[0] them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) cat = Category.objects.filter(id_theme=them, category=urllib.parse.unquote(category)) return myDumpJson(getTags(category=cat, profile=profile)) else: return HttpResponse(content="Not a good request", status=400)
def getTagsLetter(request, theme, category): """ Récupère tous les tags d'une catégorie d'un thème, en fonction d'une recherche """ if request.method == 'POST': letter = request.POST.get('letter') name = request.POST.get('login') user = User.objects.filter(username=name) them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) cat = Category.objects.filter(id_theme=them, category=urllib.parse.unquote(category)) return myDumpJson(getTags(category=cat, profile=profile, letter=letter)) else: return HttpResponse(content="Not a good request", status=400)
def getCategories(request, theme): """ Récupère toutes les catégories d'un thème """ if request.method == 'GET': them = Theme.objects.filter(theme=urllib.parse.unquote(theme)) allCategories = Category.objects.filter(id_theme=them) res = [] for cat in allCategories: c = CategoryDTO(cat) res.append(c.toJson()) return myDumpJson(res) else: return HttpResponse(content="Not a good request", status=400)
def getDemandesChallenges(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] profile2 = Profile.objects.filter(id_user=user)[0] games = Game.objects.filter(profile2=profile2, startDate=None) res = [] for g in games: profile1 = g.profile1 compatibility = defineCompatibility(profile2, profile1) if compatibility[0]: dc = ProfileDTO(profile1, compatibility[1]) res.append(dc.toJson()) return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def getDemandesChallenges(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] profile2 = Profile.objects.filter(id_user=user)[0] games = Game.objects.filter(profile2=profile2, startDate=None) res = [] for g in games: profile1 = g.profile1 compatibility = defineCompatibility(profile2, profile1) if compatibility[0] : dc = ProfileDTO(profile1, compatibility[1]) res.append(dc.toJson()) return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def getCurrentGames(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] prof = Profile.objects.filter(id_user=user)[0] games = Game.objects.filter(profile2=prof).exclude(startDate=None) res = [] for g in games: cg = CurrentGamesDTO(g.profile1, g.turn2) res.append(cg.toJson()) games = Game.objects.filter(profile1=prof).exclude(startDate=None) for g in games: cg = CurrentGamesDTO(g.profile2, g.turn1) res.append(cg.toJson()) return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def getCurrentGames(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] prof = Profile.objects.filter(id_user=user)[0] games = Game.objects.filter(profile2=prof).exclude(startDate=None) res = [] for g in games: cg = CurrentGamesDTO(g.profile1, g.turn2) res.append(cg.toJson()) games = Game.objects.filter(profile1=prof).exclude(startDate=None) for g in games: cg = CurrentGamesDTO(g.profile2, g.turn1) res.append(cg.toJson()) return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def logUser(request): """ Connecte un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) login = objJson['login'] password = objJson['password'] user = authenticate(username=login, password=password) if user is not None: if user.is_active: logger.debug(str(user) + " authenticated !") prof = Profile.objects.filter(id_user=user)[0] p = ProfileDTO(prof, prof.pourcentage) return myDumpJson(p.toJson()) else: logger.error(str(user) + " is not active !") return HttpResponse(status=401) else: logger.error("Can't authenticate " + str(user) + "!") return HttpResponse(status=400) else: return HttpResponse(content="Not a POST request", status=400)
def logUser(request): """ Connecte un utilisateur """ if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) login = objJson['login'] password = objJson['password'] user = authenticate(username=login, password=password) if user is not None: if user.is_active: logger.debug(str(user) + " authenticated !") prof = Profile.objects.filter(id_user=user)[0] p = ProfileDTO(prof, prof.pourcentage) return myDumpJson(p.toJson()) else: logger.error(str(user) + " is not active !") return HttpResponse(status=401) else: logger.error("Can't authenticate " + str(user) + "!") return HttpResponse(status=400) else: return HttpResponse(content="Not a POST request", status=400)
def getGameQuestions(request): logger = logging.getLogger(__name__) if request.method == 'POST': objJson = json.loads(request.body.decode('utf-8')) user = User.objects.filter(username=objJson['login'])[0] prof = Profile.objects.filter(id_user=user)[0] profchall = Profile.objects.filter( pseudo=objJson['pseudo-challenger'])[0] game = Game.objects.filter(profile1=prof, profile2=profchall) if len(game) == 0: game = Game.objects.filter(profile1=profchall, profile2=prof) if len(game) == 0: game = Game.objects.create_game(profile1=prof, profile2=profchall, startDate=datetime.now()) else: game = game[0] questions = Question.objects.filter(id_game=game) tab = [] for question in questions: if question.prof_ask == prof: lt = ListTags.objects.filter(id_profile=profchall, id_tag=question.id_tag) q = QuestionDTO(question, len(lt) == 1, True) else: lt = ListTags.objects.filter(id_profile=prof, id_tag=question.id_tag) q = QuestionDTO(question, len(lt) == 1, False) tab.append(q.toJson()) res = {} res['questions'] = tab res['turn'] = game.turn1 if game.profile1 == prof else game.turn2 res['startDate'] = game.startDate.strftime('%d/%m/%Y %H:%M:%S') if len(questions) > 0: res['lastDate'] = questions[len(questions) - 1].askDate.strftime( '%d/%m/%Y %H:%M:%S') else: res['lastDate'] = ' - ' f1 = Friendship.objects.filter(profile1=prof, profile2=profchall) f2 = Friendship.objects.filter(profile1=profchall, profile2=prof) res['friend'] = False res['canBeFriends'] = False if f1.exists() or f2.exists(): res['friend'] = True else: num = 0 challNum = 0 for q in res['questions']: if q['answer']: if q['profile'] == profchall: challNum += 1 if q['profile'] == prof: num += 1 res['canBeFriends'] = num >= 3 and challNum >= 3 return myDumpJson(res, status=200) else: return HttpResponse(content="Not a good request", status=400)
def test(request): didi = Profile.objects.filter(pseudo="Le didi")[0] zozo = Profile.objects.filter(pseudo="Zozo")[0] game = Game.objects.filter(profile1=zozo, profile2=didi)[0] questions = Question.objects.filter(id_game=game).delete() return myDumpJson(Question.objects.filter(id_game=game))
def test(request): didi = Profile.objects.filter(pseudo="Le didi")[0] zozo = Profile.objects.filter(pseudo="Zozo")[0] game = Game.objects.filter(profile1=zozo, profile2=didi)[0] questions = Question.objects.filter(id_game=game).delete() return myDumpJson(Question.objects.filter(id_game=game))