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)
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
