def delete_data_with_wildcard(bq_client, dataset, condition, table_prefix, start_date, end_date):
"""Delete all the tables matching the wildcard table prefix.
"""
table_list = table_list_handler.list_wildcard_table(
bq_client, dataset, table_prefix, start_date, end_date, sys.maxint
)
__delete_data_process(bq_client, dataset, condition, table_list)
def copy_table_wildcard(
bq_client, dataset, dest, table_prefix, start_date, end_date):
"""Copy the tables with name match given wildcard pattern.
"""
table_list = table_list_handler.list_wildcard_table(
bq_client,
dataset,
table_prefix,
start_date,
end_date,
sys.maxint)
_copy_table_list(bq_client, dataset, dest, table_list)
def delete_table_with_wildcard(bq_client,
dataset,
table_prefix,
start_date,
end_date,
ignore_confirm=False):
"""Delete all the tables matching the wildcard table prefix.
"""
table_list = table_list_handler.list_wildcard_table(bq_client,
dataset,
table_prefix,
start_date,
end_date,
sys.maxint)
_delete_table_list(bq_client, dataset, table_list, ignore_confirm)
def list_table(list_command):
dataset = list_command.dataset
limit = list_command.limit
if isinstance(list_command, ListCommand):
return table_list_handler.list_all_table(GOOGLE_BIGQUERY_CLIENT,
dataset,
limit)
elif isinstance(list_command, ListRegexCommand):
return table_list_handler.list_regex_table(GOOGLE_BIGQUERY_CLIENT,
dataset,
list_command.table_name_pattern,
limit)
elif isinstance(list_command, ListWildcardCommand):
return table_list_handler.list_wildcard_table(GOOGLE_BIGQUERY_CLIENT,
dataset,
list_command.table_prefix,
list_command.start_date,
list_command.end_date,
limit)
else:
raise ValueError("Unrecognised command type.")
