Graphene-SQLAlchemy

Installation

For instaling graphene, just run this command in your shell

pip install "graphene-sqlalchemy>=1.0"

Examples

Here is a simple SQLAlchemy model:

from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import backref, relationship

from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class UserModel(Base):
    __tablename__ = 'department'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    last_name = Column(String)

To create a GraphQL schema for it you simply have to write the following:

from graphene_sqlalchemy import SQLAlchemyObjectType

class User(SQLAlchemyObjectType):
    class Meta:
        model = UserModel

class Query(graphene.ObjectType):
    users = graphene.List(User)

    def resolve_users(self, args, context, info):
        query = User.get_query(context) # SQLAlchemy query
        return query.all()

schema = graphene.Schema(query=Query)

Then you can simply query the schema:

query = '''
    query {
      users {
        name,
        lastName
      }
    }
'''
result = schema.execute(query, context_value={'session': db_session})

To learn more check out the following examples:

Full example: Flask SQLAlchemy example

Contributing

After cloning this repo, ensure dependencies are installed by running:

python setup.py install

After developing, the full test suite can be evaluated by running:

python setup.py test # Use --pytest-args="-v -s" for verbose mode

Metadata

Release files for graphene-sqlalchemy 2.0.dev2017072601

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for graphene-sqlalchemy 2.0.dev2017072601
File	Size	Uploaded	Provenance
graphene-sqlalchemy-2.0.dev2017072601.tar.gz	11.6 kB	Jul 27, 2017	Without provenance	Details

Release files / graphene-sqlalchemy-2.0.dev2017072601.tar.gz

Download URL	graphene-sqlalchemy-2.0.dev2017072601.tar.gz
Size	11.6 kB
Tags	Source
SHA-256 checksum How to use checksums	`c2b12aa3d0f62370e564169016b887a711eb6b4bf9370d3abec8be5860823c72`
BLAKE2b-256 checksum How to use checksums	`d25116ce8d91b5252f0b5cd25086a88209afc4eef964baa1f7925f3ec9188c93`
Upload date	Jul 27, 2017
Uploaded using Trusted Publishing? What is trusted publishing?	No

Security for graphene-sqlalchemy 2.0.dev2017072601

Report project as malware

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.