def get_query(self, component):
return ''' SELECT COUNT(*)
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME="%s"
''' % adbapi_safe(
component.split(NAME_SPLITTER)[-1]
)
def get_query(self, component):
return '''
SELECT
count(table_name) table_count,
sum(data_length + index_length) size,
sum(data_length) data_size,
sum(index_length) index_size
FROM
information_schema.TABLES
WHERE
table_schema = "%s"
''' % adbapi_safe(component.split(NAME_SPLITTER)[-1])
def get_query(self, component):
return '''
SELECT
count(table_name) table_count,
sum(data_length + index_length) size,
sum(data_length) data_size,
sum(index_length) index_size
FROM
information_schema.TABLES
WHERE
table_schema = "%s"
''' % adbapi_safe(component.split(NAME_SPLITTER)[-1])
def get_query(self, component):
return ''' SELECT COUNT(*)
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME="%s"
''' % adbapi_safe(component.split(NAME_SPLITTER)[-1])
