server/test/unittest_postgres.py
changeset 10328 d7ff46d958f4
parent 9804 fe9ae959da08
child 10439 45e18b4a7466
child 10455 ad0615d4500d
equal deleted inserted replaced
10327:a504a7840915 10328:d7ff46d958f4
   111                         {'date': datetime(1977, 6, 7, 2, 0)})
   111                         {'date': datetime(1977, 6, 7, 2, 0)})
   112             datenaiss = cnx.execute("Any XD WHERE X nom 'boby', X tzdatenaiss XD")[0][0]
   112             datenaiss = cnx.execute("Any XD WHERE X nom 'boby', X tzdatenaiss XD")[0][0]
   113             self.assertEqual(datenaiss.tzinfo, None)
   113             self.assertEqual(datenaiss.tzinfo, None)
   114             self.assertEqual(datenaiss.utctimetuple()[:5], (1977, 6, 7, 2, 0))
   114             self.assertEqual(datenaiss.utctimetuple()[:5], (1977, 6, 7, 2, 0))
   115 
   115 
       
   116 class PostgresLimitSizeTC(CubicWebTC):
       
   117     configcls = PostgresApptestConfiguration
       
   118 
       
   119     def test(self):
       
   120         with self.admin_access.repo_cnx() as cnx:
       
   121             def sql(string):
       
   122                 return cnx.system_sql(string).fetchone()[0]
       
   123             yield self.assertEqual, sql("SELECT limit_size('<p>hello</p>', 'text/html', 20)"), \
       
   124                 '<p>hello</p>'
       
   125             yield self.assertEqual, sql("SELECT limit_size('<p>hello</p>', 'text/html', 2)"), \
       
   126                 'he...'
       
   127             yield self.assertEqual, sql("SELECT limit_size('<br/>hello', 'text/html', 2)"), \
       
   128                 'he...'
       
   129             yield self.assertEqual, sql("SELECT limit_size('<span class=\"1\">he</span>llo', 'text/html', 2)"), \
       
   130                 'he...'
       
   131             yield self.assertEqual, sql("SELECT limit_size('<span>a>b</span>', 'text/html', 2)"), \
       
   132                 'a>...'
       
   133 
   116 if __name__ == '__main__':
   134 if __name__ == '__main__':
   117     from logilab.common.testlib import unittest_main
   135     from logilab.common.testlib import unittest_main
   118     unittest_main()
   136     unittest_main()