Creating a new schema name during migration with Alembic

Hello, I'm building an application using Flask as the web framework, PostgreSQL for the database, and Flask-SQLAlchemy to communicate between the two (I'm still very new to all these technologies.) I want to use Alembic to migrate my SQLAlchemy tables that I've created in a models.py file to

Re: [sqlalchemy] Grouped data in a Flask/SQLAlchemy class

On 03/01/2017 10:22 PM, Greg Silverman wrote: On Wed, Mar 1, 2017 at 8:53 PM, mike bayer > wrote: On 03/01/2017 08:27 PM, GMS wrote: I have the following class models: | class DiagnosisDetail(Model):

Re: [sqlalchemy] Grouped data in a Flask/SQLAlchemy class

On Wed, Mar 1, 2017 at 8:53 PM, mike bayer wrote: > > > On 03/01/2017 08:27 PM, GMS wrote: > >> I have the following class models: >> >> >> | class DiagnosisDetail(Model): >> __tablename__ = 'vw_svc_diagnosis' >> diagnosis_id = Column(String(32),

Re: [sqlalchemy] Sqlalchemy is showing the wrong database tables

try running the MySQL command line client: mysql -u root -h localhost salestax then do "show tables". that will show you what tables are in the "salestax" database. On 03/01/2017 08:31 PM, Wilfredo Rivera wrote: I am trying to connect to MySQL database with sqlalchemy. The

Re: [sqlalchemy] Grouped data in a Flask/SQLAlchemy class

On 03/01/2017 08:27 PM, GMS wrote: I have the following class models: | class DiagnosisDetail(Model): __tablename__ = 'vw_svc_diagnosis' diagnosis_id = Column(String(32), primary_key=True) first_name = Column(String(255)) last_name = Column(String(255))

[sqlalchemy] Sqlalchemy is showing the wrong database tables

I am trying to connect to MySQL database with sqlalchemy. The connection is succesful, but when I query the tables of the database it shows me the wrong tables. The tables that the script shows are the ones that I see in the MySQL for Excel extension, but not the one that is in database that

[sqlalchemy] Grouped data in a Flask/SQLAlchemy class

I have the following class models: class DiagnosisDetail(Model): __tablename__ = 'vw_svc_diagnosis' diagnosis_id = Column(String(32), primary_key=True) first_name = Column(String(255)) last_name = Column(String(255)) mrn = Column(String(255))

[sqlalchemy] Grouped data in a Flask/SQLAlchemy class

I have the following class models: class DiagnosisDetail(Model): __tablename__ = 'vw_svc_diagnosis' diagnosis_id = Column(String(32), primary_key=True) first_name = Column(String(255)) last_name = Column(String(255)) mrn = Column(String(255))

[sqlalchemy] Alembic 0.9.1 released

Alembic release 0.9.1 is now available. One improvement from 0.9.0, regarding raising when a migration inadvertently left an internal transaction open, had an unintended side effect for some custom env.py environments; the issue has been fixed. Changelog is at: