import searchticker
import config
import MySQLdb
update = 'UPDATE schedule SET searched = 1 WHERE ticker = %s'
select = 'SELECT ticker FROM schedule WHERE searched = 0 LIMIT 1'
mysql = MySQLdb.connect(host = config.rhost, user = config.ruser, passwd = config.rpassword, db = config.rdatabase, port = config.rport)
cursor = mysql.cursor()
cursor.execute('SET NAMES utf8')
cursor.execute(select)
set = cursor.fetchall()
if len(set) == 1:
searchticker.search_ticker(set[0][0], 'mixed')
cursor.execute(update, set[0][0])
mysql.commit()
mysql.close()
import searchticker
import config
import MySQLdb
update = 'UPDATE schedule SET searched = 1 WHERE ticker = %s'
update2 = 'UPDATE company SET last_search = NOW() WHERE ticker = %s'
select = 'SELECT ticker FROM company WHERE in_use = 1 AND ticker NOT IN (SELECT ticker FROM schedule WHERE searched = 0 OR now() < DATE_ADD(created_at, INTERVAL 12 HOUR)) ORDER BY last_search LIMIT 1'
mysql = MySQLdb.connect(host = config.rhost, user = config.ruser, passwd = config.rpassword, db = config.rdatabase, port = config.rport)
cursor = mysql.cursor()
cursor.execute('SET NAMES utf8')
cursor.execute(select)
set = cursor.fetchall()
if len(set) == 1:
searchticker.search_ticker(set[0][0], 'popular')
cursor.execute(update, set[0][0])
cursor.execute(update2, set[0][0])
mysql.commit()
mysql.close()
