Python runsql示例

示例#1

文件： scheduler.py 项目： Clarkclk/flanker

#!/usr/bin/env python

import sys
import newtask

#print sys.argv
#print sys.argv[1]
#print sys.argv[2]
newtask.runsql(str(sys.argv[1]),str(sys.argv[2]))

#fw = open('testsch.txt','w')
#fw.write(str(sys.argv[1]))
#fw.close()

示例#2

文件： timetask.py 项目： Clarkclk/flanker

from apscheduler.schedulers.blocking import BlockingScheduler
import sys
import newtask
import string


task = str(sys.argv[1])
hour = str(sys.argv[2])
minute = str(sys.argv[3])
print task
print hour
print minute
scheduler = BlockingScheduler()
tmp = {'taskname':task,'sqlfile':'%s.sql' %task}
scheduler.add_job(newtask.runsql(**tmp), 'cron', hour = string.atoi(hour), minute = string.atoi(minute))
scheduler.start()