def _search_db(self,series_name): ''' Search the db name for a series name ''' for db in self.db_list: temp_db = DataFrameClient(self.url, self.port, self.user, self.password, db) if series_name in temp_db.get_list_series(): return db return None
def test_list_series(self): response = [{ 'columns': ['time', 'name'], 'name': 'list_series_result', 'points': [[0, 'seriesA'], [0, 'seriesB']] }] with _mocked_session('get', 200, response): cli = DataFrameClient('host', 8086, 'username', 'password', 'db') series_list = cli.get_list_series() assert series_list == ['seriesA', 'seriesB']
def test_list_series(self): """Test list of series for dataframe object.""" response = [{ 'columns': ['time', 'name'], 'name': 'list_series_result', 'points': [[0, 'seriesA'], [0, 'seriesB']] }] with _mocked_session('get', 200, response): cli = DataFrameClient('host', 8086, 'username', 'password', 'db') series_list = cli.get_list_series() self.assertEqual(series_list, ['seriesA', 'seriesB'])
def test_list_series(self): response = [ { 'columns': ['time', 'name'], 'name': 'list_series_result', 'points': [[0, 'seriesA'], [0, 'seriesB']] } ] with _mocked_session('get', 200, response): cli = DataFrameClient('host', 8086, 'username', 'password', 'db') series_list = cli.get_list_series() self.assertEqual(series_list, ['seriesA', 'seriesB'])
] processed_list = [ [ 'wage_lag_15m', 'mlag(wage_us_yoy,15)' ], [ 'zillow_median_sale_price_15m', 'mlag(zillow_median_sale_price_yoy,15)' ], ] df = DataFrameClient('localhost',8086,'root','root') if({'name':'Econ'} not in df.get_list_database()): df.create_database('Econ') df.switch_database('Econ') #add all items in interested list start = timeit.default_timer() for item in interest_list: if item[0] in df.get_list_series(): df.delete_series(item[0]) results = influx_Fred.interpret(item[1]) results = results.replace(to_replace='NaN',value='.') results = DataFrame({'value':results['value']}) df.write_points({item[0]:results}) print item print 'total time in seconds: %.2f' % (timeit.default_timer() - start) #add all items in processed list start = timeit.default_timer() influx_Econ = InfluxDB(db_name='Econ') for item in processed_list: if item[0] in df.get_list_series(): df.delete_series(item[0]) results = influx_Econ.interpret(item[1])
''' Created on Jul 8, 2015 @author: shaunz ''' from QuandlAPI import QuandlAPI from influxdb.influxdb08 import DataFrameClient from QuandlTicker import Quandl_ticker_list import timeit quandl = QuandlAPI() df = DataFrameClient('localhost', 8086, 'root', 'root') if({'name':'Quandl'} not in df.get_list_database()): df.create_database('Quandl') df.switch_database('Quandl') for series in df.get_list_series(): df.delete_series(series) start = timeit.default_timer() for item in Quandl_ticker_list: results = quandl.get_series(item[1],item[2],item[3]) results = results.replace(to_replace='NaN',value='.') print item df.write_points({item[0]:results}) print 'total time in seconds: %.2f' % (timeit.default_timer() - start)