12 lines
427 B
Bash
Executable File
12 lines
427 B
Bash
Executable File
#!/usr/bin/env bash
|
|
|
|
OLD_DATE=`date -d '-7 day' +%Y-%m-%d`
|
|
BASE_PATH="/home/backisbachus/gw2/"
|
|
OLD_DB="stats.db"
|
|
NEW_DATE=`date +%Y-%m-%dT18:00:00+00:00`
|
|
|
|
`cp $BASE_PATH$OLD_DB $BASE_PATH$OLD_DB'_'$OLD_DATE`
|
|
`sqlite3 $BASE_PATH$OLD_DB "DELETE FROM records;"`
|
|
`sqlite3 $BASE_PATH$OLD_DB "DELETE FROM diff;"`
|
|
`sqlite3 $BASE_PATH$OLD_DB "INSERT INTO records VALUES ('$NEW_DATE',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);"`
|