def query_cache(key=None, st=None, request=None, project_id=None):
project_id = project_id if project_id \
else json.loads(request.session['project_id'])
database = Database()
ac_key_tag = namespace(project_id)
ac_ids = database.autocomplete(namespace=ac_key_tag)
return ac_ids.search(str(st))
import urllib2
from walrus import Database
db = Database()
autocomplete = db.autocomplete(namespace='stocks')
def load_data():
url = 'http://media.charlesleifer.com/blog/downloads/misc/NYSE.txt'
contents = urllib2.urlopen(url).read()
for row in contents.splitlines()[1:]:
ticker, company = row.split('\t')
autocomplete.store(
ticker,
company,
{'ticker': ticker, 'company': company})
def search(p, **kwargs):
return autocomplete.search(p, **kwargs)
if __name__ == '__main__':
autocomplete.flush()
print 'Loading data (may take a few seconds...)'
load_data()
print 'Search stock data by typing a partial phrase.'
print 'Examples: "uni sta", "micro", "food", "auto"'
print 'Type "q" at any time to quit'
while 1:
cmd = raw_input('? ')
if cmd == 'q':
import urllib2
from walrus import Database
db = Database()
autocomplete = db.autocomplete(namespace='stocks')
def load_data():
url = 'http://media.charlesleifer.com/blog/downloads/misc/NYSE.txt'
contents = urllib2.urlopen(url).read()
for row in contents.splitlines()[1:]:
ticker, company = row.split('\t')
autocomplete.store(ticker, company, {
'ticker': ticker,
'company': company
})
def search(p, **kwargs):
return autocomplete.search(p, **kwargs)
if __name__ == '__main__':
autocomplete.flush()
print 'Loading data (may take a few seconds...)'
load_data()
print 'Search stock data by typing a partial phrase.'
print 'Examples: "uni sta", "micro", "food", "auto"'
print 'Type "q" at any time to quit'
import os
import json
import redis
import logging
from walrus import Database
redis_host = os.environ.get('REDISHOST', 'localhost')
redis_port = int(os.environ.get('REDISPORT', 6379))
#redis_client = redis.StrictRedis(host=redis_host, port=redis_port)
walrus_db = Database(host=redis_host, port=redis_port)
ac = walrus_db.autocomplete(stopwords_file=None)
def read_json_file(path):
return json.loads(open(path).read())
def populate_index():
products = read_json_file("products.json")
for product in products:
try:
metadata = {'sku': product['sku'], 'name': product['name']}
ac.store(obj_id=product['sku'],
title=product['name'],
data=metadata)
except Exception as e:
logging.exception(
"Issue creating index for product id: %s name: %s",
product['sku'], product['name'])
