1 files changed, 34 insertions, 0 deletions
diff --git a/test/unittest_adbh.py b/test/unittest_adbh.py
new file mode 100644
index 0000000..5c054d2
--- /dev/null
+++ b/test/unittest_adbh.py
@@ -0,0 +1,34 @@
+
+from logilab.common.testlib import TestCase, unittest_main
+
+from logilab.common.adbh import get_adv_func_helper
+
+
+class PGHelperTC(TestCase):
+    driver = 'postgres'
+    def setUp(self):
+        self.helper = get_adv_func_helper(self.driver)
+        
+    def test_type_map(self):
+        self.assertEquals(self.helper.TYPE_MAPPING['Datetime'], 'timestamp')
+        self.assertEquals(self.helper.TYPE_MAPPING['String'], 'text')
+        self.assertEquals(self.helper.TYPE_MAPPING['Password'], 'bytea')
+        self.assertEquals(self.helper.TYPE_MAPPING['Bytes'], 'bytea')
+
+
+class SQLITEHelperTC(PGHelperTC):
+    driver = 'sqlite'
+
+
+class MYHelperTC(PGHelperTC):
+    driver = 'mysql'
+        
+    def test_type_map(self):
+        self.assertEquals(self.helper.TYPE_MAPPING['Datetime'], 'datetime')
+        self.assertEquals(self.helper.TYPE_MAPPING['String'], 'mediumtext')
+        self.assertEquals(self.helper.TYPE_MAPPING['Password'], 'tinyblob')
+        self.assertEquals(self.helper.TYPE_MAPPING['Bytes'], 'longblob')
+
+        
+if __name__ == '__main__':
+    unittest_main()