Python search_ticker Examples

Example #1

File: processqueue.py Project: kperson/TwitNode

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

Example #2

File: processrandom.py Project: kperson/TwitNode

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