server/sqlutils.py
changeset 7907 08320697ca1a
parent 7906 203d574c8a1d
parent 7904 f41bb38dda7c
child 8139 f9ebb6d1abc3
equal deleted inserted replaced
7906:203d574c8a1d 7907:08320697ca1a
   336 
   336 
   337     def limit_size2(text, maxsize):
   337     def limit_size2(text, maxsize):
   338         return _limit_size(text, maxsize)
   338         return _limit_size(text, maxsize)
   339     cnx.create_function("TEXT_LIMIT_SIZE", 2, limit_size2)
   339     cnx.create_function("TEXT_LIMIT_SIZE", 2, limit_size2)
   340 
   340 
       
   341     from logilab.common.date import strptime
       
   342     def weekday(ustr):
       
   343         try:
       
   344             dt = strptime(ustr, '%Y-%m-%d %H:%M:%S')
       
   345         except:
       
   346             dt =  strptime(ustr, '%Y-%m-%d')
       
   347         # expect sunday to be 1, saturday 7 while weekday method return 0 for
       
   348         # monday
       
   349         return (dt.weekday() + 1) % 7
       
   350     cnx.create_function("WEEKDAY", 1, weekday)
       
   351 
   341     import yams.constraints
   352     import yams.constraints
   342     yams.constraints.patch_sqlite_decimal()
   353     yams.constraints.patch_sqlite_decimal()
   343 
   354 
   344 sqlite_hooks = SQL_CONNECT_HOOKS.setdefault('sqlite', [])
   355 sqlite_hooks = SQL_CONNECT_HOOKS.setdefault('sqlite', [])
   345 sqlite_hooks.append(init_sqlite_connexion)
   356 sqlite_hooks.append(init_sqlite_connexion)