search

inbo / etn

R package to access data from the European Tracking Network
https://inbo.github.io/etn/
MIT License
6 stars 5 forks source link

API and direct SQL query return different results #320

Open PietrH opened 1 month ago

PietrH commented 1 month ago

list_animal_ids() currently fails a test because the API and a local query return different results: 


Failure (test-list_animal_ids.R:11:3): list_animal_ids() returns same list over api and sql ──
`result_api` (`actual`) not identical to `result_sql` (`expected`).

        actual | expected                
[22784] 73697  | 73697    [22784]        
[22785] 73698  | 73698    [22785]        
[22786] 73699  | 73699    [22786]        
               - 73700    [22787]        
               - 73701    [22788]        
               - 73702    [22789]        
               - 73703    [22790]        
               - 73704    [22791]        
               - 73705    [22792]        
               - 73706    [22793]        
    ... ...      ...      and 26 more ...

Possibly due to https://github.com/inbo/etnservice/issues/45

Did the _sql helper code drift from what is currently in etnservice ?

PietrH commented 1 month ago

Related to #330