pyspider读取数据库中的result

from pyspider.database import connect_database


def read_from_db():
    resultdb = connect_database('mysql+resultdb://root:123456@127.0.0.1:3306/resultdb')
    for project in resultdb.projects:
        for result in resultdb.select(project):
            if result['result']['type'] != '其它':
                yield {
                    'url': result['result']['url'],
                    'type': result['result']['type']
                }


if __name__ == '__main__':
    for item in read_from_db():
        print(item)