#coding=utf8 #!/usr/bin/env python # 網站自動審核系統import pymssql import re import sys import datetime import timeDB_HOSTNAME = r'127.0.0.1:1433' DB_USERNAME = 'username' DB_PASSWORD = 'password' DB_DATABASE = 'menhu_163k'reload(sys) sys.setdefaultencoding('utf-8')#*******Connection MSSQL ************* stat = Falsetry:ms_conn = pymssql.connect(host=DB_HOSTNAME, user=DB_USERNAME, password=DB_PASSWORD, database=DB_DATABASE, charset="UTF-8")cur = ms_conn.cursor()stat = True except:print 'Could nont connect to DB server.'def content_filter(content):content = row[1]re_a_qs = re.compile('<[aA][^>]*>')content = re_a_qs.sub('', content)re_a_js = re.compile('</[aA]>')content = re_a_js.sub('', content)return contentif stat:str_log = ''params = [{"id":53, "name":"7D電影", "count":360, "day":12, "numbers":3, },{"id":54, "name":"愛樂桌游", "count":1400, "day":44, "numbers":11, },{"id":55, "name":"愛樂祺", "count":100, "day":4, "numbers":1, },{"id":56, "name":"詩美詩格", "count":1800, "day":60, "numbers":15, },]#團購定時開始tg_times = [9, 11, 14, 16, 19]#print datetime.datetime.now()tm = datetime.datetime.now()#print tm.hour#print tm.minute#print tm.secondlist_sql = [];if (tm.hour+1 in tg_times) and tm.minute==59 and tm.second>55:#if (tm.hour+1 in tg_times) and tm.minute==16 and tm.second>=0:for param in params:#增加每次團購數量list_sql.append("UPDATE mh163k_tg SET num2=num2+"+str(param['numbers'])+" WHERE num2-chrnum<"+str(param['numbers'])+" AND num2<="+str(param['count']-param['numbers'])+" AND tgid=" + str(param['id']) )list_sql.append("UPDATE mh163k_tg SET num2="+str(param['count'])+" WHERE num2-chrnum<"+str(param['numbers'])+" AND num2>"+str(param['count']-param['numbers'])+" AND tgid=" + str(param['id']) )list_sql.append("UPDATE mh163k_tg SET maiguang=0, chrdate='%d-%d-%d %d:10:00' WHERE categoryid=701" % (tm.year, tm.month, tm.day, int(tm.hour)+1) )#list_sql.append("UPDATE mh163k_tg SET maiguang=0, chrdate='%d-%d-%d %d:%d:10' WHERE categoryid=701" % (tm.year, tm.month, tm.day, tm.hour, tm.minute-1 ) )str_sql2 = ''for str_sql in list_sql:str_sql2 += str_sql + "\n";print str_sqlcur.execute(str_sql)ms_conn.commit()if not str_sql2 :str_sql2 = 'No sql running.'ms_conn.close()f = open("tg_log.txt", "a+")f.write("\n\n")f.write(str(datetime.datetime.utcnow()) + "\n")f.write(str_sql2)f.close#print '寫入日志成功' print 'Kill Content Sucess!'

　　

轉載于:https://www.cnblogs.com/echyang/p/3439290.html

總結

以上是生活随笔為你收集整理的163k地方门户网站系统团购定时结束限量控制的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。