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