[[adminsys:dbffdn]]

db.ffdn.org

Il s'agit d'une application maison en Flask, dont le code est ici : https://code.ffdn.org/FFDN/ffdn-db

Ç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
 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;
  • adminsys/dbffdn.txt
  • Dernière modification: 2018/05/23 22:39
  • par zorun