{"action":"created","issue":{"url":"https://api.github.com/repos/Legilibre/legi.py/issues/42","repository_url":"https://api.github.com/repos/Legilibre/legi.py","labels_url":"https://api.github.com/repos/Legilibre/legi.py/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/Legilibre/legi.py/issues/42/comments","events_url":"https://api.github.com/repos/Legilibre/legi.py/issues/42/events","html_url":"https://github.com/Legilibre/legi.py/issues/42","id":388228738,"node_id":"MDU6SXNzdWUzODgyMjg3Mzg=","number":42,"title":"article présent dans LEGI, mais absent dans le sqlite","user":{"login":"revolunet","id":124937,"node_id":"MDQ6VXNlcjEyNDkzNw==","avatar_url":"https://avatars0.githubusercontent.com/u/124937?v=4","gravatar_id":"","url":"https://api.github.com/users/revolunet","html_url":"https://github.com/revolunet","followers_url":"https://api.github.com/users/revolunet/followers","following_url":"https://api.github.com/users/revolunet/following{/other_user}","gists_url":"https://api.github.com/users/revolunet/gists{/gist_id}","starred_url":"https://api.github.com/users/revolunet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolunet/subscriptions","organizations_url":"https://api.github.com/users/revolunet/orgs","repos_url":"https://api.github.com/users/revolunet/repos","events_url":"https://api.github.com/users/revolunet/events{/privacy}","received_events_url":"https://api.github.com/users/revolunet/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-12-06T14:06:10Z","updated_at":"2018-12-06T15:19:35Z","closed_at":null,"author_association":"NONE","body":"Bonjour,\r\n\r\nJe me permets de remonter un petit souci, qui me semble-t-il vient de la conversion dans SQLite.\r\n\r\nArticle 1221-18 dans le code du travail\r\n\r\n - présent sur LegiFrance : https://www.legifrance.gouv.fr/affichCodeArticle.do?cidTexte=LEGITEXT000006072050&idArticle=LEGIARTI000037064963&dateTexte=&categorieLien=id\r\n - présent dans le fichier DILA `Freemium_legi_global_20180706-113123.tar.gz` (dans `legi/global/code_et_TNC_en_vigueur/code_en_vigueur/LEGI/TEXT/00/00/06/07/20/LEGITEXT000006072050/article/LEGI/ARTI/00/00/37/06/49/LEGIARTI000037064963.xml`)\r\n\r\nDans legi.sqlite : \r\n - je ne le retrouve pas dans la table des articles : `select * from articles where id=\"LEGIARTI000037064963\"` :\r\n - il est pourtant bien présent dans le sommaire :  `select * from `sommaires` where `parent` = 'LEGISCTA000006195589' and `debut` <= '2018-12-06' and (`fin` > '2018-12-06' or `fin` = '2018-12-06' or `etat` = 'VIGUEUR') order by `position` asc`.\r\n\r\n<img width=\"1003\" alt=\"capture d ecran 2018-12-06 a 15 04 13\" src=\"https://user-images.githubusercontent.com/124937/49588897-3cfe1680-f968-11e8-9d96-d3d38d69eb44.png\">\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Legilibre/legi.py/issues/comments/444907213","html_url":"https://github.com/Legilibre/legi.py/issues/42#issuecomment-444907213","issue_url":"https://api.github.com/repos/Legilibre/legi.py/issues/42","id":444907213,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NDkwNzIxMw==","user":{"login":"revolunet","id":124937,"node_id":"MDQ6VXNlcjEyNDkzNw==","avatar_url":"https://avatars0.githubusercontent.com/u/124937?v=4","gravatar_id":"","url":"https://api.github.com/users/revolunet","html_url":"https://github.com/revolunet","followers_url":"https://api.github.com/users/revolunet/followers","following_url":"https://api.github.com/users/revolunet/following{/other_user}","gists_url":"https://api.github.com/users/revolunet/gists{/gist_id}","starred_url":"https://api.github.com/users/revolunet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolunet/subscriptions","organizations_url":"https://api.github.com/users/revolunet/orgs","repos_url":"https://api.github.com/users/revolunet/repos","events_url":"https://api.github.com/users/revolunet/events{/privacy}","received_events_url":"https://api.github.com/users/revolunet/received_events","type":"User","site_admin":false},"created_at":"2018-12-06T15:19:35Z","updated_at":"2018-12-06T15:19:35Z","author_association":"NONE","body":"Merci je check ça"}}
{"actor":{"display_login":"revolunet"}}