def test_query_cond_less_than(self):
# Make sure type checking works
try:
q = pysnow.Query().field('test').less_than('a')
self.assertFalse(q)
except pysnow.QueryTypeError:
pass
# Make sure a valid operation works
q = pysnow.Query().field('test').less_than(1)
self.assertEquals(str(q), 'test<1')
def test_query_cond_ends_with(self):
# Make sure type checking works
try:
q = pysnow.Query().field('test').ends_with(1)
self.assertFalse(q)
except pysnow.QueryTypeError:
pass
# Make sure a valid operation works
q = pysnow.Query().field('test').ends_with('val')
self.assertEquals(str(q), 'testENDSWITHval')
def test_query_cond_not_equals(self):
# Make sure type checking works
try:
q = pysnow.Query().field('test').not_equals(dt)
self.assertFalse(q)
except pysnow.QueryTypeError:
pass
# Make sure a valid operation works
q = pysnow.Query().field('test').not_equals('test')
self.assertEquals(str(q), 'test!=test')
def test_query_cond_contains(self):
# Make sure type checking works
try:
q = pysnow.Query().field('test').contains(1)
self.assertFalse(q)
except pysnow.QueryTypeError:
pass
# Make sure a valid operation works
q = pysnow.Query().field('test').contains('val')
self.assertEquals(str(q), 'testLIKEval')
def test_query_cond_between(self):
# Make sure between with str arguments fails
try:
q = pysnow.Query().field('test').between('test', 'test')
self.assertFalse(q)
except pysnow.QueryTypeError:
pass
# Make sure between with int arguments works
q1 = str(pysnow.Query().field('test').between(1, 2))
self.assertEquals(str(q1), 'testBETWEEN1@2')
start = dt(1970, 1, 1)
end = dt(1970, 1, 2)
# Make sure between with dates works
q2 = str(pysnow.Query().field('test').between(start, end))
self.assertEquals(
str(q2),
'testBETWEENjavascript:gs.dateGenerate("1970-01-01 00:00:00")'
'@javascript:gs.dateGenerate("1970-01-02 00:00:00")')
def test_complex_query(self):
start = dt(2016, 2, 1)
end = dt(2016, 2, 10)
q = pysnow.Query()\
.field('f1').equals('val1')\
.AND()\
.field('f2').between(start, end)\
.NQ()\
.field('f3').equals('val3')
self.assertEqual(
str(q),
'f1=val1^f2BETWEENjavascript:gs.dateGenerate("2016-02-01 00:00:00")'
'@javascript:gs.dateGenerate("2016-02-10 00:00:00")^NQf3=val3')
def test_query_no_field(self):
try:
q = str(pysnow.Query().equals('test'))
self.assertFalse(q)
except pysnow.QueryMissingField:
pass
def test_query_logical_nq(self):
# Make sure NQ() operator between conditions works
q = pysnow.Query().field('test').equals('test').NQ().field(
'test2').equals('test')
self.assertEquals(str(q), 'test=test^NQtest2=test')
def test_query_unfinished_logical(self):
try:
q = str(pysnow.Query().field('test').equals('test').AND())
self.assertFalse(q)
except pysnow.QueryMissingField:
pass
def test_query_multiple_conditions(self):
try:
q = str(pysnow.Query().field('test').equals('test').between(1, 2))
self.assertFalse(q)
except pysnow.QueryMultipleConditions:
pass
def test_query_no_query(self):
try:
q = str(pysnow.Query())
self.assertFalse(q)
except pysnow.QueryEmpty:
pass
def test_query_no_condition(self):
try:
q = str(pysnow.Query().field('test'))
self.assertFalse(q)
except pysnow.QueryEmpty:
pass
def test_query_cond_is_empty(self):
# Make sure a valid operation works
q = pysnow.Query().field('test').is_empty()
self.assertEquals(str(q), 'testISEMPTY')