def raw_log(self,q):
time = datetime.datetime.now()
timestr = '{}.{}'.format(time.strftime('%Y-%m-%d %H:%M:%S'), time.microsecond)
ip = self.request.headers.get("X-Forwarded-For") or self.request.headers.get("X-Real-IP") or \
self.request.remote_ip
useragent = self.request.headers.get('User-Agent', 'Unknown')
sql = 'INSERT INTO test1 VALUES (NULL, %s, %s, %s, %s)'
yield security_pool.execute(sql,(timestr,ip,useragent,q))
def q_log(self, uid, d):
m = re.search(r'【(.+)】', d)
if m:
q = m.group(1)
category = 'stock'
stock = get_stock(q)
if stock and stock['type'] == 0:
is_stock = 1
else:
is_stock = 0
sql = 'SELECT * FROM test3 WHERE unionid = %s AND q = %s AND category = %s'
cur = yield security_pool.execute(sql, (uid, q, category))
row = cur.fetchone()
if row:
sql = 'UPDATE test3 SET counter = counter + 1, is_del = 0, last_visit = NOW() WHERE ' \
'unionid = %s AND q = %s AND category = %s'
yield security_pool.execute(sql, (uid, q, category))
else:
sql = 'INSERT INTO test3 VALUES (NULL, %s, %s, %s, 1, NOW(), %s, 0, 0)'
yield security_pool.execute(sql, (uid, q, category, is_stock))
