def initdb():
"""Removes all content from database and initializes it
with default values
"""
with app.app_context():
resetdb()
site = portify(url_for('api', _external=True))
conn = Historical(site)
values = get_init_values()
conn.post(conn.process(values))
post_all(conn)
print 'Database initialized'
def popdb():
"""Removes all content from database and populates it
with sample data
"""
with app.app_context():
initdb()
site = portify(url_for('api', _external=True))
conn = Historical(site)
values = get_pop_values()
conn.post(conn.process(values))
post_all(conn)
print 'Database populated'
def popdb():
"""Remove all content from database, initializes it, and populates it
with sample data
"""
initdb()
conn = Historical(app_site())
date = d.today() - timedelta(days=30)
keys = conn.get('keys')
content = [conn.process(v, keys) for v in conn.get('pop_values')]
[conn.post(values) for values in content]
post_all(conn, keys)
price = conn.get_first_price(conn.securities, date)
conn.post(conn.process(price, keys))
print 'Database populated'
def initdb():
"""Remove all content from database and initializes it
with default values
"""
resetdb()
conn = Historical(app_site())
date = d.today() - timedelta(days=45)
keys = conn.get('keys')
content = [conn.process(v, keys) for v in conn.get('init_values')]
[conn.post(values) for values in content]
post_all(conn, keys)
price = conn.get_first_price(conn.securities, date)
conn.post(conn.process(price, keys))
print 'Database initialized'
def popprices(sym=None, start=None, end=None, extra=None):
"""Add price quotes
"""
with app.app_context():
site = portify(url_for('api', _external=True))
conn = Historical(site)
sym = sym.split(',') if sym else None
divs = True if (extra and extra.startswith('d')) else False
splits = True if (extra and extra.startswith('s')) else False
values = conn.get_prices(sym, start, end, extra)
table = 'event' if (divs or splits) else 'price'
keys = conn.event_keys if (divs or splits) else conn.price_keys
conn.post(conn.process(values, table, keys))
print 'Prices table populated'
def popdb():
"""Remove all content from database, initializes it, and populates it
with sample data
"""
initdb()
conn = Historical(app_site())
date = d.today() - timedelta(days=30)
keys = conn.get('keys')
content = [conn.process(v, keys) for v in conn.get('pop_values')]
[conn.post(values) for values in content]
post_all(conn, keys)
price = conn.get_first_price(conn.securities, date)
conn.post(conn.process(price, keys))
print 'Database populated'
def initdb():
"""Remove all content from database and initializes it
with default values
"""
resetdb()
conn = Historical(app_site())
date = d.today() - timedelta(days=45)
keys = conn.get('keys')
content = [conn.process(v, keys) for v in conn.get('init_values')]
[conn.post(values) for values in content]
post_all(conn, keys)
price = conn.get_first_price(conn.securities, date)
conn.post(conn.process(price, keys))
print 'Database initialized'
def popprices(sym=None, start=None, end=None, extra=None):
"""Add prices (and optionally dividends or splits) to securities
in the database
"""
with app.app_context():
conn = Historical(app_site())
keys = conn.get('keys')
sym = sym.split(',') if sym else None
values = conn.get_price_list(sym, start, end, extra)
conn.post(conn.process(values, keys))
print 'Prices table populated'
def popprices(sym=None, start=None, end=None, extra=None):
"""Add prices (and optionally dividends or splits) to securities
in the database
"""
with app.app_context():
conn = Historical(app_site())
keys = conn.get('keys')
sym = sym.split(',') if sym else None
values = conn.get_price_list(sym, start, end, extra)
conn.post(conn.process(values, keys))
print 'Prices table populated'
