generate default graphene schema from sqlalchemy model base on graphene-sqlalchemy
Project description
generate default graphene schema from sqlalchemy model base on graphene-sqlalchemy
Installation
just run
pip install graphene_sqlalchemy_auto
Features
- auto add
offset
limit
totalCount
to pagination - auto add
dbId
for model's database id - mutation auto return ok for success,message for more information and output for model data
How To Use
example :
from graphene_sqlalchemy_auto import QueryObjectType,MutationObjectType
from sqlalchemy.ext.declarative import declarative_base
import graphene
from sqlalchemy.orm import sessionmaker
Base = declarative_base()
Session = sessionmaker()
class Query(QueryObjectType):
class Meta:
declarative_base = Base
exclude_models = ["User"] # exclude models
class Mutation(MutationObjectType):
class Meta:
declarative_base = Base
session=Session() # mutate used
include_object = []# you can use yourself mutation UserCreateMutation, UserUpdateMutation
schema = graphene.Schema(query=Query, mutation=Mutation)
Query example
just equal
query{
userList(filters:{name: "a"}){
edges{
node{
name
id
dbId
}
}
}
}
OR support more expr
query{
userList(filters:[{key: "name",op: "==", val: "a"}]){
edges{
node{
name
id
dbId
}
}
}
}
op supports:
- ==
- !=
- >=
- <=
- >
- <
- starts
- ends
- contains
- in
- notin
- any
Mutation example
createUser(input:{name: "cc",password: "dd"}){
ok
output{
id
dbId
name
}
message
}
about Schema names
- model.class.name.lower : query a data by id
- model.class.name.decapitalize[first lower]+"List": query list
- create|update|delete+model.class.name : mutation data
about many-to-many mutation
now you can use schema everywhere.some like flask,fastapi
also more example you can find in example
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for graphene-sqlalchemy-auto-1.3.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 89dff09739d9052f36836c76e80a89043d1f09012eab5dc08b7c2c41c12b791d |
|
MD5 | ad93927188014394b46e476f00bf8a14 |
|
BLAKE2b-256 | 9ed5a4f4e56ba021dcfe68ef265d36be076ed9ea2d62b2ad4912125a7209b726 |
Close
Hashes for graphene_sqlalchemy_auto-1.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cc4d1b846d48202654195aa515a15b9e050c8a2137c65a04227b4eefc98adc70 |
|
MD5 | f17110a6615d8886ad01ffc00f051efb |
|
BLAKE2b-256 | 925101062713177452d23057b4cc886d0d704e066cb48587809d6c8246707903 |