Examples not working

[thobai]

Hi there,

I've installed your package and tried to get the examples working, but I neither get it working in Jupyter nor in Superset. When trying your first example from the README, I get the error SQLError: no such table: allPeople?include=homeworld.

With the following code, I just get ValueError: [{'message': 'Missing query'}]

from sqlalchemy import create_engine
from sqlalchemy import text, inspect

from sqlalchemy.dialects import registry


# We use GraphQL SWAPI (The Star Wars API) c/o Netlify:
engine = create_engine('graphql://swapi-graphql.netlify.app/.netlify/functions/index')

with engine.connect() as connection:
    insp = inspect(connection)
    insp.get_table_names()

When trying to use your package with Apache Superset, it errors when trying to retrieve the list of tables. I used the example URL (graphql://swapi-graphql.netlify.app/.netlify/functions/index) as well as my own. Both give the same result.

Is there anything that I'm doing wrong or has the package become incompatible with newer sqlalchemy versions? I'm using sqlalchemy = "^2.0.36"

[thobai]

I got it to work with my own graphql API and it seems that something has changed with swapi-graphql.netlify.app/.netlify/functions/index. Not sure what exactly. Would be good to have a look and probably update the example.

[AnthonyTlei]

Could you share how you got it working with your own api?
I keep getting the table not found error.

Here's my test:

from sqlalchemy import create_engine
from sqlalchemy import text

engine = create_engine(f'graphql://localhost:4000/graphql?is_https=0')

query = "select name from 'allUsers'"

with engine.connect() as connection:
    for row in connection.execute(text(query)):
        print(row)

SQLError: no such table: allUsers

Note that i can query the endpoint just fine and introspection is enabled.

[thobai]

To be honest, I cannot exactly remember 🙄 I have abandoned the approach and started to implement my own DB API 2.0 driver and corresponding sqlalchemy plugin.

Yet, looking at my testing code, I can say that I had to mark my tables as list_queries so my engine statement looked like this:

engine = create_engine(
    "graphql://localhost:8000/graphql?is_https=0", list_queries=["books", "aggregation"]
)