python-sql: Fix Div operator and function

sql/tests/test_operators.py

 # -*- coding: utf-8 -*-
 #
 # Copyright (c) 2011-2013, Cédric Krier
 # Copyright (c) 2011-2013, B2CK
 # All rights reserved.
 #
 # Redistribution and use in source and binary forms, with or without
 # modification, are permitted provided that the following conditions are met:
 #     * Redistributions of source code must retain the above copyright
 #       notice, this list of conditions and the following disclaimer.
 #     * Redistributions in binary form must reproduce the above copyright
 #       notice, this list of conditions and the following disclaimer in the
 #       documentation and/or other materials provided with the distribution.
 #     * Neither the name of the <organization> nor the
 #       names of its contributors may be used to endorse or promote products
 #       derived from this software without specific prior written permission.
 #
 # THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 # AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 # IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 # ARE DISCLAIMED. IN NO EVENT SHALL <COPYRIGHT HOLDER> BE LIABLE FOR ANY
 # DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 # (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 # LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 # ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 # (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 # SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 
 import unittest
+import warnings
 from array import array
 
 from sql import Table, Literal
-from sql.operators import And, Not, Less, Equal, NotEqual, In
+from sql.operators import And, Not, Less, Equal, NotEqual, In, FloorDiv
 
 
 class TestOperators(unittest.TestCase):
     table = Table('t')
 
     def test_and(self):
         and_ = And((self.table.c1, self.table.c2))
         self.assertEqual(str(and_), '("c1" AND "c2")')
         self.assertEqual(and_.params, ())
 
@@ skipping 71 matching lines @@
         in_ = In(self.table.c1, t2.select(t2.c2) | t2.select(t2.c3))
         self.assertEqual(str(in_),
             '("c1" IN (SELECT "a"."c2" FROM "t2" AS "a" '
             'UNION SELECT "a"."c3" FROM "t2" AS "a"))')
         self.assertEqual(in_.params, ())
 
         in_ = In(self.table.c1, array('l', range(10)))
         self.assertEqual(str(in_),
             '("c1" IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s))')
         self.assertEqual(in_.params, tuple(range(10)))
+
+    def test_floordiv(self):
+        with warnings.catch_warnings(record=True) as w:
+            warnings.simplefilter("always")
+            FloorDiv(4, 2)
+            self.assertEqual(len(w), 1)
+            self.assertTrue(issubclass(w[-1].category, DeprecationWarning))
+            self.assertIn('FloorDiv operator is deprecated, use Div function',
+                str(w[-1].message))