Thank you. I may have figured out what did. Looks like I'm having the same issue again after you killed the processes. Here is what I changed right before this issue started again.
*Original Line*
db.engine.execute(text('DROP VIEW IF EXISTS vw_backlogs'))
db.engine.execute(text('CREATE VIEW vw_backlogs AS SELECT * FROM product_backlog;'))
*Changed Line*
db.session.execute(text('DROP VIEW IF EXISTS vw_backlogs'))
db.session.execute(text('CREATE VIEW vw_backlogs AS SELECT * FROM product_backlog;'))
I'm trying to specify a database binding when I execute some raw SQL. I have a separate log database that I want to clear out at the start of my app.
I have my bindings setup like this:
SQLALCHEMY_BINDS = {
'qops': SQLALCHEMY_DATABASE_URI,
'qopslog': QOPS_DB_URI,
}
So in my line of code above I'm trying to figure out how to specify the 'qopslog' binding to execute against.
Do you think changing from engine to session might be causing the issue that you saw. It's the only change I made prior to causing the problem again. Do you happen to know how I can achieve this? If not, no worries and I'll continue to research (but won't try the session thing again). :)
If you can check and kill any processes again that would be most appreciated. Again, sorry for the trouble as I learn my way around Flask and Python.
Sincerely,
Jason