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