def getObjects():
    try:
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)
        # output type
        output = 'html'
        if 'output' in request.args:
            output = request.args['output'].lower()

        # logs all attributes received
        logger.debug(get_debug_all(request))
        # gets object name
        object_name = ''
        if ('name' in request.args):
            object_name = request.args['name']
        else:
            return "Error, must specify a object name with ?name=xxx", 404

        key = {'url': request.url, 'output': output}
        tmp_dict = None
        data_dict = None
        tmp_dict = rediscache.__getCache(key)
        data = ""
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data_dict = postgres.__getObjects(object_name)

            if (output == 'html'):
                logger.info(
                    "Treating request as a web request, output to Web page")
                data = render_template(RENDER_TABLE_DATA,
                                       columns=data_dict['columns'],
                                       object_name=object_name,
                                       entries=data_dict['data'])
            else:
                logger.info(
                    "Treating request as an API request, output to Json only")
                data = ujson.dumps(data_dict)

            if (postgres.HEROKU_LOGS_TABLE
                    not in request.url):  # we don't want to cache these logs
                rediscache.__setCache(key, data.encode('utf-8'), 300)

        else:
            logger.info("Data found in redis, using it directly")
            #logger.info(tmp_dict)
            if (output == 'html'):
                #data_dict = ujson.loads(tmp_dict)
                data = tmp_dict.decode('utf-8')
            else:
                #data = ujson.loads(tmp_dict)
                data = tmp_dict

        logger.info("returning data")
        return data, 200

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 2
0
def votes_placevote():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)
        logger.debug(utils.get_debug_all(request))

        key = {'url': request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            #gameactivity__c = request.args['gameactivity__c']
            match_id = request.args['match_id']
            resultMatch = postgres.__getMatchById(match_id)
            if (resultMatch['data'][0]['question__c'] == None):
                resultMatch['data'][0]['question__c'] = ""
            data = render_template(RENDER_PLACE_BET,
                                   entry=resultMatch['data'][0],
                                   FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                                   userid=cookie,
                                   PUSHER_KEY=notification.PUSHER_KEY)
            #rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 3
0
def root_photo():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)
        logger.debug(utils.get_debug_all(request))

        key = {'url': request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data = render_template(RENDER_ROOT_PHOTO,
                                   FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                                   userid=cookie,
                                   PUSHER_KEY=notification.PUSHER_KEY)
            #rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 200, cookie,
            cookie_exists)
Esempio n. 4
0
def tables():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        logger.debug(utils.get_debug_all(request))
        #rediscache.__display_RedisContent()
        data_dict = postgres.__getTables()
        output = 'html'
        if 'output' in request.args:
            output = request.args['output'].lower()

        if (output == 'html'):
            data = render_template(RENDER_TABLES,
                                   entries=data_dict['data'],
                                   FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                                   userid=cookie,
                                   PUSHER_KEY=notification.PUSHER_KEY)
        else:
            logger.info(
                "Treating request as an API request, output to Json only")
            data = ujson.dumps(data_dict)
        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 200, cookie,
            cookie_exists)
Esempio n. 5
0
def votes_placevote():
    try:
        if (postgres.__checkHerokuLogsTable()):
                postgres.__saveLogEntry(request)
        logger.debug(utils.get_debug_all(request))

        key = {'url' : request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            #gameactivity__c = request.args['gameactivity__c']            
            match_id = request.args['match_id']            
            resultMatch = postgres.__getMatchById(match_id)
            if (resultMatch['data'][0]['question__c'] == None):
                resultMatch['data'][0]['question__c'] = ""
            data = render_template(RENDER_PLACE_BET,
                entry = resultMatch['data'][0]
                )
            rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict
            

        return data, 200

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
def root():
    try:
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)

        logger.debug(get_debug_all(request))
        rediscache.__display_RedisContent()
        """
        key = {'url' : request.url}
        tmp_dict = None
        data_dict = None
        tmp_dict = __getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data_dict  = __getTables()
            __setCache(key, ujson.dumps(data_dict), 300)
        else:
            logger.info("Data found in redis, using it directly")
            data_dict = ujson.loads(tmp_dict)
        """
        data_dict = postgres.__getTables()

        return render_template(RENDER_INDEX, entries=data_dict['data'])

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 7
0
def root():
    try:
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)
        logger.debug(utils.get_debug_all(request))

        key = {'url': request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")

            data = render_template(RENDER_ROOT)

            rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return data, 200
    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 8
0
def photo_display():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        output = 'html'
        if 'output' in request.args:
            output = request.args['output'].lower()

        # logs all attributes received
        logger.debug(utils.get_debug_all(request))
        # gets object name
        object_name = 'ImageAnalysis__c'

        name = request.args['name']
        key = {'url': request.url, 'output': output}
        tmp_dict = None
        data_dict = None

        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data_dict = postgres.__getImageAnalysis(object_name, name)

            if (output == 'html'):
                logger.info(
                    "Treating request as a web request, output to Web page")
                if ('image__c' in data_dict['columns']):
                    data = render_template(RENDER_PHOTO_DISPLAY,
                                           columns=data_dict['columns'],
                                           object_name=object_name,
                                           entries=data_dict['data'])
            else:
                logger.info(
                    "Treating request as an API request, output to Json only")
                data = ujson.dumps(data_dict)

            #if (postgres.HEROKU_LOGS_TABLE not in request.url): # we don't want to cache these logs
            #    rediscache.__setCache(key, data.encode('utf-8'), 60)

        else:
            logger.info("Data found in redis, using it directly")
            #logger.info(tmp_dict)
            if (output == 'html'):
                #data_dict = ujson.loads(tmp_dict)
                data = tmp_dict.decode('utf-8')
            else:
                #data = ujson.loads(tmp_dict)
                data = tmp_dict

        logger.info("returning data")
        return data, 200

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
def error():
    if (postgres.__checkHerokuLogsTable()):
        postgres.__saveLogEntry(request)

    logger.debug(get_debug_all(request))
    logger.error("Generating Error")
    error_code = 500
    if ('error_code' in request.args):
        error_code = int(request.args['error_code'])
    return "Error !!!!!!", error_code
Esempio n. 10
0
def error():
    cookie, cookie_exists = utils.getCookie()

    if (postgres.__checkHerokuLogsTable()):
        postgres.__saveLogEntry(request, cookie)

    logger.debug(utils.get_debug_all(request))
    logger.error("Generating Error")
    error_code = 500
    if ('error_code' in request.args):
        error_code = int(request.args['error_code'])
    return utils.returnResponse("Error !! ", error_code, cookie, cookie_exists)
Esempio n. 11
0
def createTicket():
    try:
        cookie, cookie_exists =  utils.getCookie()

        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        logger.debug(utils.get_debug_all(request))

        form = TicketForm(request.form)
        
        hosts = postgres.__getSFUsers()
        key = {'url' : MAIN_URL, 'cookie' : cookie}
        tmp_dict = rediscache.__getCache(key)
        data = ""
        if (request.method=="GET"):
            if ((tmp_dict != None) and (tmp_dict != '')):    
                #means user has already registered, forwarding him to the guest thanks
                data = render_template(CREATETICKETS, registered=True, form=form, userid=cookie, PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
            else:
                # means it has to register
                return redirect("/",code=302)
        elif request.method == 'POST':
            if ((tmp_dict != None) and (tmp_dict != '')):    
                #means user has already registered, accepting this 
                Reason=request.form['Reason']
                Subject=request.form['Subject']
                Description=request.form['Description']
                postgres.__insertCase(cookie, Subject, Description, "Self Service", Reason)
                #postgres.__saveGuestEntry(Firstname, Lastname, Email, Company, PhoneNumber, Host, cookie, Picture)
                data = render_template(GUESTTHANKS, registered=True, userid=cookie, PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                #rediscache.__setCache(key, data.encode('utf-8'), 3600)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
            else:
                # means user has not registered and is trying to post, .. 
                # so returning him the registration page first
                return redirect("/",code=302)
        else:
            # trying to hack someting ?
            return redirect("/",code=302)

        
        data = render_template(CREATETICKETS, form=form, hosts=hosts['data'],userid=cookie,PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)

        return utils.returnResponse(data, 200, cookie, cookie_exists)
    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists =  utils.getCookie()
        return utils.returnResponse("An error occured, check logDNA for more information", 200, cookie, cookie_exists)
Esempio n. 12
0
def root_photo():
    try:
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)
        logger.debug(utils.get_debug_all(request))

        data = render_template(RENDER_ROOT_PHOTO,
                               imageid=uuid.uuid4().__str__())

        return data, 200
    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 13
0
def bets_bygameactivity__c():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)
        logger.debug(utils.get_debug_all(request))

        key = {'url': request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        has_voted = False
        if ('has_voted' in request.args):
            has_voted = bool(request.args['has_voted'])
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")

            gameactivity__c = request.args['gameactivity__c']
            resultActivityName = postgres.__getGameActivityById(
                gameactivity__c)
            result = postgres.__getMatchsByGameActivityId(gameactivity__c)

            data = render_template(
                RENDER_BETS_MATCHS,
                columns=result['columns'],
                entries=result['data'],
                category_name=resultActivityName['data'][0]['activityname'],
                category_id=gameactivity__c,
                hasvoted=has_voted,
                FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                userid=cookie,
                PUSHER_KEY=notification.PUSHER_KEY)

            #rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 200, cookie,
            cookie_exists)
Esempio n. 14
0
def image():
    try:
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)
        logger.debug(utils.get_debug_all(request))
        imageid = request.args['id']
        i = request.files['fileToUpload']  # get the image
        f = ('%s.jpeg' % (imageid))
        i.save('%s/%s' % (PATH_TO_TEST_IMAGES_DIR, f))
        completeFilename = '%s/%s' % (PATH_TO_TEST_IMAGES_DIR, f)
        # now upload
        logger.debug(completeFilename)
        awsFilename = aws.uploadData(completeFilename, f)

        return "File received, thanks for sharing!  : You can review it here : " + awsFilename, 200
    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 15
0
def contact():
    try:
        cookie, cookie_exists = utils.getCookie()

        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)
        logger.debug(utils.get_debug_all(request))
        if ('phone' not in request.args):
            return utils.returnResponse("Please provide a phone number", 403,
                                        cookie, cookie_exists)
        entry_phone = request.args['phone']
        if (entry_phone == '' or entry_phone == None):
            return utils.returnResponse("Please provide a phone number", 403,
                                        cookie, cookie_exists)

        key = {'url': request.url}
        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data_dict = postgres.__execRequest(
                'select name, mobilephone, phone, email, sfid from salesforce.contact where phone = %(phone)s or mobilephone=%(phone)s',
                {'phone': entry_phone})
            logger.info(data_dict)
            rediscache.__setCache(key, data_dict, 60)

            data = ujson.dumps(data_dict)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return utils.returnResponse(data, 200, cookie, cookie_exists)
    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 403, cookie,
            cookie_exists)
Esempio n. 16
0
def tables():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        logger.debug(utils.get_debug_all(request))
        #rediscache.__display_RedisContent()
        data_dict = postgres.__getTables()

        data = render_template(RENDER_TABLES,
                               entries=data_dict['data'],
                               FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                               userid=cookie,
                               PUSHER_KEY=notification.PUSHER_KEY)
        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 200, cookie,
            cookie_exists)
Esempio n. 17
0
def getObjects():
    try:
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)
        # output type
        output = 'html'
        describe = False
        if 'output' in request.args:
            output = request.args['output'].lower()
        if 'describe' in request.args:
            describe = True

        # logs all attributes received
        logger.debug(utils.get_debug_all(request))
        # gets object name
        object_name = ''
        if ('name' in request.args):
            object_name = request.args['name']
        else:
            return "Error, must specify a object name with ?name=xxx", 404

        key = {'url': request.url, 'output': output}
        tmp_dict = None
        data_dict = None
        tmp_dict = rediscache.__getCache(key)
        data = ""
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            if (describe == False):
                data_dict = postgres.__getObjects(object_name)
            else:
                data_dict = postgres.__getObjectsDescribe(object_name)
            if (output == 'html'):
                logger.info(
                    "Treating request as a web request, output to Web page")
                if ('image__c' in data_dict['columns']):
                    data = render_template(
                        RENDER_TABLE_DATA_IMG,
                        columns=data_dict['columns'],
                        object_name=object_name,
                        entries=data_dict['data'],
                        FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                        userid=cookie,
                        PUSHER_KEY=notification.PUSHER_KEY)
                else:
                    data = render_template(
                        RENDER_TABLE_DATA,
                        columns=data_dict['columns'],
                        object_name=object_name,
                        entries=data_dict['data'],
                        FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                        userid=cookie,
                        PUSHER_KEY=notification.PUSHER_KEY)

            else:
                logger.info(
                    "Treating request as an API request, output to Json only")
                # check if describe is jere
                if describe == False:
                    data = ujson.dumps(data_dict)
                else:
                    data = ujson.dumps({'columns': data_dict['columns']})

            #if (postgres.HEROKU_LOGS_TABLE not in request.url): # we don't want to cache these logs
            #    rediscache.__setCache(key, data.encode('utf-8'), 60)

        else:
            logger.info("Data found in redis, using it directly")
            #logger.info(tmp_dict)
            if (output == 'html'):
                #data_dict = ujson.loads(tmp_dict)
                data = tmp_dict.decode('utf-8')
            else:
                #data = ujson.loads(tmp_dict)
                data = tmp_dict

        logger.info("returning data")
        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie = utils.getCookie()
        return utils.returnResponse(
            "An error occured, check logDNA for more information", 200, cookie,
            cookie_exists)
Esempio n. 18
0
def guest():
    try:
        cookie, cookie_exists =  utils.getCookie()

        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        logger.debug(utils.get_debug_all(request))

        form = ReusableForm(request.form)
        
        hosts = postgres.__getSFUsers()
        key = {'url' : MAIN_URL, 'cookie' : cookie}
        tmp_dict = rediscache.__getCache(key)
        data = ""
        if request.method == 'GET':
            if ((tmp_dict != None) and (tmp_dict != '')):    
                #means user has already registered, forwarding him to the guest thanks
                data = render_template(GUESTTHANKS, registered=True, userid=cookie, PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
            else:
                # needs to register
                data = render_template(GUESTFILE, form=form, hosts=hosts['data'],userid=cookie,PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
        elif request.method == 'POST':
            if ((tmp_dict != None) and (tmp_dict != '')):  
                #user has gone through the registration process already, need to redirect him to the guest thanks page
                data = render_template(GUESTTHANKS, registered=True, userid=cookie, PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
            else:
                #user has not registerd yet, it's the case now 
                Firstname=request.form['Firstname']
                Lastname=request.form['Lastname']
                Email=request.form['Email']
                Company=request.form['Company']
                PhoneNumber=request.form['PhoneNumber']
                Host=request.form['Host']
                Picture="https://3.bp.blogspot.com/-KIngJEZr94Q/Wsxoh-8kwuI/AAAAAAAAQyM/YlDJM1eBvzoDAUV79-0v_Us-amsjlFpkgCLcBGAs/s1600/aaa.jpg"
                if ("fileToUpload" in request.files):
                    Picture, rabbitData  =aws.AWS_upload(request.files['fileToUpload'], request)
                    rabbitData['cookie'] = cookie
                    rabbitData['UPLOAD_IN_REDIS'] = False
                    rabbitData['remote_url'] = Picture
                    logger.info(rabbitData)
                    rabbitmq.sendMessage(ujson.dumps(rabbitData), rabbitmq.CLOUDAMQP_QUEUE)


                postgres.__saveGuestEntry(Firstname, Lastname, Email, Company, PhoneNumber, Host, cookie, Picture)
                data = render_template(GUESTTHANKS, registered=False, userid=cookie, PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)
                rediscache.__setCache(key, ujson.dumps({"Status":"Logged In"}), 3600)
                return utils.returnResponse(data, 200, cookie, cookie_exists)
                    
        else:
            #redirecting the user
            return redirect("/",code=302)

        if form.validate():
            # Save the comment here.
            flash('Hello ' + Firstname)
        else:
            flash('All the form fields are required. ')
        
        data = render_template(GUESTFILE, form=form, hosts=hosts['data'],userid=cookie,PUSHER_KEY=notification.PUSHER_KEY, PUSHER_CLUSTER=notification.CLUSTER)

        return utils.returnResponse(data, 200, cookie, cookie_exists)
    except Exception as e:
        import traceback
        traceback.print_exc()
        cookie, cookie_exists =  utils.getCookie()
        return utils.returnResponse("An error occured, check logDNA for more information", 200, cookie, cookie_exists)

        
Esempio n. 19
0
def bet_vote():
    try:

        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request)
        logger.debug(utils.get_debug_all(request))

        # trick
        # ?matchid={{ entry.match_id }}&gameactivity__c={{ entry.gameactivity__c }}&vote_winner={{ entry.participant_home_id}}
        is_vote_through_get = False
        if ('matchid' in request.args and 
            'vote_winner' in request.args and
            'gameactivity__c' in request.args):
            is_vote_through_get = True

        if (request.method == 'POST' or is_vote_through_get == True):
            matchid = request.args['matchid']
            gameactivity__c=request.args['gameactivity__c']
            if (is_vote_through_get):
                winner = request.args['vote_winner']
            else:
                winner = request.form['vote_winner']
            useragent = request.headers['User-Agent']
            

            externalid = uuid.uuid4().__str__()
            createddate  = datetime.now()

            sqlRequest = """
                insert into salesforce.bet__c (winner__c, 
                useragent__c, 
                name, 
                externalid__c, 
                match__c,
                createddate) values 
                ( %(winner)s, %(useragent)s, %(externalid)s, %(externalid)s, %(matchid)s, %(createddate)s ) """
            
            postgres.MANUAL_ENGINE_POSTGRES.execute(sqlRequest,
                        {
                        'winner' : winner,
                        'useragent' : useragent,
                        'createddate':createddate,
                        'externalid' : externalid,
                        'matchid':matchid} )   
            logger.info('##### vote taken into account ####')
            return redirect('/matchs?gameactivity__c='+gameactivity__c+"&has_voted=True")
        else:            
            key = {'url' : request.url}
            tmp_dict = None
            data_dict = None
            tmp_dict = rediscache.__getCache(key)
            if ((tmp_dict == None) or (tmp_dict == '')):
                logger.info("Data not found in cache")
                sqlRequest = """
                    select   
                        salesforce.gameactivity__c.name , 
                        salesforce.gameactivity__c.sfid, 
                        (select count(*) from  salesforce.match__c where salesforce.match__c.gameactivity__c = salesforce.gameactivity__c.sfid) as nbMatchs 
                    from salesforce.gameactivity__c 

                    """
                data_dict = postgres.__execRequest(sqlRequest, None)
                
                data = render_template(RENDER_BETS_MAIN,
                    columns=data_dict['columns'],
                    entries = data_dict['data'])

                rediscache.__setCache(key, data, 60)
            else:
                logger.info("Data found in redis, using it directly")
                data = tmp_dict

            return data, 200

    except Exception as e:
        import traceback
        traceback.print_exc()
        return "An error occured, check logDNA for more information", 200
Esempio n. 20
0
def image():
    try:

        logger.debug(utils.get_debug_all(request))

        i = request.files['fileToUpload']  # get the image
        imageid = uuid.uuid4().__str__()
        f = ('%s.jpeg' % (imageid))
        i.save('%s/%s' % (PATH_TO_TEST_IMAGES_DIR, f))
        completeFilename = '%s/%s' % (PATH_TO_TEST_IMAGES_DIR, f)

        try:
            filepath = completeFilename
            image = Image.open(filepath)

            img_width = image.size[0]
            img_height = image.size[1]

            for orientation in ExifTags.TAGS.keys():
                if ExifTags.TAGS[orientation] == 'Orientation':
                    break
            exif = dict(image._getexif().items())
            logger.debug(exif[orientation])
            if exif[orientation] == 3:
                image = image.rotate(180, expand=True)
                image.save(
                    filepath,
                    quality=50,
                    subsampling=0,
                )
            elif exif[orientation] == 6:
                image = image.rotate(270, expand=True)
                image.save(
                    filepath,
                    quality=50,
                    subsampling=0,
                )
            elif exif[orientation] == 8:
                image = image.rotate(90, expand=True)
                image.save(
                    filepath,
                    quality=50,
                    subsampling=0,
                )

            img_width = image.size[0]
            img_height = image.size[1]
            image.close()
        except Exception as e:
            import traceback
            traceback.print_exc()

        # ok the entry is correct let's add it in our db
        cookie, cookie_exists = utils.getCookie()
        if (postgres.__checkHerokuLogsTable()):
            postgres.__saveLogEntry(request, cookie)

        # now upload
        logger.debug(completeFilename)

        #prepare rabbitmq data
        rabbitdata = {
            'id': imageid,
            'user-agent': request.headers['User-Agent'],
            'url': request.url,
            'image_width': img_width,
            "image_height": img_height,
            'cookie': cookie
        }

        if (UPLOAD_IN_REDIS == True):
            # Save the image into redis
            file = open(completeFilename, "rb")
            data = file.read()
            file.close()
            rediscache.__setCache(imageid, data, 3600)
            os.remove(completeFilename)
            logger.info("File saved in Redis")
            rabbitdata['UPLOAD_IN_REDIS'] = True
        else:
            # saves into AWS
            rabbitdata['UPLOAD_IN_REDIS'] = False
            remotefilename = imageid + ".jpg"
            awsFilename = aws.uploadData(completeFilename, remotefilename)
            os.remove(completeFilename)
            logger.info("File saved in AWS")
            rabbitdata['remote_url'] = awsFilename

        # Sends data to RabbitMQ
        logger.debug(rabbitdata)
        rabbitmq.sendMessage(ujson.dumps(rabbitdata), rabbitmq.CLOUDAMQP_QUEUE)
        #awsFilename = aws.uploadData(completeFilename, f)

        key = {
            'url': request.url,
            'status_upload': 'Thanks for participating',
            'error_upload': None
        }

        tmp_dict = None
        #data_dict = None
        tmp_dict = rediscache.__getCache(key)
        if ((tmp_dict == None) or (tmp_dict == '')):
            logger.info("Data not found in cache")
            data = render_template(RENDER_ROOT_PHOTO,
                                   status_upload="Thanks for participating",
                                   error_upload=None,
                                   FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
                                   userid=cookie,
                                   PUSHER_KEY=notification.PUSHER_KEY)
            #rediscache.__setCache(key, data, 60)
        else:
            logger.info("Data found in redis, using it directly")
            data = tmp_dict

        return utils.returnResponse(data, 200, cookie, cookie_exists)

    except Exception as e:
        import traceback
        cookie, cookie_exists = utils.getCookie()
        data = render_template(
            RENDER_ROOT_PHOTO,
            status_upload=None,
            error_upload=
            "An error occured while saving your file, please try again",
            FA_APIKEY=utils.FOLLOWANALYTICS_API_KEY,
            userid=cookie,
            PUSHER_KEY=notification.PUSHER_KEY)

        return utils.returnResponse(data, 200, cookie, cookie_exists)