I keep getting a request error: 'Request' object has no attribute 'get'

[jhonatanTeixeira]

python 3.6
pipenv
ubuntu 16.04
mysql 5.7

my packages:

[packages]
flask-graphql = "*"
flask-sqlalchemy = "*"
sqlalchemy-fulltext-search = "*"
graphene-sqlalchemy = ">=2.0"
flask-restful = "*"
flask-marshmallow = "*"
sqlalchemy-pagination = "*"

my code:

from graphene import ObjectType, Schema, relay, Field
from graphene_sqlalchemy import SQLAlchemyObjectType, SQLAlchemyConnectionField
from app.domain.model import Material, Grupo, Classe, Pdm

class MaterialType(SQLAlchemyObjectType):
    class Meta:
        model = Material
        interfaces = (relay.Node, )


class PdmType(SQLAlchemyObjectType):
    class Meta:
        model = Pdm
        interfaces = (relay.Node,)


class ClasseType(SQLAlchemyObjectType):
    class Meta:
        model = Classe
        interfaces = (relay.Node, )


class GrupoType(SQLAlchemyObjectType):
    class Meta:
        model = Grupo
        interfaces = (relay.Node, )


class Query(ObjectType):
    node = relay.Node.Field()
    materiais = SQLAlchemyConnectionField(MaterialType)
    pdms = SQLAlchemyConnectionField(PdmType)
    classes = SQLAlchemyConnectionField(ClasseType)
    grupos = SQLAlchemyConnectionField(GrupoType)
    material = Field(GrupoType)
    pdm = Field(PdmType)
    classe = Field(ClasseType)
    grupo = Field(GrupoType)

schema = Schema(query=Query, types=[MaterialType, PdmType, ClasseType, GrupoType])

import os
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from app.domain.model import Base

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = connection_string
db = SQLAlchemy(app, metadata=Base.metadata)

app.add_url_rule('/graphql', view_func=GraphQLView.as_view('graphql', schema=schema, graphiql=True))

my error:

An error occurred while resolving field Query.materiais
Traceback (most recent call last):
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphql/execution/executor.py", line 311, in resolve_or_error
    return executor.execute(resolve_fn, source, info, **args)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphql/execution/executors/sync.py", line 7, in execute
    return fn(*args, **kwargs)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphene_sqlalchemy/fields.py", line 36, in connection_resolver
    iterable = cls.get_query(model, info, **args)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphene_sqlalchemy/fields.py", line 20, in get_query
    return get_query(model, info.context)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphene_sqlalchemy/utils.py", line 13, in get_query
    session = get_session(context)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphene_sqlalchemy/utils.py", line 7, in get_session
    return context.get('session')
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/werkzeug/local.py", line 347, in __getattr__
    return getattr(self._get_current_object(), name)
AttributeError: 'Request' object has no attribute 'get'
Traceback (most recent call last):
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphql/execution/executor.py", line 330, in complete_value_catching_error
    exe_context, return_type, field_asts, info, result)
  File "/home/jhon/.local/share/virtualenvs/crm_api-CGOvMSyN/lib/python3.5/site-packages/graphql/execution/executor.py", line 383, in complete_value
    raise GraphQLLocatedError(field_asts, original_error=result)
graphql.error.located_error.GraphQLLocatedError: 'Request' object has no attribute 'get'

Am i doing something wrong?

[marvinkome]

What did you try to do that produced this error?

[jhonatanTeixeira]

I simply use the generated gui and any graphql query i try to do produces this error. The autocomplete works tho Em 5 de mai de 2018 21:42, "Marvin Kome" <[email protected]> escreveu: What did you try to do that produced this error? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#130 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA9PD20w17EhLFwECpQ-OlatyEiL0YBlks5tvkbcgaJpZM4Tuo5x> .

[kigen]

This is an issue with db session, I also had the same issue.

I wish you had posted your models here also so that see how you've set up your Base object.

db_session` = scoped_session(sessionmaker(autocommit=False,
                                         autoflush=False,
                                         bind=engine)) 

Base = declarative_base()
Base.query = db_session.query_property()

The key to solving your issue is this.. Base.query = db_session.query_property()

[macic]

Interesting

[jhonatanTeixeira]

@kigen that was indeed the problem. however i had to set that on a non ortodox way cause i was using flask-sqlalchemy connection

[Kacppian]

set context_value={'session': db.session} when you're trying to execute the query. If you're using flask-graphql, context={'session': db.session}

[yoursdearboy]

Seems to be a duplicate of #30

[aliwo]

it seems get_context also works for flask-graphql

app.add_url_rule('/graphql', view_func=GraphQLView.as_view('graphql', schema=schema, graphiql=True, get_context=lambda: {'session':Session()}))

the Session() func retrives SqlalchemySession from g (my custom function)

[herve-brun]

@kigen that was indeed the problem. however i had to set that on a non ortodox way cause i was using flask-sqlalchemy connection

Hi @jhonatanTeixeira ,

I know this is an old thread, but would you mind sharing the solution you had to implement ?
I'm running into the same problem :)

By advance, thank you

[valhuber]

I am having this issue, not with classical mapping. I adapted this example, resulting in this repo.

• Database.py contains Base.query = db_session.query_property()

Stacktrace:

Traceback (most recent call last): File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphql/execution/executor.py", line 452, in resolve_or_error return executor.execute(resolve_fn, source, info, **args) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphql/execution/executors/sync.py", line 16, in execute return fn(*args, **kwargs) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 78, in connection_resolver return on_resolve(resolved) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 51, in resolve_connection resolved = cls.get_query(model, info, **args) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 110, in get_query query = get_query(model, info.context) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/utils.py", line 16, in get_query session = get_session(context) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/utils.py", line 10, in get_session return context.get("session") File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/werkzeug/local.py", line 347, in __getattr__ return getattr(self._get_current_object(), name) AttributeError: 'Request' object has no attribute 'get' Traceback (most recent call last): File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphql/execution/executor.py", line 452, in resolve_or_error return executor.execute(resolve_fn, source, info, **args) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphql/execution/executors/sync.py", line 16, in execute return fn(*args, **kwargs) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 78, in connection_resolver return on_resolve(resolved) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 51, in resolve_connection resolved = cls.get_query(model, info, **args) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/fields.py", line 110, in get_query query = get_query(model, info.context) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/utils.py", line 16, in get_query session = get_session(context) File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/graphene_sqlalchemy/utils.py", line 10, in get_session return context.get("session") File "/Users/val/dev/graph_ql/payment_allocation_graphene/venv/lib/python3.8/site-packages/werkzeug/local.py", line 347, in __getattr__ return getattr(self._get_current_object(), name) graphql.error.located_error.GraphQLLocatedError: 'Request' object has no attribute 'get'

[ShantanuJoshi]

I am having this issue, not with classical mapping. I adapted this example, resulting in this repo.

Is your Base.query = db_session.query_property() in the same module as your mapping?

[valhuber]

Thanks for getting back... I will check

[mr-narender]

I tried the usual way by setting it at the model like this, which by the way doesnot work for me.

Base.query = db_session.query_property()

However, I think, @aliwo your idea was way cleaner to set the context at the root, and worked for me. thanks man.!

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related topics referencing this issue.