cubicweb/server/sqlutils.py
changeset 12220 3ba6016a459c
parent 12047 85416b43310a
child 12221 7254c153b5ce
equal deleted inserted replaced
12219:4b5f1b676366 12220:3ba6016a459c
   541 
   541 
   542     def limit_size2(text, maxsize):
   542     def limit_size2(text, maxsize):
   543         return _limit_size(text, maxsize)
   543         return _limit_size(text, maxsize)
   544     cnx.create_function("TEXT_LIMIT_SIZE", 2, limit_size2)
   544     cnx.create_function("TEXT_LIMIT_SIZE", 2, limit_size2)
   545 
   545 
   546     from logilab.common.date import strptime
       
   547 
       
   548     def weekday(ustr):
   546     def weekday(ustr):
   549         try:
   547         try:
   550             dt = strptime(ustr, '%Y-%m-%d %H:%M:%S')
   548             dt = datetime.strptime(ustr, '%Y-%m-%d %H:%M:%S')
   551         except:
   549         except:
   552             dt = strptime(ustr, '%Y-%m-%d')
   550             dt = datetime.strptime(ustr, '%Y-%m-%d')
   553         # expect sunday to be 1, saturday 7 while weekday method return 0 for
   551         # expect sunday to be 1, saturday 7 while weekday method return 0 for
   554         # monday
   552         # monday
   555         return (dt.weekday() + 1) % 7
   553         return (dt.weekday() + 1) % 7
   556     cnx.create_function("WEEKDAY", 1, weekday)
   554     cnx.create_function("WEEKDAY", 1, weekday)
   557 
   555