542 eid = rset.rows[0][0] |
542 eid = rset.rows[0][0] |
543 rset = self.execute('Any UPPER(L) WHERE X eid %s, X login L'%eid) |
543 rset = self.execute('Any UPPER(L) WHERE X eid %s, X login L'%eid) |
544 self.assertEquals(rset.rows[0][0], 'ADMIN') |
544 self.assertEquals(rset.rows[0][0], 'ADMIN') |
545 self.assertEquals(rset.description, [('String',)]) |
545 self.assertEquals(rset.description, [('String',)]) |
546 |
546 |
547 ## def test_select_simplified(self): |
547 def test_select_float_abs(self): |
548 ## ueid = self.session.user.eid |
548 # test positive number |
549 ## rset = self.execute('Any L WHERE %s login L'%ueid) |
549 eid = self.execute('INSERT Affaire A: A invoiced %(i)s', {'i': 1.2})[0][0] |
550 ## self.assertEquals(rset.rows[0][0], 'admin') |
550 rset = self.execute('Any ABS(I) WHERE X eid %(x)s, X invoiced I', {'x': eid}) |
551 ## rset = self.execute('Any L WHERE %(x)s login L', {'x':ueid}) |
551 self.assertEquals(rset.rows[0][0], 1.2) |
552 ## self.assertEquals(rset.rows[0][0], 'admin') |
552 # test negative number |
|
553 eid = self.execute('INSERT Affaire A: A invoiced %(i)s', {'i': -1.2})[0][0] |
|
554 rset = self.execute('Any ABS(I) WHERE X eid %(x)s, X invoiced I', {'x': eid}) |
|
555 self.assertEquals(rset.rows[0][0], 1.2) |
|
556 |
|
557 def test_select_int_abs(self): |
|
558 # test positive number |
|
559 eid = self.execute('INSERT Affaire A: A duration %(d)s', {'d': 12})[0][0] |
|
560 rset = self.execute('Any ABS(D) WHERE X eid %(x)s, X duration D', {'x': eid}) |
|
561 self.assertEquals(rset.rows[0][0], 12) |
|
562 # test negative number |
|
563 eid = self.execute('INSERT Affaire A: A duration %(d)s', {'d': -12})[0][0] |
|
564 rset = self.execute('Any ABS(D) WHERE X eid %(x)s, X duration D', {'x': eid}) |
|
565 self.assertEquals(rset.rows[0][0], 12) |
553 |
566 |
554 def test_select_searchable_text_1(self): |
567 def test_select_searchable_text_1(self): |
555 rset = self.execute(u"INSERT Personne X: X nom 'bidüle'") |
568 rset = self.execute(u"INSERT Personne X: X nom 'bidüle'") |
556 rset = self.execute(u"INSERT Societe X: X nom 'bidüle'") |
569 rset = self.execute(u"INSERT Societe X: X nom 'bidüle'") |
557 rset = self.execute("INSERT Societe X: X nom 'chouette'") |
570 rset = self.execute("INSERT Societe X: X nom 'chouette'") |