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