On 6/18/14, 8:31 PM, Vineet Goel wrote: > Hi, > > I am trying to convert the following SQL to SQLAlchemy: > > |SELECT teams.department, teams.team, > IF(employee_managers.team_id IS NOT NULL, employee_managers.manager, > teams.default_manager) AS manager > FROM teams > LEFT JOIN employee_managers ON employee_managers.team_id = teams.id > WHERE teams.department = 'hr' and (employee_managers.name = 'vineet' OR > employee_managers.name IS NULL)|
the SQL standard version of "IF" is "CASE", SQLAlchemy supports CASE directly see http://docs.sqlalchemy.org/en/rel_0_9/core/sqlelement.html?highlight=case#sqlalchemy.sql.expression.case > where my models look like this: > > |class EmployeeTeam(db.Model): > __tablename__ = 'teams' > id = db.Column(db.Integer, primary_key=True) > name = db.Column(db.String(140), nullable=False) > department = db.Column(db.String(140), nullable=False) > team = db.Column(db.String(140), nullable=False) > default_manager = db.Column(db.String(140), nullable=False) > > class EmployeeManagers(db.Model): > __tablename__ = 'employee_managers' > id = db.Column(db.Integer, primary_key=True) > name = db.Column(db.String(140), nullable=False) > team_id = db.Column(db.Integer, db.ForeignKey('teams.id')) > team = db.relationship('EmployeeTeam') > manager = db.Column(db.String(140), nullable=False)| > After hours of googling, I found some func.IF kind of stuff but they > all keep giving me an OperationalError: (OperationalError) (1248, > 'Every derived table must have its own alias'). > > Does anyone know a simple way to convert this SQL to SQLAlchemy? > > Any help would be much appreciated. > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.