def get(self, request):

        if not hasattr(request.user, 'risk'):
            return redirect(
                '/analysis/risk?next=/analysis/compare/{}'.format(id))
        model = ModelPortfolio()
        # user = User.objects.get(id= request.user)
        model_id = model.recommended_portfolio(request, request.user)
        portfolio = Portfolio.objects.get(id=model_id)
        # assets = Asset.objects.filter(portfolio=portfolio)
        assets = Asset.objects.raw(
            '''SELECT *, cost_basis * quantity as value 
            FROM portfolio_asset
            WHERE portfolio_asset.portfolio_id = %s ''', (id, ))
        # print(assets)
        portfolio_value = 0
        for asset in assets:
            portfolio_value += asset.value

        assets = [
            asset.to_json(asset.value, portfolio_value) for asset in assets
        ]
        for asset in assets:
            asset_value = round(asset_value, 2)

        # print(assets)
        return JsonResponse({
            'asset': assets,
            'portfolio_value': portfolio_value
        })
    def get(self,request,id):

        if not hasattr(request.user,'risk'):
            return redirect('/analysis/risk?next=/analysis/compare/{}'.format(id))
        portfolio = Portfolio.objects.get(id=id)
        print(id)
        print(portfolio.user.id)
        model = ModelPortfolio()
        model_id = model.recommended_portfolio(request,portfolio.user)
        id_model = model_id
        print(id)
        print(id_model)
        analysis = Analysis_portfolio()
        context1 = analysis.anlaysis_portfolio(id)
        context2 = analysis.anlaysis_portfolio(id_model)
        context = dict(owen = context1, model = context2)
        print(context)
        return render(request, self.template_name, context) 
    def get(self, request, id):

        if not hasattr(request.user, 'risk'):
            return redirect(
                '/analysis/risk?next=/analysis/compare/{}'.format(id))
        portfolio = Portfolio.objects.get(id=id)
        print(id)
        print(portfolio.user.id)
        model = ModelPortfolio()
        model_id = model.recommended_portfolio(request, portfolio.user)
        id_model = model_id
        print(id)
        print(id_model)
        analysis = Analysis_portfolio()
        context1 = analysis.anlaysis_portfolio(id)
        context2 = analysis.anlaysis_portfolio(id_model)
        context = dict(owen=context1, model=context2)
        print(context)
        return render(request, self.template_name, context)
    def get(self,request):
        
        if not hasattr(request.user,'risk'):
            return redirect('/analysis/risk?next=/analysis/compare/{}'.format(id))
        model = ModelPortfolio()
        # user = User.objects.get(id= request.user)
        model_id = model.recommended_portfolio(request,request.user)
        portfolio = Portfolio.objects.get(id=model_id)
        # assets = Asset.objects.filter(portfolio=portfolio)
        assets= Asset.objects.raw('''SELECT *, cost_basis * quantity as value 
            FROM portfolio_asset
            WHERE portfolio_asset.portfolio_id = %s ''',(id,))
        # print(assets)
        portfolio_value = 0 
        for asset in assets:
            portfolio_value += asset.value
        
        assets = [ asset.to_json(asset.value,portfolio_value)for asset in assets ]
        for asset in assets:
            asset_value = round(asset_value,2)

        # print(assets)
        return JsonResponse({'asset':assets,'portfolio_value':portfolio_value})