http://doku.roy20100.synology.me/ 2026-05-14T12:03:19+00:00 http://doku.roy20100.synology.me/ http://doku.roy20100.synology.me/lib/tpl/dokuwiki/images/favicon.ico text/html 2020-09-09T21:13:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://doku.roy20100.synology.me/doku.php?id=vincent:octavegirouxetphilomenedemers&rev=1599700400&do=diff Octave Giroux et Philomène Demers 2020-09-09 Tout le contenu est retourné dans le fichier Word text/html 2019-05-04T12:51:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://doku.roy20100.synology.me/doku.php?id=vincent:pdf&rev=1556988693&do=diff text/html 2019-05-03T22:05:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://doku.roy20100.synology.me/doku.php?id=vincent:python&rev=1556935518&do=diff ceci est du python import mysql.connector as mariadb import urllib.request as ulr import simplekml import time import json #connecte MariaDB conn=mariadb.connect(host='192.168.0.131',port='3307',user='roy',database='genealogy') cur=conn.cursor() kml=simplekml.Kml() #anc_id=1673247 anc_id=9999999 #cur.execute("with recursive anc as(select * from t_person where id=%s UNION select p.* from t_person p join anc on anc.idf=p.id or anc.idm=p.id) select max(py) py,max(pr) pr,lat,lon,group_concat(id,':… text/html 2019-05-03T23:39:44+00:00 Anonymous (anonymous@undisclosed.example.com) http://doku.roy20100.synology.me/doku.php?id=vincent:sql&rev=1556941184&do=diff SQL code intersection de deux arbre et aucun doublon: /*select schema*/ use genealogy; /*recursive cte1*/ with recursive anc1 as(select *,0000001 st from t_person where id=1673247 UNION select p.*,((2*anc1.st)+(p.Sexe='F')) st from t_person p join anc1 on anc1.idf=p.id or anc1.idm=p.id), /*recursive cte2*/ anc2 as(select *,0000001 st from t_person where id=1673246 UNION select p.*,((2*anc2.st)+(p.Sexe='F')) st from t_person p join anc2 on anc2.idf=p.id or anc2.idm=p.id), /*find intersect…