2022-09-26发表2022-09-27更新Scrapy1 分钟读完 (大约140个字)

django+apscheduler+scrapy

通过apscheduler调用scrapy的spider会报错：
Error:builtins.ValueError: signal only works in main thread

按以下地址方案可以解决:
https://stackoverflow.com/questions/53605039/apschedulerscrapy-signal-only-works-in-main-thread

但使用django时，该方案中的BlockingScheduler()会阻塞django主进程启动，
将BlockingScheduler()替换为BackgroundScheduler()或TwistedScheduler()即可。

from apscheduler.schedulers.background import BackgroundScheduler

import crochet
crochet.setup()

settings = get_project_settings()
configure_logging(settings)
runner = CrawlerRunner(settings)

# Note: Removing defer here for the example
# @defer.inlineCallbacks

@crochet.run_in_reactor
def crawl():
    runner.crawl(Jobaispider)#this is my spider
    runner.crawl(Jobpythonspider)#this is my spider

# sched = BlockingScheduler()
sched = BackgroundScheduler()
sched.add_job(crawl, 'date', run_date=datetime(2018, 12, 4, 10, 45, 10))
sched.start()

2022-09-25发表2022-09-26更新Office几秒读完 (大约34个字)

Excel函数：返回目标左边一列的值

方法一：INDEX+MATCH（推荐）

简单、快速
=INDEX(B:B,MATCH(A1,C:C,))

方法二：VLOOKUP

VLOOKUP(A1,IF({1,0},C1:C100,B1:B100),2,)

2021-09-25发表2022-09-25更新几秒读完 (大约65个字)

Hello World

Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in troubleshooting or you can ask me on GitHub.

Create a new post

1	$ hexo new "My New Post"