← Back to branch summary

~launchpad-results/launchpad-results/trunk

« back to all changes in this revision

Viewing changes to lib/lpresults/database/constants.py

  • Committer: Marc Tardif
  • Date: 2012-03-21 22:32:04 UTC
  • Revision ID: marc.tardif@canonical.com-20120321223204-8g7mvzzwmh8ifbrt
Added support for getting systems from a person (LP #899361)

Show diffs side-by-side

added added

removed removed

Lines of Context:
lib/lpresults/database/constants.py
1
1
# Copyright 2010-2011 Canonical Ltd.  This software is licensed under the
2
2
# GNU Affero General Public License version 3 (see the file LICENSE).
3
3
 
 
4
from __future__ import absolute_import
 
5
 
4
6
__metaclass__ = type
5
7
 
 
8
from datetime import datetime
 
9
 
6
10
from storm.locals import SQL
7
11
 
8
12
 
9
13
DEFAULT = SQL("DEFAULT")
10
14
 
11
15
# We can't use 'infinity', as psycopg doesn't know how to handle it.
12
 
INFINITY = SQL("'3000-01-01'::TIMESTAMP WITHOUT TIME ZONE")
 
16
INFINITY_DATETIME = datetime(3000, 1, 1)
 
17
INFINITY = SQL("'%s'::TIMESTAMP WITHOUT TIME ZONE" % INFINITY_DATETIME)
13
18
 
14
19
UTC_NOW = SQL("(CURRENT_TIMESTAMP AT TIME ZONE 'UTC')")