예제 #1
0
 def test_case_1(self):
     """
             Test case
             'id'  -> 'id ASC'
             """
     result = sort_str_to_sql(sort_expression='id')
     self.assertEqual(result, 'id ASC')
예제 #2
0
 def test_case_9(self):
     """
             Test case
             Incorrect input types -> ''
             """
     result = sort_str_to_sql(sort_expression=['+id'])
     self.assertEqual(result, '')
예제 #3
0
 def test_case_7(self):
     """
             Test case
             '-id,+age,-name'  -> 'id DESC, age ASC, name DESC'
             """
     result = sort_str_to_sql(sort_expression='-id,+age,-name')
     self.assertEqual(result, 'id DESC, age ASC, name DESC')
예제 #4
0
 def test_case_8(self):
     """
             Test case
             ''  -> ''
             """
     result = sort_str_to_sql(sort_expression='')
     self.assertEqual(result, '')
예제 #5
0
 def test_case_6(self):
     """
             Test case
             ' +id , -name '  -> 'id ASC, name DESC'
             """
     result = sort_str_to_sql(sort_expression=' +id , -name ')
     self.assertEqual(result, 'id ASC, name DESC')