def titles(self, mf=MusicFilter(), cursor_factory=NamedTupleCursor, fast=False):
if fast:
sql = """select distinct title as name from musics"""
return self.__fetchfast(sql)
else:
if mf is None:
sql = """select coalesce(array_agg(distinct title), array[]::text[]) as titles from musics"""
else:
sql = """select coalesce(array_agg(distinct title), array[]::text[]) as titles from do_filter(%s::filter)"""
return self.__fetchone(sql, mf, cursor_factory).titles
评论列表
文章目录