kanboard_push_delays

Repousser les délais d'un projet de X jours

UPDATE tasks 
SET `date_due` = `date_due`+(7*24*3600) 
WHERE project_id=4;

dans un script bash:

#!/bin/bash
#delays: push delays from a kanboard project management
echo "delays: push delays from a kanboard project management"
echo "how much days?"
read jours
echo "UPDATE tasks SET date_due = date_due+($jours*24*3600);" > ~/web/kanboard/data_tpzPWX3xTn/tmp
cd ~/web/kanboard/data_tpzPWX3xTn/
sqlite3 db.sqlite < tmp
rm ~/web/kanboard/data_tpzPWX3xTn/tmp