I've read over 20 different questions with the same problem - and the suggested answers didn't solve my problem. I'm still getting sqlalchemy psycopg2.errors.InsufficientPrivilege: permission denied for relation <<table>> Environment: EC2, debian 8, postgresql, flask, sqlalchemy my table in postgresql:…
I've created a few migrations already using Alembic, it's a really interesting tool. Using it on a new DB would be straightforward enough, however our usecase is to apply these migrations to existing DB's, not only to bring them "up…
code : from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker DBSession = sessionmaker() DBSession.bind = engine session = DBSession() engine = create_engine('mysql://root:password@localhost/db', echo=True) Base = declarative_base(engine) class Accounts(Base): __tablename__ = 'accounts' __table_args__ = {'autoload': True} I…