1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
|
from faker import Faker
from faker.providers.address.en_US import Provider as USAddressProvider
fake = Faker()
US_STATES = {x.lower() for x in USAddressProvider.states}
IP_v4_INDIA = "106.203.146.157"
IP_v6_INDIA = "2402:3a80:4649:de3f:0:24:74aa:b601"
IP_v4_US = "174.218.60.101"
IP_v6_US = "2600:1700:ece0:9410:55d:faf3:c15d:6e4"
IP_v6_US_SAME_64 = "2600:1700:ece0:9410:55d:faf3:c15d:aaaa"
# @pytest.fixture(scope="session")
# def delete_ipinfo(thl_web_rw) -> Callable:
# def _delete_ipinfo(ip):
# thl_web_rw.execute_write(
# query="DELETE FROM thl_geoname WHERE geoname_id IN (SELECT geoname_id FROM thl_ipinformation WHERE ip = %s);",
# params=[ip],
# )
# thl_web_rw.execute_write(
# query="DELETE FROM thl_ipinformation WHERE ip = %s;",
# params=[ip],
# )
# return _delete_ipinfo
# @pytest.skip("TODO: Replace with GRIP Client")
# class TestMaxmindBasicManager:
# def test_init(self,):
# def test_get_basic_ip_information(self, maxmind_basic_manager):
# ip = IP_v4_INDIA
# maxmind_basic_manager.run_update_geoip_db()
# res1 = maxmind_basic_manager.get_basic_ip_information(ip_address=ip)
# # assert isinstance(res1, geoip2.models.Country)
# assert res1.country.iso_code == "IN"
# assert res1.country.name == "India"
# res2 = maxmind_basic_manager.get_basic_ip_information(
# ip_address=fake.ipv4_private()
# )
# assert res2 is None
# def test_get_country_iso_from_ip_geoip2db(self, maxmind_basic_manager):
# ip = IP_v4_INDIA
# maxmind_basic_manager.run_update_geoip_db()
# res1 = maxmind_basic_manager.get_country_iso_from_ip_geoip2db(ip=ip)
# assert res1 == "in"
# res2 = maxmind_basic_manager.get_country_iso_from_ip_geoip2db(
# ip=fake.ipv4_private()
# )
# assert res2 is None
# def test_get_basic_ip_information_ipv6(self, maxmind_basic_manager):
# ip = IP_v6_INDIA
# maxmind_basic_manager.run_update_geoip_db()
# res1 = maxmind_basic_manager.get_basic_ip_information(ip_address=ip)
# assert isinstance(res1, geoip2.models.Country)
# assert res1.country.iso_code == "IN"
# assert res1.country.name == "India"
# class TestMaxmindManager:
# def test_init(self, thl_web_rr, thl_redis_config, maxmind_manager: MaxmindManager):
# instance = MaxmindManager(pg_config=thl_web_rr, redis_config=thl_redis_config)
# assert isinstance(instance, MaxmindManager)
# assert isinstance(maxmind_manager, MaxmindManager)
# def test_create_basic(
# self,
# maxmind_manager: MaxmindManager,
# geoipinfo_manager: GeoIpInfoManager,
# delete_ipinfo,
# ):
# # This is (currently) an IP in India, and so it should only do the basic lookup
# ip = IP_v4_INDIA
# delete_ipinfo(ip)
# geoipinfo_manager.clear_cache(ip)
# assert geoipinfo_manager.get_cache(ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(ip) is None
# maxmind_manager.run_ip_information(ip, force_insights=False)
# # Check that it is in the cache and in mysql
# res = geoipinfo_manager.get_cache(ip)
# assert res.ip == ip
# assert res.basic
# res = geoipinfo_manager.get_mysql(ip)
# assert res.ip == ip
# assert res.basic
# def test_create_basic_ipv6(
# self,
# maxmind_manager: MaxmindManager,
# geoipinfo_manager: GeoIpInfoManager,
# delete_ipinfo,
# ):
# # This is (currently) an IP in India, and so it should only do the basic lookup
# ip = IP_v6_INDIA
# normalized_ip, lookup_prefix = normalize_ip(ip)
# delete_ipinfo(ip)
# geoipinfo_manager.clear_cache(ip)
# delete_ipinfo(normalized_ip)
# geoipinfo_manager.clear_cache(normalized_ip)
# assert geoipinfo_manager.get_cache(ip) is None
# assert geoipinfo_manager.get_cache(normalized_ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(normalized_ip) is None
# maxmind_manager.run_ip_information(ip, force_insights=False)
# # Check that it is in the cache
# res = geoipinfo_manager.get_cache(ip)
# # The looked up IP (/128) is returned,
# assert res.ip == ip
# assert res.lookup_prefix == "/64"
# assert res.basic
# # ... but the normalized version was stored (/64)
# assert geoipinfo_manager.get_cache_raw(ip) is None
# res = json.loads(geoipinfo_manager.get_cache_raw(normalized_ip))
# assert res["ip"] == normalized_ip
# # Check mysql
# res = geoipinfo_manager.get_mysql(ip)
# assert res.ip == ip
# assert res.lookup_prefix == "/64"
# assert res.basic
# with pytest.raises(AssertionError):
# geoipinfo_manager.get_mysql_raw(ip)
# res = geoipinfo_manager.get_mysql_raw(normalized_ip)
# assert res["ip"] == normalized_ip
# def test_create_insights(
# self,
# maxmind_manager: MaxmindManager,
# geoipinfo_manager: GeoIpInfoManager,
# delete_ipinfo,
# ):
# # This is (currently) an IP in the US, so it should do insights
# ip = IP_v4_US
# delete_ipinfo(ip)
# geoipinfo_manager.clear_cache(ip)
# assert geoipinfo_manager.get_cache(ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(ip) is None
# res1 = maxmind_manager.run_ip_information(ip, force_insights=False)
# assert isinstance(res1, GeoIPInformation)
# # Check that it is in the cache and in mysql
# res2 = geoipinfo_manager.get_cache(ip)
# assert isinstance(res2, GeoIPInformation)
# assert res2.ip == ip
# assert not res2.basic
# res3 = geoipinfo_manager.get_mysql(ip)
# assert isinstance(res3, GeoIPInformation)
# assert res3.ip == ip
# assert not res3.basic
# assert res3.is_anonymous is False
# assert res3.subdivision_1_name.lower() in US_STATES
# # this might change ...
# assert res3.user_type == UserType.CELLULAR
# assert res1 == res2 == res3, "runner, cache, mysql all return same instance"
# def test_create_insights_ipv6(
# self,
# maxmind_manager: MaxmindManager,
# geoipinfo_manager: GeoIpInfoManager,
# delete_ipinfo,
# ):
# # This is (currently) an IP in the US, so it should do insights
# ip = IP_v6_US
# normalized_ip, lookup_prefix = normalize_ip(ip)
# delete_ipinfo(ip)
# geoipinfo_manager.clear_cache(ip)
# delete_ipinfo(normalized_ip)
# geoipinfo_manager.clear_cache(normalized_ip)
# assert geoipinfo_manager.get_cache(ip) is None
# assert geoipinfo_manager.get_cache(normalized_ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(ip) is None
# assert geoipinfo_manager.get_mysql_if_exists(normalized_ip) is None
# res1 = maxmind_manager.run_ip_information(ip, force_insights=False)
# assert isinstance(res1, GeoIPInformation)
# assert res1.lookup_prefix == "/64"
# # Check that it is in the cache and in mysql
# res2 = geoipinfo_manager.get_cache(ip)
# assert isinstance(res2, GeoIPInformation)
# assert res2.ip == ip
# assert not res2.basic
# res3 = geoipinfo_manager.get_mysql(ip)
# assert isinstance(res3, GeoIPInformation)
# assert res3.ip == ip
# assert not res3.basic
# assert res3.is_anonymous is False
# assert res3.subdivision_1_name.lower() in US_STATES
# # this might change ...
# assert res3.user_type == UserType.RESIDENTIAL
# assert res1 == res2 == res3, "runner, cache, mysql all return same instance"
# def test_get_or_create_ip_information(self, maxmind_manager):
# ip = IP_v4_US
# res1 = maxmind_manager.get_or_create_ip_information(ip_address=ip)
# assert isinstance(res1, GeoIPInformation)
# res2 = maxmind_manager.get_or_create_ip_information(
# ip_address=fake.ipv4_private()
# )
# assert res2 is None
# def test_get_or_create_ip_information_ipv6(
# self, maxmind_manager, delete_ipinfo, geoipinfo_manager, caplog
# ):
# ip = IP_v6_US
# normalized_ip, lookup_prefix = normalize_ip(ip)
# delete_ipinfo(normalized_ip)
# geoipinfo_manager.clear_cache(normalized_ip)
# with caplog.at_level(logging.INFO):
# res1 = maxmind_manager.get_or_create_ip_information(ip_address=ip)
# assert isinstance(res1, GeoIPInformation)
# assert res1.ip == ip
# # It looks up in insight using the normalize IP!
# assert f"get_insights_ip_information: {normalized_ip}" in caplog.text
# # And it should NOT do the lookup again with an ipv6 in the same /64 block!
# ip = IP_v6_US_SAME_64
# caplog.clear()
# with caplog.at_level(logging.INFO):
# res2 = maxmind_manager.get_or_create_ip_information(ip_address=ip)
# assert isinstance(res2, GeoIPInformation)
# assert res2.ip == ip
# assert "get_insights_ip_information" not in caplog.text
# def test_run_ip_information(self, maxmind_manager):
# ip = IP_v4_US
# res = maxmind_manager.run_ip_information(ip_address=ip)
# assert isinstance(res, GeoIPInformation)
# assert res.country_name == "United States"
# assert res.country_iso == "us"
|
