首页 > 解决方案 > PyMongo 整数溢出?不是整数?应该是<3k的巨大数字

问题描述

数据已通过我无权访问的应用程序上传到 MBD。在打印过滤后的输出时,我正在寻找的特定值显然超出了 32 位范围,尽管(因为 3GPP 指定了这个特定值)它不应该超过 1282。但是大多数值确实有意义,这让我相信该应用程序运行正常。我不知道该值是如何格式化的,但我猜这与它不是整数或 smth 有关吗?

具体来说,我希望获得可能的 时间提前无线电值。(希望该解决方案也适用于其中的其他“2147483647”)

    c = db.get_collection("measurements")
results = (c.find(( {"timestamp": {"$gt": datetime.datetime(2020, 1, 1, 12, 25, 1)}})))

for x in results:
        pprint.pprint(x)

输出:

{'_id': ObjectId('5e1b03141fea68001f5fd50c'),
 'battery': 0.38,
 'cell_info': [{'active': True,
                'cell_identity': {'cell_id': '20649231',
                                  'e_utra_absolute_radio_frequency_channel_number': '3350',
                                  'location_area_code': '58612',
                                  'mobile_country_code': '262',
                                  'mobile_network_code': '3',
                                  'physical_cell_id': '70'},
                'cell_signal_strength': {'asu': '30',
                                         'channel_quality_indicator': '2147483647',
                                         'dbm': '-110',
                                         'reference_signal_received_power': '-110',
                                         'reference_signal_received_quality': '-6',
                                         'reference_signal_signal_to_noise_ratio': '2147483647',
                                         **'timing_advance_radio': '2147483647'**},
                'type': 'LTE'},
               {'active': False,
                'cell_identity': {'cell_id': '2147483647',
                                  'e_utra_absolute_radio_frequency_channel_number': '3350',
                                  'location_area_code': '2147483647',
                                  'mobile_country_code': '262',
                                  'mobile_network_code': '3',
                                  'physical_cell_id': '288'},
                'cell_signal_strength': {'asu': '24',
                                         'channel_quality_indicator': '2147483647',
                                         'dbm': '-116',
                                         'reference_signal_received_power': '-116',
                                         'reference_signal_received_quality': '-13',
                                         'reference_signal_signal_to_noise_ratio': '2147483647',
                                         'timing_advance_radio': '2147483647'},
                'type': 'LTE'},
               {'active': False,
                'cell_identity': {'cell_id': '2147483647',
                                  'e_utra_absolute_radio_frequency_channel_number': '3350',
                                  'location_area_code': '2147483647',
                                  'mobile_country_code': '262',
                                  'mobile_network_code': '3',
                                  'physical_cell_id': '14'},
                'cell_signal_strength': {'asu': '16',
                                         'channel_quality_indicator': '2147483647',
                                         'dbm': '-124',
                                         'reference_signal_received_power': '-124',
                                         'reference_signal_received_quality': '-17',
                                         'reference_signal_signal_to_noise_ratio': '2147483647',
                                         'timing_advance_radio': '2147483647'},
                'type': 'LTE'}],
 'location_information': {'accuracy': 6.0,
                          'age': -1531,
                          'altitude': 395.0,
                          'latitude': 49.0154534,
                          'longitude': 12.0624561},
 'source_id': ObjectId('5c923e85b3f23b0010f0cec9'),
 'timestamp': datetime.datetime(2020, 1, 12, 11, 29, 12),
 'version': 'c79a820'}

希望你们能弄清楚这里发生了什么。提前致谢。

标签: pythonprintingoverflowpymongo

解决方案


推荐阅读