gistfile1.txt

Base = declarative_base()

engine = create_engine('postgresql://vagrant:vagrant@33.33.33.15:5432/vagrant', echo=True)
engine.connect()
Session = sessionmaker(bind=engine)

class JSchema(ConcreteBase, Base):
    __tablename__ = 'json_schemas'

    id = Column(Integer, primary_key=True)
    version = Column(Integer, nullable=False)
    domain = Column(String(50), nullable=False, unique=True)
    schema = Column(Integer, nullable=False)
    ##schema = Column(psql.JSONB, nullable=False)
    
sess = Session()
sess.add(JSchema(version=1, domain='test', schema=1))
sess.commit()
sess.close()
sess = Session()
sess.query(JSchema).count() --- THROWS:

FROM (SELECT pjoin.id AS pjoin_id, pjoin.version AS pjoin_version, pjoin.domain AS pjoin_domain, pjoin.schema AS pjoin_schema, pjoin.type AS pjoin_type
FROM (SELECT json_schemas.id AS id, json_schemas.version AS version, json_schemas.domain AS domain, json_schemas.schema AS schema, None AS type
FROM json_schemas) AS pjoin) AS anon_1
2015-04-06 14:11:16,105 INFO sqlalchemy.engine.base.Engine {}
*** ProgrammingError: (ProgrammingError) column "none" does not exist
LINE 3: ....domain AS domain, json_schemas.schema AS schema, None AS ty...
                                                             ^
 'SELECT count(*) AS count_1 \nFROM (SELECT pjoin.id AS pjoin_id, pjoin.version AS pjoin_version, pjoin.domain AS pjoin_domain, pjoin.schema AS pjoin_schema, pjoin.type AS pjoin_type \nFROM (SELECT json_schemas.id AS id, json_schemas.version AS version, json_schemas.domain AS domain, json_schemas.schema AS schema, None AS type \nFROM json_schemas) AS pjoin) AS anon_1' {}
ipdb>