def test_utc(self):
base = PostgreSQLBase(config=self.config)
# Verify that we've got 'timezone=utc' set
sql = 'SHOW TIMEZONE'
results = base.query(sql)
assert 'UTC' in results[0], (
'Please set PostgreSQL to use the UTC timezone. Documentation on how to do this is '
'included in the installation instructions.')
def test_utc(self):
base = PostgreSQLBase(config=self.config)
# Verify that we've got 'timezone=utc' set
sql = 'SHOW TIMEZONE'
results = base.query(sql)
self.assertTrue('UTC' in results[0],
"""Please set PostgreSQL to use the UTC timezone.
Documentation on how to do this is included in
the INSTALL instructions.""")
def test_utc(self):
base = PostgreSQLBase(config=self.config)
# Verify that we've got 'timezone=utc' set
sql = 'SHOW TIMEZONE'
results = base.query(sql)
assert 'UTC' in results[0], (
'Please set PostgreSQL to use the UTC timezone. Documentation on how to do this is '
'included in the installation instructions.'
)
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = 'SELECT * FROM reports'
results = base.query(sql)
eq_(len(results), 2)
ok_('http://mywebsite.com' in results[0])
ok_('*****@*****.**' in results[1])
# A working query with parameters
sql = 'SELECT * FROM reports WHERE url=%(url)s'
params = {'url': 'http://mywebsite.com'}
results = base.query(sql, params)
eq_(len(results), 1)
ok_('http://mywebsite.com' in results[0])
# A failing query
sql = 'SELECT FROM reports LIMIT notanumber'
assert_raises(DatabaseError, base.query, sql)
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = 'SELECT * FROM reports'
results = base.query(sql)
eq_(len(results), 2)
ok_('http://mywebsite.com' in results[0])
ok_('*****@*****.**' in results[1])
# A working query with parameters
sql = 'SELECT * FROM reports WHERE url=%(url)s'
params = {'url': 'http://mywebsite.com'}
results = base.query(sql, params)
eq_(len(results), 1)
ok_('http://mywebsite.com' in results[0])
# A failing query
sql = 'SELECT FROM reports LIMIT notanumber'
assert_raises(DatabaseError, base.query, sql)
def test_utc(self):
base = PostgreSQLBase(config=self.config)
# Verify that we've got 'timezone=utc' set
sql = 'SHOW TIMEZONE'
results = base.query(sql)
ok_(
'UTC' in results[0],
"""Please set PostgreSQL to use the UTC timezone.
Documentation on how to do this is included in
the INSTALL instructions.""")
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = "SELECT * FROM reports"
results = base.query(sql)
self.assertEqual(len(results), 2)
self.assertTrue("http://mywebsite.com" in results[0])
self.assertTrue("*****@*****.**" in results[1])
# A working query with parameters
sql = "SELECT * FROM reports WHERE url=%(url)s"
params = {"url": "http://mywebsite.com"}
results = base.query(sql, params)
self.assertEqual(len(results), 1)
self.assertTrue("http://mywebsite.com" in results[0])
# A failing query
sql = "SELECT FROM reports"
self.assertRaises(DatabaseError, base.query, sql)
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = 'SELECT * FROM reports'
results = base.query(sql)
assert len(results) == 2
assert 'http://mywebsite.com' in results[0]
assert '*****@*****.**' in results[1]
# A working query with parameters
sql = 'SELECT * FROM reports WHERE url=%(url)s'
params = {'url': 'http://mywebsite.com'}
results = base.query(sql, params)
assert len(results) == 1
assert 'http://mywebsite.com' in results[0]
# A failing query
sql = 'SELECT FROM reports LIMIT notanumber'
with pytest.raises(DatabaseError):
base.query(sql)
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = 'SELECT * FROM release_channels ORDER BY sort'
results = base.query(sql)
assert len(results) == 5
assert results[0] == ('Nightly', 1)
assert results[1] == ('Aurora', 2)
# A working query with parameters
sql = 'SELECT * FROM release_channels WHERE release_channel=%(release_channel)s'
params = {'release_channel': 'Nightly'}
results = base.query(sql, params)
assert len(results) == 1
assert results[0] == ('Nightly', 1)
# A failing query
sql = 'SELECT FROM release_channels LIMIT notanumber'
with pytest.raises(DatabaseError):
base.query(sql)
def test_query(self):
base = PostgreSQLBase(config=self.config)
# A working query
sql = 'SELECT * FROM release_channels ORDER BY sort'
results = base.query(sql)
assert len(results) == 5
assert results[0] == ('Nightly', 1)
assert results[1] == ('Aurora', 2)
# A working query with parameters
sql = 'SELECT * FROM release_channels WHERE release_channel=%(release_channel)s'
params = {'release_channel': 'Nightly'}
results = base.query(sql, params)
assert len(results) == 1
assert results[0] == ('Nightly', 1)
# A failing query
sql = 'SELECT FROM release_channels LIMIT notanumber'
with pytest.raises(DatabaseError):
base.query(sql)
