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)