Projet

Général

Profil

0001-wip.patch

Lauréline Guérin, 17 décembre 2020 15:28

Télécharger (1,81 ko)

Voir les différences: 

Subject: [PATCH] wip


 tests/test_sql.py | 5 +++++
 wcs/sql.py        | 4 +++-
 2 files changed, 8 insertions(+), 1 deletion(-)
tests/test_sql.py
795 795 
        st.Less('receipt_time', (d + datetime.timedelta(days=20)).timetuple())])) == 20
796 796 
    assert len(data_class.select([
797 797 
        st.Greater('receipt_time', (d + datetime.timedelta(days=20)).timetuple())])) == 29
798 
    assert len(data_class.select([st.Equal('receipt_time', datetime.date(1900, 1, 1).timetuple())])) == 0
799 
    assert len(data_class.select([st.Equal('receipt_time', datetime.date(1, 1, 1))])) == 0
800 
    assert len(data_class.select([st.Greater('receipt_time', datetime.date(1, 1, 1))])) == 50
801 
    assert len(data_class.select([st.Equal('receipt_time', datetime.date(1, 1, 1).timetuple())])) == 0
802 
    assert len(data_class.select([st.Greater('receipt_time', datetime.date(1, 1, 1).timetuple())])) == 50
798 803 

  		




  799
  804
  
    

  		




  800
  805
  
    
@postgresql

  		












  

    
      wcs/sql.py
    
  





  98
  98
  
    

  		




  99
  99
  
    
    def as_sql_param(self):

  		




  100
  100
  
    
        if isinstance(self.value, time.struct_time):

  		




  101
  
  
    
            value = datetime.datetime.fromtimestamp(time.mktime(self.value))

  		




  
  101
  
    
            ts = time.mktime(self.value)

  		




  
  102
  
    
            #value = datetime.datetime.fromtimestamp(time.mktime(self.value))

  		




  
  103
  
    
            value = datetime.datetime(*self.value[:6])

  		




  102
  104
  
    
        else:

  		




  103
  105
  
    
            value = self.value

  		




  104
  106
  
    
        return {'c%s' % id(self.value): value}

  		




  105
  
  
    
-