def top_ten_query(self, handle_id): table_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'SQLite', 'table_names.sql') top_ten_query = 'select * from %s limit 10' GenericDatabase.top_ten_query(self, handle_id, table_file, top_ten_query)
def top_ten_query(self, handle_id): table_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'SQL Server', 'Survey (Ver 9+)', 'tables.sql') top_ten_query = 'select top 10 * from %s' GenericDatabase.top_ten_query(self, handle_id, table_file, top_ten_query)
def top_ten_query(self, handle_id): table_query_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'oracle', 'survey', 'tables.sql') top_ten_query = 'select * from %s where rownum <= 10' GenericDatabase.top_ten_query(self, handle_id, table_query_file, top_ten_query)
def top_ten_query(self, handle_id): table_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'SQL Server', 'Survey (Ver 9+)', 'tables.sql') top_ten_query = 'select top 10 * from %s' GenericDatabase.top_ten_query(self, handle_id, table_file, top_ten_query)
def top_ten_query(self, handle_id): table_query_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'oracle', 'survey', 'tables.sql') top_ten_query = 'select * from %s where rownum <= 10' GenericDatabase.top_ten_query(self, handle_id, table_query_file, top_ten_query)
def top_ten_query(self, handle_id): table_file = os.path.join(os.path.dirname(__file__), '..', '..', 'Data', 'database_plans', 'SQLite', 'table_names.sql') top_ten_query = 'select * from %s limit 10' GenericDatabase.top_ten_query(self, handle_id, table_file, top_ten_query)