Skip to content

Instantly share code, notes, and snippets.

View Yeboster's full-sized avatar
🧜
Surfing life's waves

Marco Yeboster

🧜
Surfing life's waves
View GitHub Profile
@Yeboster
Yeboster / database.py
Created May 1, 2018 14:44 — forked from ssomnoremac/database.py
database connection for graphene using sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base, DeferredReflection
from sqlalchemy.orm import scoped_session, sessionmaker
connection_string = << your connection string here >>
engine = create_engine(connection_string)
db_session = scoped_session(sessionmaker(autocommit=False,
autoflush=False,
bind=engine))
@Yeboster
Yeboster / models.py
Created May 1, 2018 14:44 — forked from ssomnoremac/models.py
models for graphene sqlalchemy example
from sqlalchemy import Column, Integer, ForeignKey
from sqlalchemy.orm import relationship
from database import Base
class PersonModel(Base):
__tablename__ = 'person'
uuid = Column(Integer, primary_key=True)
Articles = relationship("ArticleModel")
class ArticleModel(Base):
@Yeboster
Yeboster / schema.py
Created May 1, 2018 14:43 — forked from ssomnoremac/schema.py
schema.py for graphene and sqlalchemy
import graphene
from graphene_sqlalchemy import SQLAlchemyConnectionField, SQLAlchemyObjectType
from models import *
class Person(SQLAlchemyObjectType):
class Meta:
model = PersonModel
interfaces = (graphene.relay.Node, )