37,718
社区成员
发帖
与我相关
我的任务
分享
#!/usr/bin/python
import sys,time,datetime
def usage():
print "usage:\n%s begin_date end_date output_file" % sys.argv[0]
def main():
if 4 != len(sys.argv):
usage()
sys.exit()
fmt = "%Y-%m-%d"
fmt_2 = "%Y%m%d"
data_fmt = "PARTITION p%s VALUES LESS THAN (%d) ENGINE = MyISAM,"
bgn = time.strptime(sys.argv[1], fmt)
end = time.strptime(sys.argv[2], fmt)
begin_date = datetime.datetime(bgn[0], bgn[1], bgn[2])
end_date = datetime.datetime(end[0], end[1], end[2])
output_file = sys.argv[3]
f = open(output_file, "w")
cur_day = begin_date
while cur_day <= end_date:
next_day = cur_day + datetime.timedelta(days = 1)
str_day = cur_day.strftime(fmt_2)
time_stamp = time.mktime(next_day.timetuple())
print >> f, data_fmt % (str_day, time_stamp)
cur_day = next_day
if __name__ == "__main__":
main()
应该在python输入什么参数。