Python SQLStatements.sql_get_themes Examples

Example #1

File: testsql.py Project: eaudeweb/EionetProducts

    def test_get_themes(self):
        """ get themes"""
	err, res, msg  = self.query(SQLStatements.sql_get_themes(3, 'en', 'utf8_general_ci'))
        correct = [96L, 234L, 1062L, 618L, 893L, 1349L, 2504L, 10114L, 2711L, 10111L, 13109L, 14980L, 10117L, 3875L, 4125L, 4281L, 1922L, 4630L, 4750L, 4856L, 6237L, 10112L, 7007L, 7136L, 10118L, 7243L, 7779L, 7956L, 14979L, 8575L, 8603L, 9117L]
        list_of_themeids = [ x['theme_id'] for x in res]
        self.assertEquals(list_of_themeids, correct)

Example #2

File: test_db_speed.py Project: eaudeweb/EionetProducts

    def test_get_themes(self):
        """ test get languages"""
	self._timed_query(SQLStatements.sql_get_themes(3, 'en', 'utf8_general_ci'))