[sqlalchemy] Debugging why Flask-SQLAlchemy won't update database

Hello, I'm hoping someone might have advice on how to track down this problem or what might be causing it. I don't have code that I can use to recreate the issue as I'm not able to recreate it outside of one instance of the same codebase (I've got a local development environment, and two test

Re: [sqlalchemy] Complex joins using kwargs

I'm sorry but I think perhaps I'm too new to SQLAlchemy to understand how your solution works. Is there a tutorial or any information on using methods/functions like that as part of a query? I've tried looking through google but the terms seem to pull back lots of results which don't apply.

[sqlalchemy] Complex joins using kwargs

Hi, I'm hoping someone's encountered something like this before, or might at least be able to point me in the direction of how to solve this paradox. I've got a many-to-many relationship that I'm trying to allow a user to search for values in any of the three tables being joined. In the

Re: [sqlalchemy] three table join with confusing results

Simon, Think I figured out the issue, but no idea how to solve for it. In the DB I was using the Groups has a foreign key I didn't think was importnant and didn't include in the trimmed down example. So I was very confused when writing the file that the issue didn't repeat until I compared

Re: [sqlalchemy] three table join with confusing results

Simon, Will put a standalone script together, I'm using Flask-SQLAlchemy so it might vary some from standard SQLAlchemy, I'll post it in a few minutes, thanks! Carl On Friday, June 1, 2018 at 8:51:32 AM UTC-5, Simon King wrote: > > What does the SQL look like for each of your queries? > > Can

[sqlalchemy] three table join with confusing results

I'm trying to join three tables in SQLAlchemy and while it works on joining and filtering with two of the tables the third one it only returns an arbitrary row (always the same one for some reason) and I'm completely confused about this behavior. Table classes: class Users(db.Model):

[sqlalchemy] problem using or_ with like()?

I'm cross posting this from StackOverflow since this might be a more specialized problem (maybe a bug, but I'm guessing I'm just getting something wrong with the syntax). In the or_ clause I'm using it only uses the column that is closer to last in the table (MySQL for the DB) and ignores the

Re: [sqlalchemy] Confused about Many-to-Many outerjoin

Figured out what I had wrong, I was trying to use the second table in the list as the basis, but the order dictates how SQLAlchemy handles it. So: q = db.session.query(User, Articles, ReadArticles) should be: q = db.session.query(Articles, User, ReadArticles) and q = q.filter(User.id ==

Re: [sqlalchemy] Confused about Many-to-Many outerjoin

Simon, Thank you, I've tried a few things and am still a bit confused. I've reconfigured the table classes a bit, here is what I'm using currently to try to grok this: class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True,

[sqlalchemy] trying to retrieve data from multiple tables with .join()

Hi, I'm still relatively a newby to SQLAlchemy and not sure if I'm using the correct query to achieve what I'm trying to and hoping someone can point me in the correct direction or help me understand what I need to use to run the query I'm attempting. I'm trying to retrieve data from multiple

[sqlalchemy] Confused about Many-to-Many outerjoin

I'm using the PrettyPrinted tutorial on Many to Many relationships with Flask-SQLAlchemy however what I'm trying to figure out he doesn't go into in the tutorial and I haven't had much luck in _Essential SQLAlchemy_ or StackOverflow finding a solution. So for his example he has two main