'Test query into a dataframe.'

def test_query_into_dataframe(self):

    data = [{'name': 'foo', 'columns': ['time', 'sequence_number', 'column_one'], 'points': [[3600, 16, 2], [3600, 15, 1], [0, 14, 2], [0, 13, 1]]}]
    dataframe = pd.DataFrame(data=[[13, 1], [14, 2], [15, 1], [16, 2]], index=pd.to_datetime([0, 0, 3600, 3600], unit='s', utc=True), columns=['sequence_number', 'column_one'])
    with _mocked_session('get', 200, data):
        cli = DataFrameClient('host', 8086, 'username', 'password', 'db')
        result = cli.query('select    column_one    from    foo;')
        assert_frame_equal(dataframe, result)
