**Ceci est une ancienne révision du document !**
db.ffdn.org
Il s'agit d'une application maison en Flask, dont le code est ici : https://code.ffdn.org/FFDN/ffdn-db
Marquer un FAI comme membre de la FFDN
Ça se passe sur hermes, dans le dossier /home/ffdn-db/ffdn-db. Il faut éditer directement la base de données SQLite :
hermes:/home/ffdn-db/ffdn-db# sqlite3 ffdn-db.sqlite sqlite> update isp set is_ffdn_member = 1 where id == '35'; sqlite> select is_ffdn_member from isp where id == '35'; 1
Mise à jour d'un FAI
sqlite3 /home/ffdn-db/ffdn-db/ffdn-db.sqlite
select json from isp where id=42;
update isp set json='{"website": "https://thefnf.org", "subscriberCount": 1000, "name": "Kansas City Freedom Network", "chatrooms": ["irc://irc.thefnf.org/#fnm"], "progressStatus": 7, "coordinates": {"latitude": 39.13, "longitude": -94.55}, "mainMailingList": "kcfn@lists.thefnf.org", "coveredAreas": [{"technologies": ["wifi"], "name": "Kansas City, MO"}], "logoURL": "http://www.kcfreedom.net/cms/wp-content/uploads/2013/08/polImage24.jpg", "shortname": "KCFN", "email": "imw@thefnf.org", "description": "qmp/bmx based city-wide wireless network owned by a diverse array of local nonprofits and individuals"}' where id=42;