server/test/unittest_rql2sql.py
branchstable
changeset 4837 54969eec48eb
parent 4836 3e3c4917e94e
child 4845 dc351b96f596
equal deleted inserted replaced
4836:3e3c4917e94e 4837:54969eec48eb
  1066      '''SELECT rel_is0.eid_from
  1066      '''SELECT rel_is0.eid_from
  1067 FROM is_relation AS rel_is0
  1067 FROM is_relation AS rel_is0
  1068 WHERE rel_is0.eid_to=2'''),
  1068 WHERE rel_is0.eid_to=2'''),
  1069 
  1069 
  1070     ]
  1070     ]
  1071 from logilab.common.adbh import ADV_FUNC_HELPER_DIRECTORY
  1071 from logilab.common.adbh import get_adv_func_helper
  1072 
  1072 
  1073 class CWRQLTC(RQLGeneratorTC):
  1073 class CWRQLTC(RQLGeneratorTC):
  1074     schema = schema
  1074     schema = schema
  1075 
  1075 
  1076     def test_nonregr_sol(self):
  1076     def test_nonregr_sol(self):
  1101 
  1101 
  1102     #capture = True
  1102     #capture = True
  1103     def setUp(self):
  1103     def setUp(self):
  1104         RQLGeneratorTC.setUp(self)
  1104         RQLGeneratorTC.setUp(self)
  1105         indexer = get_indexer('postgres', 'utf8')
  1105         indexer = get_indexer('postgres', 'utf8')
  1106         dbms_helper = ADV_FUNC_HELPER_DIRECTORY['postgres']
  1106         dbms_helper = get_adv_func_helper('postgres')
  1107         dbms_helper.fti_uid_attr = indexer.uid_attr
  1107         dbms_helper.fti_uid_attr = indexer.uid_attr
  1108         dbms_helper.fti_table = indexer.table
  1108         dbms_helper.fti_table = indexer.table
  1109         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1109         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1110         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1110         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1111         self.o = SQLGenerator(schema, dbms_helper)
  1111         self.o = SQLGenerator(schema, dbms_helper)
  1404 class SqliteSQLGeneratorTC(PostgresSQLGeneratorTC):
  1404 class SqliteSQLGeneratorTC(PostgresSQLGeneratorTC):
  1405 
  1405 
  1406     def setUp(self):
  1406     def setUp(self):
  1407         RQLGeneratorTC.setUp(self)
  1407         RQLGeneratorTC.setUp(self)
  1408         indexer = get_indexer('sqlite', 'utf8')
  1408         indexer = get_indexer('sqlite', 'utf8')
  1409         dbms_helper = ADV_FUNC_HELPER_DIRECTORY['sqlite']
  1409         dbms_helper = get_adv_func_helper('sqlite')
  1410         dbms_helper.fti_uid_attr = indexer.uid_attr
  1410         dbms_helper.fti_uid_attr = indexer.uid_attr
  1411         dbms_helper.fti_table = indexer.table
  1411         dbms_helper.fti_table = indexer.table
  1412         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1412         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1413         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1413         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1414         self.o = SQLGenerator(schema, dbms_helper)
  1414         self.o = SQLGenerator(schema, dbms_helper)
  1512 class MySQLGenerator(PostgresSQLGeneratorTC):
  1512 class MySQLGenerator(PostgresSQLGeneratorTC):
  1513 
  1513 
  1514     def setUp(self):
  1514     def setUp(self):
  1515         RQLGeneratorTC.setUp(self)
  1515         RQLGeneratorTC.setUp(self)
  1516         indexer = get_indexer('mysql', 'utf8')
  1516         indexer = get_indexer('mysql', 'utf8')
  1517         dbms_helper = ADV_FUNC_HELPER_DIRECTORY['mysql']
  1517         dbms_helper = get_adv_func_helper('mysql')
  1518         dbms_helper.fti_uid_attr = indexer.uid_attr
  1518         dbms_helper.fti_uid_attr = indexer.uid_attr
  1519         dbms_helper.fti_table = indexer.table
  1519         dbms_helper.fti_table = indexer.table
  1520         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1520         dbms_helper.fti_restriction_sql = indexer.restriction_sql
  1521         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1521         dbms_helper.fti_need_distinct_query = indexer.need_distinct
  1522         self.o = SQLGenerator(schema, dbms_helper)
  1522         self.o = SQLGenerator(schema, dbms_helper)