140 |
140 |
def query(connector):
|
141 |
141 |
return Query.objects.create(
|
142 |
142 |
resource=connector,
|
143 |
143 |
name='Référenciel adresses de test',
|
144 |
144 |
slug='my_query',
|
145 |
145 |
description='Rechercher une adresse',
|
146 |
146 |
dataset='referentiel-adresse-test',
|
147 |
147 |
text_template='{{numero}} {{nom_rue|safe}} {{nom_commun}}',
|
|
148 |
filter_expression='refine.source=Ville et Eurométropole de Strasbourg&exclude.numero=42&exclude.numero=43',
|
148 |
149 |
)
|
149 |
150 |
|
150 |
151 |
|
151 |
152 |
def test_views(db, admin_user, app, connector):
|
152 |
153 |
app = login(app)
|
153 |
154 |
resp = app.get('/opendatasoft/my_connector/', status=200)
|
154 |
155 |
resp = resp.click('New Query')
|
155 |
156 |
resp.form['name'] = 'my query'
|
... | ... | |
187 |
188 |
|
188 |
189 |
@mock.patch('passerelle.utils.Request.get')
|
189 |
190 |
def test_search_using_q(mocked_get, app, connector):
|
190 |
191 |
endpoint = utils.generic_endpoint_url('opendatasoft', 'search', slug=connector.slug)
|
191 |
192 |
assert endpoint == '/opendatasoft/my_connector/search'
|
192 |
193 |
params = {
|
193 |
194 |
'dataset': 'referentiel-adresse-test',
|
194 |
195 |
'text_template': '{{numero}} {{nom_rue|safe}} {{nom_commun}}',
|
|
196 |
'refine.source': 'Ville et Eurométropole de Strasbourg',
|
|
197 |
'exclude.numero': ['42', '43'],
|
195 |
198 |
'q': "rue de l'aubepine",
|
196 |
199 |
'rows': 3,
|
197 |
200 |
}
|
198 |
201 |
mocked_get.return_value = utils.FakedResponse(content=FAKED_CONTENT_Q_SEARCH, status_code=200)
|
199 |
202 |
resp = app.get(endpoint, params=params, status=200)
|
200 |
203 |
assert not resp.json['err']
|
201 |
204 |
assert len(resp.json['data']) == 3
|
202 |
205 |
# check order is kept
|
... | ... | |
217 |
220 |
|
218 |
221 |
@mock.patch('passerelle.utils.Request.get')
|
219 |
222 |
def test_search_using_id(mocked_get, app, connector):
|
220 |
223 |
endpoint = utils.generic_endpoint_url('opendatasoft', 'search', slug=connector.slug)
|
221 |
224 |
assert endpoint == '/opendatasoft/my_connector/search'
|
222 |
225 |
params = {
|
223 |
226 |
'dataset': 'referentiel-adresse-test',
|
224 |
227 |
'text_template': '{{numero}} {{nom_rue|safe}} {{nom_commun}}',
|
|
228 |
'refine.source': 'Ville et Eurométropole de Strasbourg',
|
|
229 |
'exclude.numero': ['42', '43'],
|
225 |
230 |
'id': '7cafcd5c692773e8b863587b2d38d6be82e023d8',
|
226 |
231 |
}
|
227 |
232 |
mocked_get.return_value = utils.FakedResponse(content=FAKED_CONTENT_ID_SEARCH, status_code=200)
|
228 |
233 |
resp = app.get(endpoint, params=params, status=200)
|
229 |
234 |
assert len(resp.json['data']) == 1
|
230 |
235 |
assert resp.json['data'][0]['text'] == "19 RUE DE L'AUBEPINE Lipsheim"
|
231 |
236 |
|
232 |
237 |
|
... | ... | |
234 |
239 |
def test_query_q_using_q(mocked_get, app, query):
|
235 |
240 |
endpoint = '/opendatasoft/my_connector/q/my_query/'
|
236 |
241 |
params = {
|
237 |
242 |
'q': "rue de l'aubepine",
|
238 |
243 |
'rows': 3,
|
239 |
244 |
}
|
240 |
245 |
mocked_get.return_value = utils.FakedResponse(content=FAKED_CONTENT_Q_SEARCH, status_code=200)
|
241 |
246 |
resp = app.get(endpoint, params=params, status=200)
|
|
247 |
assert mocked_get.call_args[1]['params'] == {
|
|
248 |
'dataset': 'referentiel-adresse-test',
|
|
249 |
'q': "rue de l'aubepine",
|
|
250 |
'apikey': 'my_secret',
|
|
251 |
'rows': '3',
|
|
252 |
'refine.source': ['Ville et Eurométropole de Strasbourg'],
|
|
253 |
'exclude.numero': ['42', '43'],
|
|
254 |
}
|
242 |
255 |
assert not resp.json['err']
|
243 |
256 |
assert len(resp.json['data']) == 3
|
244 |
257 |
# check order is kept
|
245 |
258 |
assert [x['id'] for x in resp.json['data']] == [
|
246 |
259 |
'e00cf6161e52a4c8fe510b2b74d4952036cb3473',
|
247 |
260 |
'7cafcd5c692773e8b863587b2d38d6be82e023d8',
|
248 |
261 |
'0984a5e1745701f71c91af73ce764e1f7132e0ff',
|
249 |
262 |
]
|
... | ... | |
260 |
273 |
@mock.patch('passerelle.utils.Request.get')
|
261 |
274 |
def test_query_q_using_id(mocked_get, app, query):
|
262 |
275 |
endpoint = '/opendatasoft/my_connector/q/my_query/'
|
263 |
276 |
params = {
|
264 |
277 |
'id': '7cafcd5c692773e8b863587b2d38d6be82e023d8',
|
265 |
278 |
}
|
266 |
279 |
mocked_get.return_value = utils.FakedResponse(content=FAKED_CONTENT_ID_SEARCH, status_code=200)
|
267 |
280 |
resp = app.get(endpoint, params=params, status=200)
|
|
281 |
assert mocked_get.call_args[1]['params'] == {
|
|
282 |
'dataset': 'referentiel-adresse-test',
|
|
283 |
'q': 'recordid:7cafcd5c692773e8b863587b2d38d6be82e023d8',
|
|
284 |
'apikey': 'my_secret',
|
|
285 |
'refine.source': ['Ville et Eurométropole de Strasbourg'],
|
|
286 |
'exclude.numero': ['42', '43'],
|
|
287 |
}
|
268 |
288 |
assert len(resp.json['data']) == 1
|
269 |
289 |
assert resp.json['data'][0]['text'] == "19 RUE DE L'AUBEPINE Lipsheim"
|
270 |
290 |
|
271 |
291 |
|
272 |
292 |
def test_opendatasoft_query_unicity(admin_user, app, connector, query):
|
273 |
293 |
connector2 = OpenDataSoft.objects.create(
|
274 |
294 |
slug='my_connector2',
|
275 |
295 |
api_key='my_secret',
|
276 |
|
-
|