collection.py 文件源码

def genres(self, mf=MusicFilter(), cursor_factory=NamedTupleCursor, fast=False):
        if fast:
            sql = """select distinct name from genres"""
            return self.__fetchfast(sql)
        else:
            if mf is None:
                sql = """select coalesce(array_agg(distinct name), array[]::text[]) as genres from genres"""
            else:
                sql = """select coalesce(array_agg(distinct genre), array[]::text[]) as genres from do_filter(%s::filter)"""
        return self.__fetchone(sql, mf, cursor_factory).genres