def add_featured_project(self, project):
"""See `IPillarSet`."""
query = """
PillarName.name = %s
AND PillarName.id = FeaturedProject.pillar_name
""" % sqlvalues(project.name)
existing = FeaturedProject.selectOne(query,
clauseTables=['PillarName'])
if existing is None:
pillar_name = PillarName.selectOneBy(name=project.name)
return FeaturedProject(pillar_name=pillar_name.id)
def remove_featured_project(self, project):
"""See `IPillarSet`."""
query = """
PillarName.name = %s
AND PillarName.id = FeaturedProject.pillar_name
""" % sqlvalues(project.name)
existing = FeaturedProject.selectOne(
query, clauseTables=['PillarName'])
if existing is not None:
existing.destroySelf()
def remove_featured_project(self, project):
"""See `IPillarSet`."""
query = """
PillarName.name = %s
AND PillarName.id = FeaturedProject.pillar_name
""" % sqlvalues(project.name)
existing = FeaturedProject.selectOne(query,
clauseTables=['PillarName'])
if existing is not None:
existing.destroySelf()
def add_featured_project(self, project):
"""See `IPillarSet`."""
query = """
PillarName.name = %s
AND PillarName.id = FeaturedProject.pillar_name
""" % sqlvalues(project.name)
existing = FeaturedProject.selectOne(
query, clauseTables=['PillarName'])
if existing is None:
pillar_name = PillarName.selectOneBy(name=project.name)
return FeaturedProject(pillar_name=pillar_name.id)
