def main(unused_argv):
cfg = config.Config(FLAGS.config,
mode=FLAGS.mode,
env_path=FLAGS.dotenv_path)
shdb = gsheets.SheetsDB(cfg.TOKEN_LOC, cfg.SHEET_ID)
sqldb = sqlite.SQLiteDB(cfg.db.sqlite_path)
import_sheet = shdb.get_sheet_as_pd("Import")
sync = synchronizer.Synchronizer(shdb, sqldb)
sync.sync_icus()
sync.sync_users()
sqldb.execute("DELETE FROM bed_updates")
for row in import_sheet.iterrows():
row_info = {
"icu_name": row[1]["Hopital"],
"n_covid_occ": row[1]["NbCOVID"],
"n_covid_free": row[1]["NbLitDispo"],
"n_ncovid_free": 0,
"n_covid_deaths": row[1]["NbDeces"],
"n_covid_healed": row[1]["NbSortieVivant"],
"n_covid_refused": 0,
"n_covid_transfered": 0,
}
icu_id = sqldb.get_icu_id_from_name(row_info["icu_name"])
row_info["icu_id"] = icu_id
print(row_info)
sqldb.update_bedcount(**row_info)
def main(unused_argv):
cfg = config.Config(FLAGS.config,
mode=FLAGS.mode,
env_path=FLAGS.dotenv_path)
# First we migrate
mgt = migrator.Migrator(cfg, FLAGS.old_db_path)
mgt.run()
# Now we add the region that was not in the old one.
sheets = gsheets.SheetsDB(cfg.TOKEN_LOC, cfg.SHEET_ID)
sync = synchronizer.StoreSynchronizer(sheets, mgt.new_db)
sync.sync_icus()
def main(unused_argv):
cfg = config.Config(FLAGS.config, mode=FLAGS.mode)
sdb = gsheets.SheetsDB(cfg.TOKEN_LOC, cfg.SHEET_ID)
sender = mb_sender.MBSender(api_key=config.SMS_KEY,
originator=cfg.sms.origin)
users = sdb.get_users()
print(users)
for row in users.iterrows():
print(row)
tel = row[1]["tel"]
print(tel)
sender.send_message(tel, "Test")
def main(unused_argv):
cfg = config.Config(FLAGS.config,
mode=FLAGS.mode,
env_path=FLAGS.dotenv_path)
shdb = gsheets.SheetsDB(cfg.TOKEN_LOC, cfg.SHEET_ID)
sqldb = sqlite.SQLiteDB(cfg.db.sqlite_path)
sync = synchronizer.Synchronizer(shdb, sqldb)
reply = (str(
input(
"!!Are you sure you want to sync, this will drop all users!! (duh/nay)"
)).lower().strip())
if reply == "duh":
sync.sync_icus()
sync.sync_users()
def test_icus(self):
shdb = gsheets.SheetsDB(self.config.TOKEN_LOC, self.config.SHEET_ID)
shdb.get_icus()
