37,720
社区成员
发帖
与我相关
我的任务
分享
./model/__init__.py
./model/site.py
./crawl.py
# -*- coding:utf-8 -*-
import MySQLdb
conn = MySQLdb.connect(host="localhost",
user="u_1",
passwd="p_-#13(",
db="db2",
port=3306,
charset="utf8")
cursor = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)
# -*- coding:utf-8 -*-
def next_task():
"""
获取下一个要执行的站点
:return:
"""
sql = "select *,(select max(addtime) from zb_crawl_log where sid=zb_sites.sid ) lastcrawl " + \
"from zb_sites having ifnull(lastcrawl,0) < unix_timestamp()-%s " + \
"order by lastcrawl asc limit 1"
param = (7200,) # 2小时
cursor.execute(sql, param)
return cursor.fetchone()
#!/usr/bin/env python
# -*- coding:utf-8 -*-
from model import site as site_model
print site_model.next_task()
NameError: global name 'cursor' is not defined