From kde-active  Thu May 30 23:02:15 2013
From: "Aaron J. Seigo" <aseigo () kde ! org>
Date: Thu, 30 May 2013 23:02:15 +0000
To: kde-active
Subject: bodega and UTC
Message-Id: <1866521.cQzzXfZkB7 () freedom>
X-MARC-Message: https://marc.info/?l=kde-active&m=136995496113244
MIME-Version: 1
Content-Type: multipart/mixed; boundary="--===============5006325842653722912=="


--===============5006325842653722912==
Content-Type: multipart/signed; boundary="nextPart3781675.rxpbOvPgN5"; micalg="pgp-sha1"; protocol="application/pgp-signature"


--nextPart3781675.rxpbOvPgN5
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"

hi ...

i just pushed some changes to bodega that forces the server to run in U=
TC.=20
this was accomplished by setting the env's tz to 'UTC' in app.js

the server also now expects dates and times to be fetched from the data=
base in=20
UTC. the easiest way to achieve that is to edit postgresql.conf and mak=
e sure=20
that "timezone =3D 'UTC'" (it defaults to posixrules .. which means the=
 local=20
timezone of the machine) and then restart postgresql.

the less easy way would involve a small patch to bodegadb.js when creat=
ing the=20
db connection to first do a "SET time zone 'utc'".

these changes will ensure that all dates and times in the database will=
 be=20
stored and retrieved sensibly even if the server changes its timezone. =
it also=20
means we can reliably run the test suite in different timezones. the st=
ats=20
test, for instance, should now work as well in Phillie as it does in Z=C3=
=BCrich ;)

--=20
Aaron J. Seigo
--nextPart3781675.rxpbOvPgN5
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.20 (GNU/Linux)

iEYEABECAAYFAlGn2nwACgkQ1rcusafx20N6qgCdGRKLKYdRrV4C514/Kj8C5RIw
fKMAn0JObukF1kwQFXQ3kgnzh2kODOJW
=AbjJ
-----END PGP SIGNATURE-----

--nextPart3781675.rxpbOvPgN5--


--===============5006325842653722912==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Active mailing list
Active@kde.org
https://mail.kde.org/mailman/listinfo/active

--===============5006325842653722912==--