mongo-tz-test-alterantive.bash

#!/bin/bash

DB="test"
COL="tz"
ZONES="London Berlin Istanbul"
DATE="2000-01-01"

echo "System timezone: $(date -R)"

echo ""
echo -ne "Drop collection $COL: "
echo "db.${COL}.drop()" | mongo $DB --quiet

echo ""
echo "Inserting $DATE in different timezones"
for ZONE in $ZONES
do
   echo "- Europe/$ZONE"
   php -r "date_default_timezone_set('Europe/$ZONE'); (new MongoClient())->selectDB('$DB')->selectCollection('$COL')->insert(['tz' => date('e'), 'time' => new MongoDate(strtotim
e('$DATE'))]);"
done

echo ""
echo "DB contents"
echo "db.${COL}.find()" | mongo $DB --quiet


echo ""
echo "Reading in different timezones"
for ZONE in $ZONES
do
    echo "- Europe/$ZONE"
    php -r "date_default_timezone_set('Europe/$ZONE'); \$c = (new MongoClient)->selectDB('$DB')->selectCollection('$COL')->find(); foreach (\$c as \$d) echo '  => ', \$d['tz'],
'  ', date('c', \$d['time']->sec), PHP_EOL;"
done