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))
